Timed Start

[uk]

I want to create a form whereby users can set a database to run at a certain time and date, eg if you want the report to run at 3am the following day so it can be ready for you when you get into work.

Any ideas on how this can be done?

 

[Joe4]

I would set up the database to run upon opening, then open the database with some a scheduler. I believe that Windows comes with a scheduler.

 

[Cbrine]

I had to do the same thing, and what I did was setup an autoexec Macro that had a condition that checked the current time to see if it was before 9:00am. Then set it on the MSscheduler as Jimkey said. The scheduler would open at 8am in the morning and execute the processing code, and if I, or anyone else opened after 9am the report selection screen would appear.

 

[Joe4]

Jimkey

Ouch!!! Boy, does my name get butchered or what!

 

[Cbrine]

Jimkey

Ouch!!! Boy, does my name get butchered or what!

I actually went back the prior to post to check on it and still messed it up!!!



Sorry, jmiskey(I copied and pasted this time)

 

[Joe4]

I see that you are a Calvin & Hobbes lover, so I'll forgive you this time...

 

[Cbrine]

My name's Calvin, who else could be my hero!!