VBA Run to Line Not Working

[kyoch]

I'm working with a password protected DB and can't debug the code using the ctrl+F8 feature.

There's probably a simple fix this so does anyone have any suggestions?

 

[MarkK]

So what happens, it runs past the line with the cursor in it?

 

[kyoch]

I get the "Beep" noise from my computer and nothing happens.

 

[gemma-the-husky]

try ctrl+break.

I had a "bleep" problem with stuck code, and that identified the stuck location for me.

 

[kyoch]

Nada. No response with ctrl+break

 

[Cronk]

You do have the password, no?

 

[kyoch]

Yes, I do have have the password.

 

[arnelgp]

debug means going to vbe window, that is Alt-F11

 

[kyoch]

Ok, arnelgp.

 

[kyoch]

I'm still not able to step through my code. Anyone have suggestions? Is there a setting somewhere that got turned off?

 

[JHB]

Only this database or all other also?

 

[kyoch]

Just this one. It works in other databases.

 

[JHB]

Did you check if the option "Use Access Special Keys" for the current database is marked?

 

[kyoch]

Yes, it is marked.

 

[kyoch]

If I do ctrl+F8 on a dim line then I get the message "Line is not an executable statement", as expected. But when I try to execute a line can can be executed, nothing happens.

 

[JHB]

Place a break point in your code, when the program stops by that line, place the cursor some codelines below and then press <Ctrl>+F8.

 

[kyoch]

Placing a break in the code, then executing the code by clicking the button on my form worked. I was then able to step through the code using F8 but I still can't execute the code if i try and execute by pressing ctrl+F8 in the VBE.

 

[JHB]

If the feature is importen for you, I would suggest creating a new database and import all over in it.

 

[JHB]

I was then able to step through the code using F8 but I still can't execute the code if i try and execute by pressing ctrl+F8 in the VBE.

Hmm - maybe I misunderstand you - but ctrl+F8 steps to the line in which the cursor is.