Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

I want to set up a simple meeting b

I want to set up a simple meeting b

I want to set up a simple meeting b

I want to set up a simple meeting booking application in Access.

- There are multiple people who can be booked
- The slots have a defined duration of 30 mins
- Each person has a schedule (days of week and times of day)
- A person once booked for a slot can not be booked again

I am totally out of ideas of how to do this apart from creating a massive table with all the "available" slots. Any ideas?

Product Manager

RE: I want to set up a simple meeting b

Is this for one meeting room? Or multiple rooms?
For each room, do the meetings start at midnight and can run for 24 hours in 30 minutes increments?
Are there any breaks between the meetings? (Lunch, dinner, sleep, sanity break, etc.)

I am sure others will have a whole bunch other questions even before you start...

"how to do this" - start by gathering ALL requirements.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: I want to set up a simple meeting b

You need to build the available schedule somehow which it seems you can do.

From a pragmatic point of view I would do just as you suggest build a table / schedule based on available slots.

Anything else is just going to be a lot of extra work to achieve the same result so directionally you are headed in the right direction.

If you have multiple booking agents for each person who can be booked, you need to decide how to resolve booking conflicts especially around first available. But if only I book myself, it becomes an easier exercise.

But as Andy said you want all the requirements up front for clarity. Things like meeting rooms require more tables... preventing overlaps etc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close