Recordset object issues and 'too few parameters'

[bseymour12]

I am very much a novice and would greatly value any input on this issue. I had written a function which was an absolute parallel construction to the one listed below, but this one keeps giving me 'two few parameters. Expected 2' error in the immediate window. I have looked very carefully at the WHERE statement in the immediate window (debugging) and I cannot see any error. With further debugging attempts, it keeps sending me to this line: Set rt = dc.OpenRecordset(strsqli). Here is the complete code for the function:

Function arrears(longID As Long, strID As String)
 
 
 
Dim rt As DAO.Recordset
Dim startArrears As Currency
Dim dc As DAO.Database
Dim strsqli As String
 
Set dc = CurrentDb
 
 
 strsqli = "SELECT tlbstartArrears.personID, tlbstartArrears.unitID, tlbstartArrears.startBalance AS starting " & _
"FROM tlbstartArrears " & _
"WHERE (((tblstartArrears.personID)=" & longID & ")" & "AND" & "((tblstartArrears.strID)='" & strID & "'" & "));"
 
Set rt = dc.OpenRecordset(strsqli)
startArrears = rt!starting
 
arrears = startArrears
 
rt.Close
dc.Close
Set rt = Nothing
Set dc = Nothing

I have a feeling that the bang operator is not being used correctly. The sql string is just about identical in form the other function where it works perfectly. I am not experienced enough with recordsets to quite figure this one out. Please help!

[twinnyfo]

First, please use the Code tags when posting code, so it is easier for us to follow.

Second, right before the line that gives you the error, insert:

Debug.Print strsqli

Then post what is listed int he immediate window. This will help us debug what is wrong with your string.

However, one problem might be iwth your "AND"

It should probably be:

& " AND " &

Note the spaces around the keyword.

[bseymour12]

To twinnyfo,

I really appreciate input on this issue; I think that I did figure this one out! I am not sure how to use code tags feature. I presume it is the [code/] button. I will try it out.

[zmbd]

feature. I presume it is the [code/] button. I will try it out.

Yes that the ticket (^_^)

Simply click on the [CODE/] button in the post toolbar and then cut and paste your script between the [code] [/code] tags.

This link will provide some general hints on how to setup your VBA-Editor, basic troubleshooting, and how to post your formated text and scripts.

[bseymour12]

Thank you zmbd and others; this is finally coming along better. I am sure that from a design point of view, this database project is crude compared to those of professional developers, but it manages to do the trick so far.Seem to be getting the hang of sql syntax also. Evidently, a fair number of 'novices' are trying there hand at writing a database and injecting code for more customized performance.