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.... )
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
EMP_PICTURE.Picture = ""