Reports in MS Access 2003

[vaidyanathan]

Hi,
Im vaidyanathan. I have reports in my project MS Access 2003.
I store images,attachments,documents as ole object.
While generating the report, it takes too much time to generate as the
images is more.
Is there any way to easily solve this problem?
Bcoz there is some issue resolved in MS Access 2003.

Please help me out.

 

[ansentry]

If you store images within the database you will have problems. Store the images in a folder on hard disk and then refer to their location when you want to use them.

Have a look at the attached sample;

When you unzip it put the database on your desktop and then put the medal.bmp into C:\Temp

Open the database and then open the form frmImage and you will see the image and its path.

When you open the frmCustomer you will see a button "Preview Report" when you click it the report will open and if the Money amount exceeds $100 then the image will be displayed.

If you want to use multiple images in reports or forms then you should do a search in the forum e.g "Images" or post back with further questions.