[AccessD] FW: FW: Create a BarGram from data

Arthur Fuller fuller.artful at gmail.com
Fri Sep 28 17:07:02 CDT 2007


If it were me, I would do it in Excel not Access. It's simple to export the
data to Excel.
hth,
Arthur

On 9/28/07, max.wanadoo at gmail.com <max.wanadoo at gmail.com> wrote:
>
> Thanks Don, that is Ace!
> I will use that as it looks nice and simple.
>
> Jim: Thanks for sending the Excel Code.  It is appreciated.
>
> Regards
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray,
> Don
> [IT]
> Sent: Friday, September 28, 2007 6:34 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: FW: Create a BarGram from data
>
> Max,
>
> Or more simply:
>
> MaxRectangleHeight = 4 * 1440
> NewRectangleHeight = (Raised / Target) * MaxRectangleHeight
> Me!rctRaised.Height = NewRectangleHeight
>
> That's about the way I've done it.
>
> Good luck!
>
> Don
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> max.wanadoo at gmail.com
> Sent: Friday, September 28, 2007 10:02 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] FW: FW: Create a BarGram from data
>
> It does Don,
> Thanks very much.  You see, what I can do is use an Access report/form or
> whatever, which is scaled correctley for the actual v target and the use
> the
> PntScrn button on the keyboard, past it into Paint and save as a
> jpeg.  This
> I can then drop onto the web page on, say, a weekly basis.
>
> I just need the code to generate the correct "picture" in Access so that
> it
> is accurate.
>
> So if target = 100% and equals £100,000 and equals  4inches (4 x 1440
> twips)
>
> and
>
> we have raised £20,000 to date then the corresponding bar is:
>
> Raised = ((20000/10000) * 100)=20% of 4inches (=5760 Twips)
> 5760*(20/100)=1152 Twips
>
> Excel give me: =(4*1440)*((Raised/Target)*100)/100
>
> Have I got this right or is there a better way of scaling it?
>
>
> Ta very much
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray,
> Don
> [IT]
> Sent: Friday, September 28, 2007 5:32 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: FW: Create a BarGram from data
>
> Max,
>
> The way I did it was to establish a position on the page, bar width, and a
> maximum bar height for the rectangles.  If you have only two values to
> compare (walked v target) just make the rectangle representing the target
> the maximum size and whatever color you want it.  Then you can superimpose
> a
> rectangle of a different color over the target, and set its height value
> according to the ratio of walked to target.  Just apply the same ratio to
> the max height, set that as the height value, and redraw.  Note that the
> properties sheet expresses the rectangle's dimensions in inches, but your
> code must use twips.  1 inch = 1440 twips, if my memory serves.  I've also
> done this by positioning different sized rectangles next to each other
> when
> I had more than two metrics to compare to the whole.
>
> Hope this helps . . .
>
> Don
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> max.wanadoo at gmail.com
> Sent: Friday, September 28, 2007 9:00 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] FW: FW: Create a BarGram from data
>
> I have never done this Don,
> Can you Scale a range so that it, say, fits a given size and then, say,
> colour the increasing element, say blue, and the bit still to go, say red?
>
> It would be a start.
> Thanks
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray,
> Don
> [IT]
> Sent: Friday, September 28, 2007 4:51 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] FW: FW: Create a BarGram from data
>
> Max,
>
> Well, you probably already have this part figured out, but it's the only
> part I have an idea about.  I've created "bar charts" on Access reports
> and
> forms using retrieved values to describe the dimensions of rectangle
> controls.  But I suspect that your question is aimed more at creating the
> graphic externally using Access data and moving it into your website,
> presumably in an automated way.  That's beyond my ken, for sure.  I've
> never
> used Access pages, but maybe there's some potential there?
>
> Good luck . . .
>
> Don
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> max.wanadoo at gmail.com
> Sent: Friday, September 28, 2007 8:33 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] FW: FW: Create a BarGram from data
>
> Sorry for the repeat posting, but I have to try one more time to see if
> anybody can help me with this.
> Thanks
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> max.wanadoo at gmail.com
> Sent: Friday, September 28, 2007 1:51 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] FW: Create a BarGram from data
>
> Hi folks, just re-posting this hoping that somebody will be able to help
> me
> out here.
> Ta
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> max.wanadoo at gmail.com
> Sent: Friday, September 28, 2007 6:38 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Create a BarGram from data
>
> Hi Folks,
> I have to do something which I have never done before and would really
> appreciate your help and feedback.
> The charity I support is doing a charity walk and we need to have a guage
> generated showing progress (something like you see on the side of a church
> to show how the restoration fund for the new church roof is progressing).
>
> My Access tables will capture the MilesWalked v MilesTarget and
> FundsRaised
> v FundsTarget.
>
> Somehow I have to generate a "picture" of each from these values which I
> can
> then drop onto the web site as two graphics.
>
> I will need to "scale" the MilesWalked to the MilesTarget and create the
> "picture" from that.
>
> And then do the same with the funds.  A sort of Progress Bar thingie but
> for
> the web site.
>
> All input is captured into an MDB, but how on earth do I do the rest?
>
> Any help would be most appreciated.  Evan a start point.
>
> Thanks
> Max
>
> --
> 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
>
>
>
> --
> 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
>
>
> --
> 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