Does an OCX exists for this problem? 1

[Flippertje]

Hello all,

i have the following problem to solve.
I've made a db with agreements. An agreement can be either:

1. not met and therefore too late
2. coming up within 10 days
3. not yet due

I'm trying to find an indicator that consists of a number of dots (depending on the amount of agreements). The dots can be in case of

option1: red
option2: orange
option3: grey

My question is:
1. has anyone seen such an indicator ?
2. or do you know of another way to create this feature?

MAAAAAANY thanks and a certain star for the golden tip !!

Scoobs

 

[MajP]

This might be able to be done simply with conditional formatting if you can use little squares instead of little circles. I have a lot of "Stop Light charts I use. In general you can have a textbox lets call it "txtBxAgreements" and test for the conditions. I if a certain condition is met, make both the background and the text the same color. This will allow you four colors, the default and 3 conditions. Send more details, so I can see if this approach works. If you need more than four conditions this can be done depending on your version of Access.

1. Describe your table structure for agreements and relevant fields
2. Describe how you determine the conditions.
3. Describe how you want to use this "control"
4. How many conditions?
5. Version of Access?

 

[Crowley16]

you can use dots as well, just use a full stop but make the font really big, then conditional format the font-colour...

--------------------
Procrastinate Now!

 

[MajP]

What do you mean "use a full stop"? How do you do this? Thanks.

 

[Crowley16]

make a label...

in the label, type a full stop "." and nothing else

set the font on that label to something huge, like 50 or so...

then set the conditional formatting on that label...

--------------------
Procrastinate Now!

 

[MajP]

Crowley,
Is that British, a "Full Stop" translates to a "Period"? The second question is how do you conditionally format a label. I thought you can only format the control with the critieria being tested. I did not think that there was a way to test another field.

 

[Crowley16]

hmm, looks like you'll have to use code...

got mixed up with conditional formatting of the entire row, ala excel...

in code, just change the .forecolor property if the value of whatever is whatever...

--------------------
Procrastinate Now!

 

[MajP]

Got it. Yeah that is easy enough in a single form view, but I thought you had found a way to do this on a continous form view. That is a common request on this site, but I have never seen a way to do that because Access treats every instance of a control on a continous form as a single control. You can change it in code, but they will all change.
But, I like the "Full Stop" idea for making a circle. You would think that they give you a rectangle, they could give you a circle.

 

[Crowley16]

erm, I'm sure you can do this individually, somehow...

mess about with the events and properties...

--------------------
Procrastinate Now!

 

[Crowley16]

just thought of a really nasty work around to this...

you could have a text box which is in front of the circle, and have the text box be transparent, and the forecolour to be the same as the background colour...

then all you have to do is to set the value of that textbox to be another fullstop, which covers the fullstop in the back so it looks like it's hidden the fullstop...

of course this does mean you need to have 3 different positions for the 3 different coloured full stops...

unless you have a series of coloured full stops all on top of each other, and just set thier values depending on the result...

very nasty way of doing things, but it would probably work...

--------------------
Procrastinate Now!

 

[Flippertje]

Many thanks for your troubles already. Is it possible to give specific color to the full stops in just one textbox?

The problem is that the number of agreements could grow beyond the width of the page...

I have a set of 'agreementholders'(i'm dutch trying to translate this in english ). Behind each 'holder' i have to create a way to make visible the amaount of agreements the hold and their status (grey/orange/green).
I tried solving this with a graph but that doesnt work because the form is continuous.

I've been exeperimenting with another approach in the meantime.
What if i use a singleform and use createobject to fill the page with 'agreementholders' (normally done with a continous form) and behind that a singlebarred graph.

Is this an idea?

 

[MajP]

No you can not have multiple colors in one control. Why can you not list agreements down the page in a continous sub form and color the agreement buttons? The main form would be the agreement holder information, and the subform would be the colored agreements and other agreement fields

If you have only three criteria (grey, orange, green) you should be able to do this no problem with the conditional formatting that I described.

 

[Flippertje]

At the moment i have the conditional format active. I'm trying to make it sexier by using 'shading' (i dont know the word for it; i mean that 2 colors get mixed) colors. also i like to show just how many agreements are red, grey or orange....

It's getting a long story and i'm beginning to believe i want too much of it

Flippertje

 

[MajP]

Not sure how you have it set up but this is my vision. This is suppose to represent a form with a subform, and a subform with a form footer.
-----------------------------------------------------------
MainForm

AgreementHolderName AgreementHodlerField 2
-------------------------------------------
SubForm Detail
ButtonColor Agreement1
ButtonColor Agreement2
.
.
ButtonColor AgreementN
------------------------------------------
Suform Footer
Count of buttonColor where Grey
Count of buttonColor where orange
Count of buttoncolor where Green
Count of buttonColor
------------------------------------------
-------------------------------------------------------