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?
Printable View
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';"
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!
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?