Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
egghi
Starting Member
17 Posts |
 Posted - 2006-10-26 : 21:47:18
|
| Hi, I have a strsql for a form in ACCESS 2003, and the update statement just does not do the job that I wanted it to. I tried to add/delete quotes and debugged for hours, but still can't fix it. Please help!!Dim strUpdateEmail As StringstrUpdateEmail = "UPDATE [User] SET Email = '" & Me.txtFillEmail.Value & "' WHERE WindowsUser ='" & Me.txtFillWindowsUser.Value & "';"DoCmd.RunSQL strUpdateEmailThank you, thank you! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-27 : 01:13:34
|
| If you do a DEBUG.PRINT strUpdateEmail, what do you get?Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Update strsql does not work...