User Profile
Collapse
-
thnx a lot... this was very helpful... i kept on playing with the syntax.. thnx again.. -
Date Comparison in VB 6.0 and Access.. please help meee
hi.. i have a problem about date comparison in VB 6.0 and MS Access
i want to compare dates from access to a date from DTpicker control in VB 6.0.. this is my code but it doesnt work coz i get a syntax error..
"Select * from Reservations where DateCheckIn <= #date1# and DateCheckOut > #date1# and [RoomNo] = ' " & cmb_room & " ' "
"Select * from Reservations where... -
Follow Up question
hi.. i have a problem almost the same as the one posted so i decided to post it as a reply.. hope someone could help me..
i want to compare dates from access to a date from DTpicker control in VB 6.0.. this is my code but it doesnt work coz i get a syntax error..
"Select * from Reservations where DateCheckIn <= #date1# and DateCheckOut > #date1# and [RoomNo] = ' " & cmb_room...Leave a comment:
No activity results to display
Show More
Leave a comment: