exit

[slimjen]

I have an exit button on my switchboard in a database that exits only the database. How do I code it to exit Access too?

[Toyman]

I have an exit button on my switchboard in a database that exits only the database. How do I code it to exit Access too?

What is the code you have in the exit button. One simple code is:

docmd.RunCommand acCmdExit

[slimjen]

CmdExitApplication
            CloseCurrentDatabase

I'll try the simple code.
Thanks

[slimjen]

ok. I tried this. But it bypasses the "compact on close" I would like this to happen before closing the database.

[Toyman]

ok. I tried this. But it bypasses the "compact on close" I would like this to happen before closing the database.

Ref: "docmd.RunCommand acCmdExit"
No, I just checked the code in my db running Access 2010 with the db option to "compact on close" checked. The exit code ran and the db got compacted.