"Print All" functionality

[Guest]

Hi all,

I have an app that's essentially an office issues db. So issues are the
"main" table. For each issue, there can be other realted records in tables
as well. There can be related parties whose data is stored in a contacts'
table. There can be "notes" that are stored in their own table, and there
can be external documents linked inside the app that are related to the
individual issue (scanned documents stored in an organzed file structure to
support the db).

I would like to be able to set something up that would, to the extent
possible, print all the records related to a particular issue with (in a
perfect world), only the need to hit one command button. At the very least,
I'd like to be able to hit a command button and print all related Access data
about the issue. I'm guessing that to accompish either of these goals, I'd
start by making a form that encapsulates the form where my issues are entered
into the database (basically, my 'main' form where issues are entered and/or
viewed by users). That would, I guess, give them basically the issue in
print form. Then, I'd guess I make the report larger by adding in the
records from related tables (specifically, the notes table) but possibly the
contacts table.

I guess the final thing would be to get the other (external) documents to
print. These documents would be scans or word documents mostly, and as I
said earlier they will be located in their own folder (by issue) that can be
derived by issue info (I could use some combination of the issue id, and one
or two other pieces of data to name the folders).

Bottom line: I need some direction on how to, with the least effort
possible by the users, set up something that will allow me to "print all"
'records' (internal to my access app and external including word and scanned
docs) related to an "Issue".

There's got to be a way!

Thanks,
CW

 

[Jeff Boyce]

Step one ... build a query that connects all the related rows-in-tables. No
need to build a form, as that only displays data either in tables or queries
(so, you need the query!).

Once your query is returning all the related data, then look at building a
report based on that query. You can, if needed, export a report to either
Word or Excel.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Jeff,

Thanks for the reply. That confirms what I was thinking. Now all I have to
do is figure out how to print external documents...like printing all
documents in a windows explorer folder or something.

Thanks again,
CW