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

Simple C++ Codings for Virtual Base Class
Declare & Define the Functions getnumber() and putnumber(). And declare and define the function 'getmarks()' and 'putmarks()'. Create the derived class sports virtually derived from

Sizeof Operator & Coma Operator In C++
In C++ Language 'sizeof' operator returns the size of the variable or type. Here 'size' means how many bytes of memory is being used by a variable or type. Coma "," Operator is used

Switch Case Statements Break Statement
Lets see a sample without break statement, then we will discuss switch case with break 'Switch Case' statement is mostly used with 'break statement' even though the break is

C Program to calculate Area of a Polygon
Given the coordinates of the vertices of a convex polygon, calculate its area and perimeter. Subdivide it into triangles and calculate the area of each triangle with the

C Language Code Display Prime Numbers
Any whole number which is Greater than 1 & has only two factors that is 1 and the number itself, is called a "Prime Number". Other than these two number it has No Positive Divisor.

Prints Days in Month Logical OR Operator
The above logic is simple & easy to code. But it's lengthy and not optimal to implement. In the above solution we are performing same task for multiple conditions i.e. print 31 days

C Program Code Nested If..Else Statement
When an if else statement is present inside the body of another "if" or "else" then this is called nested if else. C Else and else..if are optional statements, a program having only

C++ Program to Implement Counting Sort
In c++ sort pogram sample, count the number of 'occurrences' of each element. And store it in the Array of size same as the range of data input. Use element value to refer the counter