Question about Quite up dates

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
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.
 
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.
 
Put the following line of code before your code to run the append query:
DoCmd.SetWarnings False

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