How to activate hyperlink in text box

[dillneus]

Hello,

I have a problem with hyperlink.
I have a text box that contains link to the document. I enter the link by clicking on the button "add link". When I add link, the windows browser opens and i can search for exact document. But when I save the path in the Link text box, the link doent work. It is stored in News table and I changed it for hyperlink but still doesnt work. I noticed that when I am saving the path, it saves me the path as a link name that is shown in the text box, but the hyperlink path is empty.
How to make it works?
I would be grateful for help.


Greets

Greg

[ADezii]

Hello,

I have a problem with hyperlink.
I have a text box that contains link to the document. I enter the link by clicking on the button "add link". When I add link, the windows browser opens and i can search for exact document. But when I save the path in the Link text box, the link doent work. It is stored in News table and I changed it for hyperlink but still doesnt work. I noticed that when I am saving the path, it saves me the path as a link name that is shown in the text box, but the hyperlink path is empty.
How to make it works?
I would be grateful for help.


Greets

Greg

You cannot Add a Hyperlink to a Text Box on a Form, when you attempt this a Label containing the Hyperlink will be added to the Form, and clicking on it will Navigate to the Destination. It obviously will not be Bound or saved to a Table. If a Field in a Table is defined as Hyperlink and Links are added at the Table Level, you can then set the Control Source of a Text Box to this Field and you can activate the Hyperlink in this manner. You can also programmaticall y add a Hyperlink to a Text Box on a Form and Bind it to the underlying Field.

[dillneus]

You cannot Add a Hyperlink to a Text Box on a Form, when you attempt this a Label containing the Hyperlink will be added to the Form, and clicking on it will Navigate to the Destination. It obviously will not be Bound or saved to a Table. If a Field in a Table is defined as Hyperlink and Links are added at the Table Level, you can then set the Control Source of a Text Box to this Field and you can activate the Hyperlink in this manner. You can also programmaticall y add a Hyperlink to a Text Box on a Form and Bind it to the underlying Field.

thank you for reply. but i think i wasnt too clear.
actually i can store this hyperlink to the table field but then i cannot open hyperlink.

Maybe i will describe it more detailed:

i have News Table where there is a News.Link field (it is set as hyperlink).

then I have News Form where I have text box - Link - which has control soucre News.Link from the News Table.

Under that Link I have button which opens browser and then in the folders on the hard drive I can choose one document. I press save and the whole path is saved on this text box Link, which is bound to News.Link.

But this paths doesnt open a hyperlink, although I set hyperlink options in Form and in Table.

Now I want to be able to open document just by clicking on that text box field in Form. Now I am clicking and nothing happens.

Do you know how to do it?

[ADezii]

thank you for reply. but i think i wasnt too clear.
actually i can store this hyperlink to the table field but then i cannot open hyperlink.

Maybe i will describe it more detailed:

i have News Table where there is a News.Link field (it is set as hyperlink).

then I have News Form where I have text box - Link - which has control soucre News.Link from the News Table.

Under that Link I have button which opens browser and then in the folders on the hard drive I can choose one document. I press save and the whole path is saved on this text box Link, which is bound to News.Link.

But this paths doesnt open a hyperlink, although I set hyperlink options in Form and in Table.

Now I want to be able to open document just by clicking on that text box field in Form. Now I am clicking and nothing happens.

Do you know how to do it?

I answered a similar Question several weeks ago, referring to this Post should help you. The key point to remember is that a Hyperlink can consist of three Sections delimited by a '#' sign. Specifying only the URL will not work, it will simply be assigned to the Caption.
Inserting a Hyperlink into a Table

[dillneus]

I answered a similar Question several weeks ago, referring to this Post should help you. The key point to remember is that a Hyperlink can consist of three Sections delimited by a '#' sign. Specifying only the URL will not work, it will simply be assigned to the Caption.
Inserting a Hyperlink into a Table

Thx for link. It sounds like the answer for my question. but i dont know how to put it to my database. I quite begginer so some things i dont understand.

So:
What is this File Dialog: msoFileDialogFi lePicker, msoFileDialogVi ewDetails
Is it module or sth like that?
I have to modules: openSavebrowser and basBrowseFiles for opening the browser and inserting the file path into the text box (but it put only the path in the text display part, not in path part).
Maybe I have wrong module (FileDialogFile Picer??). Do you have maybe codes for that FilesDialogs that are mentioned in the code from that link?

Where shall I insert that code that was in that link you gave me? I have button that is named link2. shall i put in into onclick option in Event Procedures?

greets

[ADezii]

Thx for link. It sounds like the answer for my question. but i dont know how to put it to my database. I quite begginer so some things i dont understand.

So:
What is this File Dialog: msoFileDialogFi lePicker, msoFileDialogVi ewDetails
Is it module or sth like that?
I have to modules: openSavebrowser and basBrowseFiles for opening the browser and inserting the file path into the text box (but it put only the path in the text display part, not in path part).
Maybe I have wrong module (FileDialogFile Picer??). Do you have maybe codes for that FilesDialogs that are mentioned in the code from that link?

Where shall I insert that code that was in that link you gave me? I have button that is named link2. shall i put in into onclick option in Event Procedures?

greets

The Link that I provided for you also shows sample FileDialog code.

[dillneus]

The Link that I provided for you also shows sample FileDialog code.

I saw that code but i dont know exactly how to change it...
msoFileDialogFi lePicker, msoFileDialogVi ewDetails - i dont know my equivalent of thos fields...
are there modules codes or sth else???...
I will follow that sample you gave on my example, and if you could check if this is correct i would be greatful:

What is the Field Name? Link

Is this Field defined as a Hyperlink Data Type in the Table? YES

What is the Table's Name? NEWS

What URL are you trying to Update the Field to? (Microsoft.com, Google.com, TheScripts.com, etc.)
I have text box: Link which is bound to [News].[Link] field.


Now what i need is to be able to add paths of files into Link field as a hyperlink path.

So where should i put this code:

Dim varItem As Variant
 
With Application.FileDialog(msoFileDialogFilePicker) what should i put into msoFileDialogPicker?? 
 
With .Filters
     .Clear
     .Add "Text Files", "*.txt"
     .Add "Database Files", "*.mdb"
     .Add "All Files", "*.*"
   End With
       'The Show Method returns True if 1 or more files are selected
       .AllowMultiSelect = True
       .FilterIndex = 2     'Database files
       .ButtonName = "Link2"
       .InitialFileName = vbNullString
       .InitialView = msoFileDialogViewDetails' (and what is that FiledDialogViewDetails?? )
 
       .Title = "Find the damn File!"
          If .Show Then
            For Each varItem In .SelectedItems     'There will only be 1
              Me![Link] = varItem
            Next varItem
          End If
End With

I am quite lost with that and i dont know how to proceed further...

greets
Greg

[ADezii]

I saw that code but i dont know exactly how to change it...
msoFileDialogFi lePicker, msoFileDialogVi ewDetails - i dont know my equivalent of thos fields...
are there modules codes or sth else???...
I will follow that sample you gave on my example, and if you could check if this is correct i would be greatful:

What is the Field Name? Link

Is this Field defined as a Hyperlink Data Type in the Table? YES

What is the Table's Name? NEWS

What URL are you trying to Update the Field to? (Microsoft.com, Google.com, TheScripts.com, etc.)
I have text box: Link which is bound to [News].[Link] field.


Now what i need is to be able to add paths of files into Link field as a hyperlink path.

So where should i put this code:

Dim varItem As Variant
 
With Application.FileDialog(msoFileDialogFilePicker) what should i put into msoFileDialogPicker?? 
 
With .Filters
     .Clear
     .Add "Text Files", "*.txt"
     .Add "Database Files", "*.mdb"
     .Add "All Files", "*.*"
   End With
       'The Show Method returns True if 1 or more files are selected
       .AllowMultiSelect = True
       .FilterIndex = 2     'Database files
       .ButtonName = "Link2"
       .InitialFileName = vbNullString
       .InitialView = msoFileDialogViewDetails '(and what is that FiledDialogViewDetails?? )
 
       .Title = "Find the damn File!"
          If .Show Then
            For Each varItem In .SelectedItems     'There will only be 1
              Me![Link] = varItem
            Next varItem
          End If
End With

I am quite lost with that and i dont know how to proceed further...

greets
Greg

Don't have the time right now but I'll give you step-by-step detailed information as soon as I get the chance, hopefully tonight.

[dillneus]

Don't have the time right now but I'll give you step-by-step detailed information as soon as I get the chance, hopefully tonight.

ok no problem. i will check it tommorow then. thx

[ADezii]

ok no problem. i will check it tommorow then. thx

The following code, placed in the Click() Event of a Command Button named cmdPopulateHype rlink will:

1. Open a File Dialog Box, and allow you to select only 1 File of any type.
2. Allow you to customize the Button and Dialog Title Captions within the File Dialog Box.
3. Write the Hyperlink Caption and Address (both are required) to the Link Text Box on the Current Form. The Control Source for this Link Text Box is the [Link] Field.
4. The Record Source for the Form is the Table News.
5. The code has been thoroughly tested and is fully functional. I inserted Comments where I thought they may be needed.
6. Any questions, feel free to ask.

Private Sub cmdPopulateHyperlink_Click()
'First, set a Reference to the Microsoft Office XX.X Object Library
 
Dim strButtonCaption As String, strDialogTitle As String
Dim strHyperlinkFile As String
 
'Define your own Captions if necessary
strButtonCaption = "Save Hyperlink"
strDialogTitle = "Select File to Create Hyperlink to"
 
With Application.FileDialog(msoFileDialogFilePicker)
  With .Filters
    .Clear
    .Add "All Files", "*.*"     'Allow ALL File types
  End With
  'The Show Method returns True if 1 or more files are selected
    .AllowMultiSelect = False       'Critical Line
    .FilterIndex = 1 'Database files
    .ButtonName = strButtonCaption
    .InitialFileName = vbNullString
    .InitialView = msoFileDialogViewDetails     'Detailed View
    .Title = strDialogTitle
  If .Show Then
    For Each varItem In .SelectedItems 'There will only be 1
      'Caption and Address of Hyperlink will be the same (Caption#Address)
      strHyperlinkFile = varItem & "#" & varItem
        Me![Link] = strHyperlinkFile
    Next varItem
  End If
End With
End Sub