by shruti phatak (1 Submission)
Category: Files/File Controls/Input/Output
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 3rd May 2002
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Function to Check record exist in master file before opening transaction form
Dim oprs As ADODB.Recordset
Set oprs = New ADODB.Recordset
SQL = "select * from " & fn
oprs.Open SQL, DB, adOpenKeyset, adLockReadOnly
If oprs.RecordCount <> 0 Then
openfil = True
Else
msg = "No Records In " & fn & " First Enter That!!"
MsgBox msg
openfil = False
End If
End Function
Call this function with master filename as parameter
No comments have been posted about Function to Check record exist in master file before opening transaction form. Why not be the first to post a comment about Function to Check record exist in master file before opening transaction form.