VBA, error 2342 with docmd.runsql

error 2342 with docmd.runsql

Author	Message
Olivier Dan #1 / 12	error 2342 with docmd.runsql Hello, I hope someone will help with that: I run the following code DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") and I have an error 2342 : "a runSQL action requires an argument consisting of an SQL statement" I don't understand because the SQL code seems to work. thanks in advance Sent via Deja.com http://www.--*.com/ Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Dirk Goldga #2 / 12	error 2342 with docmd.runsql The SQL statement must be an action query or a data-definition query, not one that returns a recordset. A simple Select query is not valid for RunSQL. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > Hello, > I hope someone will help with that: I run the following code > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > and I have an error 2342 : "a runSQL action requires an argument > consisting of an SQL statement" > I don't understand because the SQL code seems to work. > thanks in advance > Sent via Deja.com http://www.deja.com/ > Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Olivier Dan #3 / 12	error 2342 with docmd.runsql oh OK thanks. but then, how do I run a SELECT query without using the docmd.openquery command ? Olivier Quote: > The SQL statement must be an action query or a data-definition query, not > one that returns a recordset. A simple Select query is not valid for > RunSQL. > -- > Dirk Goldgar > (remove NOSPAM from reply address) > > Hello, > > I hope someone will help with that: I run the following code > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > and I have an error 2342 : "a runSQL action requires an argument > > consisting of an SQL statement" > > I don't understand because the SQL code seems to work. > > thanks in advance > > Sent via Deja.com http://www.deja.com/ > > Before you buy. -- ----------------------------- My page; Have a look. http://www.etek.chalmers.se/~em8dang Sent via Deja.com http://www.deja.com/ Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

michk #4 / 12	error 2342 with docmd.runsql DAO's OpenRecordset method does very nicely.... check it out in online help. -- ?MichKa (insensitive fruitarian) random junk of dubious value, a multilingual website, the 54-language TSI Form/Report to Data Access Page Wizard, and lots of replication "stuff" at the (no scripts required!) http://www.trigeminal.com/ ? Quote: > oh OK thanks. > but then, how do I run a SELECT query without using the docmd.openquery > command ? > Olivier > > The SQL statement must be an action query or a data-definition query, > not > > one that returns a recordset. A simple Select query is not valid for > > RunSQL. > > -- > > Dirk Goldgar > > (remove NOSPAM from reply address) > > > Hello, > > > I hope someone will help with that: I run the following code > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > > and I have an error 2342 : "a runSQL action requires an argument > > > consisting of an SQL statement" > > > I don't understand because the SQL code seems to work. > > > thanks in advance > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > -- > ----------------------------- > My page; Have a look. > http://www.etek.chalmers.se/~em8dang > Sent via Deja.com http://www.deja.com/ > Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Dirk Goldga #5 / 12	error 2342 with docmd.runsql If you don't want to use DoCmd.OpenQuery, presumably you don't want to display the results for the user, but rather manipulate them programmatically. To do that, you have to open a recordset on the query, using code like: -------- sample code --------- Dim rst As Recordset Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") With rst 'Do stuff with the recordset ... 'When done, close the recordset. .Close End With Set rst = Nothing -------- end sample code --------- If this is the sort of thing you had in mind, you've got to do a bit of reading in the help file to know how to proceed. If it's not what you had in mind, you'd better explain more fully what you're after. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > oh OK thanks. > but then, how do I run a SELECT query without using the docmd.openquery > command ? > Olivier > > The SQL statement must be an action query or a data-definition query, > not > > one that returns a recordset. A simple Select query is not valid for > > RunSQL. > > -- > > Dirk Goldgar > > (remove NOSPAM from reply address) > > > Hello, > > > I hope someone will help with that: I run the following code > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > > and I have an error 2342 : "a runSQL action requires an argument > > > consisting of an SQL statement" > > > I don't understand because the SQL code seems to work. > > > thanks in advance > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > -- > ----------------------------- > My page; Have a look. > http://www.etek.chalmers.se/~em8dang > Sent via Deja.com http://www.deja.com/ > Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Olivier Dan #6 / 12	error 2342 with docmd.runsql well, this query is actually designed to display information to the user. But I want to minimize the number of objects in my database, because I will have to share it and I think restrictions must be specified for each users. thanks for the code, I will test it and check online help on recordset. Olivier Quote: > If you don't want to use DoCmd.OpenQuery, presumably you don't want to > display the results for the user, but rather manipulate them > programmatically. To do that, you have to open a recordset on the query, > using code like: > -------- sample code --------- > Dim rst As Recordset > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > With rst > 'Do stuff with the recordset ... > 'When done, close the recordset. > .Close > End With > Set rst = Nothing > -------- end sample code --------- > If this is the sort of thing you had in mind, you've got to do a bit of > reading in the help file to know how to proceed. If it's not what you had > in mind, you'd better explain more fully what you're after. > -- > Dirk Goldgar > (remove NOSPAM from reply address) > > oh OK thanks. > > but then, how do I run a SELECT query without using the docmd.openquery > > command ? > > Olivier > > > The SQL statement must be an action query or a data-definition query, > > not > > > one that returns a recordset. A simple Select query is not valid for > > > RunSQL. > > > -- > > > Dirk Goldgar > > > (remove NOSPAM from reply address) > > > > Hello, > > > > I hope someone will help with that: I run the following code > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > > > and I have an error 2342 : "a runSQL action requires an argument > > > > consisting of an SQL statement" > > > > I don't understand because the SQL code seems to work. > > > > thanks in advance > > > > Sent via Deja.com http://www.deja.com/ > > > > Before you buy. > > -- > > ----------------------------- > > My page; Have a look. > > http://www.etek.chalmers.se/~em8dang > > Sent via Deja.com http://www.deja.com/ > > Before you buy. -- ----------------------------- My page; Have a look. http://www.etek.chalmers.se/~em8dang Sent via Deja.com http://www.deja.com/ Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Dirk Goldga #7 / 12	error 2342 with docmd.runsql Hmm. You may want to create temporary QueryDef, and open that. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > well, this query is actually designed to display information to the > user. But I want to minimize the number of objects in my database, > because I will have to share it and I think restrictions must be > specified for each users. > thanks for the code, I will test it and check online help on recordset. > Olivier > > If you don't want to use DoCmd.OpenQuery, presumably you don't want to > > display the results for the user, but rather manipulate them > > programmatically. To do that, you have to open a recordset on the > query, > > using code like: > > -------- sample code --------- > > Dim rst As Recordset > > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > With rst > > 'Do stuff with the recordset ... > > 'When done, close the recordset. > > .Close > > End With > > Set rst = Nothing > > -------- end sample code --------- > > If this is the sort of thing you had in mind, you've got to do a bit > of > > reading in the help file to know how to proceed. If it's not what you > had > > in mind, you'd better explain more fully what you're after. > > -- > > Dirk Goldgar > > (remove NOSPAM from reply address) > > > oh OK thanks. > > > but then, how do I run a SELECT query without using the > docmd.openquery > > > command ? > > > Olivier > > > > The SQL statement must be an action query or a data-definition > query, > > > not > > > > one that returns a recordset. A simple Select query is not valid > for > > > > RunSQL. > > > > -- > > > > Dirk Goldgar > > > > (remove NOSPAM from reply address) > > > > > Hello, > > > > > I hope someone will help with that: I run the following code > > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]![SrchPolNb]));") > > > > > and I have an error 2342 : "a runSQL action requires an argument > > > > > consisting of an SQL statement" > > > > > I don't understand because the SQL code seems to work. > > > > > thanks in advance > > > > > Sent via Deja.com http://www.deja.com/ > > > > > Before you buy. > > > -- > > > ----------------------------- > > > My page; Have a look. > > > http://www.etek.chalmers.se/~em8dang > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > -- > ----------------------------- > My page; Have a look. > http://www.etek.chalmers.se/~em8dang > Sent via Deja.com http://www.deja.com/ > Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Olivier Dan #8 / 12	error 2342 with docmd.runsql I've tried the code you provide me with the openrecordset method but I have the following error : "error 3061. Too few parameters. Expected 1". ? can you help me again with that ? olivier Quote: > well, this query is actually designed to display information to the > user. But I want to minimize the number of objects in my database, > because I will have to share it and I think restrictions must be > specified for each users. > thanks for the code, I will test it and check online help on recordset. > Olivier > > If you don't want to use DoCmd.OpenQuery, presumably you don't want to > > display the results for the user, but rather manipulate them > > programmatically. To do that, you have to open a recordset on the > query, > > using code like: > > -------- sample code --------- > > Dim rst As Recordset > > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! [SrchPolNb]));") > > With rst > > 'Do stuff with the recordset ... > > 'When done, close the recordset. > > .Close > > End With > > Set rst = Nothing > > -------- end sample code --------- > > If this is the sort of thing you had in mind, you've got to do a bit > of > > reading in the help file to know how to proceed. If it's not what you > had > > in mind, you'd better explain more fully what you're after. > > -- > > Dirk Goldgar > > (remove NOSPAM from reply address) > > > oh OK thanks. > > > but then, how do I run a SELECT query without using the > docmd.openquery > > > command ? > > > Olivier > > > > The SQL statement must be an action query or a data-definition > query, > > > not > > > > one that returns a recordset. A simple Select query is not valid > for > > > > RunSQL. > > > > -- > > > > Dirk Goldgar > > > > (remove NOSPAM from reply address) > > > > > Hello, > > > > > I hope someone will help with that: I run the following code > > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! [SrchPolNb]));") > > > > > and I have an error 2342 : "a runSQL action requires an argument > > > > > consisting of an SQL statement" > > > > > I don't understand because the SQL code seems to work. > > > > > thanks in advance > > > > > Sent via Deja.com http://www.deja.com/ > > > > > Before you buy. > > > -- > > > ----------------------------- > > > My page; Have a look. > > > http://www.etek.chalmers.se/~em8dang > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > -- > ----------------------------- > My page; Have a look. > http://www.etek.chalmers.se/~em8dang > Sent via Deja.com http://www.deja.com/ > Before you buy. -- ----------------------------- My page; Have a look. http://www.etek.chalmers.se/~em8dang Sent via Deja.com http://www.deja.com/ Before you buy.
Tue, 03 Sep 2002 03:00:00 GMT

Dirk Goldga #9 / 12	error 2342 with docmd.runsql Sorry, should have been: Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl WHERE (((InsCatTbl.InsPolNb) Like """ & [Forms]![SearchFrm]![SrchPolNb] & """));") -- Dirk Goldgar (to reply via email, remove NOSPAM from address) Quote: >I've tried the code you provide me with the openrecordset method >but I have the following error : >"error 3061. Too few parameters. Expected 1". ? >can you help me again with that ? >olivier >> well, this query is actually designed to display information to the >> user. But I want to minimize the number of objects in my database, >> because I will have to share it and I think restrictions must be >> specified for each users. >> thanks for the code, I will test it and check online help on >recordset. >> Olivier >> > If you don't want to use DoCmd.OpenQuery, presumably you don't want >to >> > display the results for the user, but rather manipulate them >> > programmatically. To do that, you have to open a recordset on the >> query, >> > using code like: >> > -------- sample code --------- >> > Dim rst As Recordset >> > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl >> > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! >[SrchPolNb]));") >> > With rst >> > 'Do stuff with the recordset ... >> > 'When done, close the recordset. >> > .Close >> > End With >> > Set rst = Nothing >> > -------- end sample code --------- >> > If this is the sort of thing you had in mind, you've got to do a bit >> of >> > reading in the help file to know how to proceed. If it's not what >you >> had >> > in mind, you'd better explain more fully what you're after. >> > -- >> > Dirk Goldgar >> > (remove NOSPAM from reply address) >> > > oh OK thanks. >> > > but then, how do I run a SELECT query without using the >> docmd.openquery >> > > command ? >> > > Olivier >> > > > The SQL statement must be an action query or a data-definition >> query, >> > > not >> > > > one that returns a recordset. A simple Select query is not valid >> for >> > > > RunSQL. >> > > > -- >> > > > Dirk Goldgar >> > > > (remove NOSPAM from reply address) >> > > > > Hello, >> > > > > I hope someone will help with that: I run the following code >> > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE >> > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! >[SrchPolNb]));") >> > > > > and I have an error 2342 : "a runSQL action requires an >argument >> > > > > consisting of an SQL statement" >> > > > > I don't understand because the SQL code seems to work. >> > > > > thanks in advance >> > > > > Sent via Deja.com http://www.deja.com/ >> > > > > Before you buy. >> > > -- >> > > ----------------------------- >> > > My page; Have a look. >> > > http://www.etek.chalmers.se/~em8dang >> > > Sent via Deja.com http://www.deja.com/ >> > > Before you buy. >> -- >> ----------------------------- >> My page; Have a look. >> http://www.etek.chalmers.se/~em8dang >> Sent via Deja.com http://www.deja.com/ >> Before you buy. >-- >----------------------------- >My page; Have a look. >http://www.etek.chalmers.se/~em8dang >Sent via Deja.com http://www.deja.com/ >Before you buy.
Wed, 04 Sep 2002 03:00:00 GMT

Olivier Dan #10 / 12	error 2342 with docmd.runsql hum, still does not work but it's ok, I've used the .CreateQueryDef method instead. thanks for your help Quote: > Sorry, should have been: > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > WHERE (((InsCatTbl.InsPolNb) Like """ & [Forms]![SearchFrm]! [SrchPolNb] & > """));") > -- > Dirk Goldgar > (to reply via email, remove NOSPAM from address) > >I've tried the code you provide me with the openrecordset method > >but I have the following error : > >"error 3061. Too few parameters. Expected 1". ? > >can you help me again with that ? > >olivier > >> well, this query is actually designed to display information to the > >> user. But I want to minimize the number of objects in my database, > >> because I will have to share it and I think restrictions must be > >> specified for each users. > >> thanks for the code, I will test it and check online help on > >recordset. > >> Olivier > >> > If you don't want to use DoCmd.OpenQuery, presumably you don't want > >to > >> > display the results for the user, but rather manipulate them > >> > programmatically. To do that, you have to open a recordset on the > >> query, > >> > using code like: > >> > -------- sample code --------- > >> > Dim rst As Recordset > >> > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > >> > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! > >[SrchPolNb]));") > >> > With rst > >> > 'Do stuff with the recordset ... > >> > 'When done, close the recordset. > >> > .Close > >> > End With > >> > Set rst = Nothing > >> > -------- end sample code --------- > >> > If this is the sort of thing you had in mind, you've got to do a bit > >> of > >> > reading in the help file to know how to proceed. If it's not what > >you > >> had > >> > in mind, you'd better explain more fully what you're after. > >> > -- > >> > Dirk Goldgar > >> > (remove NOSPAM from reply address) > >> > > oh OK thanks. > >> > > but then, how do I run a SELECT query without using the > >> docmd.openquery > >> > > command ? > >> > > Olivier > >> > > > The SQL statement must be an action query or a data- definition > >> query, > >> > > not > >> > > > one that returns a recordset. A simple Select query is not valid > >> for > >> > > > RunSQL. > >> > > > -- > >> > > > Dirk Goldgar > >> > > > (remove NOSPAM from reply address) > >> > > > > Hello, > >> > > > > I hope someone will help with that: I run the following code > >> > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > >> > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! > >[SrchPolNb]));") > >> > > > > and I have an error 2342 : "a runSQL action requires an > >argument > >> > > > > consisting of an SQL statement" > >> > > > > I don't understand because the SQL code seems to work. > >> > > > > thanks in advance > >> > > > > Sent via Deja.com http://www.deja.com/ > >> > > > > Before you buy. > >> > > -- > >> > > ----------------------------- > >> > > My page; Have a look. > >> > > http://www.etek.chalmers.se/~em8dang > >> > > Sent via Deja.com http://www.deja.com/ > >> > > Before you buy. > >> -- > >> ----------------------------- > >> My page; Have a look. > >> http://www.etek.chalmers.se/~em8dang > >> Sent via Deja.com http://www.deja.com/ > >> Before you buy. > >-- > >----------------------------- > >My page; Have a look. > >http://www.etek.chalmers.se/~em8dang > >Sent via Deja.com http://www.deja.com/ > >Before you buy. -- ----------------------------- My page; Have a look. http://www.etek.chalmers.se/~em8dang Sent via Deja.com http://www.deja.com/ Before you buy.
Fri, 06 Sep 2002 03:00:00 GMT

Dirk Goldga #11 / 12	error 2342 with docmd.runsql Well, it beats me, then. Glad you found a workaround. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > hum, still does not work but it's ok, I've used the .CreateQueryDef > method instead. > thanks for your help > > Sorry, should have been: > > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM InsCatTbl > > WHERE (((InsCatTbl.InsPolNb) Like """ & [Forms]![SearchFrm]! > [SrchPolNb] & > > """));") > > -- > > Dirk Goldgar > > (to reply via email, remove NOSPAM from address) > > >I've tried the code you provide me with the openrecordset method > > >but I have the following error : > > >"error 3061. Too few parameters. Expected 1". ? > > >can you help me again with that ? > > >olivier > > >> well, this query is actually designed to display information to the > > >> user. But I want to minimize the number of objects in my database, > > >> because I will have to share it and I think restrictions must be > > >> specified for each users. > > >> thanks for the code, I will test it and check online help on > > >recordset. > > >> Olivier > > >> > If you don't want to use DoCmd.OpenQuery, presumably you don't > want > > >to > > >> > display the results for the user, but rather manipulate them > > >> > programmatically. To do that, you have to open a recordset on the > > >> query, > > >> > using code like: > > >> > -------- sample code --------- > > >> > Dim rst As Recordset > > >> > Set rst = CurrentDB.OpenRecordset("SELECT InsCatTbl.* FROM > InsCatTbl > > >> > WHERE (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! > > >[SrchPolNb]));") > > >> > With rst > > >> > 'Do stuff with the recordset ... > > >> > 'When done, close the recordset. > > >> > .Close > > >> > End With > > >> > Set rst = Nothing > > >> > -------- end sample code --------- > > >> > If this is the sort of thing you had in mind, you've got to do a > bit > > >> of > > >> > reading in the help file to know how to proceed. If it's not what > > >you > > >> had > > >> > in mind, you'd better explain more fully what you're after. > > >> > -- > > >> > Dirk Goldgar > > >> > (remove NOSPAM from reply address) > > >> > > oh OK thanks. > > >> > > but then, how do I run a SELECT query without using the > > >> docmd.openquery > > >> > > command ? > > >> > > Olivier > > >> > > > The SQL statement must be an action query or a data- > definition > > >> query, > > >> > > not > > >> > > > one that returns a recordset. A simple Select query is not > valid > > >> for > > >> > > > RunSQL. > > >> > > > -- > > >> > > > Dirk Goldgar > > >> > > > (remove NOSPAM from reply address) > > >> > > > > Hello, > > >> > > > > I hope someone will help with that: I run the following > code > > >> > > > > DoCmd.RunSQL ("SELECT InsCatTbl.* FROM InsCatTbl WHERE > > >> > > > > (((InsCatTbl.InsPolNb) Like [Forms]![SearchFrm]! > > >[SrchPolNb]));") > > >> > > > > and I have an error 2342 : "a runSQL action requires an > > >argument > > >> > > > > consisting of an SQL statement" > > >> > > > > I don't understand because the SQL code seems to work. > > >> > > > > thanks in advance > > >> > > > > Sent via Deja.com http://www.deja.com/ > > >> > > > > Before you buy. > > >> > > -- > > >> > > ----------------------------- > > >> > > My page; Have a look. > > >> > > http://www.etek.chalmers.se/~em8dang > > >> > > Sent via Deja.com http://www.deja.com/ > > >> > > Before you buy. > > >> -- > > >> ----------------------------- > > >> My page; Have a look. > > >> http://www.etek.chalmers.se/~em8dang > > >> Sent via Deja.com http://www.deja.com/ > > >> Before you buy. > > >-- > > >----------------------------- > > >My page; Have a look. > > >http://www.etek.chalmers.se/~em8dang > > >Sent via Deja.com http://www.deja.com/ > > >Before you buy. > -- > ----------------------------- > My page; Have a look. > http://www.etek.chalmers.se/~em8dang > Sent via Deja.com http://www.deja.com/ > Before you buy.
Fri, 06 Sep 2002 03:00:00 GMT

Page 1 of 1

[ 12 post ]