none
Error 438 RRS feed

  • 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

    Friday, August 26, 2016 7:32 AM

Answers

All replies

  • 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

    Friday, August 26, 2016 1:34 PM
  • 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

    Friday, August 26, 2016 2:15 PM
  • 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

    Monday, August 29, 2016 5:55 AM
  • 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

    Monday, August 29, 2016 11:42 AM
  • 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 

    • Marked as answer by Deon SA Monday, August 29, 2016 2:21 PM
    Monday, August 29, 2016 1:43 PM
  • Thanks a mil!!

    This works 100%.

    Monday, August 29, 2016 2:21 PM