VBA & Macro Problems

Use an Access VBA Progress Bar from a Splash Form

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

The user needs to run an Access VBA progress-bar example from a splash form.

How to Use an Access VBA Progress Bar 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.
Before you start

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.

Solution 1Recommended

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.

1
Add the sample code

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.

2
Check the references

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.

3
Open the form event

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.

4
Call and test the procedure

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.

Call the progress-bar procedure from the splash form
Using the form module: You can instead adapt the example as a Public procedure in the splash form's module and call it from the form event. Use the sample's actual names and object references; they depend on the progress-bar implementation.
Free Microsoft Office alternative

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.

Review and analyze Access data exported to a spreadsheetOpen and edit Microsoft Excel XLSX files and Word DOCX filesUse a familiar interface for an easier move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.