Architects room data sheets

I have produced all my tables for my room data sheets (I only have 2, one for general room information which contains unique text or yes/no check boxes and the second for equipment whichwill be within each room) but I am now a little stuck with the room information input form (my main form which will allow users to input the data for each room and add or delete existingrooms).

Within my room information input form I have the room number and name at the top and have tabbed pages for each section of the room data sheets, piped services, wastes, power and comms.etc.I haven't had any problems setting these up so far and all seem to work fine.

I now need to add the relevant equipment which will be within each room. I have created a separate table for each piece of equipment with the relevant information eg name, manufacturer, size, required services.etc.

I would like a tabbed page within my room information input form which produces a drop down list where I can select a piece of equipment (from my equipment table) and type in the quantity of that piece of equipment within the room, once I have selected a piece of equipment I want it to produce a second drop down list where I could add a secondor third if required.

Currently when I insert the table it does just that and gives me a list of all the items within my equipment table. This tells me I should not be importing the table but I'm not sure what ineed to produce (table, query,form)

Sponsored Links:

Related Topics

Query based report question - run report on one record
So I have 3 tables in my DB, Estate, Room and Item. Every estate has multiple rooms, each room has multiple items. I have made acceptable data entry forms for my employees using split forms/nested data sheets. I have record navigation button that switched the estate the user is viewing.

I want a button to create a report for the estate at hand. This report will show the items in the estate, grouped by room. I have the report showing what I want, but the problem is that it is reporting on all estates - not just the active one.

How can I do this? I am trying to keep this as user friendly (least amount of typing/ideally just a single button) as possible.


Primary Keys
I have three tables in my database but have chosen the wrong unique identifiers: This is what I have come up with so far.

Customer: (Customer ID, Last Name, First Name, Contact Number, Email) Key: Customer ID
Room: (Room ID, Room Name, Phone Number, Equipment, Disabled Access, Capacity) Key: Room ID
Booking: (Room ID, Customer ID, Subject, Booking Date, Time) Key:Room ID & Customer ID

The customer needs to be able to book the same room in the same day at a different time but this is leading to the Room ID being duplicated and this is the primary key.


VBA count sheets excel from Access
Excel.Application.ActiveWorkbook.Sheets(Sheets.Cou nt) doesn't work gives Method of sheets error


Data Model Example: Hotel Room Booking Scenario
The following data model is designed to hold information relating to a Hotel Room Booking System.
For this scenario we need to define the following facts:
These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.
A local hotel needs a system that keeps track of its bookings (future, current and archived), rooms and guests. A room can be of a particular type and a particular price band. Room prices vary from a room to a room (depending on its type, available facilities, band, etc.) and from a season to a season (depending on the time of the year).


Queries by table data
I am new to the world of Access and I'm trying to work my way through it. I am stuck on, honestly, quite a number of things and hoping someone could help me out. All I have saved in the file is table data (about a hotel, dates, type of room, etc) and I am trying to create queries that determine average length of stay based on room type, average number of visitors per room type, base income per room, strongest customer base, etc. I am completely stuck on how to run a query for the first request (average length of stay based on room type.

I am pretty familiar with excel and what I would have done was determine the # of days based on the arrival/departure date and then run an averageif function for each room type. I don't know what to do with access though


Queries by table data
I am stuck on, honestly, All I have saved in the file is table data (about a hotel, dates, type of room, etc) and I am trying to create queries that determine average length of stay based on room type, average number of visitors per roomtype, base income per room, strongest customer base, etc.

I am completely stuck on how to run a query for the first request (average length of stay based on room type.

I am pretty familiar with excel and what I would have done was determine the # of days based on the arrival/departure date and then run an averageif function for each room type. I don't know what to do with access though.


COmpletely confused about doing calculationsin queries
I have a small table for a hotel with 30 rooms.3 room types. I have to find out:

1. The average length of stay per room type
2. The average # of visitors per room type
3. The base income per room length of visit x daily rate) during a specified period of time (a single month)

I have the following fields:
First Name
Last Name
Room Name
Room Type
Arrival Date
Departure Date
# Guests
Daily Rate

I have been able to do a query including the room type, arrival and departure dates.

I have been doing a bunch of online learning for access but it is not helping. Maybe I am taking the wrong online courses. Can anyone help me to understand how to make calculations and where they are placed in a query


Format info on form by type
There is a query or table that has all data as seen in the pic. The pic shows form dividers which essentially partition the form by room. My clunky idea is to create several subforms. Each with a room header and then a student detail section. Each subform will have to have a query based on the room.

Each form can grow or shrink and maybe even not be visible (no students in room 56). Size and presence of the subform could be detected and subforms placed and positioned.

Reports have an excellent solution to this with a group by option. No option exists for forms.


Date and time serch
and im no vb pro too), SOooo Im stuck in a project! here it goes

I have a two tables
1 Rooms
---------------------(holds room details)
Room no
Room type

2 Reservation
--------------------(Holds reservation)
Room No
Start Date
Start Time
End Date
End Time

from this I like get the reservation detail mostly notreserved details
like: if a room reserved
2007/06/05 12:00 to 2007/06/07 13:00
this room shuold not apear in the serch query results (if I serched for free roms
between 2007/06/05/ any time to 2007/06/06 any time


Download Excel sheets into contacts
I am new to the 2010 version and I am working on downloading contact sheets from excel into access. The download is complete and I see all the sheets and can filter, but my contacts page is still empty. How do I get the contacts from the different sheets into my contact list?


Crosstab query to return the items list
I have a database of light fixture symbols/identifiers, I.e. E01, E02, etc. The table contains other information about the fixture. In this table I have created a string to store a list of locations.

I have another table with records that contain a room property as well as the light fixture key. So for example, a series of records could be:
E01 - living room
E02 - living room
E01 - dining room
E03 - kitchen
E01 - kitchen

The tables are linked and I want to create a report that shows all the light fixture data, including a list of all the rooms in which that fixture is used.
Example:
E01 - living room, dining room, kitchen
E02 - dining room
E03 - kitchen

I created a crosstab query that shows the quantity of each light fixture in each room, but I can't figure out how to use that to get what I want.
Ideally, all I want is a string to use in a report, but I'm not sure how to get it.

I think I've just gotten too bogged down in the problem.


Conversion from Excel to Access
I have a document that I am wondering if it can be converted into an Access database, how easy it will be, and if it can retain the same functionality as my current book.

Let me first explain the Excel workbook.

The book is full of formatted "documents" used to standardize our consulting process. The first couple of worksheets are data input areas,

Every sheet "pulls" information from another sheet, and some sheets have multiple sheets that they pull data from.

Some sheets are simply contracts that can be printed and most have calculations built in.


Prevent double booking!
I'm doing a project on a database system for room reservation, in the booking table I have the booking id, room name and client id, and the date in and the date, out how would I do to ensurethat when I'm booking a room on a certain date in and date out, the room is available and not booking?


Function max in update query in access
I tried to get the max date value, but I got an error - Cannot have aggregate function in WHERE clause (((Room.status)="free") AND ((Max([Reservation.date_checkout]))>=Date()));

Code: UPDATE Room INNER JOIN Reservation ON Room.id_p = Reservation.room SET Room.status = "occupied"
WHERE (((Room.status)="free") AND ((Max([Reservation.date_checkout]))>=Date()));

I also tried something like that, but without any luck:
UPDATE Room INNER JOIN Reservation ON Room.id_p = Reservation.room SET Room.status = "occupied", date_checkout = (SELECT MAX(date_checkout) FROM Reservation)
WHERE (((Room.status)="free") AND ((Reservation.date_checkout))>=Date


Msg to pop-up if a form has been updated?
The database is used in room 1 to enter a job request and the other room 2 guys will be complete the job request. What I need is when a new job is entered in room 1 that a msgbox alerts a new job has been entered in room 2.

The form has a requery every 1min but I only want the msgbox when a new job has been entered. I have tried putting the followingin the Afterupdate but this is not working? The Macro is just a msgbox.


Replacing and Adding Data
I have 4 Excel sheets that feed into 1 database. From there, I have been able to create multiple queries and develop 1 table with data from all 4 sheets. My problem arises when data is updated (new address, open issue changed to closed, etc.) or new entries are added. How can I get my database to search for updates from the queries and correct the old entries while adding the new?


Excel / access report question.
An introduction first.

Im Paul, work as a Lab technician in a food lab. We are just going through ISO 17025 accreditaion.
Ive built and maintain an access database but it is by no means my area of experise.

I have been given, a small task to create a basic access database for sample tracking.

My problem is, we have been keeping our records on separate excel sheets. Given the amount of information on these multiple sheets, it is not feasible to migrate this data into access.

The question I was going to ask is :- Can I create a field with a hyperlink to one of my excel sheets, which would print off as, maybe sheet two of my report?
The other fields within the database would be minimal; it is just a reference number tying together a few excel sheets


One selection force another selection
I am learning how to use Microsoft Access,

I want to allow the user to select a site which in turn will allow them to select a room within that specific site.whether I need two separate tables, one table with two fields, or how I need to relate the data.

Example:

Site 1 has rooms 3, 4, 5, & Office.
Site 2 has rooms 1, 2, 6 & Storage.
Site 3 has rooms 8, 9, 10, Office 1 & Office 2.

If the user chooses "site 1" then they are called to select a room contained within site 1.

The form would have two sections: Site & Room The user would have to select the site and then choose the room.


One selection force another selection
I want to allow the user to select a site which in turn will allow them to select a room within that specific site. I'm not sure how to organize the information.whether I need two separate tables, one table with two fields, or how I need to relate the data.

Example:

Site 1 has rooms 3, 4, 5, & Office.
Site 2 has rooms 1, 2, 6 & Storage.
Site 3 has rooms 8, 9, 10, Office 1 & Office 2.

If the user chooses "site 1" then they are called to select a room contained within site 1.

The form would have two sections: Site & Room The user would have to select the site and then choose the room


transfering data from different queries to on excel file in different sheets
I m access user. I have made some queries. & want to transfer data from different queries to on excel file in different sheets. I have tried transfersheet macro. but. it transfers with one inverted coma in text column. due to this the data exported to excel is no use to me. as I m not able to upload the same to another application or even apply vlook in excel which is my basic purpose for doing this entire thing