1,216
社区成员
发帖
与我相关
我的任务
分享
Dim fileno As Integer
ReT.Open "select * from file_Info order by 文档编号 asc", Con, adOpenKeyset, adLockBatchOptimistic
Dim min As Integer
Dim max As Integer
ReT.MoveFirst
min = Val(ReT.Fields("文档编号"))
ReT.MoveLast
max = Val(ReT.Fields("文档编号"))
fileno = InputBox("请输入要查询的文档编号:" & Chr(13) & "请注意输入的数字比如在" & min & "-" & max & "之间!", "查询")
If Not ReT.BOF And Not ReT.EOF Then
ReT.Find "文档编号=" & fileno
MsgBox ReT.Fields("文档编号")
End If
Fill '此为将查询的结果的各个列分别填入文本框中
ReT.Close