I've got a table of members in a microsoft access database, and i've got a report to create an ID card for each of them. Simple! Now though I want to add a photo to this card, so would like a record on access with the image stored on it. Is that poss? It would be even FABBER if I could run a macro or something to take an image from a webcam, at a certain size, and add that to a record? or if not, does anyone know of any software that does it?
Much Love!
Microsoft Access Help
Yes, it is possible as they had such a system at my old college which enabled Access to access image capture via Photo Editor and you could save the picture it took to the database.
As to how you can do it, I can't help you there. Not got the faintest idea.
As to how you can do it, I can't help you there. Not got the faintest idea.
To add the image to the ID card you need an OLE object field in the table (& query). Also create a box in the report bound to the OLE field in the report.
^_^ I forget exactly how to do that though... probably explains why I got 13/60 on my AS Computing database project. Says it all really.
^_^ I forget exactly how to do that though... probably explains why I got 13/60 on my AS Computing database project. Says it all really.