Apache OpenOffice Community Forum

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.

Ready made macro solution for http, mail and file hyperlinks:
viewtopic.php?f=13&t=78351#p358909

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

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.

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.

[Moderator: Above three posts moved here from viewtopic.php?f=13&t=78351]

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.

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:

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.

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.