X button of Access.exe not working

[Epsilon101]

Hi guyz,

Strange thing here.

I have 2 access dbases
both are split to backends of their own
both are used among 15-20 people.
Ive checked the startup menu on both dbases and they are identical apart from the name and the startup form, yet only one of them lets people close the .exe directly.

1 of them however, when opened, has the access.exe window behind greyed out and the control box on it at top right cant be clicked. So only way for people to get out of the dbase is through the buttons ive provided or by hotkeys or 'ending task'.

Annoying thing about this is my users dont seem to notice the buttons ive provided, and just try clicking the application, when they cant exit they go to ctrl+alt+del and end task, this is getting annoying because they are sometimes in the middle of editing a record while doing it.

It might just of happened by me changing something by accident, but i dont think there is even a setting for this.

Anyone got any ideas.

Thanks

---------------------------------------

Neil

 

[RickSpr]

I'm kind of confused about what you're saying: "has the access.exe window behind greyed out". By "the access.exe" window I assume you mean the application window, the main window within which you normally see the Database Window.

If this window were somehow "greyed out" (disabled), all of its child windows would be disabled as well, except maybe for modal windows. I thought maybe one of your startup forms was being opened modally, but there's really no way to do that with a startup form, and I don't think that would disable the application window anyway.

My best guess at this point is that in one of the database the main form is opened modal, and in the other it isn't. There's a parameter to OpenForm that will open a form modally even if its Modal property is False.

BTW, is this disabling of the application window's close box intended, or unwanted? There is a way to let the user click the application's close button and still get control in your VBA code to do a controlled shutdown. I'll describe it if you're interested.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein