Exiting Access 2010 via Switchboard

Sanjo

Registered User.
Local time
Today, 04:41
Joined
Mar 14, 2012
Messages
62
Being a novice I could not understand what I was reading as advice on how to make changes neccessary to exit the Access 2010 software, not just the database, thru the Switchboard. So I finally came up with a procedure I hope will help folks:

1st = Create a Macro
-click on Create at top of Access
-click on the arrow on the small window that comes up and scrowl down to "QuitAccess"
-another window appears with options. click on arrow and select "Save All"
-give the Macro a name
-X out and save

2nd = open the Switchboard Manager
- click on "New" (assuming you don't already have an Exit button)
- a 3 field window appears.
.In the TEXT field type in "Return to Desktop" or whatever
.In the COMMAND field select "Run Macro"
.In the MACRO field select the name of the macro you created above.

get out of Switchboard Manager by clicking "close" twice.

For my simple mind I need this detailed instructions. I hope this helps someone.
 
the simple command

docmd.quit

shuts down access, not just the active database. i am pretty sure the standard switchboard manage includes an option (option 6? offhand) to execute this.

check the code for the event "handle button click"

I normally edit the switchboard items table directly to set up my switchboards, so I am not sure how you do this with the switchboard manager app.
 
thanks Gemma, but the Switchboard Manager doesn't include any option except to exit the DB. I looked on the properties screen for an event "handle button click" and couldn't find it. I guess I will stick with the small macro because it works perfectly and I am having a devil of a time trying to understand exactly, step-by-step, the procedure for inserting the "docmd.quit" command whereever it is supposed to go.

thanks for your help.
 

Users who are viewing this thread

Back
Top Bottom