A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Quit macro not working in runtime



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 11:47 PM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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  
Old May 18th, 2010, 03:22 AM posted to microsoft.public.access
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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  
Old May 18th, 2010, 07:27 AM posted to microsoft.public.access
Rick Brandt
external usenet poster
 
Posts: 4,354
Default 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.
  #4  
Old May 18th, 2010, 08:46 AM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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)

.

  #5  
Old May 18th, 2010, 08:51 AM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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)

.

  #6  
Old May 18th, 2010, 08:54 AM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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)

.

  #7  
Old May 18th, 2010, 02:49 PM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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.
.

  #8  
Old May 19th, 2010, 08:18 PM posted to microsoft.public.access
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default 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)

  #9  
Old May 25th, 2010, 03:11 PM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default Quit macro not working in runtime

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" 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)

  #10  
Old May 25th, 2010, 05:01 PM posted to microsoft.public.access
owl
external usenet poster
 
Posts: 128
Default 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)

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.