I highly advise against using the attachment field, or indeed, imbedding the graphics into the Database.
Instead I suggest that you store the pictures in a directory and then store a path to those images in the database.
If you will use the search bar above, you will find that there are dozens of threads that all ask basically the same question:
“How Do I get an image in/on-to my form/report?”
So for a little background and one method:
Use images in your Access forms, reports, and controls (v2003) I think it is
very important that there is an understanding of the fundamental methods of storage methods in the older MDB files as there is some carry over into the V2007/2010 formats (maybe 2013 too; however, I know very little about that version). I Still do not advise using the OLE method as it has been known to cause bloat along with other issues within the older databases and doesn't transfer well.
Provided in this link is also a link for a video for
V2010 Video: Add, reuse, and update images on forms and reports
Finally, the way I’ve done this for years is to create a custom function and use it as the “picture” value for a “linked” image. The function refers to another control on the form for the file name and then works out the relative path via the
currentproject.path
value. Perhaps I may post an example database using my function.
However, shortly after I had figured out how to do this on my own I came across the following information that does something similar in that it uses a custom function; however, still much different in the final implementation:
How to display images from a folder in a form, a report, or a data access page Article ID: 285820 (v2003) where in the events are used for updating the images, whereas my does not use any events.
If there's enough interest, I might create that generic db using my people template and some clipart... wont take me but a moment or two as the rest of the code is already in production.
swayamprakash
Keep in mind, we are not here to create the project nor write the code for you. If you can post your work, we can certainly guide you in the right direction.