PSUIVERSON
Technical User
Recently I have begun experiencing a pretty significant glitch in MS ACCESS 2002 that is causing me a major headache. When attempting to do a simple import of any type of file (.txt,.xls,.dbf etc.) I receive a quick message box that states "Type Mismatch". When I click "OK" it takes me to a pseudo import specification wizard that has a form name of 'mx_FrmMain:Form'.
The wizard is blank and when you click NEXT you get the message:
'The expression you entered refers to an object that is closed or doesn't exist.'
Very bizzare. The really crazy thing is that it is fickle. Some days I can import without issue. Also I have modules d that using vba import .txt files that when fired off have no issue. Yet recently more and more, I am running into this problem and it's preventing myself and other members of my group to not be able to import.
NOTE:
I found only this answer on GOOGLE and the solution did not work. Has anyone else experienced this? Can you help? Thanks a ton...
The wizard is blank and when you click NEXT you get the message:
'The expression you entered refers to an object that is closed or doesn't exist.'
Very bizzare. The really crazy thing is that it is fickle. Some days I can import without issue. Also I have modules d that using vba import .txt files that when fired off have no issue. Yet recently more and more, I am running into this problem and it's preventing myself and other members of my group to not be able to import.
NOTE:
I found only this answer on GOOGLE and the solution did not work. Has anyone else experienced this? Can you help? Thanks a ton...
