Path Expression on Form

[Vinnie]

Hello all:

I have a Table which contains hyperlinks to Files stored over a network
share.
The table is Linked to the main Employee Table

FileID (PK)
Employee ID
FileType
hypFile

The hypFile is the Hyperlink to the File (could be a Word Doc, or a BMP, or
anything; but it is always linked to an Employee.

I would like to set the Folder Hierarchy up in such a way that users will
more or less have to access these Files by using the Forms in Access
Provided.

My Question is:
I would like to know if there is an Expression which will incorporate the
EmployeeID, so I do have to write the path each time I add a file.

Ex:

\\Server1\Documents\Resumes\1.doc

This is assuming I have a Doc in the Folder already Named 1.doc. I would
like to know how to go about using an expression to write the path, knowing
the path already. So the bulk of the path is pre-written and all that
would have to be done is maybe change the extension or something.

="\\Server1\Documents\Resumes\1.doc" & [EmployeeID] & ".doc" - When I try
this expression, it does not take....is it because the Employee ID is a
Number and not Text?

Thank you

 

[Ron2006]

You have the reference formated incorrectly.


if there is a directory for each emplyee It should be:
="\\Server1\Documents\Resumes\" & [EmployeeID] & "\1.doc.doc"

Ron

 

[Ron2006]

And I goofed it too. There should only be one DOC

You have the reference formated incorrectly.

if there is a directory for each emplyee It should be:
="\\Server1\Documents\Resumes\" & [EmployeeID] & "\1.doc"


Ron

 

[Vinnie]

thanks,Ill give it a try again.

And I goofed it too. There should only be one DOC

You have the reference formated incorrectly.

if there is a directory for each emplyee It should be:
="\\Server1\Documents\Resumes\" & [EmployeeID] & "\1.doc"


Ron

You have the reference formated incorrectly.


if there is a directory for each emplyee It should be:
="\\Server1\Documents\Resumes\" & [EmployeeID] & "\1.doc.doc"

Ron