Access default FILENAME for Report ExportWithFormatting

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paul Howarth
    New Member
    • Dec 2010
    • 22

    Access default FILENAME for Report ExportWithFormatting

    I am using ExportWithForma tting in a Macro to print a Report to PDF.

    The default PDF Filename is the name of the report (in my example "rptNODGLal l".

    Is there a way to make Access set the PDF Filename as something other than the Report name?

    Since I am always manually naming the exported PDF to the Client_ID which is contained within the report, I'd like to have the ExportWithForma tting routine to default to File name = Client_ID instead of defaulting to File name = rptNODGLall.
    [imgnothumb]http://bytes.com/attachments/attachment/5933d1326398080/default-filename-screenshot.jpg[/imgnothumb]
    [imgnothumb]http://bytes.com/attachments/attachment/5934d1326398080/exportwithforma tting-screen-shot.jpg[/imgnothumb]
    Attached Files
    Last edited by NeoPa; Jan 12 '12, 09:44 PM. Reason: Made pics viewable
  • tuxalot
    New Member
    • Feb 2009
    • 200

    #2
    Can be done quite easily in VBA. Not sure in a macro.

    Comment

    Working...