customer detail.docx
TRANSCRIPT
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 1/8
customer detail
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click(
rs.!ove"ast
rs.AddNew
Call ad
rs.#$date
!s%Bo& ' ello ) *+e data +as been stored success,ull-' vb/n,ormation
0nd Sub
Private Sub ad(
rs( 2 *e&t1.*e&t
rs(1 2 *e&t3.*e&t
rs(3 2 *e&t4.*e&t
rs(4 2 *e&t5.*e&t
rs(5 2 *e&t6.*e&t
0nd Sub
Private Sub Command3_Click(
rs.Delete
rs.#$date
!s%Bo& ' ello ) *+e data +as been deleted success,ull-' vb/n,ormation
0nd Sub
Private Sub Command4_Click(
7ne&t
rs.!oveNe&t
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 2/8
/, rs.0O8 *+en
rs.!ove8irst
Call s+owte&t
0lse
Call s+owte&t
0nd /,
0nd Sub
Private Sub s+owte&t(
/, Not rs.BO8 *+en
*e&t1.*e&t 2 rs(
*e&t3.*e&t 2 rs(1
*e&t4.*e&t 2 rs(3
*e&t5.*e&t 2 rs(4
*e&t6.*e&t 2 rs(5
0nd /,
0nd Sub
Private Sub Command5_Click(
rs.!ove8irst
Call s+owte&t
0nd Sub
Private Sub Command6_Click(
rs.!ove"ast
Call s+owte&t
0nd Sub
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 3/8
Private Sub 8orm_"oad(
Dim a As "abel
On 0rror 9o*o a
db.O$en 'Provider2!icroso,t.:et.O"0DB.5.;Data Source2D<=!ODi8>=de$artmentalstore=sam.mdb;Persist Securit- /n,o28alse'
rs.O$en ',1' db adO$enD-namic ad"ockO$timistic
Call s+owte&t
a<
0nd Sub
stock detail
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click(
rs.!ove"ast
rs.AddNew
Call ad
rs.#$date
!s%Bo& ' ello ) *+e data +as been stored success,ull-' vb/n,ormation
0nd Sub
Private Sub ad(
rs( 2 *e&t1.*e&t
rs(1 2 *e&t3.*e&t
rs(3 2 *e&t4.*e&t
rs(4 2 *e&t5.*e&t
rs(5 2 *e&t6.*e&t
0nd Sub
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 4/8
Private Sub Command3_Click(
rs.Delete
rs.#$date
!s%Bo& ' ello ) *+e data +as been deleted success,ull-' vb/n,ormation
0nd Sub
Private Sub Command4_Click(
7ne&t
rs.!oveNe&t
/, rs.0O8 *+en
rs.!ove8irst
Call s+owte&t
0lse
Call s+owte&t
0nd /,
0nd Sub
Private Sub s+owte&t(
/, Not rs.BO8 *+en
*e&t1.*e&t 2 rs(
*e&t3.*e&t 2 rs(1
*e&t4.*e&t 2 rs(3
*e&t5.*e&t 2 rs(4
*e&t6.*e&t 2 rs(5
7*e&t?.*e&t 2 rs(6
0nd /,
0nd Sub
Private Sub Command5_Click(
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 5/8
rs.!ove8irst
Call s+owte&t
0nd Sub
Private Sub Command6_Click(
rs.!ove"ast
Call s+owte&t
0nd Sub
Private Sub 8orm_"oad(
Dim a As "abel
On 0rror 9o*o a
db.O$en 'Provider2!icroso,t.:et.O"0DB.5.;Data Source2D<=!ODi8>=de$artmental
store=sam.mdb;Persist Securit- /n,o28alse'
rs.O$en ',4' db adO$enD-namic ad"ockO$timistic
Call s+owte&t
a<
0nd Sub
SALES
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Private Sub Command1_Click(
rs.!ove"ast
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 6/8
rs.AddNew
Call ad
rs.#$date
!s%Bo& ' ello ) *+e data +as been stored success,ull-' vb/n,ormation
0nd Sub
Private Sub ad(
rs( 2 *e&t1.*e&t
rs(1 2 *e&t3.*e&t
rs(3 2 *e&t4.*e&t
rs(4 2 *e&t5.*e&t
rs(5 2 *e&t6.*e&t
0nd Sub
Private Sub Command3_Click(
rs.Delete
rs.#$date
!s%Bo& ' ello ) *+e data +as been deleted success,ull-' vb/n,ormation
0nd Sub
Private Sub Command4_Click(
7ne&t
rs.!oveNe&t
/, rs.0O8 *+en
rs.!ove8irst
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 7/8
Call s+owte&t
0lse
Call s+owte&t
0nd /,
0nd Sub
Private Sub s+owte&t(
/, Not rs.BO8 *+en
*e&t1.*e&t 2 rs(
*e&t3.*e&t 2 rs(1
*e&t4.*e&t 2 rs(3
*e&t5.*e&t 2 rs(4
*e&t6.*e&t 2 rs(5
0nd /,
0nd Sub
Private Sub Command5_Click(
rs.!ove8irst
Call s+owte&t
0nd Sub
Private Sub Command6_Click(
rs.!ove"ast
7/24/2019 customer detail.docx
http://slidepdf.com/reader/full/customer-detaildocx 8/8
Call s+owte&t
0nd Sub
Private Sub 8orm_"oad(
Dim a As "abel
On 0rror 9o*o a
db.O$en 'Provider2!icroso,t.:et.O"0DB.5.;Data Source2D<=!ODi8>=de$artmental
store=sam.mdb;Persist Securit- /n,o28alse'
rs.O$en ',?' db adO$enD-namic ad"ockO$timistic
Call s+owte&t
a<
0nd Sub