Display progress of Orders graphically

[laffeg]

Hi

In an Access continuous form detail section how can you display progress of orders graphically

Each order has to go through five stages

the query will calculate for each stage whether the order has completed that stage ( based on dates in and out of each department )

I want the form control to show some sort of image - a tick - or a shaded box to show that order has completed that stage

any ideas what type form control will allow me to show the image dependent on the value of the calculated field?

thanks

 

[vbaInet]

You would need to create 5 images of rectangles that will display the varying stages.

Drop an image control that will have its Control Source set to the FULL PATH of the corresponding image based on the calculation. To achieve this it's either you create a table that will hold two fields, the values of the 5 stages and the full path then you can simply JOIN that table to your form's record source via the stages field, or you do it using several IIF()s

 

[gemma-the-husky]

you can use the progress at the bottom.

look at syscmd in help.

 

[vbaInet]

I think the OP is talking about order progress with respect to stages. And it's for a continuous form so each record will display the stage that particular order is at.

 

[smig]

you can put 5 textboxes (with no data in) and use conditional format to change their color based on your criteria.
this will give you aka progressbar for each record

you can also use the real progress bar and create a function that will calculate percent done based on all the criteria you have

 

[vbaInet]

you can put 5 textboxes (with no data in) and use conditional format to change their color based on your criteria.
this will give you aka progressbar for each record

Sounds plausible and I imagine you mentioned 5 textboxes so one can have different shades. It still won't work because the conditions must be 5 and conditional formatting doesn't support that.

you can also use the real progress bar and create a function that will calculate percent done based on all the criteria you have

Progress bars are expensive in relation to continuous forms.

 

[MMaynard]

Why not just add 5 checkboxes to the record?

 

[vbaInet]

Why not just add 5 checkboxes to the record?

The OP might think it's not graphical enough

But it's a good suggestion since that's the second option the OP was looking for. It will work with a frame and the option number would have already been calculated in the underlying record source.

 

[smig]

I'll explain my idea:
you need to use a textbox because there is no way to set conditional format for label.
what you do is make 5 small textboxes, that will look like a small rectangles close to each other.
you set their default background to something like gray, and for each one of them you set the conditional format for another criteria to change to green...

if one record passed two criteria two boxes will be green, if another record passed 4 criteria 4 boxes will be green....

it's the same as using the 5 checkboxes but look nicer

 

[smig]

in the attached picture you can see my suggestion

db is also attached

 

[vbaInet]

Good thinking smig. I'm liking the textbox graphical representation. Maybe the OP would be happy with that.

But I would still stick to less controls.