max.wanadoo at gmail.com
max.wanadoo at gmail.com
Fri Sep 28 10:59:41 CDT 2007
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