How to view PDF files on a form?

Creating and using forms
Post Reply
PicoPi
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

How to view PDF files on a form?

Post by PicoPi »

Hi everyone,
I am designing my own little electronics parts database. I would like to display a pdf file through a link to the data directory where my PDF files are stored.
Is there a way to display a PDF in a window inside a form? The link to the file is stored in a VARCHAR table column.
I know how to do it in MS Access, but not OpenOffice base.
Thanks for any pointers.
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to view PDF files on a form?

Post by Villeroy »

Ready made macro solution for http, mail and file hyperlinks:
viewtopic.php?f=13&t=78351#p358909
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
PicoPi
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: [Solved] How to add hyperlink in table of Base?

Post by PicoPi »

I am not sure what hyperlinks have to do with viewing a pdf file inside a subform!
This is what I had in mind but for Base
https://youtu.be/KeyoRBTAa9I
OpenOffice 4.1.2 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] How to add hyperlink in table of Base?

Post by Villeroy »

Continuation from viewtopic.php?f=39&t=85550
PicoPi wrote:I am not sure what hyperlinks have to do with viewing a pdf file inside a subform!
This is what I had in mind but for Base
https://youtu.be/KeyoRBTAa9I
As much as a video about MS Access has to do with Base.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
PicoPi
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: [Solved] How to add hyperlink in table of Base?

Post by PicoPi »

Villeroy wrote:Continuation from viewtopic.php?f=39&t=85550
PicoPi wrote:I am not sure what hyperlinks have to do with viewing a pdf file inside a subform!
This is what I had in mind but for Base
https://youtu.be/KeyoRBTAa9I
As much as a video about MS Access has to do with Base.
IF you had bother seeing the first 5 seconds of the video, you would've see that it wasn't the access part I wanted to show.
It was describing what I wanted to accomplish.
You can mark it [Solved], but its not.
OpenOffice 4.1.2 on Windows 7
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: How to view PDF files on a form?

Post by acknak »

[Moderator: Above three posts moved here from viewtopic.php?f=13&t=78351]
AOO4/LO5 • Linux • Fedora 23
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: How to view PDF files on a form?

Post by floris v »

Some people don't like watching videos, it's better to write down what you want. If there's no easy way to do that and a video works better, make that as plain as crystal. Rationale: we are quite willing to help people, even when we don't know them, but we don't want to waste our time for them.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to view PDF files on a form?

Post by Villeroy »

If I understand it correctly, he wants to display the content of a PDF file in some form widget. OpenOffice form controls can display the usual bitmap formats in a picture control. Any other files have to be opened by hyperlink. Base does not even have a hyperlink control, therefore my macro which tries to open the usual types of hyperlinks http(s):, mailto: and file:
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
PicoPi
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: How to view PDF files on a form?

Post by PicoPi »

Villeroy wrote:If I understand it correctly, he wants to display the content of a PDF file in some form widget. OpenOffice form controls can display the usual bitmap formats in a picture control. Any other files have to be opened by hyperlink. Base does not even have a hyperlink control, therefore my macro which tries to open the usual types of hyperlinks http(s):, mailto: and file:
I am moving the project to a LAMP server. I think it's easier and a lot more portable and universal.
MySQL can store the path to the PDF files and I can easily show whatever I want on the HTML5 page with CSS3. That way, I can access my parts data from anywhere.
After learning what ACCESS and BASE can do, I am shocked at how refined and advanced ACCESS is, compared to anything else out there.
Although, I preferred the old look, and not this Windows 8 bland.
Thank you all for taking the time to respond. Sorry for any confusion. :super:
OpenOffice 4.1.2 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to view PDF files on a form?

Post by Villeroy »

Base is drastically overestimated since it came up with a separate document type "just like MSAccess" in 2005. There is nothing like MSAccess in this office suite but this little extra called "Base" can do more than most people try to do so desparately on spreadsheets.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply