Exit Access On Close switchboard

J

Joe Leon

I created a switchboard with the switcboard manager.

First: I want only the switchboard to be displayed when opened. How do I
do this?

Second: When closing the switchboard either through the X or a button I
want a complete Exit from Access. How do I do this?

Thanks!
Joe...
 
F

fredg

I created a switchboard with the switcboard manager.

First: I want only the switchboard to be displayed when opened. How do I
do this?

Tools + StartUp
Select the Switchboard in the Display Form/Page dropdown box.

To hide the database:
Remove the check from the Display Database Window box.

To bypass the startup settings if you need to, hold down the Shift Key
when opening the database.
Second: When closing the switchboard either through the X or a button I
want a complete Exit from Access. How do I do this?

Open the Switchboard form's Code window.

In the Switchboard code sheet, find the
Private Function HandleButtonClick(intBtn As Integer)
function.
Change:
Case conCmdExitApplication
CloseCurrentDatabase
To:
Case conCmdExitApplication
DoCmd.Quit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top