VBA code won't work in Access 2007

[MaggieL]

I'm trying to add basic code to and OnChange event for a text box on a form
but I keep getting error messages. This code worked in Access 2003. For
example:
"Dim varEndDate as Date" This code produces error message: "Object or class
does not support the set of events." "This error occurs when an event has
failed to run because MS ACCESS cannot evaluate the location of teh logic for
the event"

This error occurs for any code I have. Can you please help? Thanks, Maggie

 

[Allen Browne]

Are you using Windows Vista?

If so, you need to run Access with administrative priveleges.
Explanation of how:
http://allenbrowne.com/bug-17.html

Once you have that sorted out, and the references correct (link in article
above), you do need to tell A2007 that you trust the folder where this
database resides. The yellow box at the top of this article explains that:
http://allenbrowne.com/Access2007.html

 

[Cindy]

i am also having problems. Seems to work with MS Access 2007 here at our
company, but at the customer's company, none of the form coding works. And it
doesn't appear that they have ability to change the security setting. Does
this mean that the customer cannot use it anymore?

 

[Allen Browne]

If the customer does not have the ability to set their security, perhaps
their local policies are restricted. If so, their network administrator
should be able to sort it out for them.