Access 2007 Breakpoints

[carlboone]

I'm wondering if I don't have Access 2007 configured properly. I can't seem to intercept any events. Nothing happens when I set a breakpoint on an event such as On Enter.

In trying to figure out what's going on, I created a simple text box on my switchboard form called txbTest. I added code to the On Load event which is a very simple statement: me!txbTest="Test". Even this simple code doesn't seem to be working - the txbTest is remains empty after the form is loaded. I just tried exactly the same thing in Access 2000 and it works as expected.

 

[boblarson]

Go to the Office Button > ACCESS OPTIONS and then make sure, under Current Database, that you don't have the USE ACCESS SPECIAL KEYS unchecked. Normally you would keep it unchecked to keep F11 from being used but it also keeps breakpoints from being used, so if you want to use breakpoints you have to check that box.

 

[carlboone]

Enable Special Access Keys is checked. So that's doesn't seem to be the problem.

 

[carlboone]

I meant "Use Access Special Keys" is checked...

 

[boblarson]

Then do you have the database location set as a trusted location (see here for more about that).

 

[vbaInet]

Remember to check the related Event column on the property sheet to ensure that "[Event Procedure]" is selected.

 

[carlboone]

[Event Procedure] is selected..

I added the Trusted Location and both the simple code on my switchboard and the breakpoints are now working. Now I can start debugging my application.

Thanks for the assistance.

 

[boblarson]

[Event Procedure] is selected..

I added the Trusted Location and both the simple code on my switchboard and the breakpoints are now working. Now I can start debugging my application.

Thanks for the assistance.