Marilyn Messineo
asked on
Object Variable or With Block Variable not set - Microsoft Access vba
Not sure what I'm doing wrong. But I'm receiving an error "Object Variable or With Block Variable not set":
Public Function Contracts_CRM_audit()
Dim DB As Dao.Database
Dim strSQL As String
Dim rstContracts As Recordset
Set DB = CurrentDb
Do Until rstContracts.EOF
strSQL = "SELECT Max([Report Date]), [Contract Reference No], Issue from tbl_contracts_crm_Audit_hi story GROUP BY Issue"
Set rstContracts = DB.OpenRecordset(strSQL, dbOpenDynaset)
strIssue = rstContracts!Issue & "; "
rstContracts.MoveNext
Loop
MsgBox strIssue
End Function
Public Function Contracts_CRM_audit()
Dim DB As Dao.Database
Dim strSQL As String
Dim rstContracts As Recordset
Set DB = CurrentDb
Do Until rstContracts.EOF
strSQL = "SELECT Max([Report Date]), [Contract Reference No], Issue from tbl_contracts_crm_Audit_hi
Set rstContracts = DB.OpenRecordset(strSQL, dbOpenDynaset)
strIssue = rstContracts!Issue & "; "
rstContracts.MoveNext
Loop
MsgBox strIssue
End Function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Open in new window