How can I automate application procedures?

[rashar via AccessMonster.com]

I have an application created in Access 2003 VBA. To run the application, you
have to click on the access icon, then click the open button that browses to
a folder. The application grabs a text file in that folder and imports it in
to a table. Then, I have a print button that you click that loads the data to
a form, and then I can choose an adobe print driver to create an adobe pdf
file to my desktop.

Is there any code or another way that I can automate the above actions
unattended?

Thanks in advance.

 

[mscertified]

Not from within Access. You would need to have a VB program running
continually and then you would need a trigger that the program would test to
run the process.
You would have to modify the Access DB to include all your processing in the
autoexec so it runs at startup. It would be much easier to do all this in SQL
Server as it has a scheduler built-in.

Dorian.

 

[Klatuu]

Create a Scheduled task in the Windows Task Scheduler.
Use either a Macro named AutoExec to intiate the process or indentify a
startup form to initiate the process.

 

[rashar via AccessMonster.com]

Create a Scheduled task in the Windows Task Scheduler.
Use either a Macro named AutoExec to intiate the process or indentify a
startup form to initiate the process.

I have an application created in Access 2003 VBA. To run the application, you
have to click on the access icon, then click the open button that browses to

[quoted text clipped - 7 lines]

Thanks in advance.

Thanks guys for the info.. I will give this a try.