468,316 Members | 1,894 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

"Quit" in macro closes out the whole app

I was wondering why when you create a macro and you choose quit, it
close out the whole app? i'm running a macro that does alot of
appends and updates and at the end i want to be able to save all my
data only. please advise. thank you.

Nov 13 '05 #1
6 2146
ken
so don't choose quit. Access saves everything automatically..as far as
I know

Nov 13 '05 #2
alright thanks for the response. that was very simple.

Nov 13 '05 #3
Br
ken <ge****@gmail.com> wrote:
so don't choose quit. Access saves everything automatically..as far as
I know


There is an option with the Quit action to do with telling Access to
save or not (default is save).
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #4
I think the AcQuitOption determines if modified Access objects are
saved, not data.

Nov 13 '05 #5
Br
ly******@yahoo.ca wrote:
I think the AcQuitOption determines if modified Access objects are
saved, not data.


The Quit action has an option with values "Save All", "Prompt",
"Exit".....
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
Nov 13 '05 #6
These constants have been replaced in Access 2003 with
acQuitPrompt
acQuitSaveAll
and
acQuitSaveNone.

But save what? The original poster talks about updates and appends. The
help file talks about changes to Access Objects. I doubt that these
Constants will have any effect on updates and appends. Usually when one
does updates and appends they are effected immediatelly unless they are
done through an unbound form, or within a transaction.

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Agnes | last post: by
1 post views Thread by robotlizz | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.