VBA code to manipulate a .jpeg Exif tag used by Explorer to store

[Don Keating]

What I am trying to do is use

Windows Vista
MS Access 2007 database
VBA code
to edit the
Caption and Tags fields stored in .jpgs used by Picasa 3 and the
Tags, Comments and Titles fields you see in an Explorer Window file
properties details list.


I am not familiar with C, VB or .NET but I can use VBA.

Any idea how I might be able to do this?

 

[Karl E. Peterson]

What I am trying to do is use

Windows Vista
MS Access 2007 database
VBA code
to edit the
Caption and Tags fields stored in .jpgs used by Picasa 3 and the
Tags, Comments and Titles fields you see in an Explorer Window file
properties details list.


I am not familiar with C, VB or .NET but I can use VBA.

Any idea how I might be able to do this?

I'd start here: http://www.google.com/search?q=exif+vb

Lots of good examples.

 

[Don Keating]

Thanks for that.
My difficulty is not being able to convert the vb into vba.
I think I need a .dll which I can reference from Access which provides the
properties and events for vba to use.

 

[Karl E. Peterson]

Thanks for that.
My difficulty is not being able to convert the vb into vba.

Huh. For this sort of task, there's truly very little difference between the two.
This is a core language task.

What part(s) are you having trouble with?

I think I need a .dll which I can reference from Access which provides the
properties and events for vba to use.

Well, that's another way. You could wrap all the functionality into a DLL, but
unless this is going to propogate across dozens of MDBs, I can't imagine why you'd
go to that sort of trouble. The code is pretty darn straight-forward, as I recall.
--
..NET: It's About Trust!
http://vfred.mvps.org