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
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