Problem writing code

[JimO]

For some reason I am no longer getting the helper menu when I enter code, for example; I want to close the current form and type docmd. at this point I used to get a dropdown list of actions but now the list flashes open the closes and the docmd. turns red and I am left with no help. I have been able to type some code in say notepad and copy and paste but my knowledge of code limits me. It is a real pain to deal with. Any ideas how to get my helper menu to pop up again?

Thanks


Jim O

[CJ_London]

sounds like you have a form timer event running somewhere. Do you have any forms open (not in design view?) whilst trying to edit the vba. or is this something specific to docmd?

[JimO]

I do have a form open with a clock timer running. Is their any workaround?

Jim O

[JimO]

That is the issue. I turned off the clock and it all works now. I would like to have the clock run as well if it does not turn into a major issue.

Jim O

[CJ_London]

well it's causing problems at the moment. Depends on what you are trying to do. You could increase the timer interval or have the code triggered off a different event while testing. Or manually set the timer interval to 0 whilst writing code. But if this is supposed to be a way of working (developing code and running a timer event at the same time), you have a major issue

Good luck with your project

[JimO]

The clock is just something I was doing as a learning experience. I don't wright that much code so I guess I will turn it off as needed. It's another part of the learning curve.

Thanks for your time and input.

Jim O