Access 2007 FAQ
When I use the Exit Database option on the Switchboard form created by the Switchboard Manager it only closes the database and not Access as well. What do I need to change in order for Access 2007 to close as well?
Follow along with these steps:
1. Open your Switchboard form in Design view
2. Select the command button on the form - named Option1 by default.
3. Open the Property Sheet window
4. On the Event tab, you should see [Embedded Macro] listed on the On Click event property line
5. Click the builder button (...) for this event to view the embedded macro logic
6. Scroll down the list of existing actions and arguments until you find this one:
[Command]=6
7. Change the Action for that line from CloseDatabase to use the Quit action
Note, if you don't see the Quit action, you need to show all untrusted actions. See this Related Topic for information on how to do that.
8. For the Argument of the Quit action, select one of the three options based on your need - Prompt, Save All, or Exit
9. Save your changes to this embedded macro
10. You'll need to repeat these steps for the text box called OptionLabel1 to make that embedded macro use the Quit action
11. Save all your form changes when you're finished and then test it out
When you use the Exit Application option offered by the Switchboard Wizard, your database and Access all close.
Note, that the Quit action is an untrusted action if you use the Save All or Exit argument. You'll need to enable the content of the database in order for that macro action to function properly. For more information on enabling content in Access 2007, see the following Related Topic.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page