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!
--
Thanks!
Gary S

Also, I am running multiple versions of Access(2003,2007) and my os is vista.
--
Thanks!
Gary S


"Gary S" wrote:

> 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!
> --
> Thanks!
> 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
--
Thanks!
Gary S


"Gary S" wrote:

> 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!
> --
> Thanks!
> Gary S

Gary S <(E-Mail Removed)> wrote:

>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

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,thanks for your help!
--
Thanks!
Gary S


"Tony Toews [MVP]" wrote:

> Gary S <(E-Mail Removed)> wrote:
>
> >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
>
> 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/
>

Gary S <(E-Mail Removed)> wrote:

>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
--
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/