Bruce Button wrote:
-----Original Message-----
From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED]
Sent: 10 December 2005 08:51 AM
To: [email protected]
Subject: Re: [users] Hyperlinks in Base
Bruce Button wrote:
Thank you for your comments, Andrew. My needs are:
To create a field in a database which will store the URL of a file on my
hard drive. In Access this would be a hyperlink field. One could click on
the URL in any view (table, form, etc.) and the file (or web address,
etc.)
would open.
It seems that Base doesn't have this functionality. Of course the best
solution is to be able to define a hyperlink at the table level, but,
failing that, it would help to be able to create a control on a form that
would open the file reference by a URL stored in a text field (each
record
must be able to store a different URL). Can one do this easily using a
macro?
A related query: the (very useful)"File Selection" control would be much
more useful if it could be linked to a field in a table, just as the
"Text
Box" and other fields can. Is there an easy solution to this?
Thanks for the help
Bruce Button
I have a "ramblings" document on the database page of my web site. I
would need to look at it again to remind myself how I filled in the
values. Either way, it would be rather easy to add a button that opened
a file selection object to choose a file or directory. The URL can then
easily be stored in a field. It would take a bit more work to cause a
URL to be executed. You would want to carefully define the behavior. In
general, you can simply "execute" the url and the OS will typically find
the associated application and open it.
On a dialog, there is a file selection control (I remember looking at it
when I wrote my Macro book), but at that time, I had a reason that I
prefered to create my own dialog. I would have to go back and read that
section in my book. I have not checked to see if there is a file control
that you can drop into a form. It probably does exist, but I only have a
confidence level of about 60% on that.
I assume that you have not done any macro programming in the past?
Andrew, thanks for your input.
I haven't done any OOo macro programming - just a little in VBA. The OOo API
is a little confusing to me at this stage, although I'm willing to learn.
Looks like your book will be helpful.
It seems as though I'll need to work on your suggestion of creating a button
next to a text field in order to execute a url.
Perhaps the OOo developers can consider adding a hyperlink field (or some
equivalent functionality) in later versions of OOo.
Oh, well, OOo makes this macro VERY VERY VERY easy to write....
If you have my free macro document, then check out the section titled
"Using a “default application” to open a file"
You will find a macro similar to the following:
Sub RunURL
Dim sURL$
Dim oSvc as object
oSvc = createUnoService("com.sun.star.system.SystemShellExecute")
sURL = "file:///andrew0/home/andy/tmp/Disney%20Pictures/index.html"
oSvc.execute(sURL, "", 0)
End Sub
In other words, your macro will simply have to take the URL from the
field and then use code like that found above and you are FINISHED! Talk
about EASY!
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
