hi guys,

does someone know how to make run a form in access, lets say at a certain date and hour automatically ?... like all i have to do is to write a code in vb & i keep the access file open...and then it runs autom....

i dont know if its possible, but if someone thinks know how to, it would be cool to help, thnx.

There are two method that I normally use to do this:

1) Use a form's timer property to run the code at the desired internval.

2) use the Windows Task Scheduler to open then MDB that has a startup form the runs the code and then quits.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

thnx for the help man