Refreshing Access App

[Richard Krupa]

Hey guys,

I have a section of code that downloads the update files off an FTP site.
The form has a progress bar indicating how much has downloaded and how much
to go etc... Obvisouly the speed of the connection dictates how long this
function takes.

When my users minimize the Access window to do something else and come back
to it later to see how much has downloaded and how much to go, the Progress
bars wont refresh and they think its stalled when in fact it has not, just
the screen will no longer refresh.

How can i fix this? If they let it go and the file finishes downloading, the
screen will finially refresh with full progress bars but only after the
downloads has finished.

If they leave it alone and keep the focus on the access app, the progress
bars will continue to updates on the screen, it only occurs if they minimize
it to do something else and come back to it later.

Any help would be greatly appreciated!!

 

[Nikos Yannacopoulos]

Richard,

You might use the On got focus event of the form to run a
couple of lines of code to Repaint the form.

HTH,
Nikos

 

[michele mitarotonda]

Hey guys,

I have a section of code that downloads the update files off an FTP site.
The form has a progress bar indicating how much has downloaded and how much
to go etc... Obvisouly the speed of the connection dictates how long this
function takes.

When my users minimize the Access window to do something else and come back
to it later to see how much has downloaded and how much to go, the Progress
bars wont refresh and they think its stalled when in fact it has not, just
the screen will no longer refresh.

How can i fix this? If they let it go and the file finishes downloading, the
screen will finially refresh with full progress bars but only after the
downloads has finished.

If they leave it alone and keep the focus on the access app, the progress
bars will continue to updates on the screen, it only occurs if they minimize
it to do something else and come back to it later.

Any help would be greatly appreciated!!

 

[michele mitarotonda]

Hey guys,

I have a section of code that downloads the update files off an FTP site.
The form has a progress bar indicating how much has downloaded and how much
to go etc... Obvisouly the speed of the connection dictates how long this
function takes.

When my users minimize the Access window to do something else and come back
to it later to see how much has downloaded and how much to go, the Progress
bars wont refresh and they think its stalled when in fact it has not, just
the screen will no longer refresh.

How can i fix this? If they let it go and the file finishes downloading, the
screen will finially refresh with full progress bars but only after the
downloads has finished.

If they leave it alone and keep the focus on the access app, the progress
bars will continue to updates on the screen, it only occurs if they minimize
it to do something else and come back to it later.

Any help would be greatly appreciated!!