Move all Record and Display in a Table in Microsoft 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 Move all Record and Display in a Table in Microsoft 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

Private Sub Command3_Click()
On Error Resume Next
Call drop
Call dbConn
conn.Execute "DELETE FROM tblInfo"
MsgBox "All information has been successfully moved!", vbInformation
Call SQLDB(Me.Adodc1, "Select * from tblInfo order by LASTNAME")
End Sub



Private Sub Form_Activate()
On Error Resume Next
Call SQLDB(Me.Adodc1, "Select * from tblInfo order by LASTNAME Desc")
Set Me.DataGrid1.DataSource = Me.Adodc1
Call SQLDB(Me.Adodc2, "Select * from tblInfoTech order by FULLNAME Desc")
Set Me.DataGrid2.DataSource = Me.Adodc2
End Sub

Public Sub drop()
    Call SQLDB(Me.Adodc1, "Select * From tblInfo")
    Call SQLDB(Me.Adodc2, "Select * From tblInfoTech")
   
    If Me.Adodc1.Recordset.RecordCount = 0 Then
    ElseIf Me.Adodc1.Recordset.RecordCount = 1 Then
        Me.Caption = Me.Adodc1.Recordset.Fields("LASTNAME").Value & ", " & Me.Adodc1.Recordset.Fields("FIRSTNAME").Value & " " & Me.Adodc1.Recordset.Fields("MIDDLENAME").Value
        With Me.Adodc2.Recordset
            .AddNew
            .Fields(1) = Me.Caption
            .Fields(2) = Me.Adodc1.Recordset.Fields(4)
            .Update
        End With
    Else
     
        Me.Adodc1.Recordset.MoveNext
        Me.Adodc1.Recordset.MoveFirst
        Me.Caption = Me.Adodc1.Recordset.Fields("LASTNAME").Value & ", " & Me.Adodc1.Recordset.Fields("FIRSTNAME").Value & " " & Me.Adodc1.Recordset.Fields("MIDDLENAME").Value
            Do Until Me.Adodc1.Recordset.BOF
           
                If Me.Adodc1.Recordset.EOF = True Then
                    Me.Adodc1.Recordset.MoveFirst
   
                    Exit Do
                   
                Else
   
                    With Me.Adodc2.Recordset
                        .AddNew
                        .Fields(1) = Me.Caption
                        .Fields(2) = Me.Adodc1.Recordset.Fields(4)
                        .Update
                       
                        Me.Adodc1.Recordset.MoveNext
                         Me.Caption = ""
                         Me.Caption = Me.Adodc1.Recordset.Fields("LASTNAME").Value & ", " & Me.Adodc1.Recordset.Fields("FIRSTNAME").Value & " " & Me.Adodc1.Recordset.Fields("MIDDLENAME").Value
                     
                    End With
                       
                End If
               
            Loop
    End If
Me.Adodc1.Refresh
Me.Adodc2.Refresh

End Sub


MODULE CODES(DB Connection)

Option Explicit

'variables for ADODB
Public conn As New ADODB.Connection
Public ctr As Integer



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

Public Sub dbConn()
  Set conn = New ADODB.Connection
  conn.ConnectionString = strConn2
  conn.Open
End Sub

Public Function strConn2() As String
  strConn2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "
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

DOWNLOAD SOURCE CODE HERE

Show and Hide Password in JQuery Framework

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 show and Hide Password in JQuery

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

//showpassword js
$(".showpas").on('click', function () {
$(this).parent().find('input').toggleAttr('type', 'text', 'password');
$(this).toggleClass('show');

if ($(this).hasClass('show')) {
$(this).text('hide');
} else {
$(this).text('Show');
}
});

// jquery toggle just the attribute value
$.fn.toggleAttr = function (attr, val1, val2) {
var test = $(this).attr(attr);
if (test === val1) {
$(this).attr(attr, val2);
return this;
}
if (test === val2) {
$(this).attr(attr, val1);
return this;
}
// default to val1 if neither
$(this).attr(attr, val1);

DOWNLOAD SOURCE CODE HERE

return this;
};

Select and Save Color Header as Image in Microsoft 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 to Select and Save Color Header as Image in Vb6

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

Private Sub colorpicker_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
colorpick.Picture = Nothing
colorpick.BackColor = colorpicker.Point(x, y)
End Sub

Private Sub Command1_Click()
namefile = App.Path & ("/" & Me.Caption) & ".jpg"
SavePicture colorpick.Image, namefile
End Sub

Private Sub Form_Load()
colorpick.Picture = LoadPicture(App.Path & "\Header.jpg")
End Sub

DOWNLOAD SOURCE CODE HERE

Perimeter of the Rectangle Solver in C++

In this article I would like to share with you a simple program that I wrote using C++ as my programming language that will ask the user to give length and width of the rectangle and then the program will compute the perimeter of the rectangle. The code is very simple and easy to understand by the beginners in C++ programming.

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

perimeter.cpp

// perimeter.cpp

// Author : Jake Rodriguez Pomperada

// Date   : October 5, 2019   5:49 AM Saturday

// Email  : jakerpomperada@gmail.com

// Webiste : http://www.jakerpomperada.com

// Location : Bacolod City, Negros Occidental Philippines

#include <iostream>

using namespace std;

int main() {

int length=0,width=0, perimeter=0;

cout <<"\n\n";

cout <<"\tPerimeter of the Rectangle Solver";

cout <<"\n\n";

cout <<"\tGive length of the rectangle :";

cin >> length;

cout <<"\tGive width of the rectangle :";

cin >> width;

perimeter = 2 * (length * width);

cout <<"\n\n";

cout << "\tPerimeter of the rectangle is "

    << perimeter <<".";

    

cout <<"\n\n";

cout <<"\tEnd of Program";    

}

Perimeter of the Rectangle Solver in C++

Basic Arithmetic Operations in C++

In this article I will share you guys a sample program that I created using C++ that will ask the user to give two numbers and then the program will perform basic arithmetic operations such as addition, subtraction, multiplication and division. The code is very simple and easy to understand.

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

basic_math.cpp

#include <iostream>

using namespace std;

int main() {

int a=0,b=0, sum=0, difference=0;

int product=0, quotient=0;

cout <<"\n\n";

cout << "\tBasic Arithmetic Operations in C++";

cout <<"\n\n";

cout << "\tEnter two numbers :";

cin >> a >> b;

sum = (a+b);

difference = (a-b);

product = (a*b);

quotient= (a/b);

cout <<"\n";

cout << "\tThe sum of " << a << " and "

      << b << " is " << sum << ".\n";

      

cout << "\tThe difference of " << a << " and "

      << b << " is " << difference << ".\n";

cout << "\tThe product of " << a << " and "

      << b << " is " << product << ".\n";

cout << "\tThe quotient of " << a << " and "

      << b << " is " << quotient << ".\n";

cout <<"\n";

cout <<"\tEnd of the Program";

}

Basic Arithmetic Operations in C++

Odd and Even Number Checker in C Using Pointers

Write a program that will ask the user to give a number and then the program check if the given number is an odd or even number using pointers and display the result on the screen using C programming language.

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

/* odd_even.c

   Author   : Jake Rodriguez Pomperada,BSCS,MAED-IT

   Date     : November 26, 2018  Monday  9:07 AM

   Location : Bacolod City, Negros Occidental

   Tool     : Dev C++ Version 5.11

   Website  : http://www.jakerpomperada.com

   Email    : jakerpomperada@jakerpomperada.com and jakerpomperada@gmail.com

*/

#include<stdio.h>

int main()

{

   int num=0;

   int *ptr;

   printf("\n\n");

   printf("\tOdd and Even Number Checker");

   printf("\n\n");

   printf("\tEnter a Number : ");

   scanf("%d",&num);

   ptr = &num; 

  if (*ptr%2==0) {

       printf("\n");

         printf("\tThe given number %d is an EVEN number.",num);

     }

    else {

    printf("\n");

     printf("\tThe given number %d is an ODD number.",num);

   }

  printf("\n\n");

  printf("\tEND OF PROGRAM");

  printf("\n\n");

}

Decimal To Binary Converter in C

A simple program that I wrote to ask the user to give the decimal number and then it will convert into binary value using C programming language.

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

#include<stdio.h>
#include<conio.h>

int main()
{
long int d;
int i=0,a[25],j;
printf("\tDecimal To Binary Number Converter");
printf("\n\n");
printf("Enter the Decimal No.:");
scanf("%d",&d);
while(d>0)
{
a[i]=d%2;
d=d/2;
i++;
}
printf("Binary Number Equivalent : ");
for (j=i-1;j>=0;j--)
printf("%d",a[j]);
getch();
}

Basic example of toggleClass using JQuery Framework

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 Basic example of toggleClass using Jquery.

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.

It will Change Text Button and image size after clicking the button 

Program Listing

$('#pokeme').click(function () {
$(this).toggleClass('poked');

if ($(this).hasClass('poked')) {
$(this).text('Poke Me Again');
$('.img-wrapper img').css('height', '400px');
} else {
$(this).text('Poke Me');
$('.img-wrapper img').css('height', 'unset');
}
});

DOWNLOAD SOURCE CODE HERE

Loop and Count Navigation Menu in JQuery Framework

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 Loop and Count Navigation Menu in Jquery.

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

$(document).ready(function(){
var numbr_li;
$('#navbar-menus ul').each(function(){

$('li').each(function(){
numbr_li = $(this).index()+1;
});
console.log(numbr_li);
$('.numcount').text(numbr_li);
});
});

DOWNLOAD SOURCE CODE HERE

Display Picture on Change Event Using JQuery

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 Display Picture on change event using Jquery.

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

$('#addpic').on('change', function () {
addProf(this);
console.log('change');
});


function addProf(input) {
if (input.files && input.files[0]) {
var reader = new FileReader();

reader.onload = function (e) {
$('#imgpic').attr('src', e.target.result);
$('#imgpic').show();
};
reader.readAsDataURL(input.files[0]);
}
}

DOWNLOAD SOURCE CODE HERE