Re: [MSAccessProfessionals] Save report with First_Name & Last_Name in PDF format

Ryan,

Create a new, blank report in design view with no record source. Drag the first report from the navigation pane into the report header section. Drag the second report into the detail section and the third into the report footer.

Some things to keep in mind:

1. each section can only grow to about 21 inches
2. any page sections from your reports will not display and must be replaced by report or group sections

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ryan S <ryan.paschal@gmail.com>
Sent: Saturday, March 4, 2023 6:37 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Save report with First_Name & Last_Name in PDF format

 

How to do that?

On Sun, 5 Mar 2023 at 03.30 Bill Mosca <wrmosca@comcast.net> wrote:

Ryan

One way that I've used in the past is to make one "shell" report and put all the reports you want in as sub reports. Be sure to use the "Can Shrink/Grow" properties so you don't end up with a lot of white space.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Ryan S
Sent: Sunday, February 26, 2023 11:31 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Save report with First_Name & Last_Name in PDF format

 

Dear Members,

 

How to combine multiple reports into a single PDF file?
I use MS Access 2013.

 

Thank you in advance.

 

Best regards,

Ryan

 

 

 

On Sat, 7 Jan 2023 at 11:29, LOU(at home) <lou@ix.net.au> wrote:

Hello Crystal,
thank you for your reply. Unfortunately my 'coding' capabilities are nowhere near yours and I have to confess I don't have a clue to as to what part of your code I need to use to replace my faulty code. :(
I'm sorry if I have wasted your time but I do appreciate your intentions, it's just that my old brain is not as sharp as it once was. :(
If you should get some spare time and guide me where and how to use your code it would be appreciated.

Kind regards,
Lou

--