Run Update Query in silently in background

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ghadley_00@yahoo.com - 30 Dec 2005 13:18 GMT

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
ghadley_00@yahoo.com

Reply to this Message

Rainbow01 - 30 Dec 2005 14:50 GMT

from Rainbow01 Hong Kong

i am using Chinese verson of access
i am not sure the English item name

u can try this:
in access' custom option, u can turn off the item of Updating Query(in
Chinese:動作查詢) for no message box appear to ask user for confirm.

"ghadley_00@yahoo.com" 來函：

> 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
[quoted text clipped - 11 lines]
> George
> ghadley_00@yahoo.com

Reply to this Message

bob - 30 Dec 2005 14:57 GMT

within the macro use setwarnings (false) before the query, then setwarnings
(true) after the query

Bob Galway

Reply to this Message

Douglas J. Steele - 30 Dec 2005 14:58 GMT

Issue a SetWarnings False before running the query. Make sure to set it back
to True afterwards.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

ghadley_00@yahoo.com - 30 Dec 2005 16:03 GMT

That took care of it. Thanks.

Reply to this Message

Steve Schapel - 30 Dec 2005 19:06 GMT

> ... Make sure to set it back
> to True afterwards.

<pedantic> ... or simply allow it to automatically reset to Yes at the
end of the macro. ;-) </pedantic>

Signature

Steve Schapel, Microsoft Access MVP

Reply to this Message

Douglas J. Steele - 30 Dec 2005 22:38 GMT

>> ... Make sure to set it back to True afterwards.
>
> <pedantic> ... or simply allow it to automatically reset to Yes at the
> end of the macro. ;-) </pedantic>

Say what? Assigning a value to SetWarnings in a macro isn't "permanent",
like it is in VBA?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

Steve Schapel - 31 Dec 2005 00:08 GMT

> Say what? Assigning a value to SetWarnings in a macro isn't "permanent",
> like it is in VBA?

Correct, Doug. Just for the duration of the macro's execution.

Signature

Steve Schapel, Microsoft Access MVP

Reply to this Message