How to view PDF files on a form?

Creating and using forms

How to view PDF files on a form?

Postby PicoPi » Wed Oct 12, 2016 2:32 pm

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.
PicoPi
 
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: How to view PDF files on a form?

Postby Villeroy » Wed Oct 12, 2016 3:10 pm

Ready made macro solution for http, mail and file hyperlinks:
https://forum.openoffice.org/en/forum/v ... 51#p358909
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby PicoPi » Wed Oct 12, 2016 4:02 pm

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
PicoPi
 
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

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

Postby Villeroy » Wed Oct 12, 2016 9:38 pm

Continuation from https://forum.openoffice.org/en/forum/v ... 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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby PicoPi » Wed Oct 12, 2016 9:49 pm

Villeroy wrote:Continuation from https://forum.openoffice.org/en/forum/v ... 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
PicoPi
 
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: How to view PDF files on a form?

Postby acknak » Thu Oct 13, 2016 1:50 am

[Moderator: Above three posts moved here from https://forum.openoffice.org/en/forum/v ... 13&t=78351]
AOO4/LO5 • Linux • Fedora 23
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?

Postby floris v » Thu Oct 13, 2016 9:53 am

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.
AOO 4.1.6 op Linux Mint
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
floris v
Moderator
 
Posts: 4203
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: How to view PDF files on a form?

Postby Villeroy » Thu Oct 13, 2016 11:32 am

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to view PDF files on a form?

Postby PicoPi » Fri Oct 14, 2016 9:55 am

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
PicoPi
 
Posts: 4
Joined: Wed Oct 12, 2016 2:24 pm

Re: How to view PDF files on a form?

Postby Villeroy » Fri Oct 14, 2016 12:27 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28536
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 3 guests