Re: Exporting Reports to Word

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you, but I am still having a problem, maybe I should have said this in
the beginning, my report is based on 4 querys, so I have a main report and 3
sub reports. Each query is from different tables. Do you have any other
suggestions or am I trying to do something that is not possible.
--
Lisa S.


"gllincoln" wrote:

Hi Lisa,

Oop's. In my previous message, I somehow missed the part about export to
WORD. I guess 'the subject line' was too subtle for me... <blush>

Function myStoreReports() As Boolean

Dim rs As DAO.Recordset
dim myFileName as string

Set rs = CurrentDb.OpenRecordset("SELECT DISTINCT [Store_ID] FROM
[MyStoreTableName];")
Do While Not rs.EOF
myFileName = rs.fields(0) & "_" & Format(Now(),
"YY-MM-dd_hh-mm-ss") & ".rtf"
DoCmd.OpenReport "My Report", acViewNormal, , "Store_ID='" &
rs.Fields(0) & "'"
DoCmd.OutputTo acReport, "My Report", "RichTextFormat(*.rtf)",
myFileName, False, ""
DoCmd.Close acReport, "My Report"
rs.MoveNext
Loop
Set rs = Nothing
myStoreReports = True

End Function


Try this version of the function instead - it will send it to an rtf file
which is as close to a Word Doc as you are going to get with Access
exporting.

Gordon





"Lisa" <Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36C7A7A5-2AED-4FAD-A816-7E0BEFF938BF@xxxxxxxxxxxxxxxx
Would Ihave to set a macro for each store? If so That would not be
dynamic
enough. We are continuing to grow and open an additional 10 stores a
year
which would mean I would have to add a macro everytime a store opened.
--
Lisa S.


"gllincoln" wrote:

Hi Lisa,

The easiest way would probably be to filter the report to contain only
one
store at a time and print that 'view'. If you want to automate the
process
you could create series of macro steps to apply filter, export report,
apply
new filter, export report.

Hope this helps,
Gordon


"Lisa" <Lisa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A9D2A35E-E609-492D-84BD-751289DD6EF8@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Auto Formatting Report
    ... Duane Hookom ... I have 58 stores and want to layout ... > report one-time and 6 column report the next. ... >> MS Access MVP ...
    (microsoft.public.access.reports)
  • Re: from link how to take the printout
    ... stores only the path+picture in a field. ... But this time with a report or label. ... Make a report or label and add a picture control ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Report from cross-tab
    ... Provide enough columns on the report the the maximum number of stores you ... Save the report with no RecordSource, and nothing in the Control Source of ... report's RecordSource. ...
    (microsoft.public.access.reports)
  • RE: Exclude unique records
    ... "Katie D." ... > report and I need to change it though. ... > orders from stores who have ordered from me multiple times on this report. ...
    (microsoft.public.access.reports)
  • Re: Exporting to word - OLE Objects, pictures
    ... I am hoping that a repost might reach ... >>along with one OLE Object field that stores (unlinked, ... >>to output the report to Word or Excel (so as to be able ... >>Of course .snp will allow me to see the picture, ...
    (microsoft.public.access.externaldata)