Setting a Hyperlink (UNC) in code 1

[LarryDeLaruelle]

I am trying to complete a hyperlink field by prompting the user for the file name and then adding the balance of the path.

This is what I have:

Private Sub cmdLink_Click()

BitMapLink = "\\Eagle\Delaruellelarry$\" & txtFileName & ".bmp"

End Sub

cmdLink is a command button to create the string and assign it to BitMapLink. BitMapLink is the Hyperlink field.

The basic UNC will always be the same. I just want to concatenate the file name and extension which will always be a bitmap.

This code works ok as far as creating the string. When I point to it the cursor responds appropriately by changing to a pointing hand. However, clicking on the link produces no response.

I've tried Access help (both 97 and A2K) with no appreciable assistance.

Any idea why this process will not work?

Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[SiberBob]

I just read a post that "might" help you... Not sure...

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=1971&newpid=705&cfid=85091367&cftoken=61883671

Titled: Opening Files
How do I open a Word/Excel/Picture/Any Other File from Access?

The code contained therein works for any extension including mailto: and http: references...

Hope that helps...

Bob

 

[LarryDeLaruelle]

Bob:

Thanks for the reply, I was about to give up on this post.

I tried the link but it takes me to the Tek-Tips log on screen.

Where did you find this post?

Thanks again. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[SiberBob]

Go to the Keyword Search area using the link under your handle in the upper left corner of this page...

Cut and paste the next line in the search box
How do I open a File from Access

and Set the search settings to search for
Scope: full site
Use: All words
Area: FAQs - - - This one's important...
Fields: full text
When: Any Date


Or go to the forum:
Microsoft: Access Modules (VBA Coding) Forum
Then go to the FAQs
Then scroll down to FAQ 6a

Good luck with it...

Bob

 

[LarryDeLaruelle]

Bob:

Thanks for moving me in the right direction.

I solved the problem by setting a display label for the hyperlink.

BitMapLink = "Screen Shot:#\\Eagle\Delaruellelarry$\" & txtFileName & ".bmp#"

Where "Screen Shot:" is the value displayed in the control and the remainder (between the pound signs) is the actual UN
C.
Larry De Laruelle
ldelaruelle@familychildrenscenter.org