create switchboard button that will close program entirely

[robnsd]

I have a switchboard button that closes the database but leaves Access
open. Is there a way I can have the button close the database and
Access with one click?

 

[Fred Boer]

Dear robnsd:

Try the following code:

DoCmd.Quit

HTH

 

[Guest]

Where would the command go? >thanks-

Dear robnsd:

Try the following code:

DoCmd.Quit

HTH
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available here:
http://www3.sympatico.ca/lornarourke/

 

[Fred Boer]

Dear Markitos:

Open the switchboard form in design view.
Select the command button.
Press "Alt-Enter", or using the main menu choose View>Properties and click
on the "Event" tab.
Navigate to the "On Click" field - there should be "[Event Procedure]"
displayed in this field. Clicking into this field will reveal some ellipses
(...) on the right of the field.
Click on these.
The IDE code window will open, and you should be in a sub-routine.
I can't be sure what code will be there, but probably you will see the
following line:

docmd.close

Replace that line with "Docmd.quit".

Post back if you need more help!

Cheers!
Fred