|
Subject:
|
run automatically...help plz
|
|
Posted By:
|
lom2pac
|
Post Date:
|
8/1/2006 1:48:09 PM
|
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.
|
|
Reply By:
|
AccessMaster
|
Reply Date:
|
8/7/2006 1:44:25 AM
|
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
|
|
Reply By:
|
lom2pac
|
Reply Date:
|
8/7/2006 10:42:24 AM
|
thnx for the help man
|