Opening a Network Folder Path

[newbie_204]

Forgive me, my coding skills are less then par, but I am trying to design a button that will redirect the user to a specific folder on a shared network drive to access the files easier. My road block is how to get the button to identify a sub folder sorted by year based on the first two integers of the project number so that it can be utilized with different project years, I don't even know if it's possible or not. Project files are standard as being 150001 for 2015, 160001 for 2016 etc.



For example, if the project file is 150030, located in R:\Project Files\2015\150030;

1 - I would need the string to identify the first two digits of the project years '15' so that it would first direct to the R:\Project Files\2015
2 - then I would need it to recognize the whole project number to then redirect into the R:\Project Files\2015\150030

Any help is appreciated, thanks in advance.

derek.

[pbaldy]

Try FollowHyperlink with a string built from the value:

"R:\Project Files\20" & Left(FieldName, 2) & "" & FieldName

[newbie_204]

Try FollowHyperlink with a string built from the value:

"R:\Project Files\20" & Left(FieldName, 2) & "" & FieldName

Perfect, worked like a charm

[pbaldy]

Happy to help.