VBA Event Procedures won't run in Access 2007

  • Thread starter Thread starter mindseye11
  • Start date Start date
M

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
 
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

----------
Click to expand...
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?
 
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?
Click to expand...

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!
 
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!
Click to expand...

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
 
Back
Top