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

Run Update Query silently in background

P: n/a
I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update query
to run in the background, and not ask the user for any perrmissions. I
was thinking to run the query as part of the autoexec macro.

can anyone recommend a way that I can have the update query run in the
background? I don't see an obvious way to set the SetWarnings command
for the query.

Any help would be greatly appreciated.

Best wishes,

George
gh********@yahoo.com

Dec 30 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
gh********@yahoo.com wrote:
I have a MS access 200 DB in which I have an update query which
repalces all the " " with ''" in a field. I would like the update
query to run in the background, and not ask the user for any
perrmissions. I was thinking to run the query as part of the autoexec
macro.

can anyone recommend a way that I can have the update query run in the
background? I don't see an obvious way to set the SetWarnings command
for the query.

Any help would be greatly appreciated.

Best wishes,

George
gh********@yahoo.com


CurrentDB.Execute "QueryName", dbFailOnError

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Dec 30 '05 #2

P: n/a
Another way to do it is to use (in VBA):
On Error Resume Next
DoCmd.OpenQuery "qryName"

Dec 30 '05 #3

P: n/a
Steve wrote:
Another way to do it is to use (in VBA):
On Error Resume Next
DoCmd.OpenQuery "qryName"


I don't believe that would eliminate warnings and confirmation prompts.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Dec 30 '05 #4

P: n/a
Sorry, I meant:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryName"
DoCmd.SetWarnings True

Don't know what I was thinking when I wrote the On Error Resume Next
bit.

Dec 30 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.