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.