Run command on a specific date

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

Guest

Hi. I have a database that gathers data for return tags for customers who are
returning their rented instruments to the store. At the end of each week I
have to email the list of tags for that week to the store manager. Is there a
way to set up Access to automatically run my email macro every Friday?
 
You could try starting a scheduled job to run Access, using the command line
option /X <macro> to run a macro.

Gary
 
I knew about that, but I have to run the database on a daily basis anyway,
and I have to run a report from our retail system first before I can run the
database. Some days I run the report at 9am, other days I don't get to it til
3pm... so having the database run at a set time is a no go.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Command to run access, open to specific form and specific record 1
Calculating End-of-Week Date 3
Access "OutputTo" Command HTML Template 0
Stored date is not being recognised 1
Parse dates from text field 2
Question regarding Access 3
calculating weekending date 4
value on a specific date 3

Back
Top