Tables :: Avoid Double Bookings In Simple Database?
Jun 7, 2013
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 am supposed to make a database for a hotel system, how I could prevent double bookings.
My Reservation Table has the following fields:
Reservation No. (PK) Room No. (FK) Customer ID (FK) Payment ID(FK) Reservation In Date Reservation Out Date
Together with preventing double bookings is there a way automatically that can mark in the Room Table, the status as "available" or "booked" automatically by looking at the date today?
I have a form which allows the user to book rooms.
On this form, there are the following fields:
BookingID: (Autonumber) RoomID: Text box Time:Text Box Date: Text Box Class: Text Box Teacher: Text Box
The form adds this information to the Booking table.
What I'm looking to do is prevent the user from double booking a room,like being able to check if the Room is already booked at that time and date, before the new information is added to the table and the room becomes double booked.
Basically this would be checking the RoomID, Time and Date fields, as everything else is irrelevant. What would be the best way to do this?
2 tables in an Access database tblPurchases: columns: Index (PK-autonumber)| Store| Product| Cost data: 1| Staples | Tape | $0.89 2| Staples | Paper | $4.50 3| OfficeMax | Markers | $3.50 4| OfficeMax | Paper | $4.75 5| OfficeMax | Pens | $1.98
tblInfo: columns: Index (PK-autonumber) | Store | Product The data in the access database tblInfo.Store is queried from tblPurchases.
Here is the query for the rowin my database design view:
SELECT DISTINCT tblPurchases.Index, tblPurchases.Store FROM tblPurchases;
When I am in the database and access the column's pull down, I get ALL records, including duplicates (so OfficeMax is listed 3 times.) How do I get it so I only see Staples OfficeMax in the pull down when in the database?
Ok. I have tables vinculate to ORACLE, the primary key of Oracle is double, from Access of query return one number rounding 1,00000902026541907589E+20 this is the problem, in query i have this funtion: IIF(isnull([CAMPO1]);[CAMPO2];[CAMPO1]) this return one number ok field(CAMPO1) and other bad(CAMPO2 it's rounding). I need that return this query two doubles. example:
bad - 1,00000902026542E+20 = 100000902026542000000 ok - 1,00000902026541907589E+20 = 100000902026541907589
i already make this sql for dlookup table for may insert button, all going good, but when i'm going to make double command with different msg box for different criteria, it going fail
1. This my Working code:
If Me.txtidborang.Tag & "" = "" = (DLookup("NoGerankod", "HutangKeseluruhan", "NoGerankod='" & Me.txtnogeran & "'")) Then MsgBox "Grant Number Invalid", vbOKOnly Me.[cbostatuspembayaran] = "Geran Negatif" CurrentDb.Execute "INSERT INTO Januari (bla..bla..bla..) End if
2. This my not working code:
If Me.txtidborang.Tag & "" = "" = (DLookup("NoGerankod", "HutangKeseluruhan", "NoGerankod='" & Me.txtnogeran & "'")) Then MsgBox "Grant Number Invalid", vbOKOnly Me.[cbostatuspembayaran] = "Geran Negatif" If Me.txtidborang.Tag & "" = "" = (DLookup("NoMatrikkod", "HutangKeseluruhan", "NoMatrikkod='" & Me.txtukmper & "'")) Then MsgBox "This Student still have debt ", vbOKOnly Me.[cbostatuspembayaran] = "Geran Aktif"
CurrentDb.Execute "INSERT INTO Januari (bla..bla..bla..)
End if End if
Q: How can i combine two dlookup together for different msg box?
For some reason I cannot enter decimal values without the number rounding up or down. I've already set it to 'Number' and 'double' and have also tried 'Fixed' set to 2 decimal places. Right now the only way it works is if I set it to 'Text'. However I need to do some calculations with these values eventually.
What's strange is I have another table in the same database that is NOT rounding and is working just fine.
I have a form that utilizes a combo box with 2 options: 0 & 0.5. If I select 0.5 on the combo box the field in the table records it as 2. Why doesn't it reflect as 0.5? And how do I fix it?
This is the general info that I have for the field properties:
Field Size - Double Decimal Places - 1 Default Value - 0
im making a system and part of that system is the booking of the library
2 classes can be in the library at once i want a way where if a 3rd teacher tries to book a slot then theyll be told its not available if only one class was allowed itd be easy, by using a compound key but cos 2 classes are allowed this is a bit hard for me lol trying to think of a way to allow 2 bookings but not more any ideas? thanks
I am trying to create a query that will count the number of bookings in january and a seperate count for the number of bookings in february from a table called booking order. im using the start date as the date to tell which month the booking was in. This is what i have come up with but it doesn't work and i am not to sure where to go from here. select count(jan.[booking no]), count(feb.[booking no]) from [booking order] jan, [booking order] feb where jan.[booking no].[start date] > 31/12/2006 and < 01/02/2007 and feb.[booking no].[start date] > 31/01/2007 and < 01/03/2007;
I would like to display a page that tells the user that there are no "bookings" for TODAY. It is a restaurant booking database which I have nearly completed. When there are bookings for TODAY, it shows a table with the customers booked for today (that's working ok), but if there aren't any for 'today' when I open that page, it just shows the headings of the table with no customers. I'd like to just display a message (and no table elements) when there aren't any bookings for today. Pretty confusing explanation? sorry bout that.
Could someone check the following code. i've set up a form for creating regular bookings, and have a field, for which you type in the frequency in days you want the bookings for. (ie, 7 days for every week on that day, 14 for every two weeks etc...) and it seems to work, however it just alters the one record, instead of creating entirely new ones. Could someone please help:
Private Sub cmdCreate_Click() Dim date2 As Date Dim period As String Dim cost2 As Currency Dim frequency2 As Integer
Do While year = actual_year
date2 = Date_For period = Time_Period cost2 = Cost frequency2 = Frequency
Date_For = date2 + frequency2 Time_Period = period Cost = cost2 Frequency = frequency2
DoCmd.Close acTable, "tblRegularBookings" Loop
End Sub
Also, one of the other problems i'm trying to solve is for those who want to create a regular booking but on say every third monday of the month for example.
I have Trainee, Staff, Course, and Booking tables and forms. Everything is working fine but I want to limit the amount of bookings per course to 50, how would I go about doing this?
I want to create a calendar to show some bookings. I have a table [tblShootDates] with some fields, the most important being [ShootDate]. I also have a [ShootDateID] which is an Autonumber and is the Primary Key. I should add that it has a Prefix "Shoot ID" 000000.
I want the calendar to show each day that a booking has taken place and the text to show is the [ShootDateID]
Hello. I am trying to create a database where I can enter contributions from members of my church, in order to give them report at year's end. We are small number, about 70, but we collect offerings every Sunday. I tried on my own, but did not achieve much. I searched about many-to-many and many-to-one, but still don't get it right. Can someone help me with the simple structure and I do the rest? I use person's information (name, etc), amount given and date of offering. Thanks in advance.:confused:
I'm building a simple time sheet database for a friend of mine.
I know that im going to have trouble checking there amount against the tax table and taking there tax out to finalise the amount they would actually get.
So basically im an intermediate access user, how would i get the database to do this when i press like a calculate tax button..???
I am trying to figure out how to setup my tables. The tracking system i am trying to create will have these information: the Tables will contain these information
- Package number - Received date - Sent date - How long have we had the package - Status (Sent or Pending)
I will also need to figure out who received and sent the package - Employee name
Please advise if I setup the tables correctly.
I will also need to query these info: - all packages received 3 days ago - how many packages an employee received and sent - How many sent or pending
Ive just started creating the table..and Ive put fields like name/address etc as text but there are a few fields that need you to select an option...so i want to use the "lookup wizard" to create a listbox or combo box dont know which is best.. BUT the problem is when I select lookup wizard it says "unable to start lookup wizard. The lookup wizard doesnt apply to fields of this data type".
Im not that expert in access programming, still have some more learning to do. anyway, my goal is to make a simple login form with a database of its users. How do I code it. The structure of my form is it has 2 unbound txtbox and 1 command button. A user will input its username and password then when the command button is clicked it will validate the user table if the data encoded is in the database. Thanks hope u can help me.
I want to create a simple database so that I can enter childrens names and then add dates to these that they will be attending our Breakfast Club. Out of this I want to be able to create a daily register of children.
Hello All, At work we have a large and messy Contacts list so I decided to set one up using a database. At present I have 3 tables:- Companies (custID,companyname,address,etc) People (nameID,firstname,middlename,lastname,custID) Phones (phoneID,phonetype,areacode,number,?????)
My problem is this, Some of the phone nos belong to the individuals and some belong to the company. If a person is replaced at a company I need to reasign the company phone nos to the new person whilst retaining the individuals and their personal phone nos. If a company is deleted I need to delete only the company phone nos. and if a person moves within the company I want the company nos to reasign to the new replacement but keep the personal nos of the individual. Now I see its going to be more complex than I thought.
Can anyone help me with the table layout and links. (nb this is only a simple database relating a person to a company without using departments etc.) Its main use is to provide phone nos names and addresses quickly. Many Thanks Peter
