General information
Category:
Forms & Form designer
Hi Liam:
I have inserted new code for open see below:
LPARAMETERS cStatus, nInputYear
IF !Used("SCHD") Then
Use SCHD in 0
Endif
SELECT ;
Ilspm, ;
Status, ;
Start, ;
Comp, ;
Ssp, ;
Ils_k, ;
Avail, ;
Ship, ;
Hull, ;
Num_Chgs ;
FROM Schd ;
WHERE Status = cStatus AND ;
Val(left(SSP,2)) = nInputYear ;
INTO CURSOR Rptstatus1 ;
ORDER BY 5
IF _TALLY > 0
REPORT FORM Rptstatus1 PREVIEW
ELSE
= MESSAGEBOX ("Sorry, there was no records matching your report criteria."), 0, (" Status Report ")
ENDIF
Question 1: Should I have an open statement Then Program Error File does not exist.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only