F8 Does not Work 1

[MacroAlan]

When I want to step thru my code I have tried F8 and only get a stupid beep. When I set a breakpoint, it never breaks.

Is there a setting I should fix?

It works perfectly in my Excel VBA -- not Access.

Alan

 

[AnotherHiggins]

Are you trying to step through an Access Macro or an Access Module? A module should work like Excel's VBA. An Access Macro is different....

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[MacroAlan]

Module in VBA

Alan

 

[CBasicAsslember]

Do you have your cursor set inside the routine you want to step through?

 

[MacroAlan]

Yes! Cursor is inside the code.

Here is the crazy thing. I took the application home to run on my own PC and it works (not works!) the same way.

I go into one of the MDBs on my own PC and add a short module. F8 works like I am expecting.

Is there a setting that would be file-specific that would prevent stepping through the code?? Where would I even begin looking?

Someone else created the DB and I was called in to fix it.

Alan

 

[xlbo]

Does the procedure you are trying to step through require parameters ? ie is it set up like

Sub/Function Proc_Name(ByVal var1 as string)

?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[MacroAlan]

[attn]Found the cure![/attn]

Go to Tools | Startup... | Use Special Access Keys

The project leader had turned this off.

Alan