Disabling File Close and File Exit

[Simon Cleal]

Acc2000

I want to prevent my users from exiting Access other than by using the
button I provide them with on my switchboard

Scanning through these forums Ive found some nice code (That's usually
'marketed' by Jeff Conrad) located here

http://support.microsoft.com/kb/245746/EN-US/

The code disables the close button (X) but this code still leaves the File
Close and File Exit menu options available

How do I disable these controls or is there an easy way to disable the whole
menu bar? (my users don't need it and I'd rather keep temptation out of their
reach!)

Thanks in advance

Simon

 

[Jeff Conrad]

"Marketed?"


Review the other possibilities I have listed on my page:

http://home.bendbroadband.com/conradsystems/accessjunkie/closebutton.html

Personally, I prefer to create my own menu bars to control
what I want the user to see.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
news:[email protected]...

 

[Simon Cleal]

D'oh!

I was completly missing the bit on custom menus!

Thanks for the help Jeff

 

[Jeff Conrad]

No problem, good luck with your project.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[John Mishefske]

Acc2000

I want to prevent my users from exiting Access other than by using the
button I provide them with on my switchboard

Scanning through these forums Ive found some nice code (That's usually
'marketed' by Jeff Conrad) located here

http://support.microsoft.com/kb/245746/EN-US/

The code disables the close button (X) but this code still leaves the File
Close and File Exit menu options available

How do I disable these controls or is there an easy way to disable the whole
menu bar? (my users don't need it and I'd rather keep temptation out of their
reach!)

One way of doing this is to open a hidden form at startup. If it is the
first form opened then it will be the last form closed.

Put code in the Form_Close or Form_Unload event of that form and
it will run however the user exits (short of a system crash or
a process kill).