Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2011
    Location
    Near Cabo San Lucas, Mexico
    Posts
    3

    Unanswered: Determining room availability in hotel reservation db

    I am writing an access database for hotel reservations and am having a problem with the code to determine availability of rooms when the only information is arrival date, departure date and days of stay. Can you help me with the MS Access code for determining the dates in between the arrival and departure dates for availability? Thank you.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2011
    Location
    Near Cabo San Lucas, Mexico
    Posts
    3
    Thank you for that link. I will need to wrap my mind around it a little, but I think I may be able to work it out.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Here's a couple of links to hotel management Access DBs, complete with source code:

    Hotel Reservation System in MS Access | Free source code, tutorials and articles

    Example Relational Database Data Models | Database Solutions for Microsoft Access | databasedev.co.uk

    I'm not really familiar with the source on the first link, but Databasedev.co.uk is a good, reliable source!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Dec 2011
    Location
    Near Cabo San Lucas, Mexico
    Posts
    3
    Thank you. I checked those out and appreciate the reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •