Hints and tips home » Access hints and tips » Closing form after a certain time period

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

Added by Meenesh on 24th October 2006

More Access hints and tips, like:

• add date to a field
• How To Find All Overdue Accounts?
• Deleting duplicate records from a table