Problem: Screen Refreshing in Access 2007

[painterz]

Hi All,

I've searched the forum for a screen refreshing issue. I'm using Access 2007 and I'm not using a tab control. I did use a tab control but dumped that design. My screen keeps refreshing about every minute. When I'm in the modules writing code, all of sudden I'm back to my main screen. Even when I'm in tables selecting a record--all of sudden I'm back to main screen. It doesn't matter what I'm doing, I keep getting put on my main screen.

This didn't use to happen so I've turned something on/off. Does anyone know what's causing this? It's a pain!

Thanks

 

[CJ_London]

not sure hwat you mean by 'main screen' but some guesses...

have you an open form with a timer event?

It's April 1 - someone playing a joke on you?

perhaps you have picked up a virus?

 

[painterz]

Sorry, for clarity main screen is my main form that contains subforms. It is form that automatically loads when I open my db.

I'm not sure how to set a timer. Is that an event on a control?

HaHa! This has been going on before today, April 1.

I have antivirus protection but not sure how good it works across platforms. I'm running Access on a Mac using Parallels (software that runs both MS and Apple OS).

 

[painterz]

The TimerInterval on all forms is set to 0.

 

[painterz]

Another note: this only seems to happen when I form is in "form view". I haven't noticed a problem in "design view".

 

[CJ_London]

the fact it only happens when a form is open implies either there is some code running which is pulling the focus back to the form or if in vba editor you are selecting that forms module.

or perhaps you are just click on it unwittingly

 

[painterz]

Definitely not clicking on any forms.

How do I know if VBA is running in the background? As far as I know, I'm only calling code in "on click" events, either on the forms or control buttons. Where else could I have code running?

 

[CJ_London]

Sorry, other than rebooting (perhaps a windows update is not fully installed) I'm out of suggestions.

 

[speakers_86]

Certainly sounds like a timer is running to me. Look at your form's properties and set the timer interval to 0.

 

[painterz]

I've rebooted when I updated yesterday (OS update). I compacted the db when I uploaded my db, yesterday--so I think I'm up on everything. This has been going on for the past week at least.

Here's a thought--I do have a function in a module, outside of the form, that puts the focus on a particular field in the subform. Would it continuously run in the background? Or only when it's called? I call it in a few controls on the subform but it's not called outside of the form so what would keep it running? (I actually just saw my Windows desktop shimmer and my form is in design mode so maybe it's not that function causing the problem.)

 

[painterz]

Thanks Speakers, it does seem like a timer interval, but as I mentioned earlier--all of my forms timer intervals are set to 0.

 

[painterz]

Hi CJ,

I've commented out all of my .refresh and .setfocus in my Utilities module (runs outside of my forms). But again, I just saw my Windows desktop shimmer, so I don't think that's going to solve my problem. Do you know what runs in the background of Access? Again, I think it's a setting I inadvertently set somewhere.

I've looked in the Advanced Options and nothing stood out as a "refresh".

Thanks

 

[JHB]

Is it possible for you to post the database with some sample data?
Is it only in one form it happen, or in all?
And the same question for databases - only in one database or in all?
Create a new database and import all from the old one.

 

[CJ_London]

I just saw my Windows desktop shimmer

bit different from a form coming to the fore - what version of windows are you using? could be your anti virus or other routine running in the background

 

[painterz]

Hi CJ,

I'm running Windows XP on a Mac OS Mountain Lion using Parallels Desktop v 5 (I think).

Not the norm, but it's how I roll

Thanks

 

[painterz]

Hi JHB,

Yes, I'm working with a test db so no problems uploading it to the group. I have my content disabled but my form still comes to the front when it's in form view. I haven't timed it but it happens on regular intervals, I'm guessing every minute. My form contains 2 subforms and 2 sub-subforms so not sure where this is coming from.

I'll take your suggestion and create a new db and import everything. If that doesn't work, I'll upload my db.

Thanks