-----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: [email protected] 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
