Hello everyone, if anybody could help me I'd deeply appreciate it.
Booking ID = the time when it is booked over the phone
Hiring ID = the time when the event is to be held
Basically I have to make some booking dates, and use January and February 2006 as test data. My only dilemma is it says that the booking dates must not be booked more than 8 weeks before the hiring, and at least 1 week before it. So if someone wanted to the hiring for 01/01/06, then they wouldn't be able to book before 01/11/05, but before 25/12/05. Can anybody help me? Thanks. I need it so that whatever the hiring date is, the booking date has to be no more than 8 weeks in advance, but 1 week before the hiring.
I have a very generic form I use to track all my To Do things on a daily basis. The form has the following fields: fldComplete, fldDueDate, and fldSubject.
The fldComplete is a check box and the fldDueDate is of course a date data type.
What I would like to create is a query that once you click the fldComplete signifying that the task is complete:
1. The record is removed from the form.
2. The fldDueDate advances either annually, monthly, quarterly etc. which automatically goes to the end of the form in sequential order.
I have been struggling with this one a while now and need to throw this open as im Stuck!
i have a database of domain names that I currently own however i need to be able to report on the TLD (eg .co.uk .com. me.uk) part of the domain. in the database the field domain is held in the format "imstuck.co.uk" i need a query that will strip the domain part and just return the TLD in a seprate field.
I have used numvers of functions but cant seem to get the right format for it to work
I have a problem with figuring out how to implement what I call “Paid In Advance”. If a customer pays 4, 5, 6, or 12 months in advance, I for some reason can’t think of how to set this up with tables, queries, forms, and reports. The example that closely matches my db is “Order Entry” from access sample db’s.
Tables are as follows: tblCustomerDetail tblCustomerHistory tblPayments
For every customer (tblCustomerDetail) there are multiple service records (tblCustomerHistory) and for every service record there are or can be multiple payments (tblPayments) for that one service record.
Just like in “Order Entry” where Customers have multiple Orders and then one or many Payments for that one Order. (Pretend that Order Details is in the Orders table.)
The problem that I’m having is trying to come up with a way to assign the “Paid In Advance” money to the customers account without assigning it to a service record or payment. I can’t assign it to a service record because it hasn’t been serviced yet. And I can’t assign it to a payment because the service record generates a new record in the tblPayments when a new service record is entered, and besides that wouldn’t work because the “Paid In Advance” money would only be applied to that one service record.
I hope everyone is following what I’m saying. If anyone has any clue as to what I am trying to do, please feel free to help me. As always any help would be greatly appreciated.
Thanks
P.S. If anyone knows where there is a sample db of what I am trying to do, I would be grateful if you could post the link in your reply.
Private Sub Form_Load() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("select * from tblpatient, dbOpenDynaset) If Not (rs.BOF And rs.EOF) Then rs.MoveFirst Do While Not rs.EOF ' do stuff rs.MoveNext Loop rs.Close Set rs = Nothing End If End Sub
I have watched it step through on debug and it does everything right for the first record, but it seems to come back to the same record.
AutoID : AutoNumber Name: Text RecordID: Number "Long Integer"
I have created a form that aytomatically starts a new record and I have also placed the following Code in the form's module:
Private Sub Form_Current() ' Comments: If this is the first entry then set the RequestID to 1, ' else find the maximum RequestID and add 1 to it.
If Not IsNull(DMax("[RequestID]", "tblMain")) Then Me.RequestID = DMax("[RequestID]", "tblMain") + 1 Else Me.RequestID = 1 End If
End Sub
I have saved the form as a Data Access page but the code doesn't work and I couldn't find a code simialr to that which I can use in my html page?! Maybe I can use ADO to open a recordset ans search for the maximum value but I don't know the exact code and how to write the result back to the recordID field in the html page?
Please could someone give me help on this topic, I need to slove it for coursework in Access but im having the following problem.
Im creating a database for a hotel which rents out its room obviously. The problem i have is if a guest books a room for say march 3rd until march 6th, theres currently no way in which to stop another guest booking the room for any of these dates.
I think i know how to stop double booking for the start day, but not the days inbetween if you understand. The database has 3 tables: Guest Info Room info Bookings
If anyone can help it would be greatly appreciated.
P.S the method i hope to use, is the hotel will enter the start date of a guests stay and then enter the number of nights the guest is staying for e.g. 3rd-6th of march would be input as: Begin date: 03/03/08 for:'3' nights.
I have been asked to ceate a customer booking database for the computer stations and my mind has gone a complete blank. I have all my other tables but just can't think how to do it. I have 10 computers and they are booked hourly, Monday to Friday but each day finishes at a different time.
Can anyone please help I'm suppose to have it done by Monday. :eek:
I am in the process of creating a Room Bookings database using the limited graphical tools of Access 2003. I intend to break up the day from 0700 to 1900 into 48 X 15 minute chunks (the minimum bookable time) and have these graphically represented on the form as boxes whose colour change depending on whether it is booked and who by. It would be normal to have up to 8 colours available for this as any one room would be unlikely to be booked by more than 8 people in one day. I would envisage that each day would be covered by a separate subform.
Has anyone else tried a graphical representation of a booking form?
It would be interesting to hear others views or experiences...
Hi I have a database which uses a form to book appointments, new or existing customers are booked in this way, or not as this case may be. I have designed the form with my three options to book someone in, that are a Date, a Time and the treatment.
My date is taken from tables containing the appropriate dates for any Monday, (No Tues) another table for Weds etc until Sat for the next 4 years My Time is taken from one table containing appropriate times in the day. My Treatment is taken from a table containing a list of treatments.
How can I book an appointment without duplicating dates and times? How can I produce a list of these bookings either daily, or weekly to forward these details via Microsoft Outlook? I hope I am not asking for too much as I have been trying to do this on my own now for a while and have searched the board. I have got this far so I don't want give up now. Many Thanks Bern :confused:
I am wanting to prevent a double booking. I have a form called:
frm_Booking which records an ArrivalDate and DepartureDate
and another form
frm_Building_Booking which records a BuildingID number
I want to ensure that a customer cannot book a BuildingID for an ArrivalDate and DepartureDate it it has already been booked by another cusotmer or book any on the days between.
However a customer should be able to book a BuildingID on the DepartureDate.
For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.
Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:
Any other comments or suggestions are welcome too if there is a better way of doing this.
could someone please help me, i am having a problem trying to get rid of double bookings in the attached database.
This database is for an assignment for my students, and unfortunately i had got the point now that i have got incredbily stupid and cannot see a solution.
I want to make sure that a client cannot double book an instructor and a car on a specific time or date...
Obviously i would also want to make sure that if one client has booked a specific car or instructor no other client would be able to book it, in the same time and date slot.. All lessons are 1 hour long
for some reason i have to make sure that a client can book a specific car... This unit is being taught alongside another unit by another teacher, who does not see the complexities of the problem, and insists that this complexity is in the database, however they do not know the solution either.
I have tried creating different types of primary key combinations, but that does not work..
Any ideas or suggestions would be greatly appreciated
I have been tasked with creating a system for booking instructors with clients. Customers will book in for a lesson which can be anything from 30 mins to three hours long in half hour chunks. There are up to seven instructors available and I need to be able book up to six months in advance and hopefully display a daily screen with a grid showing who is booked out with who at various time of the day. Can anyone suggest some piece of freeware or example database to get me started?
Firstly can i say Hi to everyone on this board amazing I registered today because it took this board 3 search to answer a problem Iv had for 2days now. So big thank you !!
No then Im creating a small website where members are capable of booking the Venue via the website. At the moment my databse consists of Members_tb with attributes
I am hoping someone from this board can help me by shedding some light as to how they would go about empowering a Member to book the venue for a particular date also taking into note not to book for a date the venue is already booked for.
Any help at all will be so much help. Im just confused as to how i should tackle this issue
Consultants need to be able to log-in when they are available and be put in rotation. Agents need to be able to select the next available Consultant. I also need there to be a waiting list. I would like to be able to run reporting on Time on Waiting List, Time with Consultant, etc.
Is there a simple way to do this? I would appreciate if someone could point me in the right direction.
I have been asked to research and then produce a simple seat booking system for a movie showing in a small lecture theatre using MS Access. I'm a relative Access newbie and have had little luck in finding information on how to go about producing this system.
If anyone could provide or link me to anything which could be of use that would be great.
I have created a database to take bookings for holiday properties but can't figure out how to stop the properties from being booked over the same period. I have a table called booking order with the fields Booking no, property no, start date and end date. On the equivilant form for a property i need to be able to stop start and end dates being entered that are between existing start and end dates already booked for that property.
I have been trying to develop a system by which a air flight company can book seats on a plane for passengers. I am having the problem with one of the requirments though, in that I cannot figure out how to display all the seats on a flight, as well as the ones that have already been booked. This is required so that a form can be created for the user, so that they can give information back to customers on whether there is availble seats of their class type or not. I have attached the database with this thread, if anyone could be of any assistance, it would be greatly appreciated. Andi.
I am going to do an online airline reservation system, and the database is going to be done using MS Access. The database contains 4 tables: Customers, Payments (Credit Card details), Booking, Flight.
Can someone help me do the relationships among the tables. My personal e-mail is russcami@yahoo.com.
On Microsoft Access 2010, I am creating a database project for a DJ booking system (not for professional use) and wondered how you can stop double booking from occurring that would provide you with an error message that I could personalize.
My current booking file looks like this:
Booking ID - Primary Key Customer ID (Linked to customer table) Venue ID (Linked to venue table) Date Booked Set Up Time Start Time Finish Time Party Type Discount Code
At the moment I have the date booked as Indexed (No Duplicates) however this gives me a long error message that I can not personalise.
When a customer makes a booking, all I need to do is check that there is less than 20 cats in the cattery for every day of the customer's intended visit range. This isn't the same as a car-hire system where if a car is out for one day during the intended hire, then the booking can't be made - it doesn't matter which pen a cat is put into, as long as there is a pen free for each day of their visit.
i.e. a customer wants to hire a ford escort from 1st-10th january but it is already booked for the 9th onwards - the booking can't be made.
a customer wants to put their cat in ANY pen from the 1st - 10th so it just depends on ONE pen being free for every day of this visit.
Any suggestions? My teachers are hopeless and I need to have implemented my system by 20th January!!! :eek: Thanks, Jayce
I'm making the most simple DB where there are bookings consisting of a StartDate and EndDate. The Scenario is a car hire firm. Obviously i don't want to be able to double book a car and want to be able to list all cars available within the two dates (input).
I have set the defult input to 12/07/04(StartDate) and 12/17/04(EndDate) for the purpose of testing.
I have created a query to find all cars which are not available in relation to the input dates, but cannot get it to list the available cars!
SELECT CarDetails.CarReg FROM CarDetails INNER JOIN BookingDetails ON CarDetails.CarReg = BookingDetails.CarReg WHERE (((((([BookingDetails].[StartDate])<#12/7/2004#) And (([BookingDetails].[ReturnDate])<#12/7/2004#)) Or ((([BookingDetails].[StartDate])>#12/17/2004#) And (([BookingDetails].[ReturnDate])>#12/17/2004#)))=False));