T
Trial & Error
Ive been working on setting up a DB that will accept staff information, as
well as lesson registration infromation.
This is however not the point of my question.
1 - What I would like to do is limit the dates that a user can select to
book a lesson.
Any date in the future is fine, but I would like to block the entry of any
date that has already passed.
2 - This DB will be used to accept lesson bookings. Naturally there will be
days & times where no lessons will be available. Is there any clear cut way
to have booking limits entered, I would need the date field on the
registration form to verify that no limits had been set on the selected day &
time. I would hopefully like to have a form that would accept limits that
needed to be set.
General notes: Lessons would run every day, at each hour from 9am - 8 pm.
I have tables that accept staff details, client info, and lesson info.
ps. im in access 2003
well as lesson registration infromation.
This is however not the point of my question.
1 - What I would like to do is limit the dates that a user can select to
book a lesson.
Any date in the future is fine, but I would like to block the entry of any
date that has already passed.
2 - This DB will be used to accept lesson bookings. Naturally there will be
days & times where no lessons will be available. Is there any clear cut way
to have booking limits entered, I would need the date field on the
registration form to verify that no limits had been set on the selected day &
time. I would hopefully like to have a form that would accept limits that
needed to be set.
General notes: Lessons would run every day, at each hour from 9am - 8 pm.
I have tables that accept staff details, client info, and lesson info.
ps. im in access 2003