If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recurring Entries
I am designing a scheduling database for a transportation company. They have
clients who they transport on a recurring basis, like every Mon, Wed & Fri for instance. Everything about the transport is the same each time with the exception of the date. Is there any way to make an appointment recurring so it doesn't have to be data entered each and every time? I am in the design stages of the DB so I can pretty much do anything necessary to accomplish this. |
#2
|
|||
|
|||
Recurring Entries
On Thu, 24 Jul 2008 17:00:15 -0700, Sandra P wrote:
I am designing a scheduling database for a transportation company. They have clients who they transport on a recurring basis, like every Mon, Wed & Fri for instance. Everything about the transport is the same each time with the exception of the date. Is there any way to make an appointment recurring so it doesn't have to be data entered each and every time? I am in the design stages of the DB so I can pretty much do anything necessary to accomplish this. Let's assume the appointment schedule is from 8/1/2008 to 12/31/2009. More dates can be added later when needed. Add a record to the appointment table for each date in the above time frame. I'll assume this has already been done. You can use the Weekday() function to determine the weekday number, Sunday being day 1. (This can be changed within the function if a different day is day 1.) Then... You can run an Update query (after you have the table and fields set up with all of the dates, etc.). Update YourTable Set YourTable.AppointmentWith = "ABC Delivery" Where WeekDay(YourTable.DateField) In (2,4,6) So, if the date is a Monday, Wednesday, or Friday, the AppointmentWith field will show "ABC Delivery". Save the query to re-use when additional dates are added. Of course you could use VBA to fill the table with all the dates, and at the same time also fill the AppointmentWith field. But that would be a separate post. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Recurring Entries
See:
Recurring events at: http://allenbrowne.com/AppRecur.html The article includes a sample database that shows how to record one entry and have the database calculate the recurrences. It also illustrates how to handle particular instances of a recurring sequence differently (where an instance is to be skipped or rescheduled. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Sandra P" wrote in message ... I am designing a scheduling database for a transportation company. They have clients who they transport on a recurring basis, like every Mon, Wed & Fri for instance. Everything about the transport is the same each time with the exception of the date. Is there any way to make an appointment recurring so it doesn't have to be data entered each and every time? I am in the design stages of the DB so I can pretty much do anything necessary to accomplish this. |
Thread Tools | |
Display Modes | |
|
|