[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