Question about Quite up dates

[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.

 

[Marshall Barton]

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.

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.

 

[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

 

[Joe Cilinceon]

Thanks Guys that did it.