Re: [libreoffice-users] can i add a file to a form in base?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi davzeppelin,
> greetings anyone, i'm trying to create a database where each entry
> points to a pdf file too (which is different for every individual
> form)
>
> following some tutorials on youtube i already made the basic table
> and form with simple things: ID, first and last name and
> description, but i have found nothing about how to link external
> files
>
> and another thing, is it possible to make something like a button
> in the form that starts adobe reader and displays the pdf file so
> that the user can open it from there? do i have to make a macro?

There is a separate *.pdf for described examples of the Base Handbuch
in German. You could find it here together with the example databases:
http://robert.familiegrosskopf.de/lo_hb/BeispielDBs_mit_Beschreibung_V51
.zip
There is a database "Beispiel_Bilder_einbinden.odb" (subfolder
"Externe_Bilder")
But it's all in German ...

So some hints here:
What you wan't doesn't work without a macro.
You have to integrate a control for searching for the directory to the
file. If the directory is found the directory must be copied to a
field, which is connected as a varchar-field to the database.
Now the directory could be saved. Another macro must be created to
open the document when clicking on the diectory. This will work with
oShell.execute("...."). The content inside the brackets would be the
path to the file. It will automatically start the programm, which
could show the file on your system. Works with *.pdf, also with images
and all other files.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBAgAGBQJYOGj6AAoJELDKYwaoS9AIJGQP/Rwr6tTkWpcLf33z3VAfPwQH
aWGmw6n522EdFRFcdSV9mA/E4o8RUnYlrsarZHlA0cKogoJmoLM4B7lKgbXPg7P0
JkefVQbiJoEk3l8WWkBuTbU6+cz+XjUnm36zpoTivGvTz0+4GAAcCUlhnB3FHcvD
/lvTjshRgNEB5v0MYMvsl+7PBcYOZMo6Xgtu3oS7Z8YQQ6q9nOdkjLrftkh8+bKM
yyDyxOds80T3tWF2gIzb5E/5XbciDwbTLH3gZLbhF8HL5flZCXydLWuhEJRtiDuL
c+/vUJHTeYaV5ByyabGMskwOtqtQTjf0A7Cx/ROwALNS0y5K4NPEDvNnwsgfoE+6
EkQdxI0Br4EVb07E1w1ScFR+gE+4na75MbrxvGCdjynDc1VS9pvYqWm2EV+gXD4V
ATuaDcm9i0Pmpa2vdU0cb1Yw+OuV5gOEiOsDekvXEN4Wo/SRhOyKrI4IlTW9WN6s
2C7Nz9VTl/rLYoIPf3rGFW+MYgV0of4IjKLMvLddOwVPEg687HsQl5B0cK/9Qgnj
IdcZaoM52xcbF4Hp91lO0L18pT1ya+RT4qMtcBdWQHgcP/cxxHdF1mn5a+R8/fIn
tUpR1tTqx2FtYGJ5+Avyf1LLyWrtoPcrwaQ3Io6kcLlvfzfuPCFBP/96JQ17Pa0U
WCKziKAvRz0qCZEOgOR8
=5ZE7
-----END PGP SIGNATURE-----

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted