After Update...error

[ryguy7272]

I recently installed Access 2007 on my system. I am also running Access
2002. Almost without exception now, when I try to run any code in 2002, such
as an After Update Event Procedure on a ComboBox, I get an error message.
Even simple code like this:
Private Sub cboPerson_AfterUpdate()
Me.List2.Requery
End Sub

DOES NOT run.

I get this message:
The expression After Update you entered as the property setting produced the
following error: Object or class does not support set of events.

The expression may not result in the name of the macro, the name of the
user-defined function, or [Event Procedure]
There may have been an error evaluating the function, event, or macro

This file runs perfectly fine in 2007 (and used to run fine in 2002).

What does this mean? There must be a setting somewhere that I need to
change, right. I’m assuming that this is an easy fix.


Appreciate any help with this.

Thanks!
Ryan---

 

[Tony Toews [MVP]]

Thanks Gina! I looked at that. It is set to Microsoft ActiveX Data Objects
2.1 Library. Everything is 12.0 Object Library.

I have Access 2001, with SP3. AFAIK, this is version No. 9, right. 2002
was Version No. 10 and 2003 was Version No. 11. Now everything seems to be
default Version No. 12. I don't see Ver. 9, 10, or 11 anywhere. It is set
to 12.0 now; causing problems.

Errors using multiple versions of Access under Vista/Windows 7
The expression <multiple> you entered as the event property setting
produced the following error: Object or class does not support the set
of events.
http://allenbrowne.com/bug-17.html

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 free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[ryguy7272]

Thanks Gina and Tony. I’m looking at the References in my Access 2003 right
now. I see only Microsoft Access 12.0 Object Library – nothing listed about
Microsoft Access 11.0 Object Library. Also, I see only Microsoft Office 12.0
Object Library – nothing pertaining to Microsoft Office 9.0 Object Library,
like in Allen Browne’s article (I love his stuff).

It seems like I can’t use mixed references; that’s the whole problem. I
have no relevant reference older than 12.0.

BTW, again, I am experiencing these errors in my MS Access 2003.

Any ideas on what I may be doing wrong? There must be some way of forcing
those older references to show, right.

Thanks!
Ryan---

 

[Tony Toews [MVP]]

Thanks Gina and Tony. I’m looking at the References in my Access 2003 right
now. I see only Microsoft Access 12.0 Object Library – nothing listed about
Microsoft Access 11.0 Object Library. Also, I see only Microsoft Office 12.0
Object Library – nothing pertaining to Microsoft Office 9.0 Object Library,
like in Allen Browne’s article (I love his stuff).

On his page where you see A2000 and 9.0 substitute your A2003 and
A11.0.

You need to follow his work arounds

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 free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Gina Whipp]

Ryan,

Did you read the whole page? Allen provided some causes and reasons. You
might also have some early binding going on which only you would know.
(http://www.granite.ab.ca/access/latebinding.htm)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ryguy7272]

Thanks again Tony! I believe I followed the instructions exactly; still not
working for me. I guess this is good motivation to embrace Access 2007 and
never look back...since literally my 2003 won't really do anything now...

Thanks again!
Ryan--