Hitting a wall. I want to transfer date values from tblInquiry to tblReservations. Using the code below, I get an incorrect date added to the tblReservations . . . like year 1899.
Dim mySQL As String
mySQL = "INSERT INTO tblReservation (lngResID, lngGuestID, datArrivalDate, bytNoOfNights, datDepartureDate ) Values(" & Me.lngResID & ", " & Me.lngGuestID & ", " & Me.datArrivalDate & ", " & Me.bytNoOfNights & ", " & Me.datDepartureDate & ")"
I'm sure I have to do something to the date values, but not sure what.