Question for Simon

Resolved · Low Priority · Version 2003

Mon 9 Aug 2010, 14:23 Edited on Mon 9 Aug 2010, 17:38 Delegate Kenneth said...

Kenneth has attended:
Access VBA course

Question for Simon

I realised you haven't sent over the code that you discussed on Thursday.
Could you please email us the code.

Thanks

Kenneth

Wed 11 Aug 2010, 13:47 Trainer Simon said...

RE: Question for Simon

Hi Kenneth,

Thank you for your question.

I have been so busy this week and I haven't had a chance to send the code.

After I finish training I will send that extra code to you.

Regards

Simon

Wed 11 Aug 2010, 18:21 Trainer Simon said...

RE: Question for Simon

Hi Kenneth,

Please find attached the Query, Word, Excel and Outlook code.

Sorry for the delay in responding.

Regards

Simon

Attached files...

Additional code with some notes.doc

Wed 18 Aug 2010: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips