I need to set a macro to run at a set time every day. I am using a database
to collect information from an external source. I am not at this computer
every day, and the information that I am retrieving is deleted every day. If
I don't get the information, it is lost. Is it possible to write a code to
make the macro run at a set time every day?

Use the Scheduling tool that's built into Windows, and pass it a command
line along the lines of:

"C:\Program Files\Office\msaccess.exe" "C:\Data\MyDatabase.mdb" /x MyMacro


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Michael" <(E-Mail Removed)> wrote in message
news:C6BECEBC-1338-4EA5-A79B-(E-Mail Removed)...
>I need to set a macro to run at a set time every day. I am using a
>database
> to collect information from an external source. I am not at this computer
> every day, and the information that I am retrieving is deleted every day.
> If
> I don't get the information, it is lost. Is it possible to write a code
> to
> make the macro run at a set time every day?

"Michael" <(E-Mail Removed)> wrote in message
news:C6BECEBC-1338-4EA5-A79B-(E-Mail Removed)...
>I need to set a macro to run at a set time every day. I am using a
>database
> to collect information from an external source. I am not at this computer
> every day, and the information that I am retrieving is deleted every day.
> If
> I don't get the information, it is lost. Is it possible to write a code
> to
> make the macro run at a set time every day?

I explain a possible solution here:

http://www.members.shaw.ca/AlbertKal...obs/Index.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)