I have a database that I need to show overdue items when the databse
starts up. I have a switchboard now to run things. Is there a
possibility that I can run a test or a query when the switchboard
page opens? If there are overdue items, I want to display those,
if there aren't any then I would like to proceed on to the
switchboard. Any help is appreciated.
Several different ways. Here are three.
1) Create an AutoExec macro which will only run when you first open
the database. See Access Help for assistance.
AutoExecute + Control how an Access file looks and behaves when it
opens + Create a macro that runs when an Access file first opens.
2) Code the Open event of the Switchboard to open the query.
This has the disadvantage of running the query each time the
switchboard is opened, rather than just the first time.
3) You can create a Form, using the query as it's record source. You
probably would want the form to be a continuous form view, or
Datasheet view, rather than single form view.
Code the Close event of the Form: DoCmd.OpenForm, "Switchboard Form"
Then Click Tools + StartUp
Enter the name of the new form in the Display Form/Page box.
Exit and Close Access.
Re-open Access. The new form will display whatever records are
returned by the query. When you close the form, it will open the
switchboard.
