Run Update Query in silently in background

  • Thread starter Thread starter ghadley_00
  • Start date Start date
G

ghadley_00

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
(e-mail address removed)
 
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.

"(e-mail address removed)" 來函：
 
within the macro use setwarnings (false) before the query, then setwarnings
(true) after the query

Bob Galway
 
Issue a SetWarnings False before running the query. Make sure to set it back
to True afterwards.
 
Douglas said:
... Make sure to set it back
to True afterwards.
Click to expand...

<pedantic> ... or simply allow it to automatically reset to Yes at the
end of the macro. ;-) </pedantic>
 
Steve Schapel said:
<pedantic> ... or simply allow it to automatically reset to Yes at the
end of the macro. ;-) </pedantic>
Click to expand...

Say what? Assigning a value to SetWarnings in a macro isn't "permanent",
like it is in VBA?
 
Douglas said:
Say what? Assigning a value to SetWarnings in a macro isn't "permanent",
like it is in VBA?
Click to expand...

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