VB 6 and trying to "call" an Access Form

[coyotemrh]

Using VB6 I am trying to call an access form. One site gave the code, but the first line was: Dim oAccess as Access.applicat ion

When I try to run vb. it tells me that the user type has not been defined. I guess VB 6 does not have Access.applicat ion built in as a user type. I have no idea how to (or where to) correctly define this user type. Any ideas are appreciated!

Michael.

[Killer42]

Using VB6 I am trying to call an access form. One site gave the code, but the first line was: Dim oAccess as Access.applicat ion

When I try to run vb. it tells me that the user type has not been defined. I guess VB 6 does not have Access.applicat ion built in as a user type. I have no idea how to (or where to) correctly define this user type. Any ideas are appreciated!

You need to go to the Project menu, select References, and on the resulting list, check the entry "Microsoft Access 9.0 Object Library". (The version number 9.0 may vary, of course).

(Oh, and please don't post questions in the Articles area. I've moved this one over to the main VB Forum.)