acCmdInsertObject - bmp files display picture, why don't jpg and gif?

Posted on 2004-11-17
Last Modified: 2008-01-09
I have embedded a file using acCmdInsertObject but all I see in the control is the name of the file if it is a jpg or gif. If it is a bmp or ppt(ie from the list of applications shown in the dialog box) it shows the picture.

How do I get jpg and gif to display as pictures?

I am using Access 2000, Windows XP home.
Question by:ltdrisk
    LVL 34

    Expert Comment


    Author Comment

    Thanks but it didn't work.

    Your tip showed me a form that imports jpg and gifs into an image control but this picture does not get saved in a table(ie when you close the form the picture goes away. next time you open the form you have to import the pic again.
    I have used Excel.Application.GetOpenFileName to browse to a file, so that part is fine.
    My problem now is to get the jpg to display as a picture in the Bound OLEFrame. All I see is the name of the file. If I double click it it opens the fax viewer.

    It seems the OLEFrame will not display the picture if it is a jpg or gif. I think your tip has some code to convert but it is complicated. Is there not an easier way?
    LVL 50

    Expert Comment

    by:Steve Bink
    I think this is what you are looking for:;en-us;258644

    Accepted Solution

    PAQed with points refunded (50)

    Community Support Moderator

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    733 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