Microsoft access progress bar

In microsoft access, i have 7 reports with a total number of pages about 1200 pages.
i made a form with a botton wich allow me to extract these reports to 7 different pdf files.
I wanna replace the ordinary print dialogbox by a costum dialogbox wich contains a progress bar, the number of extracted reports, the number of printed pages and the elapsed time .
Note: the number of pages can change .
Thanks
Amine400Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
Take a look at my article located here.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
+1
0
Amine400Author Commented:
Here is my reportsThis is the bottonThis is the code of the bottonThis is the resultThis is the dialog box that i geti want to replace this dialog box by a progress bar wich contain more precise informations.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You cannot replace it or turn it off.  That is built into Access.

Jim.
0
Amine400Author Commented:
And can i add the progress bar to an independent form ?
The second form should appear when push the botton
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I take that back partially, I just remembered that you can hide it with some Windows API's:

http://access.mvps.org/access/api/api0037.htm

  However I do not know if that code will work for later versions of Access.

Jim.
0
Amine400Author Commented:
What about the progress bar ?
I wanna see :
-the number of printed reports / total number of reports
-the number of printed pages
-the elapsed time
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I do not know the answer.   You should be able to run an independent form and have the report push data into the form, but it will all need to be driven from the report.

 It is an interesting question that I would like to see if there is an answer for, but at the moment I do not have any time.   Maybe Joe or Dale will take a crack at it.

 First would be to make sure the current dialog could be hidden.   The code from MVPs.org will probably need to be modified slightly as most of the class names in Access changed with 2007.   The basic technique though of finding a pop-up dialog and hiding it is still the same in Windows.

Then you will need a test progress form.  I would start just with "Current Page" and try to update that from the reports OnFormat event of the page header, or from the OnPage event and see if that works.   If it does, then you can build from there.

 There is one other alternative to hiding anything by the way, and that is to turn off repainting of the desktop window entirely while your processing.   But since you want to display your own data, that is not an option.

Jim.
0
Dale FyeCommented:
Take a look at the article I mentioned in my first post.  That article discusses progress bar options and contains a database with a form and sample code for calling that progress bar.  It has options to allow you to actually display two different bars so you can track overall progress (call this the outer loop) and progress for an inner loop, which would show progress of the steps involved in an inner loop.

Dale
0
Helen FeddemaCommented:
Take a look at my article on progress bars -- it covers both the built-in kind and a custom progress bar, which is more visible.

Here is a screen shot of the custom progress bar:

Custom progress baraccarch181.zip
0
Amine400Author Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.