Visual Basic
i have made a hotel booking system that manages an indefinite no of rooms. i want to impliment a reservation system making sure that at any one day the no of Guests in a room doesnt exceed the maximum allowable per the room any help with this will be greatly appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

How you would implement that depends almost entirely on the tools you used to build the system. What did you use?

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • This213
    >From: isaac2005 >To: this213 >Date Sent: 05 Oct 2005 >Subject: RE: Hotel Reservation System > am sorry i forgot this am using vb 6 and ms Access database. The very first thing you should do is convert the access db to MS SQL. Otherwise, you're going to reach your size limit VERY quickly. Without actually seeing your code (and there shouldn't be any reason for me to), you should be able to use most of the routines you already have for the booking system to manage the rooms over periods of time. I'm guessing you already have something built in that maintains when people are checking in and checking out - just take that a step further and do "virtual" check ins and outs for future times.
    0 pointsBadges:
  • DaveInAZ
    Well, I don't agree that switching to SQL Server should be the FIRST thing Isaac should do. He may need to, at some point, but I think it makes more sense to complete the app design first, and not get sidetracked by what, at the moment, is a moot point. It doesn't matter what the back end is if the app doesn't work. As for the main question, it's still largely a matter of guesswork for anyone to offer a solution, because we have no idea what's in place. But, it's probably safe to assume that Isaac has a CheckInDate field and a NumberOfNights field (with his own naming convention, of course). If he does, all he needs to do to avoid booking the room to multiple unrelated guests is to compare the CheckInDate field of each against the other using DateAdd("d", NumberOfNights value, CheckInDate value). The return value gives him the checkout date, and he can do the comparison easily enough using "greater than" and "less than". But, another way of interpreting his question, which is kind of vague, is that he's concerned about exceeding maximum occupancy of the room on any given night (a genuine concern during many conventions and at hotels frequented by migrant workers). For that, he simply needs to add a field to the room table for MaxOccupancy, and one to the booking table for NumberOfGuests, and compare the two. Then hope the guests are honest. ;-)
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: