Re: Run Time Error 3061 - Too Few Parameters

#1

Quote:

Dim l_db As Database, l_msg As String, l_rs As Recordset

Set l_db = OpenDatabase("c:\lisa\lisadat.mdb")
Set l_rs = l_db.OpenRecordset("SELECT COUNT(AgentsCustomerID) As
aCounted FROM QuoteHeaders WHERE AgentsCustomerID=" & Chr$(34) &
Me![AgentsCustomerID] & Chr$(34))

Try inserting a semi-colon at the end of the SQL statement (I did not
try to replicate your error).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Run Time Error 3061 - Too Few Parameters

comp.database.ms-access comp.database.ms-access

Re: Run Time Error 3061 - Too Few Parameters - 04-08-2004 , 08:10 AM