Hyperlink Variables

[CCW8]

Good Afternoon
I am using the following in expression builder for a command button to open a .pdf file on the server.

="\\ServerName\DriveName\Database\Product\Folde r\" & [ProductNumber] & ".pdf"
When I run this there is nothing.



If I place the hyperlink without a variable number on the format tab-hyperlink address
\\ServerName\DriveName\Database\Product\Folder\321 8.pdf

it will open the file.
Since I have thousands of files I do not want to manually enter...

[ajetrumpet]

Since I have thousands of files I do not want to manually enter...

so what do you want to do?

this is about ambiguious as this little hijack is: https://www.accessforums.net/access/...nks-10676.html

[CCW8]

I want to find out why this does not work and fix it. From what I understand this should work. I must be missing something. please enlighten me.

[ajetrumpet]

could it be because there is a space in the product number??

[CCW8]

Sorry I was gone so long the weather here in Alabama was bad for awhile - That appears to be a typo in this page only there are no spaces in the number. I just tried using code builder from the cmd button and I am getting an
error 13
Type Mismatch
in debug I get
Set cmdPEBFile = PEBNumberTextBox (hi-lighted)
here is my code

Private Sub cmdPEBFile_Click()
Dim cmdPEBFile As CommandButton

Set cmdPEBFile = PEBNumberTextBox

With cmdPEBFile

.Visible = True

.HyperlinkAddress = "\\ServerName\ServerDrive\Databases\EPEB\" & [PEBNumberTextBox] & ".pdf"

End With
End Sub

[nonoy]

Good Afternoon
I am using the following in expression builder for a command button to open a .pdf file on the server.

="\\ServerName\DriveName\Database\Product\Folde r\" & [ProductNumber] & ".pdf"
When I run this there is nothing.

If I place the hyperlink without a variable number on the format tab-hyperlink address
\\ServerName\DriveName\Database\Product\Folder\321 8.pdf

it will open the file.
Since I have thousands of files I do not want to manually enter...

======================

hello everyone,

i also working for the hyperlink builder and trying to link the file in jpeg format. what i did after struggling a couple of attempts is:

just to share to everyone, to link a certain file in the form (based on the above example) :

=\\ServerName\DriveName\Database\Product\Folder\&[ProductNumber]&".pdf"

it works on my file.