Replies

I had the same problem and received an answer that worked for me on the Element K Access bulletin board (http://bbs.elementkjournals.com/).

Microsoft has a couple of Knowledge Base articles that could help you, too. Q148463 – How to
display image in Form Without Storing It in Table – lets you show images on screen.

Q161010 – How to Embed a Bitmap Object in a Report at Run Time – might address your need more
directly for the printed reports.

I have found charting in Access is difficult while Excel provides charts that are much easier and more flexible to work with.
Create a query in Access that supplies the necessary data.

Open Excel.
From the menu select Data, Get External Data, Create New Query, and then select the correct driver (Usually MS Access 97 Database).

Select the query or table from the database that you are working with.

Then build the MS Query in Excel and use Excel Chart Wizard once you have imported the data.

You can set the parameters of the MS Query to be refreshed, query you for your parameters, upon opening.

Good Luck.

View the form in design view, select the graphic, push the delete key.