Grabbing Filenames - How to?

[MsfStl]

Hi, I am trying to populate a field "FN" within a table called "tblFN" with a list of .pdf filenames in the folder "C:\My Documents\Taiwan Cases\" The Access Db name is "TestPopulateCode.mdb" Can anyone assist me in the VBA code to programatically populate that field with the .pdf files from that folder? Any help you can give me is appreciated. I have searched the forums for a solution and did not find anything suitable for my needs. Thanks for your time!

 

[MStCyr]

Hi

One of the samples in the Sample Databases area would be a good start for you, simply modify the code a bit. This is located at:

http://www.access-programmers.co.uk/forums/showthread.php?t=108698

 

[KeithG]

You can use the Dir function or the file system object.