Home > IT Answers > Microsoft Windows > Repeating Data
Shazzie
70 pts.
 Repeating Data
Access 2007, Date Type Variables, Windows XP, Access 2007 form creation
Can I create something in a form in Access 2007 that allows a user to make a recurring job?  I have created a database for a Waste Management company.  I created two tables.  The first one is the date table containing the date the customer calls in for a skip or a sewage collection or a water drop-off, etc.  The second table (the many of a one-to-many relationship) contains the details eg: date assigned, date completed, type of job (sewage, skip, water, etc), customer name, truck no.  However, there are certain customers that have a "standing order", ie: a collection every Thursday or a collection/drop-off every day, etc.  how can I create a command on the form that allows the user to create a recurring appointment?  Is it possible in Access 2007?

Software/Hardware used:
Windows XP, Access 2007
ASKED: May 31, 2010  4:22 PM GMT
UPDATED: June 1, 2010  1:58:22 PM GMT
RELATED QUESTIONS
Shazzie
70 pts.
Answer Wiki:
Last Wiki Answer Submitted:  May 31, 2010  4:22 PM (GMT)  by  Shazzie   70 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

You will have to program it.

I’m still not clear about your design, and about whether you are asking how to create a command to store recurring appointments, or to do something else with those stored recurring appointments.

You could add a column to identify the appointment type, and some other columns (or maybe tables) to store additional information like recurrence period, start and end dates, etc)

Carlosdl
 60,255 pts.
 

Hi - thanks for your input. Basically I want to be able to create each appointment as a new “job” that will come up on the day’s job list. So, effectively, store the “job / appointment” in the job list table. Do you think an append query with a “dateadd” command would work?
Regards, Sharon

Shazzie
 70 pts.