Search results

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

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

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

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

That seems to have been the problems. When I used <Ctrl>-<End> to go to the "end" of the worksheet, it went to column AK. There is no data in that column that I can see. After copying the data into a new worksheet, I was able to import the data into a new table successfully.

I am getting a "subscript out of range" message when attempting to import an Excel spreadsheet into a NEW table. I have seen a couple other references to this problem, but the recommendation seems to be "redefine the table columns". However, in this case I'm letting Access create the table...