Example Apps for Businesses, Schools & Developers

Version 2.2     Last Updated 26 Nov 2021              Approx 1.2 MB

A recent forum thread Windows 10 Retrieving Extended File Properties raised issues about using the GetDetailsOf method to retrieve extended file properties.

GetDetailsOf is a member of the VBA library: Microsoft Shell Controls and Automation based on Shell32.dll.

All files include several extended properties which can be retrieved as needed using this method.

For example:
•   Date created / date modified / date last accessed
•   File size / file type / author / location

Certain types of file will also contain additional extended properties including:
•   Height / width / horizontal resolution / vertical resolution / bit size (image files)
•   Contributing artist / album / year / genre / tile / track # / length / bit rate (audio files)

There are currently over 320 extended file properties, though no files will ever contain all of those.

I decided to investigate this method further and have created an Access app which provides an easy way of obtaining and storing all the extended properties for an individual file or all files of a specified type in a selected folder.

The Access app includes the VBA reference library: Microsoft Shell Controls and Automation

NOTE:
The app also includes an example of a dynamic crosstab query where the column headers are automatically updated to match the underlying data



Screenshots

Click any image to view a larger version

List of Extended File Properties

ExtProps2

Main Form with Progress Bar

ExtProps6

Extended Properties for a file

ExtProps4

All PDF files in folder

ExtProps8
Dynamic crosstab report

ExtProps5
Saved list for a group of files

ExtProps11



Download:
The zip file contains the following items:
a)   the database FileAttributes.accdb
b)   a PDF file with full details and screenshots
c)   several text files with examples of the extended properties obtained for different types of file

Click to download:       Extended File Properties v2.2   (zipped)



Version History:
v2.0     18/03/2019    Initial release
v2.1     19/10/2019    Bug fixes mainly related to handling apostrophes
v2.2     02/09/2021    Updated to handle 320 extended file properties



NOTE:

1.     Wayne Phillips from EverythingAccess.com uses a different approach to obtain extended file properties.
        Wayne's utility can be found at: Accessing detailed file info provided by the operating system

2.     Crystal Long (Access MVP) and I ran a joint session for the US Pacific Access User Group on 2 Sept 2021 comparing these two different methods of
        obtaining extended file properties.
        The video is available on the Access User Groups YouTube channel at https://youtu.be/fwQnhKWo1Ks or you can click below:

       

3.     I also have a separate video on this topic which is available on my Isladogs YouTube channel at https://youtu.be/7jK_qRXetNs or you can click below:

       



Colin Riddington                 Mendip Data Systems                 Last Updated 26 Nov 2021


Return to Example Databases Page                                                 Return to Top