Print images from a MS-Access DB (*.mdb) with QuickReport

Posted on 2005-04-19
Last Modified: 2013-11-22

I have a MS-Access DB with bitmaps and jpgs (OLE-Objekt).
I need to print the pictures with QuickReport, but because of the OLE-format,
it is not possible.

Any ideas how i can do it?
And which event i have to use?

Thank you for any idea.

 - Farderlorn -
Question by:Farderlorn
    1 Comment
    LVL 11

    Accepted Solution

    You will have to do this manually. i.e. assign the images to the QuickReport components in the Creation events.
    However, their is a trick to using BMPs and Jpegs in  MS ACCESS Database.

    This article will give you what you need to know when dealing with Images and MS Access:

    Hope this helps!


    Page 1: Working with BLOBs. Storing pictures in Access.

    Page 2: Pulling the Jpeg with DBImage - the wrong way.

    Page 3: Streaming the Jpeg - the wrong way.

    Page 4: Seeking the start of Jpeg in the BLOB.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
    Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now