Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19

    Exclamation Unanswered: How to show images not repeat in Report , Can anyone help me please !!!

    I created report in AccessXP (sp2 Thai)

    And used image for show picture each record sort by ID

    But I have problem !!!


    in each record have some ID no picture file ( I used Image for show picture by selected picture file from path.... )

    But ...
    In my report
    It's show repeat pictures !!! ( It's selected picture file from previous ID)

    Usually ... If any ID no picture file , It not show any picture ... (It's empty)

    But it is not !!!

    I can't ....

    Can you help me please ....

    My coded :

    Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Set dbs = CurrentDb()
    Set rst = dbs.OpenRecordset("select emp_picture from employee where emp_id = " & EMP_ID)
    If Not rst.EOF Then
    EMP_PICTURE.Picture = rst!EMP_PICTURE
    Else
    EMP_PICTURE.Picture = ""

    End If

    End Sub

    -----------

    Thank you very much

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    When I open a report I default a picture to not visible. If the dir of the file <> "" then I make it visible. This may work for your form too.

  3. #3
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19
    umm I did it like you suggested me...

    it had problem yet ...

    And If click next record speed up it had error ... also

    Ummm
    You have otherway to solve this problem ?

    Thank you very much For loss your times to solved this problem ....

  4. #4
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    Wht was the error you got on changing records?

  5. #5
    Join Date
    Oct 2003
    Location
    Thailand
    Posts
    19
    ohhh I have some problem about my internet so I as reply to you late ...


    Thank you very much
    Nevermind..

    I will be The white picture file for ID which no Picture file ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •