By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,865 Members | 1,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,865 IT Pros & Developers. It's quick & easy.

"Quit" in macro closes out the whole app

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
ken
so don't choose quit. Access saves everything automatically..as far as
I know

Nov 13 '05 #2

P: n/a
alright thanks for the response. that was very simple.

Nov 13 '05 #3

P: n/a
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

P: n/a
I think the AcQuitOption determines if modified Access objects are
saved, not data.

Nov 13 '05 #5

P: n/a
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

P: n/a
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.