Seen this post on another forum, Curious how you would do solution

[Guest]

I seen this post on another forum on Access.

Sounds like an appointment database for a DR. or other professional.

Lets say your open for business Mon-Fri from 9AM to 5PM for example
excluding holidays.

You take appointments starting at 9AM and break for lunch say from 12-1. in
30 min increments.

1st Question: could you auto populate your database in a table with your
time schedule lest say from Jun 1 - to the end of July

2nd Question: If you had a listbox based on those dates with the dates and
times and you assigned a date and time slot to a client, could that date and
time dissapear from the listbox so you wouldn't double slot the date and time.

The 2nd question would probebly answer the other post. However, it just go
the rusty wheels turning in my head if there was a solution to the above
scenerio.

Thanks.

 

[Arvin Meyer [MVP]]

I'd build a table for the time slots and link it to the appointment table
with a Left or Outer join. That would show all the appointments. A Where
clause would then limit the appointments to those slots where there was no
matching record in the appointment table.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

That makes since on the database developement. I was kind of interested in
the code that would auto fill the appointments. Im only guesing you would
build a function. that would auto populate the table with appointment times
specified in the function instead of manually putting each one in the table.