toytown
چهارشنبه 22 تیر 1390, 13:32 عصر
سلام
من تو برنامه زیر دوتا دکمه دارم :
دکمه اولی یا command1برای وارد کردن اطلاعات به بانک اکسس هست کدش هم اینه
Private Sub Command1_Click()
Set DataGrid1.DataSource = Adodc1
Text4.Text = Text2.Text * Text3.Text
Text6.Text = Val(Text4.Text) + Val(Text5.Text)
Text8.Text = Text7.Text * Text2.Text
Text9.Text = Text8.Text - Text6.Text
Dim a
Dim b
Dim c
Dim d
Dim e
Dim f
Dim g
Dim h
Dim i
a = Text1.Text
b = Text2.Text
c = Text3.Text
d = Text4.Text
e = Text5.Text
f = Text6.Text
g = Text7.Text
h = Text8.Text
i = Text9.Text
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bank.mdb;Persist Security Info=False"
'connect as client
Adodc1.CursorLocation = adUseClient
'select the table to use
'SQL command
Adodc1.RecordSource = "Select * from Table1"
Adodc1.Refresh
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("a") = a
Adodc1.Recordset.Fields("b") = b
Adodc1.Recordset.Fields("c") = c
Adodc1.Recordset.Fields("d") = d
Adodc1.Recordset.Fields("e") = e
Adodc1.Recordset.Fields("f") = f
Adodc1.Recordset.Fields("g") = g
Adodc1.Recordset.Fields("h") = h
Adodc1.Recordset.Fields("i") = i
Adodc1.Recordset.Update
Adodc1.Refresh
Text1.Text = "0"
Text2.Text = "0"
Text3.Text = "0"
Text4.Text = "0"
Text5.Text = "0"
Text6.Text = "0"
Text7.Text = "0"
Text8.Text = "0"
Text9.Text = "0"
Adodc1.Refresh
Dim j
Dim k
Dim l
Dim m
Dim n
Dim o
Dim p
Dim q
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bank.mdb;"
Adodc2.RecordSource = " select sum (b) as FldSUM from (Table1)"
Adodc2.Refresh
j = Adodc2.Recordset.Fields("FldSUM")
Adodc2.RecordSource = " select sum (c) as FldSUM2 from (Table1)"
Adodc2.Refresh
k = Adodc2.Recordset.Fields("FldSUM2")
Adodc2.RecordSource = " select sum (d) as FldSUM3 from (Table1)"
Adodc2.Refresh
l = Adodc2.Recordset.Fields("FldSUM3")
Adodc2.RecordSource = " select sum (e) as FldSUM4 from (Table1)"
Adodc2.Refresh
m = Adodc2.Recordset.Fields("FldSUM4")
Adodc2.RecordSource = " select sum (f) as FldSUM5 from (Table1)"
Adodc2.Refresh
n = Adodc2.Recordset.Fields("FldSUM5")
Adodc2.RecordSource = " select sum (g) as FldSUM6 from (Table1)"
Adodc2.Refresh
o = Adodc2.Recordset.Fields("FldSUM6")
Adodc2.RecordSource = " select sum (h) as FldSUM7 from (Table1)"
Adodc2.Refresh
p = Adodc2.Recordset.Fields("FldSUM7")
Adodc2.RecordSource = " select sum (i) as FldSUM8 from (Table1)"
Adodc2.Refresh
q = Adodc2.Recordset.Fields("FldSUM8")
Text10.Text = j
Text11.Text = k
Text12.Text = l
Text13.Text = m
Text14.Text = n
Text15.Text = o
Text16.Text = p
Text17.Text = q
Dim su
su = Txt.Text
su = su + 1
Txt.Text = su
If su >= 10 Then
Command1.Enabled = False
End If
End Sub
دکمه دوم هم کدش اینه
Private Sub Command5_Click()
Command1.Enabled = True
Dim sss
sss = Txt.Text
sss = sss - 1
Txt.Text = sss
On Error GoTo error:
Adodc1.Recordset.Delete
error:
err_hdl = Err.Number
If err_hdl = -2147467259 Then
Exit Sub
End If
End Sub
حالا وقثی دکمه دوم زده میشه و یک رکورد پاک میشه و بعدش میخوایم به جای رکورد پاک شده یک رکورد جدید وارد کنیم و دکمه اول رو برای این کار میزنیم کل رکورد های جدول پاک میشه و فقط اون رکوردی که آخر کار و بعد از زدن دکمه دوم زده شده به جدول میاد
اینم سورس برنامه لطفا کمکم کنید
من تو برنامه زیر دوتا دکمه دارم :
دکمه اولی یا command1برای وارد کردن اطلاعات به بانک اکسس هست کدش هم اینه
Private Sub Command1_Click()
Set DataGrid1.DataSource = Adodc1
Text4.Text = Text2.Text * Text3.Text
Text6.Text = Val(Text4.Text) + Val(Text5.Text)
Text8.Text = Text7.Text * Text2.Text
Text9.Text = Text8.Text - Text6.Text
Dim a
Dim b
Dim c
Dim d
Dim e
Dim f
Dim g
Dim h
Dim i
a = Text1.Text
b = Text2.Text
c = Text3.Text
d = Text4.Text
e = Text5.Text
f = Text6.Text
g = Text7.Text
h = Text8.Text
i = Text9.Text
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bank.mdb;Persist Security Info=False"
'connect as client
Adodc1.CursorLocation = adUseClient
'select the table to use
'SQL command
Adodc1.RecordSource = "Select * from Table1"
Adodc1.Refresh
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("a") = a
Adodc1.Recordset.Fields("b") = b
Adodc1.Recordset.Fields("c") = c
Adodc1.Recordset.Fields("d") = d
Adodc1.Recordset.Fields("e") = e
Adodc1.Recordset.Fields("f") = f
Adodc1.Recordset.Fields("g") = g
Adodc1.Recordset.Fields("h") = h
Adodc1.Recordset.Fields("i") = i
Adodc1.Recordset.Update
Adodc1.Refresh
Text1.Text = "0"
Text2.Text = "0"
Text3.Text = "0"
Text4.Text = "0"
Text5.Text = "0"
Text6.Text = "0"
Text7.Text = "0"
Text8.Text = "0"
Text9.Text = "0"
Adodc1.Refresh
Dim j
Dim k
Dim l
Dim m
Dim n
Dim o
Dim p
Dim q
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bank.mdb;"
Adodc2.RecordSource = " select sum (b) as FldSUM from (Table1)"
Adodc2.Refresh
j = Adodc2.Recordset.Fields("FldSUM")
Adodc2.RecordSource = " select sum (c) as FldSUM2 from (Table1)"
Adodc2.Refresh
k = Adodc2.Recordset.Fields("FldSUM2")
Adodc2.RecordSource = " select sum (d) as FldSUM3 from (Table1)"
Adodc2.Refresh
l = Adodc2.Recordset.Fields("FldSUM3")
Adodc2.RecordSource = " select sum (e) as FldSUM4 from (Table1)"
Adodc2.Refresh
m = Adodc2.Recordset.Fields("FldSUM4")
Adodc2.RecordSource = " select sum (f) as FldSUM5 from (Table1)"
Adodc2.Refresh
n = Adodc2.Recordset.Fields("FldSUM5")
Adodc2.RecordSource = " select sum (g) as FldSUM6 from (Table1)"
Adodc2.Refresh
o = Adodc2.Recordset.Fields("FldSUM6")
Adodc2.RecordSource = " select sum (h) as FldSUM7 from (Table1)"
Adodc2.Refresh
p = Adodc2.Recordset.Fields("FldSUM7")
Adodc2.RecordSource = " select sum (i) as FldSUM8 from (Table1)"
Adodc2.Refresh
q = Adodc2.Recordset.Fields("FldSUM8")
Text10.Text = j
Text11.Text = k
Text12.Text = l
Text13.Text = m
Text14.Text = n
Text15.Text = o
Text16.Text = p
Text17.Text = q
Dim su
su = Txt.Text
su = su + 1
Txt.Text = su
If su >= 10 Then
Command1.Enabled = False
End If
End Sub
دکمه دوم هم کدش اینه
Private Sub Command5_Click()
Command1.Enabled = True
Dim sss
sss = Txt.Text
sss = sss - 1
Txt.Text = sss
On Error GoTo error:
Adodc1.Recordset.Delete
error:
err_hdl = Err.Number
If err_hdl = -2147467259 Then
Exit Sub
End If
End Sub
حالا وقثی دکمه دوم زده میشه و یک رکورد پاک میشه و بعدش میخوایم به جای رکورد پاک شده یک رکورد جدید وارد کنیم و دکمه اول رو برای این کار میزنیم کل رکورد های جدول پاک میشه و فقط اون رکوردی که آخر کار و بعد از زدن دکمه دوم زده شده به جدول میاد
اینم سورس برنامه لطفا کمکم کنید