Quit macro not working in runtime
in [General]
|
From: Owl on 25 May 2010 10:11 Sorry I have taken so long to reply to this and your next message. Firstly I am not getting notification emails of replies (although I always click the Notifiy me of replies) and secondly I spent ages looking for this post (searching on the exact words of the heading as I had recorded it, then searching on parts of it, etc) and it didn't come up. Then when I had given up on that and was looking at other entries, suddenly Hey Presto! it was there! That would be great, because that is exactly what I want to do - to exit Access AND the database. "Dirk Goldgar" wrote: > "Owl" <Owl(a)discussions.microsoft.com> wrote in message > news:B0D241A6-5E82-4949-B912-CC0D4BB178B1(a)microsoft.com... > > Thank you for your reply, Rick. The Quit macro (when not used in > > Runtime), > > closes Access entirely. I think you meant that the former (being, closing > > Access entirely) won't work. > > I don't think Rick means that at all. I think he means that the runtime > won't let you close the current database without exiting Access. I don't > know if that is true or not, but it makes sense. > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
From: Owl on 25 May 2010 10:15 As regards your first question: "Is there an object whose design you have modified and can't save?", No there isn't anything like that. As regards your second question: "What happens if you open the database with no other objects open except a simple unbound form that has only a button that invokes your Quit macro. Does it still fail?", I will try that. "Dirk Goldgar" wrote: > "Owl" <Owl(a)discussions.microsoft.com> wrote in message > news:8C087CA9-6B04-4ACF-93FD-3890E1C5E2B4(a)microsoft.com... > >I forgot to say that after I discovered the problem with I converted the > > macro Quit to VBA and it is the following (but still coming up with the > > same > > error message): > > > > '------------------------------------------------------------ > > ' Quit > > ' > > '------------------------------------------------------------ > > Function Quit() > > On Error GoTo Quit_Err > > > > DoCmd.Quit acExit > > > > > > Quit_Exit: > > Exit Function > > > > Quit_Err: > > MsgBox Error$ > > Resume Quit_Exit > > > > End Function > > > I don't have a problem with either the Quit action in a macro or the > DoCmd.Quit method in VBA when running Access with the /runtime switch. I > don't have a runtime-only system to test on, but I don't think this can be > the basis of your problem. > > It seems to me that your error message, "You can't carry out this action at > the present time," must be a clue to what is going on. Possibly there is > something going on in the database when you click the Quit button that is > either happening in runtime but not in normal mode, or vice versa. Is there > a record on a form that has been modified but can't be saved? Is there an > object whose design you have modified and can't save? > > What happens if you open the database with no other objects open except a > simple unbound form that has only a button that invokes your Quit macro. > Does it still fail? > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
From: Owl on 25 May 2010 11:09 I did what you asked and opened the database with no other objects open except a simple unbound form that has only a button that invokes your Quit macro. It worked. However, I need the macro to run from the switchboard. Thank you for any further help. "Owl" wrote: > As regards your first question: "Is there an > object whose design you have modified and can't save?", No there isn't > anything like that. > > As regards your second question: "What happens if you open the database with > no other objects open except a simple unbound form that has only a button > that invokes your Quit macro. Does it still fail?", I will try that. > > "Dirk Goldgar" wrote: > > > "Owl" <Owl(a)discussions.microsoft.com> wrote in message > > news:8C087CA9-6B04-4ACF-93FD-3890E1C5E2B4(a)microsoft.com... > > >I forgot to say that after I discovered the problem with I converted the > > > macro Quit to VBA and it is the following (but still coming up with the > > > same > > > error message): > > > > > > '------------------------------------------------------------ > > > ' Quit > > > ' > > > '------------------------------------------------------------ > > > Function Quit() > > > On Error GoTo Quit_Err > > > > > > DoCmd.Quit acExit > > > > > > > > > Quit_Exit: > > > Exit Function > > > > > > Quit_Err: > > > MsgBox Error$ > > > Resume Quit_Exit > > > > > > End Function > > > > > > I don't have a problem with either the Quit action in a macro or the > > DoCmd.Quit method in VBA when running Access with the /runtime switch. I > > don't have a runtime-only system to test on, but I don't think this can be > > the basis of your problem. > > > > It seems to me that your error message, "You can't carry out this action at > > the present time," must be a clue to what is going on. Possibly there is > > something going on in the database when you click the Quit button that is > > either happening in runtime but not in normal mode, or vice versa. Is there > > a record on a form that has been modified but can't be saved? Is there an > > object whose design you have modified and can't save? > > > > What happens if you open the database with no other objects open except a > > simple unbound form that has only a button that invokes your Quit macro. > > Does it still fail? > > > > -- > > Dirk Goldgar, MS Access MVP > > Access tips: www.datagnostics.com/tips.html > > > > (please reply to the newsgroup) > >
From: Owl on 25 May 2010 12:01 It didn't help. I am still not getting email notifications. Does anyone know what I can do? Thanks for any help. "Owl" wrote: > > Sorry, sorry, me again. I may have sorted out the minor Notify me of > replies. I have just seen the little icon in the bottom right corner that > allowed me to enable Notification. Presumably that will work now. I am > really sorry if you spent any time helping me with that before you see this. > > Looking forward to help on the other problem, though - my Quit macro. > > > "Dirk Goldgar" wrote: > > > "Owl" <Owl(a)discussions.microsoft.com> wrote in message > > news:127C35AB-50A5-455A-B803-BA6EE2D8A9ED(a)microsoft.com... > > > This is the very first time I am using Runtime. I am using Runtime 2007 > > > and > > > my Quit macro isn't working. What can I do about it? > > > > > > Thanks for any replies. > > > > > > What exactly are the actions in your Quit macro? > > > > When you say "isn't working", what exactly do you mean? Do you get an error > > message, or does nothing at all happen when you run it? How is the macro > > invoked? > > > > -- > > Dirk Goldgar, MS Access MVP > > Access tips: www.datagnostics.com/tips.html > > > > (please reply to the newsgroup) > > > > . > >
From: Douglas J. Steele on 25 May 2010 12:25 Don't waste any time trying to get it to work. Microsoft's web interface to these newsgroups has never really worked properly, so even if you managed to get it working today, there's no guarantee it'll work tomorrow. And the fact that Microsoft is dropping these newsgroups in favour of new web-based forums makes it even more futile to worry about it! <g> -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Owl" <Owl(a)discussions.microsoft.com> wrote in message news:C2C741DC-54FC-4007-8B46-D58200BF011F(a)microsoft.com... > It didn't help. I am still not getting email notifications. Does anyone > know what I can do? > > Thanks for any help. > > "Owl" wrote: > >> >> Sorry, sorry, me again. I may have sorted out the minor Notify me of >> replies. I have just seen the little icon in the bottom right corner >> that >> allowed me to enable Notification. Presumably that will work now. I am >> really sorry if you spent any time helping me with that before you see >> this. >> >> Looking forward to help on the other problem, though - my Quit macro. >> >> >> "Dirk Goldgar" wrote: >> >> > "Owl" <Owl(a)discussions.microsoft.com> wrote in message >> > news:127C35AB-50A5-455A-B803-BA6EE2D8A9ED(a)microsoft.com... >> > > This is the very first time I am using Runtime. I am using Runtime >> > > 2007 >> > > and >> > > my Quit macro isn't working. What can I do about it? >> > > >> > > Thanks for any replies. >> > >> > >> > What exactly are the actions in your Quit macro? >> > >> > When you say "isn't working", what exactly do you mean? Do you get an >> > error >> > message, or does nothing at all happen when you run it? How is the >> > macro >> > invoked? >> > >> > -- >> > Dirk Goldgar, MS Access MVP >> > Access tips: www.datagnostics.com/tips.html >> > >> > (please reply to the newsgroup) >> > >> > . >> >
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: #### in Access Pivot Tables Next: what do i do if product key i hav got is being shown invalid |