[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