Button to exit access completely

[mcmcd99]

Hello, I am trying to make a button that I can put in my form that will close out of Access completely. Currently I have DoCmd.Quit acQuitSaveAll


but all that does is close the form within the navigation pane, and not the navigation form itself, or the MS Access 2016 program.

I'm doing this because I have my main navigation form open in full screen to hide the back end.

(On another note- My forms aren't actually opening maximized, even though I have DoCmd.Maximize in their loadup setting, any thoughts?)

[June7]

DoCmd.Quit works for me - closes the app. Why do you use acQuitSaveAll insteadof acQuitSaveNone? The Save is to save db design changes. I only want to allow that if I (the admin/developer) opens the db. So I have a Users table and code that identifiers the user and their permissions. So my Quit code is:

DoCmd.Quit IIf(Me!Permissions = "admin", acQuitSaveAll, acQuitSaveNone)

I don't understand what you mean by 'hide the backend'. How does maximizing form hide backend?

I don't set forms maximized but I just tested the code and it worked.

[mcmcd99]

I want to hide the ability to change design or tables directly, leaving only the form interface visible so that the users don't mess with anything they shouldn't. That's what I meant by that.

Also, my form doesn't seem to want to actually go full screen. I have "Fit To Screen" as "Yes" but that doesn't seem to do anything!

[June7]

I set up db with Navigation Pane hidden, disable right click shortcut, disable function keys, disable all X close including the app, customized ribbon that removes File>Exit. It's complicated but works unless users know the shift key bypass. I've never taken the extra step of distributing accde version.

Is your db split design (frontend and backend)?

I've never used 'maximize' or 'fit to screen'.