Joe O'Connell
joeo at appoli.com
Mon Apr 7 07:46:54 CDT 2008
Kathryn, ClickBook installs as a print driver and can automatically convert any document to print in booklet form. It will put the correct pages together on the "front side" of each piece of paper. It then instructs you how to reinsert the pages in the printer to print on the "back side" of each piece of paper. After it is printed, all you have to do is fold in half and you have a booklet with all pages in the correct sequence. I first used ClickBook to create booklets more than 15 years ago (DOS version). It extremely easy to use and well worth the money. Joe O'Connell -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett Sent: Monday, April 07, 2008 12:22 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Need booklet type report I still need to get it in a format to print in booklet form. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Joe O'Connell > Sent: 06 Apr 2008 8:30 pm > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Need booklet type report > > Kathryn, > > ClickBook allows you to print in booklet format. Information > can be found at > > http://www.bluesquirrel.com/products/clickbook/index.html?ASCI > D=1161&gclid=COXH1-aAyJICFQEoPQodOkxqPA > > Joe O'Connell > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Kathryn Bassett > Sent: Sunday, April 06, 2008 12:02 AM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Need booklet type report > > Four years ago, I had help from the list to make a report > that included pictures. However, that report only worked for > me as a proof for several reasons, one of which is that it is > plain 8.5x11. I ended up having to use WordPerfect to pull in > the information from Access to do what I wanted to do, > because I could figure out how to do it there. > > Now, I need to do another version (of my church photo > directory), and I've lost the WordPerfect template form that > did the work. So, before I go to the trouble of recreating > it, I thought I'd see if you all can help with doing what > needs doing either self contained in my mdb or in conjunction > with Word (I only can do easy stuff in Word). I'd rather have > a Word template to do the work so I can do further editing. > > First - versions. Access2003, though ABCtest.mdb in > http://www.altadenabaptist.org/problems/photodir is > Access2000 format because I never had reason to update it. I > have Word2003 as well. > > Second - Obviously I'm not including the photos, so for > testing you'll need to put a picture someplace and copy the > path into the photo field of the members table for all the people. > > Now, on to what I need, which is a report that will print in > booklet format. > http://www.altadenabaptist.org/problems/photodir/diretory1.jpg > shows a scan of the central pages from the old directory. > > Ultimately, when it comes to actual printing, I will need to > print things like this: > Left Right > 20 1 > 2 19 > 18 3 > 4 17 > 16 5 > Etc > > Every entry has a Lastname and Firstname, and some people > have a Connections field filled in. I do NOT want the word > Connections to print if that field is blank. See the Larson, > Lebsch and McCall entries in the above jpg for example. > > I need to have this done before the end of April so I'm > hoping that one of you is willing to work with me to do this. > > Oh, a side anomoly. Though all my paths start with > O:\Online\abc\photos, they used to start with > D:\MyFiles\Online\abc\photos. When I open the report that's > currently in the mdb, it comes up with an error that > "Microsoft Office Access can't open the file > 'D:\MyFiles\Online\abc\photos\b\bassettdavid.jpg'." I can't > find anyplace where that is, so why does it say that? If I > click ok, it then goes on to make the report. > > -- > Kathryn Rhinehart Bassett (Pasadena CA) > "Genealogy is my bag" "GH is my soap" > kathryn at bassett.net > http://bassett.net > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.7/1361 - Release > Date: 05 Apr > 08 7:53 am > > > > -- > 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 > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.22.8/1362 - Release > Date: 06 Apr 08 11:12 am > > No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.8/1362 - Release Date: 06 Apr 08 11:12 am -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com