Results 1 to 2 of 2
  1. #1
    sureshfina is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    1

    Load images in access using iif function?

    hi,
    I have little knowledge in access and eager to know more.I have made a form named stcok details. It contains the follwing fields 1.part number 2.Image. I want to use iif condition in the image field expression. i want to load the material image when i give the part number. i have given following expression in image field, but it is not working.


    expr1:iif([part number]="123","c:\images\mat.jpg","no image"). it give the words as it is inside the quote. how do i load the image. What is the data type of image field (text or OLE object)

    thanks in advance
    suresh

  2. #2
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Post OLE Object data type

    In the underlying table, you will need to ensure the data type for the image field is set to OLE object. You can then enter your image for each record by right clicking the field and embedding or linking the image file. No expression necessary in your query.

    RC
    Fruit Heights, Utah
    Last edited by MAF4Fam6; 12-24-2009 at 12:34 AM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Program to load data
    By fsmikwen in forum Access
    Replies: 2
    Last Post: 12-10-2009, 08:36 AM
  2. Replies: 17
    Last Post: 08-26-2009, 11:27 AM
  3. Load tables name and fields name to list box
    By casseopia00 in forum Programming
    Replies: 1
    Last Post: 06-30-2009, 10:09 PM
  4. to_char function in Access?
    By Amber_1977 in forum Queries
    Replies: 0
    Last Post: 01-20-2009, 04:45 PM
  5. Access Report and embedded images
    By joypanattil in forum Reports
    Replies: 0
    Last Post: 11-22-2008, 03:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums