Re: 3061 Error when doing everything that works in another module.

3061 error, meaning "too few parameters...", right?

I assume that the SQL statement is a properly delimited text string in your
code:
selector = "SELECT Vendor.V_Name FROM Vendor WHERE (((Vendor.[V_
ID])=39));"

You mention "native ACCESS".... is this a reference to using the design view
of a query to create the SQL statement and to run the query? It works there,
but not in your code? What is the exact error message that you're getting?

--

Ken Snell
<MS ACCESS MVP>



"Andy Dorph" <AndyDorph@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:35CA080F-307E-4AF3-96CC-68F8A790A534@xxxxxxxxxxxxxxxx
>I reference the proper DAO Library.
> I included Dim rs as DAO.RecorSet.
> I created the SQL in native Access.
> The Query works in native Access.
>
> The command lines are:
>
> selector = SELECT Vendor.V_Name FROM Vendor WHERE (((Vendor.[V_ ID])=39));
>
> Set rs = CurrentDb.OpenRecordset(selector)
>
> I am still receiving a 3061 error. What am I doing wrong? If nothing is
> wrong with the code, how do I fix this?
>
> Thanks in advance.
>


.

Relevant Pages

  • Re: SQL question: field name changes but is always the 1st field
    ... which you can then reference ... the same number of fields and in identical order, ... before my query and this way I can always guarantee it will have the ... out hope it can be done in a SQL statement (albeit a very very very ...
    (microsoft.public.access.queries)
  • Re: Error using " in .open with ADODB.Recordset
    ... recordset but I'm getting hung up on the SQL statement. ... query that has a string as a condition. ... Dim mrk As String ...
    (microsoft.public.data.ado)
  • Re: expiration
    ... First what type of field are you applying the criteria against? ... You can try the following in a query. ... If you are trying to get just records with the License has expired within ... it is the actual SQL statement that is executed. ...
    (microsoft.public.access.queries)
  • Re: Same date range in main and sub form
    ... You need to concatenate together the parts to make up the SQL string ... it will look like the SQL statement you original ... Allen Browne - Microsoft MVP. ... well as the name of the query on which the form is based. ...
    (microsoft.public.access.forms)
  • Re: expiration
    ... If you are trying to get just records with the License has expired within ... In the Design view of the query ... This query is based off the existing employee database created by someone ... it is the actual SQL statement that is executed. ...
    (microsoft.public.access.queries)
Loading