> -----Original Message----- > From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED] > Sent: 11 December 2005 08:01 AM > To: [email protected] > Subject: Re: [users] Hyperlinks in Base > > 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 > Thanks again for your help, Andrew. You do encourage one to use OOo!
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
