General information
Category:
Database DAO/RDO/ODBC/ADO
First of all, thanks a lot to everybody who reply to my last question... It'S very appreciated!
But I have another one..
In my database I have a Column named Date Out in Date format. When a customer rent a room, the program write the 'Date In' and put 01-01-01 in 'Date Out'. When the customer leave the room the program write the 'Date Out'.
When I rent a room I would like to know if I can rent it to the customer so I do a rs.FindFirst with the date_out beacause if the date is 01-01-01 it's beacause the room is rented to another customer...
rs.NoMatch always return TRUE but it's not true...
Public Function fnCanLocateRoom(rs As Recordset)
With rs
.FindFirst "'Date Out' = '01-01-01'"
If .NoMatch = True Then
fnCanLocateRoom = True
Else
fnCanLocateRoom = False
End If
End With
End Function
Thanks again!
Yannick Lepage
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only