急,在线等! 提示BOF 或 EOF 中有一个是“真”,或者当前的记录已被删除,所需的操作要求一个当前的记录。是怎么回事啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Private Sub Command2_Click()With Adodc1.Recordset .Update .Fields(0) = Text1.Text .Fields(1) = Text2.Text .Fields(2) = Text3.Text .Fields(3) = Text4.Text .Fields(4) = Text5.Text .Fields(5) = .Fields(5) + Text6.Text .Fields(6) = Text7.Text .UpdateEnd WithAdodc1.RefreshDataGrid1.RefreshAdodc1.RefreshDataGrid1.RefreshAdodc1.Recordset.MoveFirstWith Adodc2.Recordset .AddNew .Fields(0) = Text1.Text .Fields(1) = Text2.Text .Fields(2) = Text3.Text .Fields(3) = Text4.Text .Fields(4) = Text5.Text .Fields(5) = Text6.Text .Fields(6) = .Fields(3) * .Fields(5) .Fields(7) = Text7.Text .Fields(8) = Date .UpdateEnd WithAdodc2.RefreshAdodc2.Recordset.MoveFirstText1.Text = ""Text2.Text = ""Text3.Text = ""Text4.Text = ""Text5.Text = ""Text6.Text = ""Text7.Text = ""End SubPrivate Sub Command4_Click() If Text1.Text = "" Then MsgBox "药品编号不能为空!" End If With Adodc1.Recordset .AddNew .Fields(0) = Text1.Text .Fields(1) = Text2.Text .Fields(2) = Text3.Text .Fields(3) = Text4.Text .Fields(4) = Text5.Text .Fields(5) = Val(Text6.Text) .Fields(6) = Text7.Text .Update End With Adodc1.Refresh DataGrid1.Refresh Adodc1.Refresh DataGrid1.Refresh Adodc1.Recordset.MoveFirst With Adodc2.Recordset .AddNew .Fields(0) = Text1.Text .Fields(1) = Text2.Text .Fields(2) = Text3.Text .Fields(3) = Text4.Text .Fields(4) = Text5.Text .Fields(5) = Text6.Text .Fields(6) = .Fields(3) * .Fields(5) .Fields(7) = Text7.Text .Fields(8) = Date .UpdateEnd WithAdodc2.RefreshAdodc2.Recordset.MoveFirstText1.Text = ""Text2.Text = ""Text3.Text = ""Text4.Text = ""Text5.Text = ""Text6.Text = ""Text7.Text = ""Adodc1.RecordSource = "药品信息表 order by 编号" End SubPrivate Sub Command5_Click()Unload MeEnd SubPrivate Sub Command3_Click()If Not (Adodc1.Recordset.BOF Or Adodc1.Recordset.EOF) Then sc = MsgBox("确定删除该数据吗?", vbOKCancel) If sc = 1 Then Adodc1.Recordset.Delete Text1.Text = "" Text2.Text = "" Text3.Text = "" Text4.Text = "" Text5.Text = "" Text6.Text = "" Text7.Text = "" Adodc1.Recordset.MoveFirst End If Else MsgBox " 记录集中没有数据!"End IfAdodc1.RefreshDataGrid1.RefreshAdodc1.RefreshDataGrid1.RefreshEnd SubPrivate Sub DataGrid1_Click()Text1.Text = Adodc1.Recordset.Fields("编号")Text2.Text = Adodc1.Recordset.Fields("名称")Text3.Text = Adodc1.Recordset.Fields("类别")Text4.Text = Adodc1.Recordset.Fields("单价")Text5.Text = Adodc1.Recordset.Fields("售价")Text6.Text = Adodc1.Recordset.Fields("数量")Text7.Text = Adodc1.Recordset.Fields("供应商")End SubPrivate Sub Form_Load()Adodc1.Visible = False'Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\毕业设计\likangyaodian.mdb;Persist Security Info=False"Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\likangyaodian.mdb"Adodc1.RecordSource = "药品信息表 order by 编号"Adodc1.RefreshAdodc2.Visible = False'Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\毕业设计\likangyaodian.mdb;Persist Security Info=False"Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\likangyaodian.mdb"Adodc2.RecordSource = "入库明细表 "Adodc2.RefreshSet DataGrid1.DataSource = Adodc1DataGrid1.AllowAddNew = FalseDataGrid1.AllowUpdate = FalseDataGrid1.AllowDelete = FalseText1.Text = ""Text2.Text = ""Text3.Text = ""Text4.Text = ""Text5.Text = ""Text6.Text = ""Text7.Text = ""End SubPrivate Sub Form_Activate()Adodc1.RefreshDataGrid1.RefreshMe.RefreshAdodc2.RefreshEnd SubPrivate Sub Text1_LostFocus()Adodc1.Recordset.Find "编号='" & Text1.Text & "'"If Adodc1.Recordset.EOF = False ThenText1.Text = Adodc1.Recordset.Fields("编号")Text2.Text = Adodc1.Recordset.Fields("名称")Text3.Text = Adodc1.Recordset.Fields("类别")Text4.Text = Adodc1.Recordset.Fields("单价")Text5.Text = Adodc1.Recordset.Fields("售价")Text6.Text = Adodc1.Recordset.Fields("数量")Text7.Text = Adodc1.Recordset.Fields("供应商")End IfEnd Sub Adodc1.RecordSource = "select * from 药品信息表 order by 编号" 你应该检查下哪处错了 假如我想让文本框一变化,datagrid控件的指针就指向文本框中输入的值的那条记录,该怎么写代码??? vb 打开多个窗体,在任务栏显示的问题 求教 vb 的窜口通信问题 哪位高手可以提供一个VSFlexGrid和VSPrint的例子?数据库是SQL SERVER或者ACCESS都可以 各大高手,关于VB中一简单的问题! 请教Activebar和FRoomView控件的使用方法? 如何配置DCOM? 怪事,为什么用下面这段代码压缩数据库会这样报错.欢迎大家探讨 VB中异步的问题,如果中止异步和异步出错时怎样处理。 GB2312编码如何转换到中文字符串? 我是一个超级莱鸟,问一个超级莱鸟题 急,在线等! linpansheng 请回复
With Adodc1.Recordset
.Update
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
.Fields(2) = Text3.Text
.Fields(3) = Text4.Text
.Fields(4) = Text5.Text
.Fields(5) = .Fields(5) + Text6.Text
.Fields(6) = Text7.Text
.Update
End With
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Recordset.MoveFirst
With Adodc2.Recordset
.AddNew
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
.Fields(2) = Text3.Text
.Fields(3) = Text4.Text
.Fields(4) = Text5.Text
.Fields(5) = Text6.Text
.Fields(6) = .Fields(3) * .Fields(5)
.Fields(7) = Text7.Text
.Fields(8) = Date
.Update
End With
Adodc2.Refresh
Adodc2.Recordset.MoveFirst
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
End Sub
Private Sub Command4_Click()
If Text1.Text = "" Then
MsgBox "药品编号不能为空!"
End If
With Adodc1.Recordset
.AddNew
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
.Fields(2) = Text3.Text
.Fields(3) = Text4.Text
.Fields(4) = Text5.Text
.Fields(5) = Val(Text6.Text)
.Fields(6) = Text7.Text
.Update
End With
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Recordset.MoveFirst
With Adodc2.Recordset
.AddNew
.Fields(0) = Text1.Text
.Fields(1) = Text2.Text
.Fields(2) = Text3.Text
.Fields(3) = Text4.Text
.Fields(4) = Text5.Text
.Fields(5) = Text6.Text
.Fields(6) = .Fields(3) * .Fields(5)
.Fields(7) = Text7.Text
.Fields(8) = Date
.Update
End With
Adodc2.Refresh
Adodc2.Recordset.MoveFirst
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Adodc1.RecordSource = "药品信息表 order by 编号" End SubPrivate Sub Command5_Click()
Unload Me
End Sub
Private Sub Command3_Click()
If Not (Adodc1.Recordset.BOF Or Adodc1.Recordset.EOF) Then
sc = MsgBox("确定删除该数据吗?", vbOKCancel)
If sc = 1 Then
Adodc1.Recordset.Delete
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Adodc1.Recordset.MoveFirst
End If
Else
MsgBox " 记录集中没有数据!"
End If
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Refresh
DataGrid1.Refresh
End Sub
Private Sub DataGrid1_Click()
Text1.Text = Adodc1.Recordset.Fields("编号")
Text2.Text = Adodc1.Recordset.Fields("名称")
Text3.Text = Adodc1.Recordset.Fields("类别")
Text4.Text = Adodc1.Recordset.Fields("单价")
Text5.Text = Adodc1.Recordset.Fields("售价")
Text6.Text = Adodc1.Recordset.Fields("数量")
Text7.Text = Adodc1.Recordset.Fields("供应商")
End Sub
Private Sub Form_Load()
Adodc1.Visible = False
'Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\毕业设计\likangyaodian.mdb;Persist Security Info=False"
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\likangyaodian.mdb"
Adodc1.RecordSource = "药品信息表 order by 编号"
Adodc1.Refresh
Adodc2.Visible = False
'Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\毕业设计\likangyaodian.mdb;Persist Security Info=False"
Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\likangyaodian.mdb"
Adodc2.RecordSource = "入库明细表 "
Adodc2.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.AllowAddNew = False
DataGrid1.AllowUpdate = False
DataGrid1.AllowDelete = False
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
End Sub
Private Sub Form_Activate()
Adodc1.Refresh
DataGrid1.Refresh
Me.Refresh
Adodc2.Refresh
End Sub
Private Sub Text1_LostFocus()
Adodc1.Recordset.Find "编号='" & Text1.Text & "'"
If Adodc1.Recordset.EOF = False Then
Text1.Text = Adodc1.Recordset.Fields("编号")
Text2.Text = Adodc1.Recordset.Fields("名称")
Text3.Text = Adodc1.Recordset.Fields("类别")
Text4.Text = Adodc1.Recordset.Fields("单价")
Text5.Text = Adodc1.Recordset.Fields("售价")
Text6.Text = Adodc1.Recordset.Fields("数量")
Text7.Text = Adodc1.Recordset.Fields("供应商")
End If
End Sub