Pull file details and extended details into a form.

[PhillipsK]

Good day,

I have been working on a librarian database (Access 2010) that tracks files and catalogs important information about each file and provides search and link to each file located in a single folder library. I have been able to draw file path and filename and put those elements into a form and create the linking, however, getting the extended properties/details have brought me to ask the experts. I would like the form to autopopulate any metadata that is already in the file to the form. Once I get that working I am thinking once user adds data that is missing to go ahead and write it to the file.

Any push in the right direction would be much appreciated!

Thanks,

Kendall

[jimatqsi]

Check out the file system object and file object

https://msdn.microsoft.com/EN-US/library/office/gg251349(v=office.14).aspx

Jim

[PhillipsK]

Thanks Jim, will give that a try. Out of hours of Google searches and MSN did not come across this one.

[PhillipsK]

Thanks again Jim - got the basic details to pull quite easily. Now for the extended ekk.

[jimatqsi]

So glad you made good progress. Congratulations and good luck with the following part. Feel free to post a new thread if you need additional help. You'll find plenty of willing hands to pitch in here.

Jim