I have a question about recordset error. If somebody can reference a code that uses recordset, it would be helpful.
strSQL = "SELECT * FROM Proffessor"
Set dbsProject = CurrentDb
Set rstProf = dbsProject.OpenRecordset(strSQL) this line gives type mismatch error.
I am trying to make a recordset and I got a type mismatch error
Set dbsProject = OpenDatabase("C:\Palslab04\My Documents\Project.mdb")
Set rstProf = dbsProject.OpenRecordset("Proffessor", dbOpenTable)
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.