Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open a Word File after Export (Access 2000)

    I have a report I export as a rtf file. Is there any way I can automatically have the report open in Word AFTER I export it?

    Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open a Word File after Export (Access 2000)

    I'm not sure how you're exporting your report, but if you're using the OutputTo method, check out the AutoStart argument. The below line of code exports my report named "Rpt" to a Rich Text Format document named "MyReport.rtf" at the root of my D partition. The True value as the 5th argument is what tells the OS to fire up the application associated with .rtf files. Best of luck!
    <pre>DoCmd.OutputTo acReport, "rpt", "RichTextFormat(*.rtf)", "D:MyReport.rtf", True, "", 0</pre>

    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •