If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Quit macro not working in runtime
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. |
#2
|
|||
|
|||
Quit macro not working in runtime
"Owl" wrote in message
... 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) |
#3
|
|||
|
|||
Quit macro not working in runtime
Thank you for your reply, Dirk.
The actions in my Quit macro (which works - to exit the database - on every single other database I use OUT of Runtime) are simply Quit (and of the options to Save or Prompt or Exit, I have selected Exit). By not working, I mean it comes up with the following error message (THEN paradoxically carries out the action requested): You can’t carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However, is performing another activity that prevents this action from being carried out now. For example, no actions on a form can be carried out while is repainting a control or calculating an expression. Carry out the action later. Then there is an OK button and when I press the OK button, I am taken out of the database as I wanted to be immediately with no further problem, but I don't want the error message coming up. The macro is invoked from a switchboard. So far, I am using my database with Runtime on a computer WITH Access 2007, but am hoping to be able to try it out on a computer without Access tonight - hopefully I will have the Quit problem sorted out by then. I have Runtime and my small simple application database file (not split - I am going to try to do it with a copy of the database split when I have mastered this unsplit one) in the same folder. I have made the folder that they are in, a Trusted Location. By the way, a separate issue and much less important to me right now (but I don't know where to go to ask about this), for many months, I haven't been "notified of replies" even when it has been a number of days before I have come back into Microsoft Discussions to see if somebody has replied to a question of mine. Do you know which forum or where else I can go to ask for help on this? Or do you know what I can do myself? I am clicking on Notify me of replies. When this started (but I am not sure0 possibly co-incided with the time I had a new hard drive put into my computer, some months ago. Thanks for any more help you or anyone else gives me. "Dirk Goldgar" wrote: "Owl" wrote in message ... 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) . |
#4
|
|||
|
|||
Quit macro not working in runtime
Owl wrote:
Thank you for your reply, Dirk. The actions in my Quit macro (which works - to exit the database - on every single other database I use OUT of Runtime) are simply Quit (and of the options to Save or Prompt or Exit, I have selected Exit). By not working, I mean it comes up with the following error message (THEN paradoxically carries out the action requested): You can’t carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However, is performing another activity that prevents this action from being carried out now. For example, no actions on a form can be carried out while is repainting a control or calculating an expression. Carry out the action later. Then there is an OK button and when I press the OK button, I am taken out of the database as I wanted to be immediately with no further problem, but I don't want the error message coming up. The macro is invoked from a switchboard. So far, I am using my database with Runtime on a computer WITH Access 2007, but am hoping to be able to try it out on a computer without Access tonight - hopefully I will have the Quit problem sorted out by then. I have Runtime and my small simple application database file (not split - I am going to try to do it with a copy of the database split when I have mastered this unsplit one) in the same folder. I have made the folder that they are in, a Trusted Location. Does the Quit macro (when not using the runtime) close Access entirely or just the file currently opened? The runtime cannot be used without a file opened so the latter would not be allowed. |
#5
|
|||
|
|||
Quit macro not working in runtime
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 appreciate being told that immensely. Every bit I can learn about Runtime helps a lot because I am really floundering with it. So, how can I have something on my switchboard to exit Access then? "Rick Brandt" wrote: Owl wrote: Thank you for your reply, Dirk. The actions in my Quit macro (which works - to exit the database - on every single other database I use OUT of Runtime) are simply Quit (and of the options to Save or Prompt or Exit, I have selected Exit). By not working, I mean it comes up with the following error message (THEN paradoxically carries out the action requested): You can’t carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However, is performing another activity that prevents this action from being carried out now. For example, no actions on a form can be carried out while is repainting a control or calculating an expression. Carry out the action later. Then there is an OK button and when I press the OK button, I am taken out of the database as I wanted to be immediately with no further problem, but I don't want the error message coming up. The macro is invoked from a switchboard. So far, I am using my database with Runtime on a computer WITH Access 2007, but am hoping to be able to try it out on a computer without Access tonight - hopefully I will have the Quit problem sorted out by then. I have Runtime and my small simple application database file (not split - I am going to try to do it with a copy of the database split when I have mastered this unsplit one) in the same folder. I have made the folder that they are in, a Trusted Location. Does the Quit macro (when not using the runtime) close Access entirely or just the file currently opened? The runtime cannot be used without a file opened so the latter would not be allowed. . |
#6
|
|||
|
|||
Quit macro not working in runtime
"Owl" wrote in message
... 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) |
#7
|
|||
|
|||
Quit macro not working in runtime
Oh, and further to this, this is happening in 2 separate attempts to use
Runtime with the application. The first is with an accdb file and the necessary bit before the Target to direct the system to Runtime. The second is with an accdr file. I have the 2 attempts in 2 separate folders, both with Runtime in them. "Dirk Goldgar" wrote: "Owl" wrote in message ... 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) . |
#8
|
|||
|
|||
Quit macro not working in runtime
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" wrote in message ... 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) . |
#9
|
|||
|
|||
Quit macro not working in runtime
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" wrote in message ... 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) . |
#10
|
|||
|
|||
Quit macro not working in runtime
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" wrote in message ... 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" wrote in message ... 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) . |
|
Thread Tools | |
Display Modes | |
|
|