If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why no update? Help!
My update isn't updating the table. Why?
Code is: strSQL = "Update AVAILABILITY " & _ "Set AVAILABILITY.[Booking ID] = " & varNewID & _ " WHERE AVAILABILITY.BookingDate= " & _ Forms![SINGLE BOOKING AVAILABILITY]!BookingDate & _ " And AVAILABILITY.Period=" & Forms![SINGLE BOOKING AVAILABILITY]!Combo8 & _ " And AVAILABILITY.Room=""" & Forms![SINGLE BOOKING AVAILABILITY]!Combo10 & """" DoCmd.RunSQL strSQL MsgBox strSQL where varNewID is declared as Long. The MsgBox produces: UPDATE AVAILABILITY SET AVAILABILITY.[Booking ID] = 86 WHERE AVAILABILITY.BookingDate = 07/09/2004 And AVAILABILITY.Period = 1 And AVAILABILITY.Room = "H4" Booking Table contains the record: Booking Date = 07/09/2004 (date/time field) Period = 1 (Number field) Room = H4 (text field) Day Number = 4 (Number field) Booking ID = 1 (Number field) I get an ACCESS popup box stating: You are about to update 0 rows, etc. asking for a YES or No response Why isn't the row in the table getting updated? Is it something to do with the format of the date? Also how can I stop the ACCESS popup box asking the user to confirm update? I just want the update to take place in the background. Thanks for your help. |
#2
|
|||
|
|||
Why no update? Help!
Enclose the data in pound signs!
Something like: WHERE AVAILABILITY.BookingDate = #07/09/2004# -- Marin Kostov Microsoft Office XP Master Instructor |
Thread Tools | |
Display Modes | |
|
|