Asger Blond
ab-mi at post3.tele.dk
Sat Dec 11 13:06:56 CST 2010
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