Automating an Append Query In Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Append Query from Access that pulls information straight from a SQL
Server (i.e., Access is linked to this Server Database) and appends it into a
table in another Access db.
I run the query everyday; all it does is pull information based on the prior
date - this is the only "criteria". I was just wondering if there's a way to
automate this process so that this information can be pulled automatically.
I'm familiar with Excel VBA but I'm not comfortable Access at that level.

Thanks,
RL
 
Few steps
1. Create a function that run the Query
Function FunctionName()
docmd.OpenQuery "QueryName"
application.quit
End Function

2. Create a macro that will run the function, name the macro AutoExec, when
access load it will run this macro automatically, If you want to open the mdb
without running the macro, then open it while holding the shift key down

3. Set the Windows schedular to run the MDB in a certain time.
 
How do I insert my query parameters automatically (based on what I put in
VBA) into the query I'm opening up?
 
Back
Top