border20
Registered User.
- Local time
- Today, 13:58
- Joined
- Jan 8, 2003
- Messages
- 92
In a field I want to change all the value that are o to 1.
I have the folowing code wich gives me an error...
can anyone tell me why ?
code
Dim sqlStr1 As String
sqlStr1 = "UPDATE tablename SET [field name] = 1 WHERE [field name] = 0;"
DoCmd.RunSQL sqlStr1
thx
I have the folowing code wich gives me an error...
can anyone tell me why ?
code
Dim sqlStr1 As String
sqlStr1 = "UPDATE tablename SET [field name] = 1 WHERE [field name] = 0;"
DoCmd.RunSQL sqlStr1
thx