Error 438

Question

Goodday,

I have a form in the FE that contains a ProgressBar control. I am using this control when I am formatting an Excel workbook with VBA to indicate to the user that something is happening as this Excel file has a large number of rows and takes some time to format.

All works well, except on 2 user's PC's. They get an error message "438 - Object doesn't support this property or method".

I could pin it down to the progress bar. The code where this error occur, as follows:

"Forms!EngineeringReorderForm.ProgressBar1.Max = ReOrderReportRecordCount + 100"

Any help will be appreciated.

Deon

Answer 1

Do you use an ActiveX control for the progress bar, e.g. "Microsoft ProgressBar Control, version 6.0"? If yes, do the 2 users have the same version of Office installed? Perhaps you need the re-register this ActiveX controls on these users PCs, or repair the Office installation.

Matthias Kläy, Kläy Computing AG

Answer 2

As mklaey suggests and further: Compare versions of OS and Office of the two non working computers with the working ones. The decrepancies should point you in the right direction.

---

Best regards, George

Answer 3

Hi,

Yes, I am using an ActiveX control.

All PC's are loaded the same: Windows 7 (64bit), MS Office (32bit).

The only difference is that the users do not run MS Access, but MS Access Runtime 2013 (32bit).

I have uninstalled MS Office and the Runtime and re-installed it, but get the same error. I will re-register the control and post the outcome.

Thanks

Answer 4

I have re-registered the ActiveX control on the user's PC's, but still get the same error.

Is there an alternative to the ActiveX Progressbar?

Thanks

Deon

Answer 5

I have put an example of a progress bar that uses no external tools on my OneDrive:

    https://1drv.ms/u/s!As7GRfSvBItbk5wlIgSFv1zBf2Z3Ow

It should be pretty self-explaining.

Matthias Kläy, Kläy Computing AG 

Answer 6

Thanks a mil!!

This works 100%.