Issues with conversion from Access 97 into Access 2002

[Guest]

I continue to get "type mismatch errors" when I select several command
buttons, They worked fin in 97 version, and I have debugged, I have stpped
in, stepped out. I am stummped. These commands are not tied to qrys or to
tables, there is not any alpha vs numeric issues causing the error message. I
have the Access 2002 bible, I have used Microsoft tech net. I am just not
sure where else to go. Also the previous Dim statement for databases was Dim
d as database, it no longer works in 2002 version. I have changed it to
reflect "dim db As AccessObject" Anyone have any feedback?
Thanks Christine Please do not email me directly.

 

[Marshall Barton]

I continue to get "type mismatch errors" when I select several command
buttons, They worked fin in 97 version, and I have debugged, I have stpped
in, stepped out. I am stummped. These commands are not tied to qrys or to
tables, there is not any alpha vs numeric issues causing the error message. I
have the Access 2002 bible, I have used Microsoft tech net. I am just not
sure where else to go. Also the previous Dim statement for databases was Dim
d as database, it no longer works in 2002 version. I have changed it to
reflect "dim db As AccessObject" Anyone have any feedback?

I think you have a references problem. Open the VBA window
and use the Tools - References menu item to verify that the
list is corresct and double check that each checked library
is actually installed on the machine.

This site may also help:
http://allenbrowne.com/ser-38.html

 

[Guest]

:

Okay, I have checked the references in VB. I have removed: owc10.dll,
wdmacctl.ocx, cpqbcm.dll and cpqrec.dll. I have the following selected:
Visual basic for applications, Microsoft access 10.0 object library, OLE
Automation, Microsoft activeX data objects 2.1 and Microsoft DAO 3.6 object
library. I went through all of the libraries listed in references I could not
locate any as “missingâ€. Any more ideas? I am running on a 2000 Server,
Access 2002 application on Microsoft Professional O/S. However there are a
few users who are running XP Professional as well. Help ;0) Christine

 

[Marshall Barton]

Okay, I have checked the references in VB. I have removed: owc10.dll,
wdmacctl.ocx, cpqbcm.dll and cpqrec.dll. I have the following selected:
Visual basic for applications, Microsoft access 10.0 object library, OLE
Automation, Microsoft activeX data objects 2.1 and Microsoft DAO 3.6 object
library. I went through all of the libraries listed in references I could not
locate any as “missing”. Any more ideas? I am running on a 2000 Server,
Access 2002 application on Microsoft Professional O/S. However there are a
few users who are running XP Professional as well. Help ;0) Christine

Are you still having trouble with the Dim db As Database
statement? Database is a DAO library object, so it should
work if you have a reference to that library. If it doesn't
work, it usually means some other library is not right.

If that statement now works, what new problem are you
seeing?

Are you sure you need both ADO and DAO? I can't tell from
here, but I suspect that the ADO library is the one that's
getting in the way. If you really are using both libraries
(unusual in A97), then you will have to disambiguate the
items in them that have the same name, e.g. Dim rs As
DAO.Recordset.

 

[Guest]

You rock. I feel so silly and that apparently was it. I removed: Microsoft
activeX data objects 2.1 and so far so good. I went in and re-edited the code
and so far 4 of the 5 issues I was having have been resolved. Thank you so
much for your help.