[AccessD] Access files by date

Rocky Smolin rockysmolin at bchacc.com
Wed Aug 2 09:35:05 CDT 2017


Beautiful.  But jpg is missing.  None of the formats listed have Date Taken
checked.  Is jpg the only one using that field?

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
jack drawbridge
Sent: Wednesday, August 02, 2017 7:12 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access files by date

Rocky,

You may get some info from this recent link.
https://www.access-programmers.co.uk/forums/showthread.php?p=1537880#post153
7880

Good luck.

On Wed, Aug 2, 2017 at 10:03 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Cool. But the list you posted is even more helpful.  Are those 296 
> fields all standard (if unused) in a jpg file?  DO you know of a link 
> to a site with more description of those fields?
>
> Tia
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Stuart McLachlan
> Sent: Tuesday, August 01, 2017 2:43 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access files by date
>
> On 1 Aug 2017 at 7:56, Rocky Smolin wrote:
> > ' search jpg header fields to find which one is the original date
> ...
> > objFolder.GetDetailsOf(objFolderItem, 16) ' turns out to be field 12
>
> > GetProperty = objFolder.GetDetailsOf(objFolderItem, 12)
>
> FWIW,..
> replacing
> objFolder.GetDetailsOf(objFolderItem, 16) with 
> objFolder.GetDetailsOf(objFolder.Items, i) will return the Name of the 
> item instead of its value.
>
> I came across th list below of GetDetailsOf item numbers.
>
> Seems MS have just added  items haphazardly to a list as they have 
> identified EXIF and other metadata tags used by different types of files.
>
> If you want the Lat/Lon so that you can track your photos 
> geographically, that's item 39.
>
> Experimenting, there is no error if you ask for an item Detail that 
> doesn't exist.  I looped through a folder asking for item details up 
> to 1000 without any error
>
>
>
> '0   Name
> '1   Size
> '2   Item type
> '3   Date Modified
> '4   Date created
> '5   Date accessed
> '6   Attributes
> '7   Offline Status
> '8   Offline availability
> '9   Perceived type
> '10  owner
> '11  Kind
> '12  Date taken
> '13  Contributing artists
> '14  Album
> '15  Year
> '16  Genre
> '17  Conductors
> '18  Tags
> '19  rating
> '20  Authors
> '21  Title
> '22  Subject
> '23  Categories
> '24  Comments
> '25  copyright
> '26  #
> '27  Length
> '28  Bit Rate
> '29  Protected
> '30  Camera model
> '31  Dimensions
> '32  Camera maker
> '33  Company
> '34  File Description
> '35  Program Name
> '36  Duration
> '37  Is online
> '38  Is recurring
> '39  Location
> '40  Optional attendee addresses
> '41  Optional attendees
> '42  Organizer Address
> '43  Organizer Name
> '44  Reminder Time
> '45  Required attendee addresses
> '46  Required attendees
> '47  Resources
> '48  Meeting Status
> '49  Free/busy status
> '50  Total Size
> '51  Account Name
> '52  task Status
> '53  computer
> '54  Anniversary
> '55  Assistant 's name
> '56  Assistant 's phone
> '57  Birthday
> '58  Business Address
> '59  Business City
> '60  Business Country / region
> '61  Business P.O.box
> '62  Business postal code
> '63  Business State Or province
> '64  Business Street
> '65  Business fax
> '66  Business home page
> '67  Business phone
> '68  Callback Number
> '69  Car phone
> '70  Children
> '71  Company main phone
> '72  Department
> '73  E-mail address
> '74  e -mail2
> '75  e -mail3
> '76  E-mail list
> '77  E-mail display name
> '78  File as
> '79  First Name
> '80  Full Name
> '81  Gender
> '82  Given Name
> '83  Hobbies
> '84  Home Address
> '85  Home City
> '86  Home Country / region
> '87  Home P.O.box
> '88  Home postal code
> '89  Home State Or province
> '90  Home Street
> '91  Home fax
> '92  Home phone
> '93  IM addresses
> '94  Initials
> '95  Job Title
> '96  Label
> '97  last Name
> '98  Mailing Address
> '99  Middle Name
> '100 Cell phone
> '101 Nickname
> '102 Office Location
> '103 Other Address
> '104 Other City
> '105 Other Country / region
> '106 Other P.O.box
> '107 Other postal code
> '108 Other State Or province
> '109 Other Street
> '110 Pager
> '111 Personal Title
> '112 City
> '113 Country/region
> '114 P.O.box
> '115 Postal code
> '116 State or province
> '117 Street
> '118 Primary e - mail
> '119 Primary phone
> '120 Profession
> '121 Spouse/Partner
> '122 Suffix
> '123 TTY/TTD phone
> '124 Telex
> '125 Webpage
> '126 Content Status
> '127 Content type
> '128 Date acquired
> '129 Date archived
> '130 Date completed
> '131 Device Category
> '132 Connected
> '133 Discovery Method
> '134 Friendly Name
> '135 Local computer
> '136 Manufacturer
> '137 model
> '138 Paired
> '139 Classification
> '140 Status
> '141 Client ID
> '142 Contributors
> '143 Content created
> '144 last printed
> '145 Date last saved
> '146 Division
> '147 Document ID
> '148 Pages
> '149 Slides
> '150 Total editing time
> '151 Word Count
> '152 Due Date
> '153 End date
> '154 File Count
> '155 FileName
> '156 File Version
> '157 flag Color
> '158 flag Status
> '159 Space free
> '160 Bit Depth
> '161 Horizontal resolution
> '162 Width
> '163 Vertical resolution
> '164 Height
> '165 Importance
> '166 Is attachment
> '167 Is deleted
> '168 Encryption Status
> '169 Has flag
> '170 Is completed
> '171 Incomplete
> '172 Read Status
> '173 Shared
> '174 Creators
> '175 Date
> '176 Folder Name
> '177 Folder Path
> '178 Folder
> '179 Participants
> '180 Path
> '181 by Location
> '182 Type
> '183 Contact Names
> '184 Entry type
> '185 Language
> '186 Date visited
> '187 Description
> '188 link Status
> '189 link Target
> '190 URL
> '191 Media created
> '192 Date released
> '193 Encoded by
> '194 Producers
> '195 Publisher
> '196 Subtitle
> '197 User web URL
> '198 Writers
> '199 attachments
> '200 Bcc addresses
> '201 Bcc
> '202 Cc addresses
> '203 Cc
> '204 Conversation ID
> '205 Date Received
> '206 Date sent
> '207 From addresses
> '208 From
> '209 Has attachments
> '210 Sender Address
> '211 Sender Name
> '212 Store
> '213 To addresses
> '214 To do title
> '215 To
> '216 Mileage
> '217 Album artist
> '218 Album ID
> '219 Beats -per - Minute
> '220 Composers
> '221 Initial Key
> '222 Part of a compilation
> '223 Mood
> '224 Part of set
> '225 Period
> '226 Color
> '227 Parental rating
> '228 Parental rating reason
> '229 Space used
> '230 EXIF Version
> '231 Event
> '232 Exposure bias
> '233 Exposure Program
> '234 Exposure Time
> '235 F-stop
> '236 Flash Mode
> '237 Focal Length
> '238 35mm focal length
> '239 ISO speed
> '240 Lens maker
> '241 Lens model
> '242 Light Source
> '243 Max aperture
> '244 Metering Mode
> '245 Orientation
> '246 People
> '247 Program Mode
> '248 saturation
> '249 Subject distance
> '250 White Balance
> '251 Priority
> '252 Project
> '253 Channel Number
> '254 Episode Name
> '255 Closed captioning
> '256 Rerun
> '257 SAP
> '258 Broadcast Date
> '259 Program Description
> '260 Recording Time
> '261 Station call sign
> '262 Station Name
> '263 Summary
> '264 Snippets
> '265 Auto Summary
> '266 Search ranking
> '267 Sensitivity
> '268 Shared with
> '269 Sharing Status
> '270 Product Name
> '271 Product Version
> '272 Support link
> '273 Source
> '274 Start Date
> '275 Billing Information
> '276 Complete
> '277 task owner
> '278 Total file size
> '279 Legal trademarks
> '280 Video compression
> '281 Directors
> '282 Data Rate
> '283 Frame Height
> '284 Frame Rate
> '285 Frame Width
> '286 Total bitRate
> '287 Primary disk
> '288 Memory
> '289 Machine Status
> '290 Configuration File
> '291
> '292
> '293
> '294
> '295 Masters Keywords (debug)
> '296 Masters Keywords (debug)
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list