Automatic Queries

[Thecherub]

I have an Append and Delete querry to run every day I know how to set this up, the question is how to I keep the data base from asking to confirm all the Appends and deletes.

as it does when those are the only items in the macro.

Thanks

 

[dan-cat]

Use the Set Warnings actions. Make sure the option is set to no.

 

[Rich]

or use the Execute method

 

[Thecherub]

Thank you

The set warnings action worked like a charm

 

[dan-cat]

or use the Execute method

Execute method my arse

 

[Thecherub]

No fighting

no fighting on the schoolyard boys.

I don't know it the execute method would work or not since the Set warnings worked. I didn't look any farther. If the execute was the first on the list i might not have gotten to Set Warnings.

 

[dan-cat]

C'mon Rich - letsby avenue!

 

[Rich]

I'd rather use code than a macro since there's no error handling in macros. Therefore the execute method is more efficient than DoCmd. Run Sql etc. etc Though you could of course use an autoexec macro to run the code