Calling CameraCaptureUI in Module or VB.net App using CameraCaptureUI

[DMoody007]

We have an MS Access 2013 DB that we need to capture an image and store with the record. I have found code that works in .net using the CameraCaptureUI that works nicely in VB. Wondering if I can use this interface in MS Access. Hoping someone in the forum has tried and knows if it can work.

Two thought processes:
1) Able to use the code directly in a module within access app (ideal solution for distribution purposes and maintenance)
2) Create a VB.net app with the picture capture code. Call it from MS Access to aquire the image, pass to MS Access form, and close VB.net app. Not ideal but think it could work. I personally have never tried calling a VB.net app from within access. If someone could provide a snippet of code or suggestions for optimal search in google, it would be appreciated.

[ranman256]

if you are on a form, and have a 'photo' field box,
right click, INSERT OBJECT,
the camera should be listed in the sources to load images.
select camera and grab a photo.
Does this not work?

[ItsMe]

I have not had the need for such a thing, but I recall someone posting an example of an app that uses the SendMessage function in the user32 library. I think the idea is that the camera displays in a Window and then Copy/Paste is used to store the image in an OLE object in a table.
https://www.accessforums.net/access/...tml#post234099

Another approach might be using TWAINs and the Microsoft Windows Image Acquisition Library. I do not have much experience with this library because it is not suitable for document scanning and I have not had a real need for it. However, it seems like it might work for your needs. You can make a reference to the library in Access via Tools>References. Here is a link to an overview. If you search the web, you should see VBA examples.
https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx

[DMoody007]

You both gave me some ideas to research. Thank you.
VB.net forum gave me an idea too - Keep MS Access as database and use VB.net as GUI. Requires a little more programming but very possible.