adding the date and time of a picture in a field

[LOUISBUHAGIAR54]

Hi there. Happy Festive season to all access programmers.

I am building a database to document and keep a track on a project. In one of the forms I have a text field that contains the path to a picture. An image control on the form has the latter text field as its control source and comes up automatically with the form.

The images are pictures which I take of my project, daily as works proceed using my mobile phone as a camera. Automatically the mobile phone camera registers the date and time when the picture is taken. This data is stored and transferred to my pc with the picture itself.

How can I make a field on the same access form so that the data of the date and time of the picture come up automatically as a field on the form with the picture itself.

Any ideas ?


many thanks for your patience.

LouisB

 

[John Big Booty]

You may find this thread has some code that might help you.

 

[LOUISBUHAGIAR54]

Many thanks for replying.

The information with the picture is like a record. It shows among other things the name of the picture e.g 001.jpg and the date ant time when taken as a single data bit.

I cannot understand from the lead that you have given me how to get the date and time to appear in a field on my form just like the image appears. Can you provide some more leads please ?

 

[John Big Booty]

Sorry this is not really my area. All I would be doing would be reading through the thread I linked to and playing with the code to understand how it works and then attempting to bend it to my purposes.

 

[LOUISBUHAGIAR54]

Many thanks for your attempt at helping. As I understand each picture on a computer has an associated record which contains information on the picture. This includes the pixels, date and time taken etc. etc. It has also the directory path on how it can be assessed.

What would be helpful is a way to access each picture's record and associating the date and time field to my form.

Anyone else with a knowledge in this field? It is a bit of a challenge eh ?

Many thanks for trying.


Louis B

 

[LOUISBUHAGIAR54]

I have been searching around to solve this problem. Apparently when a digital camera takes a photo it stores other data along with the image. The date consists of the camera type, focal length, exposure, date and time, etc etc. It stores the data in a record and transfers it along with the picture when images are uploaded to a computer, say. This data is called EXIF data.

I suppose there is a way how this information can be extracted from this record so that it can be shown on an access form along with the image. Can anyone oblige with any further help please ?

LouisB.

 

[jdraw]

I use a free image software called Irfanview to view images, add dates etc.

see http://www.irfanview.com
I am attaching a few jpgs.

Irfanview_00 shows a directory with the additional fields selected from a drop down. The drop down is available with right click on the column heading line. You can select the fields you want.
You could add the various values to other fields in your table and populate them when you add photos.

Irfanview_2 shows a photo (DSCF1388.jpg) opened with IrfanView. I selected image and then Information which showed me the image properties as per the image on the left. Then clicked on the EXIF Info at the bottom of that image, and it displays the image on the right showing all of the EXIF information.

I have found previously, but cant locate it at the moment, an Access database (mdb) called Image Manipulation or modification by a Trevor Lancaster (modification to something prepared by Ken Getz as I recall) that allows manipulation, resizing, rotation, flip etc. It did not, as I recall, have info about the date picture taken. I believe the data base was created in the late 90's.

Hope this is helpful.

Merry Christmas.

 

[LOUISBUHAGIAR54]

jdraw,


Many thanks for the information which is useful. However, i cannot find a way to automatically show the date and time when a picture is taken and show it as a field on the form. The picture comes up quite will using the path to the picture as the control source of the image.

This seems to be quite a complicated feat. I suppose it will have to include complicated vba code that penetrates the image EXIF information.


Happy New Year and thanks for your efforts.

LouisB

 

[jdraw]

I haven't yet found a way to do the date/time taken using vba. What I was suggesting s if you have a table in Access

eg.
MyPhotosTable

PhotoId
PhotoName
PhotoLinkToPath
PhotoDateTaken
other photo info

When you create the table and include the Photo (FileName) and Path, you could enter the Date/Time taken using the EXIF info.

How do you store the PhotoLinkToPath of the PhotoName at present?