ms access courses - Reports in access

Resolved · Low Priority · Version Standard

Wed 7 Mar 2007, 09:38 Delegate Mandy said...

Mandy has attended:
Access Intermediate course
Access Advanced course

Reports in access

How can I set the size of a report and its position on my users screen in access?

Mon 12 Mar 2007, 16:35 Trainer Richard said...

RE: Reports in access

Mandy,

You can do this my using the MOVESIZE function in a macro to open the report.
Normally you would need to run this macro from a switchboard button for it to be effective.

For full details on the MOVESIZE function, refer to the help menu (F1)

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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