access visual basic program 'type mismatch' error

T

ted

converted a ms 2003 format file to 2007 and get the 'type mismatch' error with these 2 statements; Set dbsDatabase = CurrentDb
Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)
 
D

Douglas J Steele

Ensure that your declarations are

Dim dbsDatabase As DAO.Database
Dim rstMembers AS DAO.Recordset


"ted" wrote in message

converted a ms 2003 format file to 2007 and get the 'type mismatch' error
with these 2 statements; Set dbsDatabase = CurrentDb
Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

type mismatch 1
Working outlook via vba code with xlsx - error 0
Stumped by a Type mismatch error 2
Type mismatch error - Setting Hyperlink Base property 2
Compile Error : Type Mismatch 2
Data Type mismatch 4
access2002: type mismatch 1
Type mismatch error after access 2007 conversion in form call 0

Top