B
BrianPaul
Im helping an attorney..no Pay? just keeping skills up.
Attorney question was:
She has appointment times set up hourly. 8:00, 9:00 etc. up to 8 hours a day.
So the first appointment at 8:00 AM and the last appointment at 4:00 PM
I would like to enter a date for example Jan1 through Jan 31 and have the
table fill out all dates between that date. I will probebly have to create 8
fields called time1, time2, etc and have the default set to each one. She
usually is booked 6 weeks in advanced. The goal is to have the date in a
listbox and then a cascade listbox that shows who's in that appointment slot.
If there is a time slot blank without a name on it I will have her double
click on the empty time to enter the client data in it..(I understand how to
do that part). Just wondering how I could set up to enter the dates
automatically without adding all 360 days manually. Or suggest a better way
of doing it....Thanks....If there is code, please give an example.
Attorney question was:
She has appointment times set up hourly. 8:00, 9:00 etc. up to 8 hours a day.
So the first appointment at 8:00 AM and the last appointment at 4:00 PM
I would like to enter a date for example Jan1 through Jan 31 and have the
table fill out all dates between that date. I will probebly have to create 8
fields called time1, time2, etc and have the default set to each one. She
usually is booked 6 weeks in advanced. The goal is to have the date in a
listbox and then a cascade listbox that shows who's in that appointment slot.
If there is a time slot blank without a name on it I will have her double
click on the empty time to enter the client data in it..(I understand how to
do that part). Just wondering how I could set up to enter the dates
automatically without adding all 360 days manually. Or suggest a better way
of doing it....Thanks....If there is code, please give an example.