[AccessD] Error 3061

I am VERY familiar with this error! ;-)

It always means that you have a field name misspelled in your query, or the
field is not in the table(s).  Whether misspelled or missing, as far as the
query is concerned, it's not there, and you will get a 3061 error.  In this
case the error says you're missing 1, so that means there is 1 field it
can't find.  If it said 2, then there would be two fields it can't find, and
so on.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ralf Lister
Sent: Saturday, December 11, 2010 9:57 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Error 3061

Hello,  

 

I have the AC2007 database, and run this code in a standard  module:

 

************************************************+

Sub Versicherung(table As String, F As Byte, FJahr As Long)

 

    Const tasa = 6.97

    

    Dim rs As DAO.Recordset

    Dim dbs As DAO.Database

    

    Set dbs = CurrentDb

    Set rs = dbs.OpenRecordset("qryDatos")

***************************************************    

At the last line (“Set rs = 
”) I get this error message:

 

“Se ha producido el error “3061” en tiempo de ejecución:

Pocos parametros. Se esperaba 1.”

 

(Error “3061”

Few parameter. Expected: 1)

 

What I’m doing wrong here? Can someone help?

 

TIA

 

Saludos

Actuary Ralf Lister

La Paz, Bolivia

Environment