Search results

well it looks like i have opened a can of worms here, but i happy to say that it now works perfectly. my two pennenth worth on the >0 >1 issue now that i have it working in practice is quite simple. >0 will work if i am creating a new record, but not if i am amended a record, however the >1...

being thick again i think i am being thick again. my subform is in datasheet view, so all bookings are shown for that client. so where would the before update be attached to? I am not sure what the difference between the >0 and >1 will be though. i'll do it and give feedback.

thanks guys (and any girls) need to respond to a few points first, my first error message was created because like an idiot, i was testing it on a record that had already existed, thus dcount would =1 when creating a new record, this works fine. ish i have put in some code which i think...

well, i have inserted that code without the "_" because that would not work, and i have inserted the code into the pickuppoint field, by putting it here its assumes that the user has inputted information into all the relevant fields, therefore meaning it can actually error check, if the code...

sorry guys(and girls?) but you have totally lost me, i have renamed time to timebkn, and date is now datebkn. but it still does not work. this stuff about the delimters has totally confused me. the more i think about this the more my brain forgets what i know about vba and access. can someone...

Date and time good point about the date and time fields i'll change and see what differences that makes, could it be as simple as that? if i am being honest i quickly knocked up this database in a few spare minutes to see how simple it would be to make...and to prove a point about a...

been fiddling with it After reading around this and other forums i have come up with an idea. ' checking for set of double bookings in turn using elseif ' checking instructor for double bookings If DCount("*", "[tbl_bookings]", "[instructor_id] = " & Me.[instructor_id] & "[Date] = " & Me.[Date]...

hadn't realised that lookups were such a problem hadn't realised that lookups were such a problem. Not all the fields are lookup, just instructor_id and car_id. The time lookup is just a glorified value list. i would also like to make sure that a client could not double book themselves with...

Here is the database must have been a network issue, i was sure i had uploaded it, i did zip, and compact and repair the database

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...