Hide lines From Report (more like to delete them)

scorpio_x73

Registered User.
Local time
Today, 19:00
Joined
Jul 10, 2003
Messages
12
Not Sure if this is the right place for this question, but it involves reports

so i have a report that use this code to check if a file is in place but i want not to show the corect ones but only the wrong ones as u can see in the code the problem is that i cant "delete" the corect ones and show only the "problems" the first part of if is done only cause i cant hide the corect ones

Dim FileSystemObject

Set FileSystemObject = CreateObject("Scripting.FileSystemObject")

If (FileSystemObject.FileExists("K:\(01)_Greek_All\_Greek_Ones\" & Trim(Artist) & "\" & Trim(Final) & ".rar")) Then

Final.BackColor = "16777215"
Final.ForeColor = "0"
Status.BackColor = "16777215"
Status.ForeColor = "0"
Status.Value = "Ok Good"

Else
Final.BackColor = "0"
Final.ForeColor = "16777215"
Status.BackColor = "0"
Status.ForeColor = "16777215"
Status.Value = "!!!!!!!!! Problem !!!!!!!!!"
End If

Set FileSystemObject = Nothing

End Sub


Finaly the resume is that i want to delete the lines that are "Ok Good" and leave only the lines tha are "!!!!!!!!! Problem !!!!!!!!!"


Thanks in advance
 

Users who are viewing this thread

Back
Top Bottom