Photo Storage (1 Viewer)

Hi All

I am trying to incorporate adding a photo to our Work Permit Database.

When a Contractor is added we take a photo and give him a Badge.

Exploring the site I have come up with a program called Dorgem which seems to do what I need, but I cannot get Access to save the photo.

Currently trying
Shell ("C:\Program Files\Dorgem\Dorgem.exe /m/")

[FilePath] = "E:\Database Folder\Work Permit\2011 Edition\BackEnd\WorkPermitPhotos\" & Forms!Form2.[ID] & ".jpg"

The ID Field is a unique field, so trying to save the photo as this, but I simply cannot get Access to save.

Could really do with some help.

Thanks
Gareth

My first suggestion would be to try a path that does not have any spaces.

I would recommend using the supported DBPix - The Image Control for Microsoft® Access (Click Here)

Or you can try AccessImagine, some people like it as simple and clear solution of all picturing problems in MS Access.