Apache OpenOffice Community Forum

Good Afternoon All,

I have this morning installed OpenOffice 4.0 and after a bit of a struggle created my database and form, but i am really stuggling with adding an image to my form, such as what type of field does the image path have to be saved as and how do I i
set up the image controls on my form. Any help would be very much appreciated ! I attach my database so far.

Many Thanks in advance

Adrian

Put the database document and the pictures in the same directory. Enter the picture file names into a text field. No path required. Avoid special characters including spaces in file names. A double-click on a form's picture control opens a file picker dialog.

You may also use a query to concatenate the actual file names:
SELECT *, "PicName" || '.jpeg' AS "PicFile" FROM "Table"
or
SELECT *, 'Subdirectory/' || "PicName" || '.jpeg' AS "PicFile" FROM "Table"

See also viewtopic.php?t=33534&p=153834#p153834 with a listbox of availlable pictures imported from a file listing (still without macros).

Good Evening Villeroy

Brilliant, it was as simple as that !

Many Many Thanks !

Adrian
Cornwall, England