Maximising

Resolved · Low Priority · Version 2003

Wed 16 Jun 2010, 15:44 Delegate Sarah said...

Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course

Maximising

When opening a database, can you set the forms to open up maximised automatically?

Mon 21 Jun 2010, 11:25 Trainer Stephen said...

RE: Maximising

Hi Sarah

Thanks for your question

This is very simple to do. Simply create an on open sub procedure for the form in question and add the following line of code

DoCmd.maximise

This will then automatically maximise the form when it opens

Regards

Stephen

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

Maximising

Maximising

RE: Maximising

Access articles

Access tip:

How To Find All Overdue Accounts?