Re: Codes for Checking Rooms Availability
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Sun, 16 Apr 2006 15:55:48 GMT
"oyk" <okt128@xxxxxxxxxxxx> wrote in message
news:4441c161$1_2@xxxxxxxxxxxxxxxxx
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.
.
- References:
- Codes for Checking Rooms Availability
- From: oyk
- Codes for Checking Rooms Availability
- Prev by Date: Re: Summarizing Multiple Lines in a report
- Next by Date: Re: Problems Saving Multiple Unbound Fields to a Table
- Previous by thread: Codes for Checking Rooms Availability
- Next by thread: Summarizing Multiple Lines in a report
- Index(es):
Relevant Pages
|
