Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Type Mismatch Error 13 after conversion to Access 20010 from 2003

Avatar of Bob Collison
Bob CollisonFlag for Canada asked on
Microsoft Development
26 Comments1 Solution315 ViewsLast Modified:
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_020 As Recordset
MsgBox "Test 2"
Set DB_020 = CurrentDb
MsgBox "Test 3"
Set RS_00_EMAIL_EXPORT_DATA_020 = DB_020.OpenRecordset("00_EMAIL_EXPORT_DATA, dbOpenTable")
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
ASKER CERTIFIED SOLUTION
Avatar of HainKurt
HainKurtFlag of Canada imageSr. System Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 26 Comments.
See Answers