sladerwilson
11-09-2007, 12:37 PM
I am a VBA newbie... I have an ASP Script that I wrote that contains the following SQL statement:
objRst.Open "UPDATE export SET Field48 = 'C' WHERE Field2 LIKE 'ST-%'"
I've written it in VBA as:
sql1 = "UPDATE export SET Field48 = 'C' WHERE Field2 LIKE 'ST-%'"
DoCmd.RunSQL sql1
When I run this VBA in Access it doesn't find/update any records that contain ST-xxxxx although this works flawlessly in ASP.
I am guessing VBA doesn't recognize the % or is it something else altogether?
Any help would be greatly appreciated.
objRst.Open "UPDATE export SET Field48 = 'C' WHERE Field2 LIKE 'ST-%'"
I've written it in VBA as:
sql1 = "UPDATE export SET Field48 = 'C' WHERE Field2 LIKE 'ST-%'"
DoCmd.RunSQL sql1
When I run this VBA in Access it doesn't find/update any records that contain ST-xxxxx although this works flawlessly in ASP.
I am guessing VBA doesn't recognize the % or is it something else altogether?
Any help would be greatly appreciated.