[AccessD] Error 3061

Error 3061 indicates that a parameter is missing. You can get this error if a field name has been misspelled - because Jet will interpret a misspelled field name as a parameter. But another obvious case is that the query has a parameter criterion.
Looking at Ralf's procedure I suspected that qryDato contains a parameter criterion. The procedure itself has three input parameters (table As String, F As Byte, FJahr As Long). And maybe FJahr should be passed as an argument to qryDato - this was my guess...
Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Dan Waters
Sendt: 11. december 2010 19:05
Til: 'Access Developers discussion and problem solving'
Emne: Re: [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

 




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com