File names

[daybase]

I have a database which holds details of graphic files and allows the user to view files. Due to the size and quantity of graphics I have oped against embedding the graphics but the table holds name of the file and uses that information to insert the graphic in the report or display on form. Works great but you have to type the filename correctly (obviously) for it to work. I would like to use the directory windows to find a file for inclusion but rather than load the file just read the file name for use in code or to populate the table. Can it be done and, if so, how? please keep it simple.

 

[jfgambit]

See the following post:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44810

There is a sample db that I believe will do exactly what you are looking for.

HTH

 

[daybase]

Absolutely brilliant - many thanks - only query why doesn't trim strip the trailing spaces? Had to write code to strip it down works great but puzzled.