Seen this post on another forum, Curious how you would do solution BrianPaul 22.09.2006 09:03:02 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.

Re: Seen this post on another forum, Curious how you would do solution "Arvin Meyer [MVP]" <a[ at ]m.com> 22.09.2006 10:27:41 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 "BrianPaul" <BrianPaul[ at ]discussions.microsoft.com> wrote in message news:3207E16B-08EC-419D-99AC-F4D68E546133[ at ]microsoft.com... [Quoted Text] >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.

Re: Seen this post on another forum, Curious how you would do solu BrianPaul 22.09.2006 17:55:02 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. "Arvin Meyer [MVP]" wrote: [Quoted Text] > 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 > > "BrianPaul" <BrianPaul[ at ]discussions.microsoft.com> wrote in message > news:3207E16B-08EC-419D-99AC-F4D68E546133[ at ]microsoft.com... > >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. > > >