[AccessD] Visual Basic 2012 - Simple Gauge Tool
Dan Waters
df.waters at outlook.com
Fri Mar 20 08:50:29 CDT 2015
Those horizontal gauges with the thin vertical line are nice! However, I
would change the entire color of the bar according to what the % value is.
Dan
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
jack drawbridge
Sent: Friday, March 20, 2015 8:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Visual Basic 2012 - Simple Gauge Tool
Paul,
You may find some ideas in this article from Bacon Bits.
<http://datapigtechnologies.com/blog/index.php/using-dashboard-graphics-in-a
ccess/>
I haven't used the technique but I have read it in articles.
Cheap, simple... maybe too simple.
Good luck.
jack
On Fri, Mar 20, 2015 at 9:18 AM, Dan Waters <df.waters at outlook.com> wrote:
> Hi Paul,
>
> This is a possibility:
>
> https://visualstudiogallery.msdn.microsoft.com/8c83d3c2-40be-476a-827e
> -40f65
> aac23bb
>
> Another approach might be to just set up a horizontal bar with a
> length that's proportional to the value you want to display. For
> example, you can have a dark gray rectangle (use a panel) that's 20
> pixels high and 200 pixels long. Within that can be another rectangle
> (light green?) that's 10 pixels high and has a variable width where
> 100 pixels is = 50% of the value, and your code changes its width
> according to whatever the value is. The inner rectangle should be
> aligned left with the outer rectangle. You can also show the value
> number over the bar so the user sees the exact value.
> If you want to get cool - show the inner rectangle getting larger or
> smaller for a fraction of a second after the user enters the values.
> You could also change the inner bar's color if you reach certain
> thresholds (i.e., too high or too low).
>
> For your example, I would create a background rectangle high enough to
> accommodate two inner rectangles (one for current and one for new
> gross margins), where the two inner rectangles are of different
> colors. With one bar above the other, this gives the user a quick
> visual comparison of the two values, along with having the numeric values
displayed.
>
> Round gauges can be impressive the first time they're seen. But in
> practice, they take up a lot of space, aren't really quick to read,
> don't allow for quick comparisons, and you have to find them and learn
> to use them. I really wish I could change the dashboard in my car!!
>
> HTH!
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Paul Hartland
> Sent: Friday, March 20, 2015 2:45 AM
> To: VisualBasicList; Access List
> Subject: [AccessD] Visual Basic 2012 - Simple Gauge Tool
>
> To all,
>
> I have posted to vb group and access as I don't seem to get many
> responses from the vb group for some reason. Anyway I am looking for
> a simple gauge tool and wondered if anyone on here had any
> recommendations, basically I have a form with a grid and what I (well
> the management want) is something above the grid similar (I suppose to
> a speedometer) to show percentages, it will need to have two
> needles/pointers which will indicate current gross margin percent and
> new gross margin percent when the user enters a new price, I have all
> the calculations in place for the percentages, just need a nice simple
> to use gauge tool.
>
> Thanks in advance for any help on this...
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
More information about the AccessD
mailing list