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 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]
