By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Codes for Checking Rooms Availability

P: n/a
oyk
I have a form with, among others, controls for RoomNo., CheckInDate and
CheckOutDate. I would like to check whether the RoomNo selected is occupied
for the period as stated in CheckInDate and CheckOutDate.

I have used the OpenRecordSet method for the AfterUpdate event in the form,
as follows:

Set rs = db.OpenRecordSet ("qryRoomsAvailable",dbOpenDynaSet)

However, this does not work. When I change "qryRoomsAvailable" to "tblRooms"
the codes seem to run alright.

Can anyone help me? TQ.
Apr 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a


"oyk" <ok****@streamyx.com> wrote in message
news:44**********@news.tm.net.my...
I have a form with, among others, controls for RoomNo., CheckInDate and
CheckOutDate. I would like to check whether the RoomNo selected is occupied
for the period as stated in CheckInDate and CheckOutDate.

I have used the OpenRecordSet method for the AfterUpdate event in the
form, as follows:

Set rs = db.OpenRecordSet ("qryRoomsAvailable",dbOpenDynaSet)

However, this does not work. When I change "qryRoomsAvailable" to
"tblRooms" the codes seem to run alright.

Can anyone help me?


No, not likely. Your description is very vague, you don't show the code, you
don't describe the details of the error you receive, and the instruction on
which you receive it, and you don't give us a clue as to what
"qryRoomsAvailable" may do.

Essentially, you have said, "There's something wrong somewhere; how do I fix
it?"
Ross Perot, when he was running for President, used to say, "The devil is in
the details." He was paraphrasing Mies Van Der Rohe, who said, "God is in
the details." I can't promise you an answer, but if one is to be found, we
do need the details.
Apr 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.