Prev: Counting Blanks in Non Numeric Fields
Next: Create a report based on information from two forms
From: GrimesRL on 8 Apr 2010 15:42
Susan, Can something similar be done for a query based report that is grouped
by location? I have a report that the location header is grouped and forces a
new page "before section". I would like to be able to print this big report
into separate pdf files based on the location header. I do have pdf printer
capability. I appreciate any assistance you can offer. Right now I'm stumped
on how to get this done in a less time consuming manner.

~Rhonda

"SusanV" wrote:

> Not that I'm aware of - Access doesn't support pdf files natively. You can
> use CutePDF to print to a PDF, but I'm not sure you can get the loop to work
> properly with needing the input for the file save location - I've never
> tried. I was able to find this old thread which may help you:
> http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/fdc19de1fe1b331d/ad6e8422133f2bd3?lnk=st&q=access+2000+report+pdf&rnum=7&hl=en#ad6e8422133f2bd3
>
> <link may wrap>
> Good luck!
>
> Susan
>
> "Youngpioneer" <Youngpioneer(a)discussions.microsoft.com> wrote in message
> news:F48E83A8-C5A6-425C-AA07-3FE562033963(a)microsoft.com...
> > First of all, thanks very much for your reply,
> >
> > The solution was great, but still I have only one question: Could I
> > extract
> > it as a PDF format?
>
>
>
From: Lance McGonigal on 9 Apr 2010 07:53
I can tell you how I did this. It ain't pretty but it works. I built my
report on a query that gets a parameter from a screen. I loop through my
parameters placing them on the screen and then exporting them to PDF.
Southern engineering at it's finest but it works.

GrimesRL <GrimesRL(a)discussions.microsoft.com> wrote:
> Susan, Can something similar be done for a query based report that is
> grouped
> by location? I have a report that the location header is grouped and
> forces a
> new page "before section". I would like to be able to print this big
> report
> into separate pdf files based on the location header. I do have pdf
> printer
> capability. I appreciate any assistance you can offer. Right now I'm
> stumped
> on how to get this done in a less time consuming manner.
>
> ~Rhonda
>
> "SusanV" wrote:
>
> > Not that I'm aware of - Access doesn't support pdf files natively.
> > You can
> > use CutePDF to print to a PDF, but I'm not sure you can get the loop
> > to work
> > properly with needing the input for the file save location - I've
> > never
> > tried. I was able to find this old thread which may help you:
> > http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/fdc19de1fe1b331d/ad6e8422133f2bd3?lnk=st&q=access+2000+report+pdf&rnum=7&hl=en#ad6e8422133f2bd3
> >
> > <link may wrap>
> > Good luck!
> >
> > Susan
> >
> > "Youngpioneer" <Youngpioneer(a)discussions.microsoft.com> wrote in
> > message
> > news:F48E83A8-C5A6-425C-AA07-3FE562033963(a)microsoft.com...
> > > First of all, thanks very much for your reply,
> > >
> > > The solution was great, but still I have only one question: Could
> > > I
> > > extract
> > > it as a PDF format?
> >
> >
> >
>
 | 
Pages: 1
Prev: Counting Blanks in Non Numeric Fields
Next: Create a report based on information from two forms