recurring information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i use an access database to record and track medical appointments. is there
a way or function that can be used that would be comparable to the recurrance
feature in microsoft outlook?
thanks
 
i use an access database to record and track medical appointments. is there
a way or function that can be used that would be comparable to the recurrance
feature in microsoft outlook?
thanks

Well, you could create an Append query to append multiple future
appointments. Exactly how you'ld do this would depend on your table
structure, which of course we can't see.

For example, you might want to add a handy auxiliary table named Num
with one Long Integer field N as its primary key. Fill this table with
values from 0 through the most appointments you'll ever need (be
generous, 10000 records is still a small table).

You can then create an Append query using DateAdd() to calculate
future dates. For example, if you have a form frmAppt with textboxes
txtFirstDate, txtHowMany, txtInterval (in days), you could use

INSERT INTO Appointments
(<whatever fields are needed>, AppointmentDate)
SELECT<whatever>, DateAdd("d", N * [Forms]![frmAppt]![txtInterval],
[Forms]![frmAppt]![txtFirstDate])
FROM Num
WHERE N < [Forms]![frmAppt]![txtHowMany];

John W. Vinson [MVP]
 
Back
Top