need forms help from VBA code

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I'm working on a progress bar for my app. My problem is
that every example I can find, and there are NOT a whole
lot, always have a button you have to click. And every
click causes the bar to move.

I see NOTHING about how to open, update and close the
form from my function in my module. And the several
books I have aren't helping either. I've tried a
DoCmd.OpenForm, but can't get it to work. But I'm not
even sure I'm on the right track.

Could someone possibly give me...a hint? With a form
name of frmProgBar, how would I open, update, and close
my form?

Also, how does one get the wording "inside" the progress
bar?

Any help is very much appreciated. Thanks in advance,

Tom
 
A nice looking simple progress bar can be created by drawing a rectangle from
the toolbox on your form, setting its backstyle to normal and backcolor to
yellow. Then create a label with a normal backstyle and blue background and the
same height as the rectangle. Place the label inside the rectangle at the left
side and set its width to 0. Now all you need do in your code is to
incrementally change the width of the label. Keep in mind that the width is
expressed in twips (1 twip = 1/1440")
 
Back
Top