Creating Hyperlinks from Fields within a Table

[Vylent Fyre]

Hi all – A quick new project I am trying to tackle and would appreciate any
and all suggestions / comments

I have a table, tbl_Journal_Entries_Listings_Divisional, that has these
fields:
Div, Mth & Yr, Journal No, and Scanned JE Link.

These are the fields that I could use to create a hyperlink. For example –

P:\Accounting\Divisional Scanned JE’s\2008\05 – May\JE 654321.pdf


That’s to one scanned link. Each hyperlink will be in the same location,
however, depending on the month is where it will be stored, and it will
always have the Journal No. Since I have the Mth & Yr in the table, and the
Journal No as well, could I build the hyperlinks myself using code without
having all my users add the hyperlinks themselves?

Similar to:

“P:\Accounting\Divisional Scanned JE’s\â€(knows it is 2008 from the Mth &
Year column)â€\â€(knows the month is May from the Mth & Year column)â€\JE
“(knows the Journal No from the Journal No column)â€.pdfâ€?

 

[bhicks11 via AccessMonster.com]

Hy Vylent,

Are you using the PDF viewer in your form? I do this in an application and
it works well. Rather than a hyperlink I pass the name of the file I want to
view to the PDF viewer. I can help with this if this is what you are looking
for.

Bonnie

http://www.dataplus-svc.com