PLEASE HELP! Photo capture from digital camera into Access.

  • Thread starter Thread starter georgemar
  • Start date Start date
G

georgemar

I have spent the last month searching through everything
possible on the net and talking to Microsoft in Australia
to get information on photo capture in MS Access to no
avail.

I have also posted a number of messages to this newsgroup
again to no avail.

A search of Google indicates that a lot of people are
interested in this issue and they too have had no success
nor responses.

I hope that I can impress upon your generosity out there
to start a discussion on this issue.

The main problem as I see it is that there is absolutely
no documentation anywhere on imaging within Access. I have
narrowed my research to using the Kodak Imaging ocx's
provided with XP and I have managed to find the help file
as well. For those of you who are looking for the
Imgocxd.hlp you can find it in Windows 98. However, there
are no examples or sample codes in the help file.

What I an searching for now are sample codes and examples
on how to use the ocx's with VBA.

Or is there an easier way to do this?

I hope that we can solve this for everyone.

Thanking you in advance.
George
 
I simply copy images from the MMC card that my camera uses (others cameras
use other formats of storage card/stick/disk) via a multi card reader into a
file on the hard drive, then acquire the images into Access. There are
sample databases illustrating three approaches to handling images in Access
at http://accdevel.tripod.com. Perhaps you can even use some of the code as
a start.

It isn't capturing photos directly from the camera, but it does get the
photos into the application, simply and easily. And, of course, they don't
have to be digital photos, either, but can be scans of other material.

Larry Linson
Microsoft Access MVP
 
What are you trying to achieve ?
Control of actually taking a picture, displaying a live preview video stream etc ?

Although there are standard ways of doing this the implementation varies widely between camera manufacturers,
and few provide this level of functionality without requiring you to use their own toolkits or api's.


But if it's just a case of handling images from a digital camera then there are a range of different ways
to do this.
 
TO Larry Linson and Exponent; thank you for your responses.

I have been to the various web sites suggested but most of
them talk about the handling of a graphics file(e.g Jpeg)
already created.

What I am trying to achieve is to capture the picture
from "ANY" TWAIN camera, webcam etc. and pass "MY"
filename (e.g JohnSmith.jpg) to be saved as a Jpeg and not
use the camera's generic name (e.g File0001.jpg. The name
JohnSmith.jpg is obtained from the table that underlies
the form from which the photo is taken.

When the filename JohnSmith.Jpg is saved I can then use
VBA to link it to my image control because the foreign key
will be "JohnSmith". Thus, the user doesn't have to rekey
the name into the filename. Otherwise, the user has to
either key-in the name before saving or go to explorer and
change the filename, both of which are prone to errors.

There appear to be the necessary methods within Kodak
Imaging Activex but there are no examples or sample codes.
Can you tell me if Kodak imaging activex is worth pursuing
and if so, where I can get some sample codes or directions
on how to use the activex?

regards
george

-----Original Message-----


What are you trying to achieve ?
Control of actually taking a picture, displaying a live preview video stream etc ?

Although there are standard ways of doing this the
Click to expand...
implementation varies widely between camera manufacturers,
and few provide this level of functionality without
Click to expand...
requiring you to use their own toolkits or api's.
But if it's just a case of handling images from a digital
Click to expand...
camera then there are a range of different ways
 
There appear to be the necessary
methods within Kodak Imaging
Activex but there are no examples
or sample codes. Can you tell me if
Kodak imaging activex is worth
pursuing and if so, where I can get
some sample codes or directions
on how to use the activex?
Click to expand...

Some time ago, I looked at the predecessor software, then known as the Wang
Imaging Controls (Kodak bought Wang), but the free version did not have the
functionality that I needed for the project, and the the prime contractor
and client were not interested in the for-fee enhanced controls from Wang.
Instead, they selected a high-end (and expensive) graphics package that I
would not recommend for any general use.

So, my answer is that I'm sorry but I can't offer any guidance on those. My
recollection is that the information I obtained was from the Eastman (Kodak)
website, both for the free and fee versions.

Larry Linson
Microsoft Access MVP
 
Can you accept the default File0001.jpg, and then rename it (using the VBA
Name statement)?
 
Thnk you Larry and Douglas

I feel like I am fighting a loosing battle.

As for the default filename, they change from supplier to
supplier. e.g Logitech calls their filename
Picture1.jpg. If I could somehow capture that filename
after it is taken, yes, I can change it with VBA. The
catch is catching the suppliers filename or pass a desired
filename to the supplier.

many thanks
george
 
Back
Top