Hi Ilona, You are very welcome, have to look after the Crow-eaters ay.
Regards Robin. --- In [email protected], "Ilona Wright" <[EMAIL PROTECTED]> wrote: > > 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" <ilona@> 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 --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/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/
