Access 2003

Resolved · Urgent Priority · Version 2003

Fri 6 Jun 2008, 16:15 Delegate Lisa said...

Lisa has attended:
Excel VBA Intro Intermediate course

Access 2003

How do you put a button on a form so as to email the form to various email address within an contacts database in the whole database?

Also how would you add photos to a record on a form so as you could have many picture / documents and then you can see them once you click on them?

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