Prevent Shutdown

Nothing can stop them from force closing it with the Windows Task Manager however, if they know how.

Hey Richard, I tried playing with those videos and using code. The one I couldn't close anything because it disabled the close button. Is there a code that we can place in a module to hide the red X but not disable it, just hide it. I can hide the close button on a form.

To the best of my knowledge, you can't hide the 'X' to close the application itself; that's a Windows thing. There may be some Windows API code out there that you could use, but I'm not aware of any. However, if you prevent people from closing your main menu, as I show in the video, you can control what happens if they do try to close the database, which will attempt to close the main menu. You can cancel that event.

But yes of course you can you can hide the close button on the form that's in the form's properties. You have to hide the close button and the control box.

I see, ok well I need to find the best option for only the 2 forms.Thanks again for the help.

You also can't prevent the user from shutting down the PC, which will shut down Access and every running process.  If you somehow take away their keyboards and mice, they can still press the power button to shut the PC down.  Instead of spending time and effort to do this kind of thing (which is futile anyway), spend it on handling the events that occur when the user shuts down the form or the app.

Hi Kevin and yes that's what I am doing. The computer needs to stay on in order for the database to still maintain it's connectiion to the back end. I do believe I have it solved. Richard has that video on the yesnocancel, the three way choice. I'll be using that on the forms just worded according to the forms. Thanks Kevin.

Well, I've done this with my Main Form as well and all works fine, but...when I'm on my Main Form and I click on the top border so I can go into design view it puts up the Warning message.  I've tried to use the design button on the very top menu as well as the design button at the lower right of the form as well and it still gives me that message.  But, if I do click on "Yes" it does take me to the Design Form.  I've got the code the same as what was shown on the video, any suggetions or advice on why I'm getting that Warning message when I try to get into Design View?  It also happens when I'm coming out of Datasheet View.

The form in effect has to shutdown before it goes into design so the same event that you have in place to prevent shut down occurs when you go into design mode.

That is why you see what you do.

I haven't reviewed all of the helpful advice and good humor in this thread, but maybe a simple process I use can help a bit.
I close my database with VBA from a CommandButton marked (QUIT). I've added a small table to the DB in which I record the DateTime stamp of the moment of "quitting." This is displayed on the Form which opens automatically at the DB startup. This doesn't prevent you from stupidly altering a lot of code in an ill-named backup, but can at least keep you on the last used generation of the project.