Tuesday, October 1, 2019

Civil Status Checker in Visual Basic 6

A very simple program that I wrote using Microsoft Visual Basic 6 to ask the user to give a number and then the program will check if the given number of the user represents single, married, divorced or widowed civil status. Thus our program also asks the user if the user whats to continue to run the program or not.

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

' Civil status program in vb6
' Written by Mr. Jake R. Pomperada,MAED-IT
' Date : October 1, 2019
' Email : jakerpomperada@gmail.com


Private Sub Command1_Click()
Dim a As Integer
a = Val(Form1.Text1.Text)

If (a = 1) Then
    Msg = "The Result"
    Style = vbInformation
    disppaly = MsgBox("You are still Single.", Style, "The Result")
ElseIf (a = 2) Then
Msg = "The Result"
Style = vbInformation
disppaly = MsgBox("You are Married.", Style, "The Result")
ElseIf (a = 3) Then
Msg = "The Result"
Style = vbInformation
disppaly = MsgBox("You are Divorced.", Style, "The Result")
ElseIf (a = 4) Then
Msg = "The Result"
Style = vbInformation
disppaly = MsgBox("You are Widowed.", Style, "The Result")
Else
Msg = "The Result"
Style = vbInformation
disppaly = MsgBox("Invalid Civil Status.", Style, "The Result")
End If
End Sub


Private Sub Command2_Click()
 Form1.Text1.Text = ""
 Form1.Text1.SetFocus
End Sub

Private Sub Command3_Click()
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Msg = "Do you want to continue ?"    ' Define message.
Style = vbYesNo + vbInformation + vbDefaultButton2    ' Define buttons.
Title = "Quit Program"    ' Define title.
Help = "DEMO.HLP"    ' Define Help file.
Ctxt = 1000    ' Define topic context.
        ' Display message.
Response = MsgBox(Msg, Style, Title, Help, Ctxt)
If Response = vbYes Then    ' User chose Yes.
    Form1.Text1.Text = ""
    Form1.Text1.SetFocus
Else
    End
End If
End Sub



How to use DataGrid1.Columns.Item(0) Display Data/Delete in Visual Basic 6 and MS 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 use DataGrid1.Columns.Item(0) Display Data/Delete. This simple application will help you how to use DataGrid1.Columns.Item(0) in Vb6 you can change  0 it depends on the datafields number in 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


DISPLAY

Private Sub DataGrid1_Click()
On Error Resume Next
Me.txtID.Text = Me.DataGrid1.Columns.Item(0)
Me.Text1.Text = Me.DataGrid1.Columns.Item(1)
Me.Text2.Text = Me.DataGrid1.Columns.Item(2)
Me.Text3.Text = Me.DataGrid1.Columns.Item(3)
Me.Text4.Text = Me.DataGrid1.Columns.Item(4)
End Sub

DELETE 

Private Sub Command3_Click()
On Error Resume Next
 Call SQLDB(Me.AdoCon, "Select * from tblInfo where ID like'" & Me.DataGrid1.Columns.Item(0).Text & "'")
             Me.AdoCon.Recordset.Delete
             Me.AdoCon.Refresh
             Me.Text1.Text = ""
             Me.Text2.Text = ""
             Me.Text3.Text = ""
             Me.Text4.Text = ""
             Me.txtID.Text = ""
End Sub








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