Doug Steele
dbdoug at gmail.com
Wed Feb 4 23:49:56 CST 2015
Thanks, Bill. I appreciate all suggestions. I'd like to make it as easy on myself as possible before I talk to my client. On Wed, Feb 4, 2015 at 9:33 PM, Bill Benson <bensonforums at gmail.com> wrote: > No, but I just was making a general suggestion to check out 3rd party sw > before killing myself trying to get quality eye charts from Access... > figured it was not that application's strong suit and maybe a 3rd party had > it covered. Sorry if I gave the impression this was from personal > experience. Trying to find a less painful path for you to try out Doug. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele > Sent: Thursday, February 5, 2015 12:21 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Fancy graphs from Access > > Bill: do you have any experience with DashboardBuilder? > > Dan: my experience with graphing in Access (only in A2003, mind) was > comparable to doing my own dental work with a pair of pliers and a hammer. > Both of them bent and rusty :) > > The options - Access, Excel, outside software, that have been suggested, > bring up an interesting thought. I worked for this client as a full time > employee for several years until I moved away. If I had spent three days > in > the office logging my time as 'research', nobody would have complained. > But if I now try to research their request with an invoice for 24 hours at > my standard billing rate, the proverbial s*** would hit the fan. > > Doug > > On Wed, Feb 4, 2015 at 8:26 PM, Darryl Collins < > darryl at whittleconsulting.com.au> wrote: > > > I tend to vote with Bill on this one. Let each bit of kit stick to > > its strengths. Excel is a lousy database and Access makes a poor > > charting platform. > > > > Why not just push the necessary data into Excel and make the charts > > there? You can even link Excel into Access if you want, although this > > brings with it some other issues that a stand-alone solution avoids. > > > > Horses for course yada yada. > > > > Cheers > > Darryl. > > > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com [mailto: > > accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson > > Sent: Thursday, 5 February 2015 3:14 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Fancy graphs from Access > > > > curious, why should people reinvent a wheel that third party sw seems > > to have reasonably covered? Does the 3rd party sw cost too much or > > fail to deliver? I hate tedium. If I could avoid it for non-specific > > crap like charting and dashboards I would certainly look into it, > > especially for commercial stuff where someone else is willing to foot > > the bill. They will pay a lot for my time to develop based on my > > billing rate and learning curve. > > On Feb 4, 2015 5:52 PM, "Dan Waters" <df.waters at outlook.com> wrote: > > > > > Hi Doug, > > > > > > You can make a variety of good-looking charts in Access. This looks > > > like a good place to start: > > > http://www.functionx.com/access/Lesson32.htm > > > > > > However, you may have to give up on pie charts. The reason is that > > > the leader lines for each section of the pie end up on top of each > > > other, and they cannot be relocated in code (every pie chart I ever > > > made in Excel needed to have the leader lines manually located to be > > > viewable). I guess if you turn the leaders off (if possible), then > > > you can just use the legend to show which pie section is for what. > > > > > > I've made some interesting charts in Access. It's tedious, and you > > > sometimes have to do some magic with queries, but hopefully your > customer > > > will like them. Expect to put some hours into developing each chart, > > and > > > charge accordingly. > > > > > > Good Luck! > > > Dan > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug > > > Steele > > > Sent: Wednesday, February 04, 2015 16:30 PM > > > To: Access Developers discussion and problem solving > > > Subject: [AccessD] Fancy graphs from Access > > > > > > I've just had a client ask how he can print some fancy formatted pie > > > charts and graphs from an Access database. I don't have a clue - > > > can anyone suggest a work flow that he can use? I can always build > > > a query to get the data out to Excel or ???, but from that point > > > onward I > > have no experience. > > > > > > Thanks, > > > Doug > > > -- > > > 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 >