Results 1 to 2 of 2
  1. #1
    turbo910 is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    21

    If statement for image

    hey



    On one of my forms (Products In) has a text box on it the shows what unit a product is in, either 9 or 10, and basically when the unit shows 9 i want an image to show of unit 9 layout, if its 10 then i want an image to show a picture of the layout of unit 10.

    Can anyone assist me in doing this please

    Im using access 2007

    Thanks

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    You will need to add an image to your form and cal it "Logo" then add some code on the afterupdate of the control and the oncurrent of the form. Something like this:

    Me!Logo.PictureType = 1
    If Me!ProductsIn = 9 Then
    Me!Logo.Picture = ImagePath & "9.jpg"
    Else
    Me!Logo.Picture = ImagePath & "10.jpg"
    End If

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

Similar Threads

  1. Filename displaying with image
    By Rob Parker in forum Forms
    Replies: 2
    Last Post: 01-13-2010, 05:05 PM
  2. Image control in MS Access
    By celestialcitizen in forum Forms
    Replies: 6
    Last Post: 07-03-2009, 03:25 PM
  3. Generate Image
    By dbman in forum Import/Export Data
    Replies: 0
    Last Post: 01-31-2008, 10:46 PM
  4. Image with its file name !!!!!
    By ahai in forum Access
    Replies: 0
    Last Post: 07-17-2007, 02:39 AM
  5. The file name with the image
    By ahai in forum Forms
    Replies: 0
    Last Post: 07-16-2007, 01:41 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