Object or Class does not support 2002 2003 home vs office version

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At home, sometimes I edit my program using Microsoft Office Access 2003
(11.8166.8172) SP3.
At work, I use a lower version MS Access 2002.

The form I created and edited both at home and at work begins to give me
headache. It runs well while using my own LAN ID however while testing my
program by letting somebody else's LAN ID at work she gets below error
message:


"The expression On click you entered as the event property setting
producedthe following error: Object or Class does not support the set of
events.

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

I have grown lots of hair just in case I start to lose my wits. Any help
please. See culprit below:

Private Sub OpenedDateFrom_GotFocus()
On Error Resume Next
Me.lblGetDate.Visible = True
Me.lblGetDateDueDateFrom.Visible = False
Me.lblGetDateDueDateTo.Visible = False
Me.lblGetDateOpenedDateTo.Visible = False
Me.lblGetDateDueDateFrom.Visible = False
Me.lblOpenCal.Visible = True
Me.DTPickerCalendar.Visible = True
End Sub

Could it be caused by the calendar object. The calendar activex object has
been created using my work's version. Have I missed anything here?
 
Rudy Escoto said:
"The expression On click you entered as the event property setting
producedthe following error: Object or Class does not support the set of
events.
Click to expand...
* The expression may not result in the name of a macro, the name of of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro."
Click to expand...

I strongly suspect it's a references problem.

Me.DTPickerCalendar.Visible = True

Could it be caused by the calendar object. The calendar activex object has
been created using my work's version. Have I missed anything here?
Click to expand...

Yup. Don't use the Date control. See the Calendar Tips page at my
website http://www.granite.ab.ca/access/calendars.htm

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Duane Hookum has an awesome and simple calendar in a report. See the
Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Good tip. I picked on Brendan Kidwell 's "Access Web Date Picker without
ActiveX " shown from your recommended site. The calendar picker mentions
Access 2002 however did not mention 2003. How'd that work in 2003, too? Can
we call Brendan out from zxvacation to respond eh?
 
Rudy Escoto said:
Good tip. I picked on Brendan Kidwell 's "Access Web Date Picker without
ActiveX " shown from your recommended site. The calendar picker mentions
Access 2002 however did not mention 2003. How'd that work in 2003, too?
Click to expand...

It's just a form and a module so it should work very nicely in A2000,
A2002 or A2003. I suspect it would work in A97 without many changes
and quite possibly A2.0 with a bit of work.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top