Scheduling Event Issue

[SYG]

I have set up a database that schedules a job for a specific day at a specific time period.

Job ID: (auto)
Job: job1
Startday: 6/14
StartTime: 9pm
Endday: 6/15
Endtime: 9am

Is there a way to schedule this weekly or every other day or bi weekly. Looking for a periodic event scheduler. Code or if access has an easy way of doing this instead of hitting duplicate and changing the dates manually.

Essentially I would like one job ID # for everyday the job is going on that month.

Maybe type in more information such as a week schedule mon-fri 9a-9p friday saturday 12a-9p sunday 9a-6p. then have it populate until the end of the month.

any ideas?

 

[SYG]

maybe in the form have

Monday Tuesday Wednesday Thursday Friday Saturday Sunday

Then code between start date if calendar= monday then monday=monday

.. eh?

 

[Sketchin]

First off, I would make my life easier and combine StartDay and StartTime into the same Date/Time field.

Maybe use an update query to update a table with DateAdd ("d",7,[Startdate]) ...etc.. that gets triggered at the appropriate time