Page 4 of 4

Re: Enable/Disable a Main Menu

Posted: Tue Dec 03, 2013 9:21 am
by serge_girard
Scot,

You first count the number of loops to set the RangeMax and within the loop you set the Value.

Serge

Re: Enable/Disable a Main Menu

Posted: Tue Dec 03, 2013 11:47 am
by CalScot
It's 3:45 a.m. here, and I'm very tired, but I already have the progress bar working for a couple of the steps. Much, much easier!!

The Do While !Eof() ones are easy: Just set the progressbar to 1-100, set the update trigger to the record count/100, and have a loop counter that increments the bar value +1 and resets the counter to zero whenever the trigger is reached.

It's the ones with multiple separate steps - creating files, copying differing numbers of records, etc., - that will be hard to calibrate to a scale. Ah well, it can still only be easier than trying to get labels to blink!

And so to bed.
CalScot

Re: Enable/Disable a Main Menu

Posted: Tue Dec 03, 2013 11:55 am
by serge_girard
Calscot,

Sleep well, tomorrow it will be easier!

Serge