Automated query?

  • Thread starter Thread starter Carla Bradley
  • Start date Start date
C

Carla Bradley

I have a client that wants to do the following. Is this
possible? If so, can you steer me in the right direction?
Thanks! Carla Bradley


Client has a dbase with form which has a command button
to run an append query and update existing records in a
table. He wants to know if there is a way to create a
button or somehow automate this process to run at
midnight or sometime so it doesn't have to be done
manually. He has a resource there that can help with code.
 
Hi,

There are two possible solutions.

1. Have a hidden form with a timer. This form will check
every minute if it is 12:00AM. If it is, then it runs the
append query silently. This method requires that the
databse is always open.

2. Create a task to open the database using a command
line argument (see COMMAND and COMMAND$ functions). On
the startup form, check to see if you received the
expected argument. If so, run the query, and exit out of
the database.

If you need help implementing either, post back or email
at (e-mail address removed)


Chris
 
run an append query and update existing records in a
table. He wants to know if there is a way to create a
button or somehow automate this process to run at
midnight
Click to expand...

Use a vbs script to do it, and use the system timer to run it. Don't need
access at all...

Tim F
 
Back
Top