S
State Troopers
Hi there,
I will try and explain this as clearly as possible. If you have any
questions, just ask away.
I have a table, that looks like this:
What I need to do is take all the blank fields in CLOSE and replace them
with "CLOSED"
If it says ACCEPT, keep it like that. Below is the code i am building on,
but it replaces ALL of the fields.
Thanks.
-State
Dim ssql As String
Dim stClosed As String
Dim stDir As String
Dim id As String
stDir = "1"
id = "1"
stClosed = "CLOSED"
ssql = "UPDATE tblActions Set LINE='" & stClosed & "' WHERE
tblActions.DIR='" & stDir & "' AND tblActions.CAT='" & id & "'"
CurrentDb.Execute ssql
I will try and explain this as clearly as possible. If you have any
questions, just ask away.
I have a table, that looks like this:
ID CAT COMMENT CLOSE DATE
2006-001 1 testing.... 4/25/2006
2006-001 1 CLOSED CLOSED 4/27/2006
2006-001 1 ACCEPT ACCEPT 4/26/2006
2006-001 1 test..1..2 4/23/2006
2006-001 1 more to do. 4/25/2006
What I need to do is take all the blank fields in CLOSE and replace them
with "CLOSED"
If it says ACCEPT, keep it like that. Below is the code i am building on,
but it replaces ALL of the fields.
Thanks.
-State
Dim ssql As String
Dim stClosed As String
Dim stDir As String
Dim id As String
stDir = "1"
id = "1"
stClosed = "CLOSED"
ssql = "UPDATE tblActions Set LINE='" & stClosed & "' WHERE
tblActions.DIR='" & stDir & "' AND tblActions.CAT='" & id & "'"
CurrentDb.Execute ssql