Hi,

I installed Access 2003 on my new Win7 64-bit system (that also has
Office 2010 installed but nothing else from Office 2003).

If I open almost every form or report I am getting errors stating that
OnOpen, OnClose, OnClick,.... "The expression On Click you entered as
the event property setting produced the following error: Object or
class does not support the set of events". The form or report will
not run.

What is going on? Everything works fine on my XP system and all of
our clients systems (including Win7 64-bit systems)!

Any ideas?

-paulw

See if this sorts it out:
Errors using multiple versions of Access under Vista or Windows 7
at:
http://allenbrowne.com/bug-17.html

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"PW" wrote in message news:6sr3e6dgf57oudq0viam87tvr8ms9j1kio (AT) 4ax (DOT) com...

Hi,

I installed Access 2003 on my new Win7 64-bit system (that also has
Office 2010 installed but nothing else from Office 2003).

If I open almost every form or report I am getting errors stating that
OnOpen, OnClose, OnClick,.... "The expression On Click you entered as
the event property setting produced the following error: Object or
class does not support the set of events". The form or report will
not run.

What is going on? Everything works fine on my XP system and all of
our clients systems (including Win7 64-bit systems)!

Any ideas?

-paulw

On Tue, 16 Nov 2010 17:58:40 +0800, "Allen Browne"
<AllenBrowne (AT) SeeSig (DOT) invalid> wrote:

Did not work Allen :-( I chose #2. I am still getting "Object or
class does not support the set of events".

-paulw

On Tue, 16 Nov 2010 17:58:40 +0800, "Allen Browne"
<AllenBrowne (AT) SeeSig (DOT) invalid> wrote:

I just checked the references on my wife's XP Office 2003 machine. She
has "Microsoft Access 11 Object Library" checked. I do not have that
listed. I have "Microsoft Access 14 Object Library" checked.

Could that be it? If so, where would I get 11?

Thanks,

-paulw

I found msacc.olb in the OFFICE11 folder and I tried to add it to
references but it does not appear in the list (Microsoft Access 11
Object Reference). That is what my wife's Access 2003 is using. And
I can not uncheck 14 because I am told it is in use.

Aargh!

-pw

On Mon, 15 Nov 2010 19:47:21 -0700, PW
<emailaddyinsig (AT) ifIremember (DOT) com> wrote:

Run the following code and report back the references.

Sub ViewMoreReferenceDetails()

Dim refIDE As Object

For Each refIDE In
Access.Application.VBE.ActiveVBProject.References
If refIDE.IsBroken = True Then
Debug.Print "Broken, GUID - " & refIDE.Guid
Else
Debug.Print refIDE.Description & " - " & refIDE.Name & " -
" & _
refIDE.Major & "." & refIDE.Minor & vbCrLf & _
" Location - " & refIDE.FullPath
End If
Next refIDE

End Sub

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/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

The "Microsoft Access 11 Object Library" is only for use with Access 2003.
With Access 2010, you must use "Microsoft Access 14 Object Library"

"PW" wrote in message newsaj5e6td29srrfchtkibdr4s7ec001tg4u (AT) 4ax (DOT) com...

On Tue, 16 Nov 2010 17:58:40 +0800, "Allen Browne"
<AllenBrowne (AT) SeeSig (DOT) invalid> wrote:

I just checked the references on my wife's XP Office 2003 machine. She
has "Microsoft Access 11 Object Library" checked. I do not have that
listed. I have "Microsoft Access 14 Object Library" checked.

Could that be it? If so, where would I get 11?

Thanks,

-paulw

On Tue, 16 Nov 2010 16:58:49 -0500, "Douglas J Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:

I realize that. I have both versions installed. I want use the 2003
version of the library with the 2003 version of Access, and the 2010
version with Access 2010. I want to uninstall the 2010 library that
is being referenced in 2003 and use the 2003 msacc.olb.

I want to get past the object errors in Access 2003 that I now get
because it is using the 2010 library instead. I have no need right
now for Access 2010.

Make sense?

-pw

On Tue, 16 Nov 2010 14:01:32 -0700, Tony Toews
<ttoews (AT) telusplanet (DOT) net> wrote:

Okay, I will try and figure out how to run code. I sure wish Access
had a command window like in VFP!

But you know what I think the problem is, right? My version of Access
has the reference for the 2010 object library and will not load the
2003 version (msacc.olb) from the Office11 folder. It does not show
up on the list. And, I can not uncheck the 2010 box because it is
always in use (even with a blank database).

-paul

On Tue, 16 Nov 2010 14:01:32 -0700, Tony Toews
<ttoews (AT) telusplanet (DOT) net> wrote:

Okay, I put the code in a function in a module and then made a macro
to call the function.

Nothing happened when I ran it. I went into debug and only the else
statement ran each time (maybe 8 times?).

-paul