Tuesday, October 1, 2019

Validate Contact number in Visual Basic 6 and Microsoft Access

Here is a sample program that is being provided by my close friend, business partner, and fellow software engineer Sir Larry Dave Emol. He created this program to Validate Contact number in Visual Basic 6 and Microsoft Access

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.



Sample Program Output


Program Listing


FORM CODES

Option Explicit

Public Function AppDir() As String
    If Right$(App.Path, 1) = "\" Then
        AppDir = App.Path
    Else
        AppDir = App.Path & "\"
    End If
End Function


Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource

    'Loads the database and provides the database password
    adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
 
    'Sets the command type to Table
    adoObj.CommandType = adCmdText
 
    'Loads the source table of info
    adoObj.RecordSource = AdoRec

    'refreshes database status
     adoObj.Refresh
End Sub


Module( Database Connection)

Option Explicit


Public Function AppDir() As String
    If Right$(App.Path, 1) = "\" Then
        AppDir = App.Path
    Else
        AppDir = App.Path & "\"
    End If
End Function


Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource

    'Loads the database and provides the database password
    adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
 
    'Sets the command type to Table
    adoObj.CommandType = adCmdText
 
    'Loads the source table of info
    adoObj.RecordSource = AdoRec

    'refreshes database status
     adoObj.Refresh
End Sub


Custom Modal Form Using HTML and CSS

Here is a sample program that is being provided by my close friend, business partner, and fellow software engineer Sir Larry Dave Emol. He created this program Custom Modal Form Using HTML and CSS.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.



Sample Program Output





Fixed/Shrink Navigation Menu Using HTML and CSS

Here is a sample program that is being provided by my close friend, business partner, and fellow software engineer Sir Larry Dave Emol. He created this program Fixed/Shrink Navigation Menu Using HTML and CSS.

Learn from this simple CSS and JS

* Shrink Navigation
* Fixed Navigation
* Fixed Footer
* Nice Hover Menu


I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.



Sample Program Output






Catch Duplicate Entry in Visual Basic 6 and Microsoft Access

Here is a sample program that is being provided by my close friend, business partner and fellow software engineer Sir Larry Dave Emol. He created this program using Microsoft Visual Basic 6 and Microsoft Access to Catch Duplicate Entry in the database.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.




Sample Program Output


Program Listing


FORM CODES

Private Sub Command1_Click()
    If Text1.Text = "" Or Text2.Text = "" Or Text3.Text = "" Or Text4.Text = "" Then
        msgbox.Caption = "? Please complete the data fields"
    Else
        Call SQLDB(Me.AdoCon, "SELECT * From tblinfo where FIRSTNAME like'" & Me.Text1.Text & "' and MIDDLENAME like'" & Me.Text2.Text & "' and LASTNAME like'" & Me.Text3.Text & "'")
        If Me.AdoCon.Recordset.RecordCount = 1 Then
        msgbox.Caption = "? Duplicate Entry" & " " & Me.Text1.Text & " " & Me.Text2.Text & " " & Me.Text3.Text & " " & Me.Tag
        Exit Sub
        End If
        
        Call SQLDB(Me.AdoCon, "Select * From tblInfo")
          With Me.AdoCon.Recordset
                  .AddNew
                  .Fields(1) = Text1.Text
                  .Fields(2) = Text2.Text
                  .Fields(3) = Text3.Text
                  .Fields(4) = Text4.Text
                 .Update
           End With
           Me.Text1.Text = ""
           Me.Text2.Text = ""
           Me.Text3.Text = ""
           Me.Text4.Text = ""
    End If
End Sub


Module Codes(Database Connection)

Option Explicit


Public Function AppDir() As String
    If Right$(App.Path, 1) = "\" Then
        AppDir = App.Path
    Else
        AppDir = App.Path & "\"
    End If
End Function


Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource

    'Loads the database and provides the database password
    adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
    
    'Sets the command type to Table
    adoObj.CommandType = adCmdText
    
    'Loads the source table of info
    adoObj.RecordSource = AdoRec

    'refreshes database status
     adoObj.Refresh
End Sub



Page Preloader Using Jquery and Custom CSS

Here is a sample program that is being provided by my close friend, business partner and fellow software engineer Sir Larry Dave Emol. He created this program using he called Page Preloader Using Jquery and Custom CSS. Simple jQuery preloader with few lines of CSS and jQuery code.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.


Program Listing

Custom.js

jQuery(function($){'use strict';(function(){
$('#preloader').delay(200).fadeOut('slow');
}())})

Custom CSS

#preloader {
    width: 100%;
    height: 100%;
    background: #21211e;
    z-index: 11000;
    position: fixed;
    display: flex;
    align-items: center;
    justify-content: center;
}


/*** Page Reloader **/
.LoadingDots.small .dot {
    width: 20px;
    height: 20px;
    margin: 0 2px;
}
.LoadingDots .dot {
    background-color: #ccc;
    border-radius: 100%;
    display: inline-block;
    animation: sk-bouncedelay 1s infinite ease-in-out both;
}
.LoadingDots {
    margin: 0 auto;
    text-align: center;
    width: 100%;
    min-width: 36px;
}
.LoadingDots .second {
    animation-delay: -0.16s;
    background-color: beige;
}
.LoadingDots .first {
    animation-delay: -0.32s;
    background-color: pink;
}
.LoadingDots .third {
    background-color: hotpink;
}
@keyframes sk-bouncedelay{
0%, 80%, 100% {
    -webkit-transform: scale(0);
    transform: scale(0);
}
   
40% {
    -webkit-transform: scale(1);
    transform: scale(1);
}
}
.small {
    animation: fadeInUp 150ms ease-out 0s 1 normal forwards;
}

@keyframes fadeInUp{
0% {
    opacity: 0;
    -webkit-transform: translate3d(0,5px,0);
    transform: translate3d(0,5px,0);
}

100% {
    opacity: 1;
    -webkit-transform: translate3d(0,0,0);
    transform: translate3d(0,0,0);
}
}





Monday, September 30, 2019

Add Custom CSS/HTML and Display Records in Visual Basic 6

Here is a sample program that is being provided by my close friend, business partner and fellow software engineer Sir Larry Dave Emol. He created this program using Microsoft Visual Basic 6 to add custom CSS/HTML and display the records in Visual Basic 6.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.



Sample Program Output

Program Listing

Sub LOAD()

    Dim i       As Long
   
   Call SQLDB(Me.AdoCon, "select distinct Namex from tblInfo Order by Namex")
   
      Me.WebBrowser1.Navigate2 "About:Blank"
      Do While Me.WebBrowser1.ReadyState <> READYSTATE_COMPLETE
        DoEvents
    Loop
    With WebBrowser1.Document

        .Write ("<button>Save</button>")
        .Write ("<HTML><head></head><style type='text/css'> body,td{font-family: Tahoma;} body,td{font-size:16px;} button{padding:30px; Background-color: blue;}</style>")
        .Write ("<BODY Scroll=Yes oncontextmenu='return false';>")
        .Write ("<TABLE WIDTH=100% BORDER=1 BORDERCOLOR=#215DC6 CELLPADDING=1 CELLSPACING=1>")
        .Write ("<thead>")
        .Write ("<TR>")
        .Write ("<TH BGCOLOR=#D6E9F7><B>Namex </B></TH>")
        .Write ("</TR>")
        .Write ("</thead>")
        Do While AdoCon.Recordset.EOF <> True
        i = i + 1
        .Write ("<TR>")
        .Write ("<TD bgcolor=#FFFFD2><FONT FACE=tahoma SIZE=1>" & AdoCon.Recordset.Fields("Namex").Value & "</TD>")
        .Write ("</TR>")
            AdoCon.Recordset.MoveNext
        Loop
        
    
        .Write ("</TABLE>")
        .Write ("</BODY>")
        .Write ("</HTML>")
        WebBrowser1.Document.Script.Document.Clear
        WebBrowser1.Document.Script.Document.Close
    End With
    

                
End Sub

Private Sub Form_Activate()
Call LOAD
End Sub


Leap Year Checker in Visual Basic NET

Leap Year Checker Using Microsoft Visual Basic NET

In this article I would like to share a simple program that will ask the user to give a year and then the program will determine and check if the given year is a leap year or not a leap year using Microsoft Visual Basic NET.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.






Sample Program Output


Program Listing

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim given_year As Integer

        given_year = Val(TextBox1.Text)

        If given_year Mod 100 = 0 Then
            If given_year Mod 400 = 0 Then
                MsgBox("The given year " & given_year & " is a Leap Year", vbInformation, "The Result")
            Else
                MsgBox("The given year " & given_year & " is a Not Leap Year", vbInformation, "The Result")
            End If
        Else
            If given_year Mod 4 = 0 Then
                MsgBox("The given year " & given_year & " is a Leap Year", vbInformation, "The Result")
            Else
                MsgBox("The given year " & given_year & " is a Not Leap Year", vbInformation, "The Result")
            End If
        End If
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        TextBox1.Text = ""
        TextBox1.Focus()
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        End
    End Sub
End Class





Positive and Negative Number Checker in VB.NET

Positive and Negative Number Checker in VB.NET

In this article I would like to share with you a program that will ask the user to give a number and then the program will check if the given number is a positive or negative number using Microsoft Visual Basic NET. Let us assume that zero belongs to positive number.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.




Sample Program Output


Program Listing

Public Class Form1

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        End
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim a As Integer

        a = Val(TextBox1.Text)

        If (a >= 0) Then
            MsgBox("The given number  " & a & " is a Positive Number.")
        Else
            MsgBox("The given number  " & a & " is a Negative Number.")
        End If
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        TextBox1.Text = ""
        TextBox1.Focus()
    End Sub
End Class



Area of the Circle Solver in VB.NET

Area of the Circle Solver in VB.NET

In this article I would like to share with you guys a sample program that will ask the radius value of the circle and then the program will compute the area of the circle using Microsoft Visual Basic NET.

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.
My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.


My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.


My personal website is http://www.jakerpomperada.com.




Sample Program Output

Program Listing

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        End
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim radius As Integer
        Dim area As Single

        Dim PI As Single = 3.14F

        radius = Val(TextBox1.Text)

        area = (PI * radius * radius)

        TextBox2.Text = "The area of the circle is " & area


    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        TextBox1.Text = ""
        TextBox2.Text = ""
        TextBox1.Focus()
    End Sub
End Class