Repeating Data

70 pts.
Tags:
Access 2007 forms
Date Type Variables
Microsoft Access 2007
Microsoft Windows XP
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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)
    70,200 pointsBadges:
    report
  • Shazzie
    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
    70 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following