Avatar of JohnGalt22
 asked on

Automatic printing of multiple forms

As part of my database, there are  rather detailed and complex medical records with a large number of data fields and graphical information, spread out over approximately 12 Forms.

Rather than struggle to fit all of this into a Report (though suggestions and advice in this area are more than welcome), I have been trying to devise some sort of automated method to simply print out, or assemble in a file (.pdf, etc), all of the clinical information on the Access Forms for a particular examination.  Adobe Acrobat offers some functionality as does the MS Snip Tool, but neither is what I would consider an automated process.

Perhaps a completely different approach than what I am considering, is more apropos?

Thanks for any help.
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon

A typical method of solving this is to create a new report that holds the current forms as subforms. The record source of report could be a query of the patient table or encounter table (whichever is has the information that unites all wanted forms). Setting Link Master Fields and Link Child Fields on the subforms, will automatically filter all subforms.


Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

<a large number of data fields and graphical information, spread out over approximately 12 Forms.>
<Rather than struggle to fit all of this into a Report >
So you are trying to squeeze all 12 forms worth of data onto one report!?

What version of Access please?

AFAICT you can do this with a standard Access report (that can be converted to a "File") if need be.

(Remember we don't no any info on your db, other than what you posted...)

If one "examination" can have many pieces of "clinical information", then the Examination data and the Clinical Data will be in separate tables related on the ExamID.

You can then build your main/subform as Pete outlined above.

Then you can use the report wizard to create a "Grouped" report.
(This is one Report equivalent of a main/subform)

Then you can put a button on the form to "Just" create a report for this one exam.

Not sure why you might need this as a "file", but you can make code to display the report, then send it to a file.
Dim strReportName As String
strReportName = "ptEmployeeOrders"
    'View the report
    DoCmd.OpenReport strReportName, acViewPreview, , "EmployeeID=" & Me.EmployeeID
    'Send Report To a PDF
    DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, "C:\YourFolder\Yourfile.pdf"

Basic Sample attached


I was really looking for an alternative to generating a report, but the advice given was helpful.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck