Thank you Robin. This is just the "fix" I need until I have the time to build the custom menu bar. Your solution is so simple. It's the simple ones that evade me all the time! Thank you very much
Ilona -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Robin Sent: Sunday, 16 July 2006 11:34 PM To: [email protected] Subject: [ms_access] Re: Disabling File Exit Hello Ilona, I'm assuming that you have a form open all the time otherwise you can't expect your users to use the close button that's on it. So, if you don't want to go to the trouble of building a custom menu bar (which I recommend doing and there is a good demo in the Files section called CommandBars or something and includes menu bars) then if you move your code from the button to the OnClose or OnUnload event of the form it should work. The idea being that for the database to close, the form has to close so the code will fire. Hope that helps. Regards Robin Also from Adelaide SA --- In [email protected], "Ilona Wright" <[EMAIL PROTECTED]> wrote: > > Hi Guys, > I gather that since I have not had a response regarding the disabling of the > File Exit command, there is no single VBA statement that does this. Please > reply a simple yes or no to this if you have time. > I have read in MS knowledge base about disabling all toolbars and commands > and then building your own. I gather this is what I will have to do. > > Thank you very much for all your great works. > Ilona > Adelaide, Australia > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Behalf Of Ilona Wright > Sent: Tuesday, 11 July 2006 6:23 AM > To: [email protected] > Subject: RE: [ms_access] Disabling File Exit > > > Hi Guys, > Well I have upgraded from Access 97 to Access 2003. Quite a culture shock > for me! > I am impressed with how user-friendly Access 2003 is. > > My question is how do I disable only the File Exit command? > I want my user to exit only via a programmed exit button. > Thank you in advance > > Ilona > Adelaide, Australia > > [Non-text portions of this message have been removed] > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
