In vba I need to check a specific field (ID) for special characters used in that field. The characters to check for are:
' " ! * # & ^ % $ " : ; \ | < > ? @ { } [ ]
The code I have is:
strSQL = "SELECT ......... "
Set rs = db.OpenRecordset(strSQL)
rs.MoveFirst
Do While Not rs.EOF
rstTest.AddNew
rstTest("ID").value = rs![ID]
rstTest.Update
rs.MoveNext
Loop
I need to know what I should put after "SELECT