progress meter of something like that

[Pampers]

Hi everyone,
I run a couple of reports that take like 30 seconds or so. I have a WaitForm poping up with this message, and which closes as the report is ready. That works fine.

But now I tried to put something progressing (progress bar) on the form as well, but that will only execute once the report is ready... I tried it with the activeX control and a simulated progress bar, no luck. The forms work fine as stand alone, but not if you call them when the report is being generated. How to go about this?

Pampers
Keeping it simple can be complicated

 

[mhartman1]

Hello:

What you want to do is update your progress meter using the TIMER event of the form. Every time that fires, for instance 1 second, have it adjust your progress bar.

There are many examples of how to do this. It depends on your interval.

Regards
Mark

 

[mhartman1]

Hello again

Here is an article of one such way.

http://support.microsoft.com/kb/210474/en-us

Regards
Mark

 

[mhartman1]

Hello again

An example can be found at this forum site:

http://www.utteraccess.com/forums/s...3871&page=2&view=collapsed&sb=4&o=365&fpart=1

Regards
Mark

 

[Pampers]

tnx mhartman1 for all the info,

[1]The thing with the timer is that the timer won't fire untill the report has been loaded... So the report is loaded, and then the progress meter starts.

[2]Creating a recordset and moving through it (twice), seems like a waiste of resources, since the reports complex query already takes long time to executes, now it has to do it twice (three times if you the move to last record as well).

I just need a simple solutions (like the one with the on timer event) so the user can see the report is still being generated

Pampers
Keeping it simple can be complicated

 

[mhartman1]

Hello:

This is quite simple:

http://www.databasedev.co.uk/query_progress_meter.html

Regards
Mark

 

[Pampers]

tnx again mhartman1,
Tried that one before. THis one runs the progress meter first and then executes a query or report. I need something that runs DURING the opening of the report (like a flickering button on a form). Sorry to disappoint...


Pampers
Keeping it simple can be complicated

 

[mhartman1]

Hello:

Here is an example of a timer form that I put together. It has a custom pause function as well:

Regards
Mark

http://www.access-programmers.co.uk/forums/showthread.php?t=126445

 

[Pampers]

Tnx mark, the form works well... untill you run a (lengthy) report - and it doesn't matter how I run the report. The form stops flickering untill the report (preview) is done. Is there any possibility to keep the form flickering while access is building its report.


Pampers
Keeping it simple can be complicated

 

[mhartman1]

Hello

I found this paper on screen flicker:

http://support.microsoft.com/kb/907349/en-us

Regards
Mark