File Path + string

[kevcar40]

Hi
I have created a hyperlink to a document
what i would like to do is read the string and return only the file
name
i will need to read from the right untill i read the full stop(.) and
exclude this
i then need to read from the right untill i read the first \ this will
give me the file name
from here i need to discard the rest of the file path leaving only the
file name
i am then going to display the file name in a combox box for the user
to open the document

can anyone help please

thanks

kevin

 

[Keith Wilby]

Hi
I have created a hyperlink to a document
what i would like to do is read the string and return only the file
name
i will need to read from the right untill i read the full stop(.) and
exclude this
i then need to read from the right untill i read the first \ this will
give me the file name
from here i need to discard the rest of the file path leaving only the
file name
i am then going to display the file name in a combox box for the user
to open the document

Can't you achieve this by using the "display text" property of the
hyperlink?

Keith.
www.keithwilby.com

 

[kevcar40]

Thanks for info keith
but being new to this could you help me by poining me in right
dircetion please

kevin

 

[Keith Wilby]

Thanks for info keith
but being new to this could you help me by poining me in right
dircetion please

When you open your form in runtime mode (ie not design view) and right-click
the hyperlink text box you should get a "hyperlink" item which has a
"display text" sub-menu item. Whatever you type into that box is what's
displayed in the text box and doesn't affect the actual hyperlink path to
your file.

HTH - Keith.
www.keithwilby.com