Lots of Help needed, Please!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok so I recieved this Database. I have been asked to automate it in some way. I have also been asked to create some sort of a reporting tool that shows our progress in terms of a trafic light. Example if we are doing well then we get a green light, marginal yellow light and poorly a red light. This value will be in a percentage form. 95% and better gets a green light. Ok and here is the terrible kicker, it actually has to look appealing. The problem is that I have no idea how to do this.

Thanks..
 
I think we are going to need a lot more information about the database to be
able to help you. It's easy enough to calculate the percentages you are
talking about, but percentages of what?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


redhead said:
Ok so I recieved this Database. I have been asked to automate it in some
Click to expand...
way. I have also been asked to create some sort of a reporting tool that
shows our progress in terms of a trafic light. Example if we are doing well
then we get a green light, marginal yellow light and poorly a red light.
This value will be in a percentage form. 95% and better gets a green light.
Ok and here is the terrible kicker, it actually has to look appealing. The
problem is that I have no idea how to do this.
 
You need three bitmaps (traffic lights)
& an unbound picture control + a bound control for the percentage
then you can set the picturecontrols PictureData to either of the bitmaps in
the current_event of the Report accordingly

ie
sub Report_Current()
If Me.PCTComplete >=.95 Then
Me.PicCtl.PictureData="C:\DATA\GreenLight.bmp"
ElseIf Me.PCTComplete >=.50 Then
Me.PicCtl.PictureData="C:\DATA\YellowLight.bmp"
Else
Me.PicCtl.PictureData="C:\DATA\RedLight.bmp"
End If

end sub


HTH

Pieter
 
Back
Top