Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Question Unanswered: Acrobat in access

    I need to print an access report in Acrobat, how could I send an Intro in the active window of "Save PDF file As" in a Macro or in a VB Module to make an automatic acrobat name file?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    assuming that you have acrobat writer, or some other means of creating the PDF already sorted out.

    if you set the reports caption at runtime then you can generate a unique filename as the default suggestion to the user.

    Generally I use the reportname and a time stamp
    Me.Caption = Me.Name & "_" & Format(Now(), "yyyy-mmm-dd")
    in the forms on open event

    you could extend this using other code (eg userid pulled from an API call to retrieve the network users logon). It may be appropriate to include the reports parameters or the seconds / part seconds when the report was generated.

    This suggestion doesnt get round the problem of automatically saving the file without user intervention - but its worked so far on all sites I've used it on. It helps that the users base tends to be idle and can't be bothered to type in their own filenames.


Posting Permissions

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