> -----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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
