Reservation System

[Guest]

Hi Everyone,

For Q1 , I got the cbotoolName as the filter the criteria and theHi Paul

RE : Q1

I got the cbotoolName as the filter the criteria and the txttoolName should
filter out the same thing as the cbotoolName just that the txttoolName is
toolID number and not the tool name. Hmm.. I want to filter out the name of
the tool instead of the ID number in the textbox(txttoolName)

Q2. I have a problem to prevent Duplicate Record in My ReservationForm. In
this ReservationForm, I have start date and end date, employeename and
toolname and status field for the user to fill in. In order to prevent
Duplicate Record in My ReservationForm which record source is based on the
ReservationTable, I must not allow the user to enter the same start date, end
date and the toolname the same in my record, it show prompt an error if the
user try to record it. For Eg1, the user select Digital Multimeter, Start
Date is 17/7/07 and End Date is 19/7/07, However, this record is already been
recorded in the table, it should not be allowing to record this data. For
Eg2, the user select Digital Multimeter, Start Date is 18/7/07 and End Date
is 18/7/07, this record also must not be save in the data.

How can I prevent these 2 examples of record in my table?

Q3, My Msgbox show
"Please confirm the record again"
EmployeeName : 3 (got the ID Number not the Name)
ToolName : 3 (got the ID Number not the Name)
StartDate : 7/6/2007
EndDate : 7/6/2007

How do I prevent this number to appear?

Thank for helping me

 

[pietlinden]

Hi Everyone,

For Q1 , I got the cbotoolName as the filter the criteria and theHi Paul

RE : Q1

I got the cbotoolName as the filter the criteria and the txttoolName should
filter out the same thing as the cbotoolName just that the txttoolName is
toolID number and not the tool name. Hmm.. I want to filter out the name of
the tool instead of the ID number in the textbox(txttoolName)

Q2. I have a problem to prevent Duplicate Record in My ReservationForm. In
this ReservationForm, I have start date and end date, employeename and
toolname and status field for the user to fill in. In order to prevent
Duplicate Record in My ReservationForm which record source is based on the
ReservationTable, I must not allow the user to enter the same start date, end
date and the toolname the same in my record, it show prompt an error if the
user try to record it. For Eg1, the user select Digital Multimeter, Start
Date is 17/7/07 and End Date is 19/7/07, However, this record is already been
recorded in the table, it should not be allowing to record this data. For
Eg2, the user select Digital Multimeter, Start Date is 18/7/07 and End Date
is 18/7/07, this record also must not be save in the data.

How can I prevent these 2 examples of record in my table?

Q3, My Msgbox show
"Please confirm the record again"
EmployeeName : 3 (got the ID Number not the Name)
ToolName : 3 (got the ID Number not the Name)
StartDate : 7/6/2007
EndDate : 7/6/2007

How do I prevent this number to appear?

Thank for helping me

Oh, reservation systems are a PITA to write. You should read Albert's
notes on that... Sounds like you need to use a DCount() to figure out
if your record already exists in the BeforeInsert event of your form,
and if it does, override the normal error message and use your own. (I
guess you could just trap for the error # that is... Just include a
test for that specific error in your error handling routine.,

the hard part of this problem is making sure reservations don't
overlap. I asked this question like 7 years ago. Albert Kallal gave
me some great answers. They might be on his website, or they might
just be archived here. Look around.

 

[Steve]

I use a graphic form to enter reservations. The form graphically shows
reservations made and open reservation slots. The user can visually see
where the open slots are and can add new reservations in those slots.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Keith Wilby]

I use a graphic form to enter reservations. The form graphically shows
reservations made and open reservation slots. The user can visually see
where the open slots are and can add new reservations in those slots.

Translation: I have something you could use for which there will be a fee.
The OP wants help developing his own app, he doesn't want to buy yours and
here's why:

http://home.tiscali.nl/arracom/whoissteve.html