ActiveX Progress Control

Topic

New Reply

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?

Reply | Quote

Replies

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, Visual Basic Controls in a Nutshell 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.

Reply | Quote

Hi Charlotte,

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

Reply | Quote

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.

Reply | Quote

Thank You, Charlotte

Yippeee.. it worked. 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)

Reply | Quote

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

Reply | Quote