Results 1 to 8 of 8
  1. #1
    claudio.labarbera is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Oct 2015
    Posts
    4

    Open a specific pdf page on Access

    Hello!



    I want to create for each record I'm introducing in my database a link to open a specific page of a pdf file I stored in a folder.

    Thanks to help me.

  2. #2
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Good morning!

    Will there only be one linked document?

    Gina

  3. #3
    claudio.labarbera is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Oct 2015
    Posts
    4
    Yes, the document is only one but according to the record I have to link to a specific page of the file.

  4. #4
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Well I can help you with the first part of that - not sure about linking to a specific page though.

    Add a field to your table for example "Document", field type should be attachment. Then open your form in design view and drag that new field into the form. Go to form view and double click the new field - a pop up box will come up, click Add and find your related document. Once you have attached it the next time you want to view that document, just click the attachment and then "open".

    You can also make the field type a hyperlink, follow the same basic instructions, and in form view, right click on the hyperlinked field and select your file. :-)

    Hope this helps.
    Gina

  5. #5
    claudio.labarbera is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Oct 2015
    Posts
    4
    Thanks Gina for your support. Pratically I don't want to upload the file (otherwise the database will be huge) but add a command to open a file according to a defined path and, if possible, open directly on a specific page.
    With hyperlink I can add a link to open the complete file....I suppose I have to create a macro to specify the page.

    Let's see....thanks again!!!!

  6. #6
    Mahendra1000 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2013
    Posts
    101
    I usually prefer Hyperlink for this.

  7. #7
    claudio.labarbera is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Oct 2015
    Posts
    4
    Thanks Gina for your support. Pratically I don't want to upload the file (otherwise the database will be huge) but add a command to open a file according to a defined path and, if possible, open directly on a specific page.
    With hyperlink I can add a link to open the complete file....I suppose I have to create a macro to specify the page.

    Let's see....thanks again!!!!

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    The only way I know of to open a PDF at a particular page is to automate Adobe Acrobat via VBA.

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

Similar Threads

  1. VB Editor won't open specific Class Module in Access 2007.
    By IncidentalProgrammer in forum Programming
    Replies: 1
    Last Post: 02-16-2015, 11:23 AM
  2. Replies: 2
    Last Post: 08-22-2014, 12:02 PM
  3. Replies: 1
    Last Post: 05-02-2013, 08:04 AM
  4. Open specific worksheet from Access VBA
    By SltPhx in forum Programming
    Replies: 5
    Last Post: 09-17-2012, 01:09 PM
  5. Open a specific Excel application in Access
    By Hobbes29 in forum Programming
    Replies: 1
    Last Post: 02-14-2011, 06:48 PM

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