VBA Program to run a macro

[ChuckW]

Hi,

I have an access database for sales people which is fed
from Quickbooks. I have designed it to build make tables
in order for them to run various reports. I created a
macro called MakeTables that I want to schedule to have
run daily early in the morning. Right now, I manually go
into Access and run this macro but I heard the best way
is to right a vb program which runs this macro and the
schedule this program to run in the Schedule tasks.

I don't know much about VB. Can someone tell me what I
would need to do in order to make this happen?

Thanks,

Chuck

 

[Michael J. Strickland]

Rename your macro to "AutoExec" (without quotes). This makes it run automatically when the database containing it is opened.

Then use Windows Task Scheduler to schedule your database to be opened daily.

To use Windows Task Scheduler:

Click Start, point to Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.


--
---------------------------------------------------------------
Michael J. Strickland
Quality Services (e-mail address removed)
703-560-7380
---------------------------------------------------------------
Hi,

I have an access database for sales people which is fed
from Quickbooks. I have designed it to build make tables
in order for them to run various reports. I created a
macro called MakeTables that I want to schedule to have
run daily early in the morning. Right now, I manually go
into Access and run this macro but I heard the best way
is to right a vb program which runs this macro and the
schedule this program to run in the Schedule tasks.

I don't know much about VB. Can someone tell me what I
would need to do in order to make this happen?

Thanks,

Chuck

 

[Chuck W]

Michael,

I should have specified this but I am already using the
autoexec macro to open up a password protected form that
a user must log in as. It takes about 10 minutes for the
make tables macro to run and it will run everytime one of
several people try to access the database. Also, the
second person who tries to open the database will
probably get error messages. Do you know of another
viable solution such as writing a VB program?

Thanks,

Chuck

-----Original Message-----
Rename your macro to "AutoExec" (without quotes). This

makes it run automatically when the database containing
it is opened.

Then use Windows Task Scheduler to schedule your database to be opened daily.

To use Windows Task Scheduler:

Click Start, point to Programs, point to Accessories,

point to System Tools, and then click Scheduled Tasks.in message news:[email protected]...