有会VB的吗下面是什么意思谁会解释一下

来源:百度知道 编辑:UC知道 时间:2024/06/14 02:03:28
Private Sub Command16_Click()
Dim i As Integer
Dim j As Integer
j = MaxID()
For i = 1 To j '13个变量的意思:
Dim AreaID As String
Dim area As String
Dim pc As Integer
Dim ProjID As String
Dim xmID As String
Dim Proj As String
Dim AgeID As Integer
'Dim Age As Integer
Dim AgeItem As String
Dim COMPID As String
Dim secID As String
Dim cn1 As Connection
Dim rs1 As New ADODB.Recordset
Dim sql1 As String
Set cn1 = CurrentProject.Connection
sql1 = "select ID,选手资料.选区,选手资料.专业,选手资料.组别 from 选手资料 where ID=" & Trim(i)
rs1.Open sql1, cn1, 3, 3, 1
area = rs1("选区")
Proj = rs1("专业")
AgeItem = rs1("组别")
rs1.Close

AreaID = DLookup("[选区ID]", "选区代码表", "[选区名称]='" & area & "'")
ProjI

简单来说吧。
1.就是定义变量
2.查找库资料,并且结果付值给定义的变量
3.根据变量进行判断处理,然后更新回库里面
不过更新语句应该有问题
DoCmd.RunSQL "Update 选手资料 SET 选手资料.组别代码=" & AgeID & " where 选手资料.ID = " & Trim(i)
应该写成这样才对
DoCmd.RunSQL "Update 选手资料 SET 选手资料.组别代码=" & AgeID & " where 选手资料.ID = " & Trim(i) & ""

这个是用VB编写的一个记录资料的程序` 当输入某个请求的时候` 会出现相应的资料`