[AccessD] Code to render ShortFileName

Here is code to translate short and long filenames
http://www.mvps.org/access/api/api0020.htm
Are you writing the same code as me, seems like you are following me to 
the same spots, I am writing routine to create a directory file 
structure  from a hierarchical table structure to place files.


Arthur Fuller wrote:

>Anybody got code to paste into Access that derives a short file name (i.e.
>everything shortened to 8 letters ala c:\Progr~1\Micro~1\Micro~2\etc.)?
>Ideally, I would like to use the ADH code to grab a filename then call a
>function that shortens the filename appropriately.
>
>TIA,
>Arthur
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>