Hyperlink To Attachments

  • Thread starter Thread starter Ray Meadows via AccessMonster.com
  • Start date Start date
R

Ray Meadows via AccessMonster.com

I have a data entry form. On this form I need a link to take the user to
an attachment (excel or word) on the network drive. Is this possible?

The name of the attachment may be different for each record, but the drive
and folder will be the same.

Does anyone know how I can solve this problem??

Thanks,

Ray
 
From what I remember the built in hyperlink function in Access shoul
work - seems to be a bit slow, might go a bit faster if you use
file:// prefix (eg 'file://C:\Bob.doc')

I'm sure there are better ways to do this but I'm tired and my brai
isn't quite working today
 
Is there a way to maybe have a textbox where the User can enter the name of
the file, and then the hyperlink takes the person to the file??

My issue is that each record may have an attachment and the attachment will
be a different name stored in the same folder on the network. For
instance, the user has created a record and for more information he wants
to link to his excel document on the network file folder.

Another person creates a record in Access and wants to link to her excel
document on the network file same folder.

Is there a way to perform this so that on my form is a link tied to that
record???

also, I'm not sure how the person creating the record in Access can give
the name of their excel file so that the next person coming in can click
the hyperlink and view it.

Thanks,
Ray
 
Ray,

Try it like this...
Application.FollowHyperlink "E:\YourFolder\" & Me.FileName

Put code equivalent to this on the required event, where FileName is the
name of the control on the form where you have the name of the file
entered, and replace E:\YourFolder\ with the path to the folder concerned.
 
Back
Top