[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