SQL Error- Run time error 2342

[Sunil Korah]

In one of my programmes I am getting this error when I use
DoCmd.RunSQL. The message states "A RunSQL action requires an argument
consisting of an SQL statement". Originally my statement was

DoCmd.RunSQL (strSQL)

where 'strSQL' was a string variable containing a SQL statement. Since
this was giving the error message I tried with

DoCmd.RunSQL ("select * from programmes where programmes.startdate >=
#30/09/03#;")

i.e substituting the actual SQL statement for the variable. I still
get the same error.

Any explanation.

Sunil Korah

[Pieter Linden]

hb*****@indiatimes.com (Sunil Korah) wrote in message news:<72**************************@posting.google. com>...

In one of my programmes I am getting this error when I use
DoCmd.RunSQL. The message states "A RunSQL action requires an argument
consisting of an SQL statement". Originally my statement was

DoCmd.RunSQL (strSQL)

where 'strSQL' was a string variable containing a SQL statement. Since
this was giving the error message I tried with

DoCmd.RunSQL ("select * from programmes where programmes.startdate >=
#30/09/03#;")

i.e substituting the actual SQL statement for the variable. I still
get the same error.

Any explanation.

Sunil Korah

What are you trying to do here? Open the query into a recordset? If
you're going to do that, you need something like:

dim db as dao.database
dim rs as dao.recordset

set db=currentdb
rs.Open strSQL,dbOpenSnapshot

Just selecting a bunch of records won't do anything for you... what
did you plan on doing with them?