Insert Pictures in Access

[rumads]

I have inserted pictures into my access program but when I got to print them they don't print with the information that i have added. Can someone help? Thanks.

[alansidman]

How are you trying to print them? In a report? Trying to print from a form? You need to be more specific about what you are doing and what results you are getting. I know it appears that many of the people on this forum appear to be mind readers about what the issues are, but unfortunately, I never passed that test.

Also, what version of Access are you employing?

[rumads]

Using Access 2007. Let me give you a bried description. We are working on implementing a list of all of our assets into a table within Access. This information will contain the year, make, model, etc inforamtion. The pictures were inserted into the Asset Table that we created. When completed I would like to print out the information on the asset into a 8 1/2 X 11 sheet of paper with the picture and all the necessary information. Can you please provide details on how to do this? Thanks.

[alansidman]

First, you should realize that there is a size limitation to Access. Approximately 2 Gigs. Haveing said that, depending on what you are placing in your database, pictures (images) can eat up a lot of space. You may want to consider linking your images versus actually having them in a table in the database. Of course only you can determine your needs and how much your db will grow over time.

I am assuming that you are developing a report (mind reading again) with the information and picture of the asset. So long as the image is a bound control, in the report design, you should be able to insert the image by dragging the field name to the design. How are you currently designing your report or are you trying to do this in some other object.

It may be helpful if you post a sanitized version of your data base, so that we can see exactly what you are doing. Make sure it has a limited amount of dummy (non-confidential) data.

Alan