Search results

I'm having some trouble with my code (posted below). It keeps throwing run-time error 3464 at me at the "Set rs = db.OpenRecordset(strSQL)" line. Any ideas? Private Function concDegrees(r As DAO.Recordset, n As DAO.Recordset) As String Dim rID As Long, strDegrees As String, rs As...

I'm trying to write a DLookup (and DMax) using an array as one of the criteria (code snippet below). However, I'm not sure how to get it to work. I need it to only return the [PeriodStart] if the [TitleCode] is one of the numbers in the array titleCodeSearch. I had thought there was an "In"...

I'm having a bit of trouble creating a DCount statement in my code, I'm hoping that I can get help for it here. I'm also hoping I'm posting this in the right section :D Basically, what I'm trying to do is get the number of childbearing leaves after a given date (newStart, in this case)...