Make access open other programmes?

[Niroth]

Hi guys, I'm wondering if it's possible to open other programmes from Access? Is it possible to make my access software connect to my scanner and save the newly scanned pictures with the recordID generated in access as its name, or the reverse, have the software retrieve the name the picture file and save it in a table in the software? If all this is possible, can anyone tell me how I should go about it? Thanks.

 

[CyberLynx]

I'm wondering if it's possible to open other programmes from Access?

Yes....See MS-Access VBA Help regarding the Shell Function.

Is it possible to make my access software connect to my scanner and save the newly scanned pictures with the recordID generated in access as its name, or the reverse, have the software retrieve the name the picture file and save it in a table in the software?

Yes....but no guarantees. To access the Scanner, you will need to Reference the Microsoft Windows Image Acquisition Library v2.0 within the VBA IDE (VBA Editor). This library is the WIAAut.dll which is used for connecting to the scanner, web-cam or whatever. I highly recommend you read up on this DLL Library before really getting to deep into it. There is lot of information on it. It can open a lot of different possibilities.

Just to get a Touch of it:

Dim commondialog1 As Object
Dim img As ImageFile
Set commondialog1 = CreateObject("wia.commondialog")
Set img = commondialog1.ShowAcquireImage

img.SaveFile ("c:\MyScannedImage.jpg")

.

 

[Niroth]

Thanks, I'll get right on it.