Design question (2002)

[RipperT]

I am in the design stage and wonder: I have a table that contains a name and
a "start date". An event is supposed to occur at regular intervals based on
that "start date. I know I can use calculated fields in a form or use a query
to figure the interval dates, but how do I get those dates back into a table
so I can record other info about the event?

Thanx,

Rip

 

[Duane Hookom]

You might want to download and review the Recurring.mdb at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Cheech73]

You may want to look at the contact management template as well, the subform
for instance-based calls can be modified for this purpose. Each time you
touch the record you can track the changes and see what you did last time and
when you did it.
-FT

 

[RipperT]

Thanx, but I don't need anything that sophisticated. Simply, all I would like
to know is how, when you click the button to generate the schedule, do the
settings that you selected in the form get into the table? Are they written
automatically to the table using an on_click VB procedure?

Thanx for the help,

Rip

 

[Duane Hookom]

The sample will allow you to enter the "parameters" and click a button to
create the multiple schedule records.