External Image viewers in Base
External Image viewers in Base
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)
Re: External Image viewers in Base
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: External Image viewers in Base
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)
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)
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: External Image viewers in Base
Section 3.10 of "OpenOffice.org Macros Explained" by Andrew Pitonyak.
discusses 4 variables for getting error information.
something like
should display the number..
discusses 4 variables for getting error information.
something like
Code: Select all
print "Error Number : " & Err
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11