OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

can I include hyperlinks in a BASE table?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
andy777
Newbie
Newbie


Joined: 01 Mar 2007
Posts: 1

PostPosted: Thu Mar 01, 2007 2:14 am    Post subject: can I include hyperlinks in a BASE table? Reply with quote

dear all,
beginner's question. I want to switch from Access so I am playing around with BASE. Only problem... can I include hyperlinks to, say, text files, in a BASE table and if so, how?
thanks
Andy
Back to top
View user's profile Send private message
Roger_Melly
Newbie
Newbie


Joined: 02 Mar 2007
Posts: 2

PostPosted: Sun Mar 04, 2007 7:02 am    Post subject: Reply with quote

Oh yes me too......
Back to top
View user's profile Send private message
QuazzieEvil
Super User
Super User


Joined: 17 Jan 2007
Posts: 599
Location: Houston, TX

PostPosted: Mon Mar 05, 2007 9:49 am    Post subject: Reply with quote

to my knowledge there is no direct/automated way of create a hyperlink. you can accomlish it with oobasic, however.

If you want to associate a given record with a given file: you can store the path of the file as a column (and the program path which which to open it if they differ). Now, from a base form, create a button that is linked to the code to do the work

Code:

Sub cmdOpenFile_OnClick(event As Object)
  Dim FilePath As String
  Dim OpenWith As String
  Dim Form As Object
  Form = event.Source.getModel().getParent() REM GET FORM
  REM ASSUMING THAT FILEPATH IS THE COLUMN NAME THAT CONTAINS THE
  REM FILE PATH
  FilePath=Form.getByName("FILEPATH").Text
  REM ASSUMING THAT OPENWITH IS THE NAME OF THE COLUMN CONTAINING THE
 REM PATH/NAME OF THE PROGRAM TO USE
 OpenWith=Form.getByName("OPENWITH").Text
 Shell(OpenWith & " " & FilePath ) REM OPEN THE FILE W/ SPECIFIED PROGRAM
End Sub


This should work (I have not tested it). The assumption here is that, when entering the record, a file path was specified as well as a program with which to open the file. if all your file are *.PDF, for instance you can hard code it or have it has default on the input form.
Back to top
View user's profile Send private message Visit poster's website
independentpower
General User
General User


Joined: 06 Aug 2007
Posts: 37
Location: Hyde Park Vermont

PostPosted: Wed Oct 24, 2007 6:20 am    Post subject: Reply with quote

I'm even more of a beginner than those two apparently. Can you explain in a little more detail. I was able to make the button, but I don't know enough about base to run through that programming. Will I have to do this every time I create a new text field for a particular record? Can I link to a file instead of a document? That way I could have a number of documents for a particular record in one place.
_________________
Patrick Corcoran
patrick.corcoran@independentpowerllc.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group