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