Happy Codings - Programming Code Examples

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

Check if Given Binary Tree is an AVL Tree
This is a C++ Program to check if BST is AVL. An AVL tree is a self-balancing binary search tree. It was the first such data structure to be invented. In an "AVL tree", the heights of the

C Program Printing Upside Down Triangle
Upside down triangle. A triangle with all sides equal is called "Equilateral Triangle". We shall now see how to print stars char, in equilateral triangle shape, but 'upside-down'. Equilateral

Print the Factorial of Number by recursion
Program takes a Positive integer & Calculates the factorial of the number. First user enter 6 then, Factorial will be equal to '1*2*3*4*5*6' 720. Learn to Find the "Factorial" of a number

Check a Number is Positive Negative or 0
We will use the above logic inside if to check number for Negative, Positive or Zero. Step by step Descriptive Logic to check negative, positive or zero. Input a number from user in

Code Find Second largest number in Array
Code to find the largest and second largest element in an array. Step by step descriptive logic to find second largest element in array. Find second largest element of an array in C

Code Passing Array to Function using Call
When we pass the address of an array while calling a function then this is called function call by reference. When we pass an address as an argument, the function declaration...

C Store Information Using Structures with
C Programming example Store information using structures with dynamically memory allocation. This c program asks user to store the value of noOfRecords and allocates the

Compares two Integers in The C Language
Comparing two integer variables is one of the simplest c program you can write at ease. In this program, you can either take input from user using scanf() function or statically define