F8 not working in Microsoft Access 2007

In attempting to debug, or to step through some existing code, within Access 2007, the F8 key does not allow one to step through the Subs...either Private or just Sub.  What would be causing this to occur?   At the moment I'm just at the Forms that begin the Start-up  Code, for the application.
Cook09Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
First check in the  Access Options under current database and be sure  Use Access Special Keys is checked. See image below

Also some keyboards have function keys that also have another purpose. Do the keys have something else on them. If so, be sure they are enabled.

This may also help:
Error Handling and Debugging Tips for Access 2007, VB, and VBA
http://msdn.microsoft.com/en-us/library/ee358847%28v=office.12%29.aspx

Current Database Options
0
hnasrCommented:
Other running program may be assigning F8 for one of its functions.
0
Dale FyeCommented:
On of my keyboards has a Fn Lock, which resets itself to unlocked after I reboot.  That's the first thing I check.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Cook09Author Commented:
How would I know if another running program is using the F8 key?  I can open Excel and the F8 key works as it should.  The other issue is that I put a control break on virtually every Sub or Function, and then ran the OpenMenu macro, and the code never stopped, it put up the main screen and pulled in the appropriate printers.  How would the code still be working with almost all of the code having some control break within it?
0
hnasrCommented:
"How would I know if another running program is using the F8 key? "

Snagit, a screen capture software. I assigned F8 to trigger recording. I ran code and and it stopped a a break point. Pressed F8, it did not step into code, instead it showed the capture selection.

It depends on which program has higher priority to intercept the hot key (F8 in this case).

You know which program if it starts processing the action, if it continues to process the code, then another issue is causing this.

Try to reproduce the issue with a sample database and upload.
0
Cook09Author Commented:
Attached is a safe database with the VBA.  Hopefully, you can find out the F8 issue.
Test1.accdb
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I looked at your data and the Use Access Special Keys was NOT checked in the Access Options.  As soon as I checked the box and re-opened the database all is working like you want. You can debug and use F8.

See the attached copy of your database below with the Use Access Special Keys enabled.

Here is the instructions from my original reply.

First check in the  Access Options under current database and be sure  Use Access Special Keys is checked. See image below

Current Database OptionsTest1-hitechcoach.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cook09Author Commented:
Well, what was interesting was that I did check that box, and wonder how it became unchecked.  What I have found is that if there is an error that needs debugged, F8 works okay.  To just display the Code from a Form, and try to step through, it doesn't work.  I don't believe it makes a difference between Private Sub or Sub, but I've tried both and nothing happens, unless there is an error.

Were you able to step through all of the code connected to the forms?
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Well, what was interesting was that I did check that box, and wonder how it became unchecked.

Do you possible have VBA code that turns it off at startup?

I held down the shift key when I opened you data to avoid any start up code. I open a code module and figured out a name of something I could call from the immediate window.  I was not able to use breakpoints of F8 until I checked the Use Access Special Keys. Then everything worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.