Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

On Fri, 2012-04-06 at 16:00 -0700, avamk wrote:
I am actually quite new to Base, and didn't realise I could use the File
Picker control. When I try to change its reaction to the Mouse Pressed
event, it asked me for a macro.

Do I need to write a macro to get the relative path of my desired image??? I
actually have no macro coding skills to do that...

Right you are, the control is not 'data aware', not bound to a data
column, so you will need to use a macro to transfer the file path
returned from browsing to the data column. In the default installation
of LibreOffice is a basic macro library, Tools, which contains a number
of file path manipulation macros, these should make conversion to a
relative path (note here - relative to current directory of the ODB
file, yes?) 

Anyway, I don't have an example snippet of basic on the disk at the
moment, pretty sure there are some examples at different forums already
- but I would really like to see this as an answer at - so if you don't mind I'll put an example there.
It's kind of late tonight, but maybe before I turn in. You won't need to
have a logon account there to retrieve it. 

The actual move to a data column is all of 2-3 lines, I don't think the
conversion to relative path should be too much more.. :-) I don't

What I'll do then is post back here, with a link to the entry there..or
if feel like check out the site and open the question and send that here
- then I'll post to that entry - either way is good.

Best wishes,


And how do I tie the selected file's relative path to the field I desire?

Sorry I am so new to this, but I would really appreciate any guidance you
can give me...

View this message in context:
Sent from the Users mailing list archive at

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.