Hotel Occupancy FormHelp?
Jun 22, 2010
it's not perfect but, I am terrible when it comes to calculations... what am I doing wrong? ;-;
' This procedure calculates and displays each floors occupancy rate.
Dim intCount As Integer ' Loop counter
Dim decoccupancy As Decimal ' occupancy rate
Calculate the occupancy rate for each floor, the total of all occupancy rates , and the total rooms occupied.
[code]...
it's telling me to divie the number of rooms by the occupied rooms... 18/30 = .6 or 60% and the hotel has 240 rooms
View 8 Replies
Jul 6, 2011
The program is a hotel occupancy form The Hotel has eight floors and 30 rooms oneach floor. I'm supposed to create aapplication that calculates the occupancy rate for the hotel. Theoccupancy rate is the percentage of rooms occupied, and may becalculated by dividing the number of rooms occupied by the number ofrooms. For example, if 18 rooms on the first floor are occupied, the occupancyrate is: 18/30 = .6 or 60%. The form has two out labels called totalrooms occupied and overall occupancy rate that holds two output text boxes todisplay the numbers
its only three buttons Calculate report,close, and exit Its obvious what the exit buttons issupposed to do the clear button should clear all the controls on the floor
Now the complete report button is supposedto loop and iterate eight times. Each time the loop iterates, it should displaya input box for one of the hotel floor. The input box should ask the user asksthe user the user to enter the number of rooms occupied on each floor. As theuser enters a value for each floor, the loop should calculate the occupancyrate for that floor and display the information for that floor in a list box.When the number of occupied rooms has been entered for all floors theapplication should display total number of rooms occupied an overall occupancyrate for the hotel. (the hotel has a total of 240 rooms total)
[code]...
View 6 Replies
Oct 29, 2009
The hotel has 8 floors and 30 rooms on each floor. Create an application that calculates the occupancy rate for each floor, and the overall occupancy rate for the hotel. The occupancy rate is the percentage of rooms occupied, and may be calculated by dividing the number of rooms occupied by the number of rooms.When the user clicks the "Complete Report" button, a loop should execute and iterate 8 times. Each time the loop iterates, it should display an input box for one of the hotel's floors. The input box should ask the user to enter the number of rooms occupied on that floor. As the user enters a value for each floor, the loop should calculate the occupancy rate for that floor, and display the information for that floor in the list box. When the number of occupied rooms has been entered for all the floors, the application should display the total number of rooms occupied and the overall occupnacy rate of the hotel.I have some of the code but I'm not sure which way to go now!
[Code]...
View 14 Replies
May 1, 2011
I made a hotel quote form where I want to add a discount box where the user can enter a percentage discount off the total price. What is the code to do that? [code]
View 11 Replies
Nov 29, 2010
Create an application that calculates the total cost of a stay in a hotel If the check in occurs in November-March the rate is $89/night. April-August is $99/night and September-October is $109/night. $10/night should be added if more than 2 people are in the room. More than 4 people are not allowed in the room, and a traveler can only request 1 room. A 15% tax should be added to the room rate and 10% tax added to all room service and other charges. No tax will be added for phone charges.
The program should use a function to calculate the total charges for the visitor's stay and output it to a label. There should be buttons or menus to calculate the total, clear the form, and exit the application. At least one of the button should call a sub procedure which performs its function. [Code]
View 1 Replies
Mar 18, 2009
how tell availabilty of rooms .I am having a hotel reservation system just wanna ask if how can I show that the rooms is occupied or not by using a label for the rooms
View 2 Replies
Aug 27, 2010
I need to make a small programm for ticketing on a parking for a small hotel.So i have 2 Printers pariking In (for delivery of the tickets) and 2 Readers PArking Out.Both Printers and REaders are working Serial.So i need to poll the serial ports of the printers and readers every second.The data is stored on a SQL database so i need to read and write in the database.Can i do this with 1 PC and 1 programm or 1 PC and 4 programms that are runnning at the same time ?
View 2 Replies
Jun 22, 2010
I have created a hotel booking system programme. However, I am puzzled as to how when the booking button is clicked it can search a database and find the best suited room (RoomType) and make sure that it is available (Date of Departure < system.date).
This data is held in two tables (Access):
Booking:
BookingID (Primary Key)
CustomerID (Foreign Key, Table:Customer)
Date of Arrival (Date)
Date of Departure (Date)
RoomID (Foreign Key,Table:Room) Room:
RoomID (Primary Key)
RoomType (Text)
RoomPrice (Currency)
Floor (Number)
This has all got to be done within a single button click. Any ideas as to how I can place this into my vb code?
I have a rough query for picking a room that is best suited:
Code:
SELECT roomID
FROM Room INNER JOIN Booking ON Room.RoomID = Booking.RoomID
WHERE Room.[Room Type] LIKE '" & Room_TypeTextbox.Text & "'"
AND Booking.[Date of Departure] < Now()
I have been trying for a while to get it to select a single matching record as there is a high chance that this query will return multiple records but im unsure on how to deal with that.
View 16 Replies
Nov 17, 2010
I am trying to bind a data table to display column "occupancy" inside of combo box "Wall1occ" I must admit I am very out of practice with my VB coding. Here is my code:
[Code]...
View 8 Replies
