Results 1 to 2 of 2
  1. #1
    robimi is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    Access Macro/VBA to load up a PDF

    Hello all,

    I have 1900+ records, of where each record is represents a PDF Document in my folders.

    Each document in my folders is named in the same format "2014-001a" for example. This is the combination of two fields in my Access Database - Document Number and Current Revision.

    I am looking for some Macro/VBA where I can put the same command on every records form, that will then recognise the Document Number and Current Revision of that record, and then "On Click" able to directly load up that Pdf.

    I hope someone can help,

    Thank you,



    Rob

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I would use FollowHyperlink with a string variable. Build that variable by concatenating fixed parts of the path with the field values:

    Variable = "Start of path" & Field1 & "-" & Field2 & ".pdf"
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-21-2015, 02:02 PM
  2. Replies: 1
    Last Post: 11-18-2014, 12:35 PM
  3. Load excel to access database
    By Rajesh in forum Programming
    Replies: 7
    Last Post: 01-03-2014, 11:44 AM
  4. Replies: 7
    Last Post: 03-27-2012, 09:51 AM
  5. Run macro on form load?
    By stu_C in forum Forms
    Replies: 3
    Last Post: 08-16-2011, 07:54 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums