mimehrban1
03-08-2008, 07:51 AM
hey, me again..
just a thought.. in my database, i've got 4 fields in my booking table:
- Minibus Reg *primary key of another table
- Booking Date
- Pickup Time
- Drop Off Time
im sure u've all guessed what this system is about? but, i really need some help figuring out how to make this system, so that u can only book a minibus once at a certain time.
the minibus cant be in 2 places at 1 time.. right?
plleeeeeeaseee helllppppp
ajetrumpet
03-08-2008, 08:40 AM
the minibus cant be in 2 places at 1 time.. right? YES. I would assume that should be right. :p
Anyway, why don't you use the DLookup() function for this type of preventive measure? You can read about it in the help menu. That will tell you what it is used for, and the syntax used for it to function properly.
mimehrban1
03-08-2008, 09:37 AM
Anyway, why don't you use the DLookup() function for this type of preventive measure?
ok.. iv googled it.. (because Microsoft Help always over complicates it :S).. but, im still confused.. how could i use the DLookup() to help me sort my problem? :S (i know you use it to extract certain data..)
sorry, but please could you elaborate please...
The_Doc_Man
03-08-2008, 11:33 AM
You can search this forum for lots of help regarding scheduling, booking, and reservations. All three are valid keywords for which you could search and gets lots of hits.
ajetrumpet
03-08-2008, 12:49 PM
ok.. iv googled it.. (because Microsoft Help always over complicates it :S).. but, im still confused.. how could i use the DLookup() to help me sort my problem? :S (i know you use it to extract certain data..)
sorry, but please could you elaborate please...You don't use it to extract data, you use it to LOOKUP data. What I had in mind was using it to prevent duplicate "time" entries, since you mentioned that issue about a minibus not being in two places at the same time. Say you have a record for a pickup at 5:00pm. If someone tries to enter a record for another pickup at the same time, you can catch it by using DLOOKUP as a preventive measure - i.e. - using it to search the source recordset for the time that is being entered...
mimehrban1
03-12-2008, 09:47 AM
Big Thanks ajetrumpet :)
I used the DLookup function, to look up if a minibus is booked.. or not on a certain date (minibuses are limited to 1 booknig per day). and.. went from there.
Cheers again!
ajetrumpet
03-12-2008, 04:09 PM
Good deal! Good luck with it... :)