VBA Event Procedures won't run in Access 2007

[mindseye11]

For some strange reason none of my Event Procedures are running in my
access database. I can use macros for events just fine, but if I want
to use a VBA event procedure nothing happens. If I put breakpoints in
at any event in the VBA code, I never see a single one come up. What
is going on here? Do I have to enable VBA somewhere in Access 2007?
I'm really pulling my hair out with this one. Thanks for any help!

-mindseye11

 

[Jeff Conrad [MSFT]]

See this page for a nice explanation:
http://www.access.qbuilt.com/html/trust_center.html

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[mindseye11]

See this page for a nice explanation:http://www.access.qbuilt.com/html/trust_center.html

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentialshttp://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info:http://www.AccessJunkie.com

----------

I've actually tried MANY things with the "Trust Center Settings",
including adding My Documents as a trusted location, but none of it
works. If my access db was untrusted though, would it still run the
macro code and restrict the VBA code? Or would it block both types of
code?

 

[mindseye11]

I've actually tried MANY things with the "Trust Center Settings",
including adding My Documents as a trusted location, but none of it
works. If my access db was untrusted though, would it still run the
macro code and restrict the VBA code? Or would it block both types of
code?

Well it seems after a reboot everything works fine. So it was one of
the many changes I made to the Trust Center that must have fixed it.
Thanks!

 

[Jeff Conrad [MSFT]]

Mindseye wrote in message:

Well it seems after a reboot everything works fine. So it was one of
the many changes I made to the Trust Center that must have fixed it.
Thanks!

Well that's a little odd, but I'm glad to hear things are working now!
Good luck with your project.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com