Soundsmith
Programmer
In Access 2000, I can run a series of UPDATE statement like this:
DoCmd.RunSQL "UPDATE qryRptlink SET ok = True"
They run fine. BUT, following this command with:
DoCmd.RunSQL "SELECT [qryNames].* FROM [qryNames}"
Access complains "A RunSQL action requires an action consisting of an SQL statement"
It appears Access is not seeing my SELECT keyword.
What am I missing???
David 'Dasher' Kempton
The Soundsmith
DoCmd.RunSQL "UPDATE qryRptlink SET ok = True"
They run fine. BUT, following this command with:
DoCmd.RunSQL "SELECT [qryNames].* FROM [qryNames}"
Access complains "A RunSQL action requires an action consisting of an SQL statement"
It appears Access is not seeing my SELECT keyword.
What am I missing???
David 'Dasher' Kempton
The Soundsmith