Question about Quite up dates

J

Joe Cilinceon

I have a query that appends to a Table tenant notes run from code. I was
wondering if there is a way of stopping it from asking/telling what it is
doing and do it all in the background quitely without the user having to
answer yes/no questions. I hope that is clear.
 
M

Marshall Barton

Joe said:
I have a query that appends to a Table tenant notes run from code. I was
wondering if there is a way of stopping it from asking/telling what it is
doing and do it all in the background quitely without the user having to
answer yes/no questions. I hope that is clear.
Click to expand...


Vague, but I think I understand. You're probably using
RunSQL to execute an Insert Into query.

If so, you should use the Execute method.
 
P

PC Datasheet

Put the following line of code before your code to run the append query:
DoCmd.SetWarnings False

IMPERATIVE!!!!
Put this after:
DoCmd.SetWarnings True
 
Top