Avatar of Amine400
Amine400
 asked on

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
Microsoft Access

Avatar of undefined
Last Comment
Amine400

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

+1
Amine400

ASKER
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.
Jim Dettman (EE MVE)

You cannot replace it or turn it off.  That is built into Access.

Jim.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Amine400

ASKER
And can i add the progress bar to an independent form ?
The second form should appear when push the botton
SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Amine400

ASKER
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
Jim Dettman (EE MVE)

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Helen Feddema

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Amine400

ASKER
Thanks