Results 1 to 3 of 3
  1. #1
    carlgoro is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    2

    Art booking system - how can I stop double bookings

    Hello,




    I work across a number of small venues which have art cases that can be booked for displays. I am trying to build a simple data base to report what space is available and also what art is currently being displayed. The art is usually booked by month, but sometime it can be booked for a week etc.

    I have set up 3 tables

    Art Inventory

    Art Cases by Venue

    Art Case Bookings

    In the art case booking form, I have set up the start and end date but I cannot figure out how to avoid double bookings of a case? Once I have that worked out I believe I know how to build the required reports for my needs.

    I know there are number of other posts about this sort of database but I am self taught and get totally lost when people start posting code. I've attached a copy of my database to this thread.. if anyone could help that would be amazing!!

    thank you
    Francis

    Art booking system for venues.zip

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I realize this is your first post here. But for reference, when you cross post, you should inform the readers that you have done so, and identify the link to the cross post.
    In this case:
    http://www.access-programmers.co.uk/...=1#post1265032

    Rationale: http://www.excelguru.ca/content.php?...-cross-posters

    Bottom line: Cross posting/multi posting is fine, but do have the courtesy to advise the reader and display the associated link(s).

  3. #3
    carlgoro is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    2
    No worries -thank you. I did not know if i'd get any replies so I tried putting my question in a couple places.

    Sorry for any confusion!!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Booking system form
    By pelicanbuyer in forum Forms
    Replies: 1
    Last Post: 05-11-2013, 08:13 AM
  2. prevent double booking!! help!
    By Jean-Daniel in forum Access
    Replies: 5
    Last Post: 05-16-2012, 06:09 AM
  3. Double Entry System
    By mkc80 in forum Access
    Replies: 3
    Last Post: 04-27-2012, 03:53 PM
  4. Help with making airport booking system
    By matthewjones108 in forum Access
    Replies: 3
    Last Post: 03-13-2012, 08:10 AM
  5. cascading combo boxes stop working in DAP system
    By James Brazill in forum Forms
    Replies: 5
    Last Post: 06-28-2011, 03:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums