Exporting Reports

[Lisa]

I am trying to export or publish a report into word. The report has about 80
stores within it. Each store starts at a new page. Some stores have many
pages to them. I want to export the report out to word, but I want each store
to have it's onw location. For example: Laurel will go to a new document and
Annapolis will go to it's own word document. Right now I publish the report
and all of the stores are in one document and I have to copy and paste them
into there own document. Is this possible?
Lisa S.

 

[Larry Linson]

It is possible to choose the data that goes into a particular report, and to
create a separate report for the separate stores you describe. It is not
possible (at least not simple, straightforward, and convenient) to print nor
export separate "pieces" of one report, if that is your question. If you
have a relatively small number of stores, doing this manually may be
feasible; even if you have a larger number, with some VBA code to automate
the printing/exporting, it should not be difficult to do what you want.

Larry Linson
Microsoft Office Access MVP

 

[Lisa]

Are you saying if I use VBA code I can export each store info into it's own
folder or are you saying that is not possible. If it is possible Can you
help, because I have no idea where to start but as we grow it is getting very
time consuming to export the report and then cut and paste each store into
the own word documents.

 

[Larry Linson]

If you use VBA code, and you have a table of stores (as I assume you must),
you could open a recordset, rst, on the table of stores, loop through the
recordset, and for each store,

DoCmd.OpenReport . . . , "[StoreIdent] = " & rst("StoreID")

to create a separate report for each store, in turn, where the field
StoreIdent contains the Store ID in the data in the RecordSource of the
Report and StoreID is the corresponding field in the table of stores (and
the recordset, "rst", you opened on that table). Then you can handle each of
those separate reports individually and send them to the appropriate store.

Just today, in another newsgroup or another message thread, I believe I saw
a reference to a pertinent example at the site of one of the Access MVPs.
Rather than spend much more time going into detail, I am going to see if I
can find that reference and add it later to this thread.

I personally almost never export Reports to Word, so for any help with how
you would drive Word to manipulate, handle, and distribute the individual
Reports would have to come from someone else.

Larry Linson