Format the file location based on server location no the mapped dr

[BZeyger]

I have code in place that has a user click a button and a select file
location would be entered in a filed named txtLocation based on the selected
record.

The final line of code I have is:
Me.txtLocation = strInputFileName

This works fine but it enters: Z:\FileLlocation\ABC\FileName.PDF

Instead if it entering Z:\FileLocation\ABC in the field, I would like it to
begin with \\ServerName\Filelocation\ABC

Basically, instead of it displaying the location based on the mapping on my
screen, I would like it formatted based on the server location.

 

[Gina Whipp]

BZeyger,

Suggestion, I store the UNC path in a table and then use it to 'put
together' my file path. SInce the Server Name rarely, if ever, changes no
need to worry about maintenance.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm