Joe O'Connell
joeo at appoli.com
Sun Apr 6 22:29:45 CDT 2008
Kathryn, ClickBook allows you to print in booklet format. Information can be found at http://www.bluesquirrel.com/products/clickbook/index.html?ASCID=1161&gcl id=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