 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007VBA Event Procedures won't run in Access 2007
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  SignatureJeff 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 ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- Mindseye wrote in message: news:1179726462.951786.154290@n15g2000prd.googlegroups.com... > 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! On May 21, 1:57 am, "Jeff Conrad [MSFT]" <UseContactF...@mywebsite.com> wrote: > See this page for a nice explanation:http://www.access.qbuilt.com/html/trust_center.html > [quoted text clipped - 7 lines] > > ---------- 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? > This posting is provided "AS IS" with no warranties, and confers no rights. > Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.mspx [quoted text clipped - 10 lines] > > 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! On May 21, 11:49 am, mindsey...@hotmail.com wrote: > > See this page for a nice explanation:http://www.access.qbuilt.com/html/trust_center.html > [quoted text clipped - 28 lines] > > > 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! 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: news:1179766439.698892.39440@x35g2000prf.googlegroups.com... > 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. SignatureJeff 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 ---------- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.mspx ---------- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.