markymark34
Last Activity: Feb 27 '07, 10:35 AM
Joined: Nov 28 '06
Location:
-
Sorry didnt explain myself well. You code is spot on and when you click on the combo box the right records are there. The problem is that when the form is loaded it says #name in the combo box and i cant get rid of it!... -
working well and this next bit seems like such a minor problem but the combo box always says #name? in it and no matter what i do i cant get rid of it!!
im sure its very simple...Leave a comment:
-
spot on cheers....Leave a comment:
-
SQL Query in a form
I have a form that allows examiners to be assigned to a particular centre.
So for example i have 10 examiners who all examine different subjects and i have 5 centres one of which is doing an exam in maths. What i want to do have a combo box on the Centre form that only shows examiners that can actually mark that subject(Subject _Ref_Code),
I have SQL that works
...Code:SELECT tblExaminer.Examiner_Number,
-
Ive got a headache!
Am i going about this the wrong way?
essentially all i want to do is provide a list of non booked rooms so that the person on reception can see which are available. Would it be easier to do some coding withing the booking form? For example to only display the rooms that are free during that date period?
the current code i have before update is.
If Me.NewRecord...Leave a comment:
-
thanks for your help NeoPa but it still brings back 0 results.
I tried doing a 'weekly booking query' first then an unmatched query but that didnt work either.
Think i might give up!...Leave a comment:
-
When i change it to an or it gives me rooms not booked or any rooms booked after today.
Maybe im approaching this from the wrong angle?
All i want to do is be able to print out a list of rooms that do not have a booking for say the next week.Leave a comment:
-
my sql is
Code:SELECT tblrooms.Room_Number, tblrooms.Room_Type, tblrooms.Room_Price_Id, tblrooms.Additional_Notes FROM tblrooms LEFT JOIN tblbooking ON tblrooms.Room_Number = tblbooking.Room_Number WHERE (((tblbooking.Room_Number) Is Null));
when i add date
...Code:SELECT tblrooms.Room_Number, tblrooms.Room_Type, tblrooms.Room_Price_Id, tblrooms.Additional_Notes FROM tblrooms LEFT JOIN
Leave a comment:
-
cant get that to work it just doesnt give me any results.
It works fine normally but as soon as i introduce date it stops working.
any other ideas?
thanks
Mark...Leave a comment:
-
Sorry for delay in responding
ADezii
you are great!
thanks that is spot on!
Is there an easy way i can modify that to only look at a certain day/date?
In the bookings table i have a field Bookingstartdat e? I tried >date() but that doesnt work. I understand why it doesnt work but not how to fix it!
many thanks
MarkLeave a comment:
-
Query to find available rooms
thanks again for the quick and excellent response to my last question.
Im nearly finished my mini project now and have got stuck on a way to print out a list of rooms that are not currently being booked.
I have a table
tblbooking which has in it a booking id (Auto number), cutomer ID and RoomID (from the tblroom table)
And tblroom which has RoomID roomPrice and Room Type
and what i want... -
yes thanks
was me being silly!Leave a comment:
-
excellent cheers.
only probelm is this wont catch bookings made at different dates eg
room 101 - booked from 1st dec - 5th dec
room 101 - booked from 2nd dec - 4th dec.
ive found the function DateDiff() but im not sure if its going to help?
thanks
MarkLeave a comment:
-
Hotel booking (double bookings)
Im messing around trying to learn Access and have hit a problem.
I have a table called tblbookings and i want to seach though it when trying to make a new booking to make sure the room isnt alrady booked.
In tblbookings i have a room_number, booking_start_d ate and booking_end_dat e
Ive tried all sorts of code but it either brings up an error or doesnt do anything at all. Hoping someone can help.
...
No activity results to display
Leave a comment: