![]() The OpenOffice User Profile Edit: : Added improved query to allow for handle protocol prefix mailto: http: https:Įdit: : Fixed error in completion. Unzip the Scripts/python/URLButton.py from this document and move the file to the Scripts/python/ subdirectory of your user profile folder. If you want to use the Python macro with arbitrary database documents (which is what it is written for): If the file exists it will be opened with the respective default application for the file type. The macro disables any file button for any file that does not exist. The latter variant converts a file path in system notation (C:\.) into a valid URL internally. ![]() ![]() The button names start with "URLButton" or with "FileButton". The form's "after record change" event is bound to the python macro.Ħ) The buttons are set up as hyperlink buttons (action="Open document/web page") with the corresponding field name as "additional info" property. On the Advanced tab I clicked the 'Class Path.' button. I launched LibreOffice, and chose Tools > Options. Then I downloaded UCanAccess ( and unzipped it into the folder. Column The form named "URL Buttons" is based on that query. Open an Access database in LibreOffice Base. Column "Mail" has arbitrary mail addresses. In the Setup table you can specify a path for those file names where the "Name" is 'FilePath'. "Data" has a list of arbitrary file names in column "Files". This one still works well but is more difficult to set up.Ģ) Copy the document to a trusted directory where macro execution is allowed according to Tools>Options>Security>ģ) Open the 2 tables. Improved version of this stuff can be found here: viewtopic.php?f=100
0 Comments
Leave a Reply. |