Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ActiveX Progress Control

    I found an ActiveX Progressbar control in Access, but I can't figure out how to update it with the value of progress. It has Min and Max properties but no apparent Value property.

    I prefer to use it unbound and update it with a result from the MOD operator applied to the currect record number as I process the records in a table from beginning to end.

    Anybody know how to use this thing?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ActiveX Progress Control

    I haven't used it, since I generally avoid ActiveX controls, but it isn't an Access control, it's a VB object. I've found that the best way to deal with these controls is to have the O'Reilly book, <A target="_blank" HREF=http://www.bestwebbuys.com/books/search?t=ISBN&q=1-56592-294-8>Visual Basic Controls in a Nutshell</A> close at hand.

    Unlike the SysCmd progress meter in the status bar, you can't set a value for an ActiveX progressbar. You can only set a control source and give it a min and max value to define the range.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Progress Control

    Hi Charlotte,

    Thanks for answering my question. I guess I have to scout around a bit. SysCmd, eh?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ActiveX Progress Control

    Yep. The SysCmd function is full of handy stuff, not only the progress meter, but also ways to determine whether you're running a runtime version of Access, what version number you're running, the directory where msaccess.exe is located, and the state of an object, among other goodies.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Progress Control

    Thank You, Charlotte [img]/w3timages/icons/love.gif[/img]

    Yippeee.. it worked.[img]/w3timages/icons/grin.gif[/img] Not what I started off with, but a good result nevertheless.
    Here's the code I used:
    varReturn = SysCmd(acSysCmdInitMeter, "Processing...", lngNumRecs)
    varReturn = SysCmd(acSysCmdUpdateMeter,lngCurRec)
    varReturn = SysCmd(acSysCmdRemoveMeter)

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ActiveX Progress Control

    It's well worth exploring the built in stuff before trying to make external controls work. Glad you got it going.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •