Code Works on 1 pc but not the other

[Gary S]

Hi,

For some reason code on one pc works fine, but none of the
code works on another pc(Access 2003). Even the most basic
code like opening a form I get the message: "Object or class
does not support the set of events". I have check the vba
references and they seem to be okay. Help!

 

[Gary S]

Also, I am running multiple versions of Access(2003,2007) and my os is vista.

 

[Gary S]

These are the references I am using:
1) Visual basic for applications
2) MS Access 11.0 Object Library
3) OLE automation
4) ms dao 3.6 object library
5) ms visual basic for applications extensibility 5.2
6) ms activex data objects 6.0 library
7) ms actviex data objexts recordset 6.0 library
8) ms ado ext 6.0 for ddl and security

 

[Gary S]

Tony,thanks for your help!
--
Thanks!
Gary S

Do you really need items 5, 7 and 8? Remove those one at a time and
try compiling.

Are you sure that the 6.0 is correct for the ADO references? I
would've thought 2.8.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

Tony,thanks for your help!

You're welcome.

But also please let us know what works for you and what doesn't work.
This will help us help others for the future.

Tony