Happy Codings - Programming Code Examples
Html Css Web Design Sample Codes CPlusPlus Programming Sample Codes JavaScript Programming Sample Codes C Programming Sample Codes CSharp Programming Sample Codes Java Programming Sample Codes Php Programming Sample Codes Visual Basic Programming Sample Codes


Visual Basic Programming Code Examples

Visual Basic > Database SQL Stuff Code Examples

Check record exist in master before opening transaction form

Check record exist in master before opening transaction form Public Function openfil(fn) 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 file name