External Image viewers in Base

Discuss the database features
Post Reply
lsemmens
Posts: 49
Joined: Thu May 22, 2014 11:17 am

External Image viewers in Base

Post by lsemmens »

I have a database with external links to images of average size 1000 px by 1300px. I can set a default size of the displayed image in the forms for displaying said images. I'd like the facility to be able to click on an image to display it in an external program e.g. gimp. Is that possible from within base or will I just have to live with locating said source image and opening it from a file manager.
LibreOfice Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.6 HQSLDB on Linux Mint 19 Tara - Cinnamon 3.8.9 (Gtk 3.22.30-1ubuntu3)
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: External Image viewers in Base

Post by Villeroy »

This will be complicated.
First, you need to store the URLs of picture files. You must not store the picture data in the database.
Then you need a macro viewtopic.php?t=71893&p=323909#p323909 with URL button on your form.
The URL button opens the file with the default application for picture files on your operating system, typically the one which is used when you double-click on the 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
lsemmens
Posts: 49
Joined: Thu May 22, 2014 11:17 am

Re: External Image viewers in Base

Post by lsemmens »

Thanks again for your help, I can understand that. and should be ok with that.

Another quick question. What is the command for extracting an error number in a macro

eg: I trap an error with an "on error goto" routine and want to display a message box: eg msgbox(ErrNum)
LibreOfice Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.6 HQSLDB on Linux Mint 19 Tara - Cinnamon 3.8.9 (Gtk 3.22.30-1ubuntu3)
UnklDonald418
Volunteer
Posts: 1549
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: External Image viewers in Base

Post by UnklDonald418 »

Section 3.10 of "OpenOffice.org Macros Explained" by Andrew Pitonyak.
discusses 4 variables for getting error information.
something like

Code: Select all

print "Error Number : " & Err
should display the number..
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply