Share via

Hyperlink a PDF in access

Anonymous
2019-09-25T12:41:51+00:00

Hi everyone,

in a column of a table i have the "order n." field.

i wish to link the file the record, so i can click on it and open the pdf.

is it possible?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2019-09-27T16:56:36+00:00

Yes, this is called a Split form. In a Split form you can choose to have the datasheet view on the top or bottom or either side. You can then use datasheet filtering to filter for the records you want and use the single form view to see the whole record.

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

ScottGem 68,830 Reputation points Volunteer Moderator
2019-09-27T16:19:36+00:00

A form is bound to a table. It is used to both enter new data, edit existing data and view existing data. If you want to use the form to only enter new data you can do that. A form can be in single record mode, Continuous form mode or datasheet view. That is your option.

I'm not clear what you mean by "isn't better to have it clean?"

If you want to see only the orders for this year you can apply a filter to the form to restrict it to a specific recordset.

Was this answer helpful?

1 person found this answer helpful.
0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-09-26T11:38:38+00:00

    Hi GT. I can't see what you see so it helps if you detail exactly what you did. What I suspect is that you pasted my code into the box next to the Click event. That's not how you enter code. You need to click on the ellipses (…) to the right and select the Code Builder to enter code.

    Also you can't just paste in the code I gave you. You have to use the actual path to your PDF files and the actual name of the control. Finally the On Dbl Click event is about midway down the list of events for a text box.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-09-26T06:20:42+00:00

    Hi Scottgem,

    i just tried to create a form and i got this message, after pasting your code on click event (i cannot find double click):

    Was this answer helpful?

    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-09-25T13:06:33+00:00

    Hi GT, I'm an independent adviser and can help with this.

    How does the order number relate to PDF? Do you have the PDFs saved with as orderno.pdf? For example. 45240511.pdf? If so, I would assume that all the PDFs are stored in a single folder somewhere.

    So, you can't do this with just a table. Users shouldn't work directly with tables anyway. So you create a form to interface with the table. In the Double Click event of the nr ordine control you would have code like this:

    Application.FollowHyperlink "C:\foldername" & Me.[nr ordine] & ".pdf"

    where foldername is the path to where the PDFs are stored.

    If you aren't storing the PDFs as I indicated, then you need to define how they are related.

    Was this answer helpful?

    0 comments