Thanks for your response,
Dim varRecSet As Recordset
after I changed that to
Dim varRecSet As DAO.Recordset
it worked (suggestion from other user)
Why it worked with some but not with all.
I have couple other modules which had OpenRecordset and they work fine.
Thanks again.
We are in process of upgrading our access XP database to Access 2010. I am testing this one database and getting Runtime error 13 “Type mismatch” when trying to open the form. The error is at "Set varRecSet = dbs.OpenRecordset(strPayQuery)"
“strPayQuery = "SELECT...
I like to send a .rtf and .snp format of same report as an attachment in one email.
Is there a way I can do that? We are on Access2002.
Please help.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.