The VBA prog flicker and generate problems..

[Mgomp]

Hi all.

Resently, when working with a app createt in access 2010, I have seen that the VBA make som irritating "noise" and errors;

When starting a line, the first word will be displayed i red, until the line have at least two - three words.
When writing like 'Dim Variable As Text' the VBA removes empty space between the two - three first words when writing.

On my work-computer i also see the word 'Running' flicker on the top, behind
Microsft Vusiual basic for Apllication - application name.

What can make this problem? It seem like an autocorrectur have gone crazy...

Regards,

 

[boblarson]

That behavior is usually because you have a timer running somewhere in your database.

 

[Mgomp]

Yes I have a small timer on a splash screen when the app starts.

But - first - this timer have been in the app since last november. Second - the app runs fine - the problem is the editor in VBA which creates this problem.

The problem started just a few days ago, and may there is something in the app who creates this behavior, I will chec an older backup of this app.

Regards,

 

[boblarson]

Yes I have a small timer on a splash screen when the app starts.

But - first - this timer have been in the app since last november. Second - the app runs fine - the problem is the editor in VBA which creates this problem.

The problem started just a few days ago, and may there is something in the app who creates this behavior, I will chec an older backup of this app.

Regards,

If the timer is running when you are typing in VBA it will jump backwards. Put the form in design view before working in VBA and it won't do it anymore.

 

[Mgomp]

Yepp, an older backup of the app do not create this behavior.

So, some place in the code or somwhere in the app, there are something who creates this problem.

I disabled the timer code in the splash form, without any changes...

Regards.

 

[boblarson]

Yepp, an older backup of the app do not create this behavior.

So, some place in the code or somwhere in the app, there are something who creates this problem.

I disabled the timer code in the splash form, without any changes...

Regards.

1. make sure the splash form is not even open at all.

2. Do a search on every form as there may have been a timer event accidentally added.

3. If all else fails, try doing a DECOMPILE and see if that helps.
See here for how:
http://www.granite.ab.ca/access/decompile.htm

(and before decompiling, make a backup copy so you aren't hosed if something goes wrong in the process).

 

[Mgomp]

Hi again

Thank you, Larson.

The /decompile was an new experience for me. I did not fined any timer, but after a second run with the /decompile, the vba for this app seems to act normaly again.

Thanks again!

Regards.

 

[boblarson]

Hi again

Thank you, Larson.

The /decompile was an new experience for me. I did not fined any timer, but after a second run with the /decompile, the vba for this app seems to act normaly again.

Thanks again!

Regards.

Glad to be able to help. I have found that the Decompile works in many cases where you have behavior that goes against what logic says should happen. It doesn't fix everything but for some things that get somehow not working right (for example a form which has a button which should run the click event for the button but doesn't, even though the database is in a trusted location, etc.).