Help! Newby to access - recurring events

[stevo63]

Hi all,


I am helping to build a database for an equestrian centre that has lessons
with tables of
clients, lesson times , horses

looking for advice if possible in this scenario

client A - comes on a monday(date field) at 8pm(time field) and comes weekly "w" (frequency field), how can i once booking that lesson and putting w into the freq column make that all of his/her particular lesson details carry forward 7 days(until further notice), or 14 days for f fortnightly?



hope this makes sense to someone

[June7]

That will require VBA code to write records to table. Instead of repeating the booking info, lessons table could have start date and end date fields for each booking.

Might check out template databases. Open Access and a selection of templates is offered.

[stevo63]

That will require VBA code to write records to table. Instead of repeating the booking info, lessons table could have start date and end date fields for each booking.

Might check out template databases. Open Access and a selection of templates is offered.

Thanks for your quick reply....will look into it

Steve