<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=362264001-03062003><FONT face=Arial color=#0000ff size=2>Great
*simple* idea Don. I will take that one on board too.
</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV><!-- Converted from text/rtf format --><BR>
<P><SPAN lang=en-au><FONT face=Arial color=#0000ff size=2>Regards</FONT></SPAN>
</P>
<P><SPAN lang=en-au><FONT face=Arial color=#0000ff size=2>David</FONT></SPAN>
</P>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com] <BR><B>Sent:</B> Tuesday, 3 June 2003 2:34
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD]
Opening Recordset Error<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>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.<BR>_d<BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Nancy Lytle" <NANCY.LYTLE@AUATAC.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "Accessd" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Opening Recordset Error
<DIV></DIV>>Date: Mon, 2 Jun 2003 09:56:48 -0400
<DIV></DIV>>
<DIV></DIV>>Can someone see what I am missing here? I keep getting the
error: "Too few
<DIV></DIV>>Parameters: Expected 1"
<DIV></DIV>>
<DIV></DIV>>Dim intCounter As Integer
<DIV></DIV>>Dim rstFunded As DAO.Recordset
<DIV></DIV>>Dim dbFunded As DAO.Database
<DIV></DIV>>Dim strFunded As String
<DIV></DIV>>strFunded = "SELECT Sum([tblInvoiceFunding.FundsFromCode]) AS
Funded"
<DIV></DIV>>strFunded = strFunded & " , tblInvoiceFunding.InvoiceID
FROM
<DIV></DIV>>tblInvoiceFunding GROUP BY tblInvoiceFunding.InvoiceID"
<DIV></DIV>>strFunded = strFunded & " HAVING
<DIV></DIV>>(((tblInvoiceFunding.InvoiceID)=[Forms]![frmInvoiceDataEntry]![txtINVOICE_ID
<DIV></DIV>>]))"
<DIV></DIV>>Set dbFunded = CurrentDb()
<DIV></DIV>>Set rstFunded = dbFunded.OpenRecordset(strFunded,
dbOpenDynaset, dbReadOnly)
<DIV></DIV>>
<DIV></DIV>>TIA,
<DIV></DIV>>Nancy L
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></DIV><BR clear=all>
<HR>
Protect your PC - <A href="http://g.msn.com/8HMKENUS/2755??PS=">Click here</A>
for McAfee.com VirusScan Online </BLOCKQUOTE><CODE><FONT SIZE=3><BR>
<BR>
NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege <BR>
intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering <BR>
the message to the intended recipient, be advised that you have received this message in error and that any dissemination, <BR>
copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. <BR>
If you have received this message in error please notify the sender immediately and delete the message<BR>
<BR>
Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation.<BR>
Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests:<BR>
Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, <BR>
Kobe Alumina Associates (Australia) Pty Limited 10 percent, Nissho Iwai Alumina Pty Limited 4 percent.<BR>
</FONT></CODE>
</BODY></HTML>