Open hyperlink and print documents

[Hossein]

My dear friends

I have some hyperlink in my database as below picture:





I create a report which prints some information on A4 paper. for example this information belongs to PO Number 90101205 [you can find this PO number in picture]

Finlay I need to a VBA code that opens hyperlink and prints attached documents to related PO number 90101205 as well

[June7]

Maybe. Review https://social.msdn.microsoft.com/Fo...-external-file

I have not gotten anything to work yet.

If these are PNG image files, why don't you just make them part of report with an Image control? Reference the image file path in ControlSource property. If the file path is not already in a text field, it can be extracted from the hyperlink string.

[Hossein]

Maybe. Review https://social.msdn.microsoft.com/Fo...-external-file

I have not gotten anything to work yet.

If these are PNG image files, why don't you just make them part of report with an Image control? Reference the image file path in ControlSource property. If the file path is not already in a text field, it can be extracted from the hyperlink string.

I want open hyperlink by using click on a bottom. i try do to but not successful

you can find the my code, forms and errors as the below pictures :

[June7]

Code works for me. Cannot replicate issue.

Again, why not use an Image control in report and make the image part of the report?

[Hossein]

Code works for me. Cannot replicate issue.

Again, why not use an Image control in report and make the image part of the report?

If i want open link by Firefox it's working, but i want open images or documents by windows programs and i cannot do that.

why not use an Image control in report and make the image part of the report?
Because some times the link includes PDF files. can image control open PDF files ?

Also i try to do that but i have same error

[Hossein]

I found a new simple way for open the hyperlink by using bottom, but i have same error !

Attachment 36278

Attachment 36279

[isladogs]

Responding to a PM by Hossein...
Not sure exactly what this thread is about but I'm unable to open either attachment from the last post

I NEVER use Hyperlink fields as they are often problematic.
Suggest you change it to a text field and just enter the file path

Then if you want to open that path use: Application.FollowHyperlink "yourfilepath"
Or to view the picture use : Me.PI_Image.Picture = "yourfilepath"

[Micron]

see if this helps
http://allenbrowne.com/func-GoHyperlink.html

[moke123]

You should probably test if the file exists before trying to open it.

just a guess but in your screenshot there is an octothorpe (#) after the file name which leads me to believe your using a hyperlink datatype and your passing some of the display text.

heres some info on hyperlink datatype... https://codekabinett.com/rdumps.php?...link-data-type

[Hossein]

see if this helps
http://allenbrowne.com/func-GoHyperlink.html

I use it but i couldn't fix my error

[Hossein]

You should probably test if the file exists before trying to open it.

just a guess but in your screenshot there is an octothorpe (#) after the file name which leads me to believe your using a hyperlink datatype and your passing some of the display text.

heres some info on hyperlink datatype... https://codekabinett.com/rdumps.php?...link-data-type

Many Many Many thanks for your help. Really do not know how to thank you.

My problem fixed by part GetHyperlinkFullAddress.

[moke123]

Glad you got it sorted out.

I'm not a fan of hyperlink datatype and find it difficult to work with.

My preference is to store the link or file path as plain text and use shell execute to open it.
heres a link to a Shell execute procedure...http://access.mvps.org/access/api/api0018.htm

[June7]

And no, an Image control cannot display PDF file. Guess you will have to stick with solution of printing separately.