Automatically adding a record

[Scott McSweeney]

Hi I'm making a database for a lawnmowing bussiness and have got stuck on the scheduling. when entering jobs done I want to have a new shedule(record) entered automatically at say 2 weeks from the date entered. with queries I can show the jobs that are due by having a yes/no feild indicating wheather the job is done, and a date feild in which the job was done. but to schedule a new job I'd need to make an identical record with a new date(say 2 weeks away) when the yes/no field is yes. can this be done?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Silverlight Modal Dialog With Custom User Controls
http://www.eggheadcafe.com/tutorial...01-d47cf3410feb/silverlight-modal-dialog.aspx

 

[Dorian]

Yes it can be done. You don't need a yes/no field for 'job done' as the 'date
job done' serves this purpose. Eliminate all redundant fields, this is good
database practice.
You could have a button on your form to create the new appointment. The
button would run the code to do an INSERT to your appointment table. Look up
the Insert command in Access HELP system. You could also have a scheduling
mechanism that could generate records, for example where someone wants their
lawn done every 2 weeks.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".