[AccessD] Opening Recordset Error

Great *simple* idea Don.  I will take that one on board too.  
 
 


Regards 

David 

	-----Original Message-----
	From: Don Elliker [mailto:delliker at hotmail.com] 
	Sent: Tuesday, 3 June 2003 2:34 AM
	To: accessd at databaseadvisors.com
	Subject: Re: [AccessD] Opening Recordset Error
	
	

	I don't know if you solved this already, but I would do a
debug.print to see the SQL thats getting created before it executes
-then it will jump out at you.
	_d
	




	"Things are only free to the extent that you don't pay for
them." 
	
	>From: "Nancy Lytle" 
	>Reply-To: accessd at databaseadvisors.com 
	>To: "Accessd" 
	>Subject: [AccessD] Opening Recordset Error 
	>Date: Mon, 2 Jun 2003 09:56:48 -0400 
	> 
	>Can someone see what I am missing here? I keep getting the
error: "Too few 
	>Parameters: Expected 1" 
	> 
	>Dim intCounter As Integer 
	>Dim rstFunded As DAO.Recordset 
	>Dim dbFunded As DAO.Database 
	>Dim strFunded As String 
	>strFunded = "SELECT Sum([tblInvoiceFunding.FundsFromCode]) AS
Funded" 
	>strFunded = strFunded & " , tblInvoiceFunding.InvoiceID FROM 
	>tblInvoiceFunding GROUP BY tblInvoiceFunding.InvoiceID" 
	>strFunded = strFunded & " HAVING 
	
>(((tblInvoiceFunding.InvoiceID)=[Forms]![frmInvoiceDataEntry]![txtINVOI
CE_ID 
	>]))" 
	>Set dbFunded = CurrentDb() 
	>Set rstFunded = dbFunded.OpenRecordset(strFunded,
dbOpenDynaset, dbReadOnly) 
	> 
	>TIA, 
	>Nancy L 
	> 
	>_______________________________________________ 
	>AccessD mailing list 
	>AccessD at databaseadvisors.com 
	>http://databaseadvisors.com/mailman/listinfo/accessd 
	>Website: http://www.databaseadvisors.com 

  _____  

	Protect your PC - Click here
<http://g.msn.com/8HMKENUS/2755??PS=>  for McAfee.com VirusScan Online 



NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege 
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering 
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, 
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein.  
If you have received this message in error please notify the sender immediately and delete the message

Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation.
Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests:
Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, 
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030603/c62213cd/attachment-0001.html>