How to do this...Appointment Database

[Guest]

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.

 

[Guest]

Brian

You could use a Flex Grid control to do this. See my Flex Grid demo program
at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for an example of a diary appointment facility. You will need to write some
VBA code however.

 

[Guest]

Hi Peter,

Very nice sample!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks, Will give it a try...

Brian

You could use a Flex Grid control to do this. See my Flex Grid demo program
at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for an example of a diary appointment facility. You will need to write some
VBA code however.