External File Properties

[mhkaye]

I am able to get a list of file names in a specified folder using
code, but is there a way to get the document properties too?

For instance, I use the document title and comment fields in the
properties of files to store contract number and supplier number
respectively. These are mostly mdi files. I can view these file
properties in Windows Explorer so presumably this 'header' data is
accessible.

Ultimately I want to ba able to retrieve files relating to a specific
contract or supplier number obtained from the external document
properties.

Thanks for any advice.

Mark

 

[Guest]

Dear Mark,

I did a search in the programming area of the Access discussions and
see some discussions that mention the Dir function, which to me sounds like
the old DOS command DIR. If that is what it is, there were some extra options
that you could do with the dir command to see other bits of information
pertaining to each file entry. I am not sure if those properties you
mentioned were available.

Are you using the Dir function to get your file names?

I did my search for "List Files" - you might want to try it.
Good luck,

 

[Tony Toews [MVP]]

I am able to get a list of file names in a specified folder using
code, but is there a way to get the document properties too?

For instance, I use the document title and comment fields in the
properties of files to store contract number and supplier number
respectively. These are mostly mdi files. I can view these file
properties in Windows Explorer so presumably this 'header' data is
accessible.

Do some searching at vbnet.mvps.org. You should be able to find an
API call there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/