SQL won't run

[damarious]

Access 2000
This code snippet:

Dim strSQL1 As String
strSQL1 = "SELECT ips FROM MainData WHERE (cnum ='123456');"
DoCmd.RunSQL (strSQL1)

Returns the error:
"A RunSQL action requires an argument consisting of an SQL ststement"

What's up?

from the access help files:



DoCmd.RunSQL "UPDATE Employees " & _
"SET Employees.Title = 'Regional Sales Manager' " & _
"WHERE Employees.Title = 'Sales Manager';"

[damarious]

DoCmd.RunSQL "SELECT ips FROM MainData WHERE (cnum='123456');"

returns the same error.

I'm going to scream! It just won't query the database!

[Thom]

Hey Larryn! I can't FIND the Openrecordset Method/Action in Access2000 help for ADO! What's the ADO equivalent for DAO's OpenRecordset?? My code is:

Dim MSA2K As Access.Application
Set MSA2K = New Access.Application
MSA2K.OpenCurrentDatabase "C:\Test.mdb"
MSA2K.DoCmd.RunSQL=("SELECT * FROM TestResults WHERE TestNumber = 2")
I get the SAME error! Is there a workaround for this?