Recent content by egyptian_prince

how to display number of seats left!!! Hello folks! ive got a question! i have a database for a coach company. there a several forms but i am focusing upon two! these are the Booking form and the Coach table. the reason y these two are focused upon is because the Booking table has the number...

so in theory, this would be typed in the validation rule properties section on the form or table design? and secondly will it look like this: SELECT DateOfOrder FROM tblBookings WHERE DateOfOuting = ' " & DateOfOrder & AND OutingID = & OutingID & is that correct? also could recommend any...

No duplicate records!!!!!!!!!!!! I have another enquiry! how would i make sure that the same bookings cannot be booked twice? so for example, Mr John Smith cannot book a trip to Liverpool twice!!! egyptian_prince

there is a problem! there is no BeforeInsert event section! im looking on design view on the form, and there's nothing of the sort! there is BeforeUpdate, and that's the closest one to it that i can find! what would i type in anyway in the field? egyptian_prince

No duplicate records!!!!!!!!!!!! I have another enquiry! how would i make sure that the same bookings cannot be booked twice? so for example, Mr John Smith cannot book a trip to Liverpool twice!!! egyptian_prince

hey jeff, right, ive tried that in the before update for txtDateOfOrder, but the problem is that it rejects all dates, even the correct ones! what do i do now? :confused: :confused: :confused: :( :( :(

in regards to question 1, what would i put in the validation field? im trying: =Date FROM tblOuting.DateOfOuting<Date IN tblBooking.DateOfOrder but there's no joy! no joy at all! get back to me please! cheers!

Question 1: your assumption is correct. each outing has multiple bookings! would i have to change that in order for the dates to work? Question 2: with your advice, i will put into practise now! and i will c how it goes! btw, i don't know VBA at all, im gonna learn that soon! ive got some...

The answer to the question 1 is that the relationship to the tblBooking and tblOuting is the OutingID is a primary key in tblOuting and a foreign key in tblBooking. About question 2, im completely lost! can u be more specific because im new to access! Thanks for the reply! please get back in...

Values relating in other tables!please read..... i have a tblBooking.DateOfOrder and i want to make the date in this field not exceed the date in tblOuting.DateOfOuting ive tried: tblBooking.DateOfOrder<tblOuting.DateOfOuting The second one is that i have created the database, with a...

i need help! well basically, there is two of them! the first one is: i have a tblBooking.DateOfOrder and i want to make the date in this field not exceed the date in tblOuting.DateOfOuting ive tried: tblBooking.DateOfOrder<tblOuting.DateOfOuting The second one is that i have created the...

i need help! hey rich, ive sent u the prob in the email service!!!! sorry, im new to this service!!!! thanks

i need help! rich ive sent you an email, check there please!!!!! thanks!

i need help can u help anyone help me with validation rule's? if so mail me please!