Need to Autorun an Append Query

[bluefox951]

Ok, so I'm sure this question has already been asked, but I'll go ahead and ask again.

I've written an Append Query to update a table every time is runs. I need this append query to run once a day, preferably around 4 in the morning. That way, it can take the previous days information and append in on to the table. How do I go about doing this? I've gotten a macro to work, but it can't bypass the warning messages. What do I do?

 

[neileg]

I don't use macros but if it was in VBA you would use SetWarnings to turn the warnings off and then on again.

 

[Doozer1979]

Convert your Macro into VBA code ,and add:

docmd.SetWarnings False

Insert rest of Code here

docmd.SetWarnings True


If you don't turn the warnings back on you'll not get error messages that you might want to be warned about!

 

[bluefox951]

Got it, but one more thing

Awesome, I got the macro to run on it's own with no problems. But after it's all done, how do I automatically close Access? Any suggestions?

 

[bluefox951]

Nevermind

nevermind, i got how to close access. Thanks all