Use an Access VBA Progress Bar from a Splash Form
Question details
The user needs to run an Access VBA progress-bar example from a splash form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A splash form should display progress while an Access procedure runs.
- Observed behavior
- The progress-bar class has initialization, update, and completion logic, but the example procedure needs to be placed in a standard module or adapted for the form.
Download and inspect the author's sample so you can identify the progress-bar class, required controls, and exact procedure names. Open your database with VBA content enabled if prompted.
Call the progress-bar procedure from the splash form
Place the example in a standard module or adapt it in the form module, then call it from the splash form's Load or Open event.
Open the VBA editor with Alt+F11. Add the author's progress-bar class and place the example procedure in a standard module using Insert > Module, following the sample's setup instructions.
Compare the procedure with the downloadable sample. Update form and control references as needed, and use the exact class, initialization, update, and completion names supplied by the author.
Open the splash form in Design View and select the form in the Property Sheet. On the Event tab, set On Load or On Open to [Event Procedure], then select the build button to open its VBA event handler.
In the event handler, call the example procedure by its actual name, passing any arguments required by the sample. Open the splash form and check that the bar initializes, updates during the work, and completes.

Work with exported Access data in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Export Access data to a spreadsheet to bring it into WPS; WPS does not run Access databases or fix Access VBA progress-bar code.

Frequently Asked Questions
Where should I put the progress-bar example procedure?
In the VBA editor, use Insert > Module to add it to a standard module, or adapt it as a Public procedure in the splash form's module. Keep the author's class and initialization requirements in place.
Which splash form event should call the procedure?
Use the form's On Load or On Open event. In Design View, select the form, open the Property Sheet's Event tab, and choose [Event Procedure] for the event.
Why can't Access find the procedure or progress-bar object?
Check the exact procedure and class names against the downloadable sample. Confirm that the class is present, the procedure is accessible from the event, and all form and control references match your database.
Can WPS Office run my Access VBA progress bar?
No. The progress bar requires Microsoft Access and its VBA environment. You can export Access data to an Excel file and open that file in WPS Spreadsheets, but the Access form and VBA code will not run there.




