Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2014

    Lightbulb Unanswered: File location based on a form field

    Hello there

    I'm working on adding some additions to a simple purchasing database we use at the company I work for.

    You can currently use lists to view every supplier we work with, their contacts and any purchases we have made with them. Each purchase normally has an invoice that goes with it. I'd like to be able to double click on the purchase in question (which appears in a list) and open that invoice.

    The way I'm thinking this would work would be for the file source to be based on a field in the form that contains the list.

    Currently every invoice has a consistent file name. It shows up as invoice-[po number].pdf. This PO number is stored in the purchasing system so can be referenced.

    Trouble is I have no idea how this would be done, I'm guessing it's actually some really simple VBA code. Any help would be greatly appreciated!

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    Are you talking about importing a PDF file from a perm. file location?

  3. #3
    Join Date
    Mar 2009
    Provided Answers: 15
    Use the ShellExecute API function (see: How To Use ShellExecute to Launch Associated File (32-bit))
    Have a nice day!

Posting Permissions

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