troubleshooting Question
Type Mismatch Error 13 after conversion to Access 20010 from 2003
Bob Collison
asked on
asked on
Hi Experts,
I have just converted a 2003 Access application to 2010 and when I began testing encountered Type Mismatch Error 13 in the following code between Message Test 3 and Message Test 4.
Dim DB_020 As Database
MsgBox "Test 1"
Dim RS_00_EMAIL_EXPORT_DATA_02
MsgBox "Test 2"
Set DB_020 = CurrentDb
MsgBox "Test 3"
Set RS_00_EMAIL_EXPORT_DATA_02
MsgBox "Test 4"
Has the required code changed and if so can you suggest what it should be?
I am also attaching a file containing the VBA References from the 2003 version and the converted 2010 version. Are there any that are missing / incorrect?
Thanks.
Bob Collison
EE-Question-VBA-References.docx
I have just converted a 2003 Access application to 2010 and when I began testing encountered Type Mismatch Error 13 in the following code between Message Test 3 and Message Test 4.
Dim DB_020 As Database
MsgBox "Test 1"
Dim RS_00_EMAIL_EXPORT_DATA_02
MsgBox "Test 2"
Set DB_020 = CurrentDb
MsgBox "Test 3"
Set RS_00_EMAIL_EXPORT_DATA_02
MsgBox "Test 4"
Has the required code changed and if so can you suggest what it should be?
I am also attaching a file containing the VBA References from the 2003 version and the converted 2010 version. Are there any that are missing / incorrect?
Thanks.
Bob Collison
EE-Question-VBA-References.docx
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 20 Answers and 26 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.