FLCoderMike
Registered User.
- Local time
- Today, 06:32
- Joined
- Nov 14, 2007
- Messages
- 29
I have a simple database, (see attached).
I am trying to generate reports based on 4 simple criteria:
Status : Paid|Unpaid|Unrealized (checkboxes)
Company ID (Select Box)
Start Date (Calendar Function)
End Date (Calendar Function)
I pass these criteria to my class and in there I select the report to open with the criteria, I do a quick select to make sure there are records to print, and I check to see the criteria and select statements to make sure they are being passed and they are, but as soon as I try to open the recordset to check the row count I get "Too few parameters, expected n"
The offending form is Report Search, the parameters to use are:
Unpaid (checkbox)
JnJ (Company)
Start Date '6/01/2008'
End Date '6/30/2008'
I have playing with this since Thursday and I am lost, any help will be greatly appreciated.
Looks like the db is too big to attach, I'll email to ayone who is willing to help. Thx.
I am trying to generate reports based on 4 simple criteria:
Status : Paid|Unpaid|Unrealized (checkboxes)
Company ID (Select Box)
Start Date (Calendar Function)
End Date (Calendar Function)
I pass these criteria to my class and in there I select the report to open with the criteria, I do a quick select to make sure there are records to print, and I check to see the criteria and select statements to make sure they are being passed and they are, but as soon as I try to open the recordset to check the row count I get "Too few parameters, expected n"
The offending form is Report Search, the parameters to use are:
Unpaid (checkbox)
JnJ (Company)
Start Date '6/01/2008'
End Date '6/30/2008'
I have playing with this since Thursday and I am lost, any help will be greatly appreciated.
Looks like the db is too big to attach, I'll email to ayone who is willing to help. Thx.
Last edited:
