Before Update Event

[June7]

That code goes in a general module I named Customization.

It gets called behind form that opens by default when db opens. For my purposes, the line is:

If Me!Permissions <> "admin" Then Call SetAccessXCloseButton(False)

Yes, I was confused. I thought you meant the Close action by click on the A icon at top left of app window.



Sorry, I have nothing for the Windows taskbar other than possibly hiding the Access app window (I never implemented) https://stackoverflow.com/questions/...nd-and-taskbar

[data808]

That code goes in a general module I named Customization.

It gets called behind form that opens by default when db opens. For my purposes, the line is:

If Me!Permissions <> "admin" Then Call SetAccessXCloseButton(False)

Yes, I was confused. I thought you meant the Close action by click on the A icon at top left of app window.

Sorry, I have nothing for the Windows taskbar other than possibly hiding the Access app window (I never implemented) https://stackoverflow.com/questions/...nd-and-taskbar

No worries @June7. Thanks for trying. I think disabling the taskbar for closing the app is almost impossible. So when you said you had a solution for it, I was very excited to see if it would work. The other thing in Access that bothers me is the MDI window. I think I heard there is a way to completely get rid of it but I'm not sure how to do that. Right now I always have it minimized but it will pop back up occasionally if the user left clicks on the Access icon in the taskbar or some other scenarios like opening a split form maximized, it will bring up the MDI window behind so I always do code to try and hide that thing whenever I can and also a few minimize MDI window buttons scattered throughout the app for the user to click on if the MDI window is being annoying or in the way.

Your "Cancel = True" did help with the scenario of the undo happening if the user clicks no when asked to save changes but then I get other errors if I repeat it again or try another scenario. I think I am just going to surrender and keep my original code as it has worked for the most part. It just didn't prompt the user when they close by taskbar to let them know that changes are going to be saved whether they like it or not. It would have been nice to be able to have at least a message box to tell them that but ultimately, if it could ask if they wanted to save the changes would have been ideal. I just can't believe Microsoft did not give a simple solution for such a common scenario.

Thanks everyone for trying to help.

[Minty]

Have a read of this / look at the video - it's a really good take on validations and the Before update event.
https://www.access-programmers.co.uk...-and-2.324342/