1. Dim Filter As String With e.Form.Controls("输入查询姓名") If .Value IsNot Nothing Then Filter = "姓名 = '" & .Value & "'" End If End With If Filter > "" Then Tables("人事工资管理").Filter = Filter End If 数据转出时是很快的,没必要用进度条,提示是可以的
5楼
smileboy 发表于:2009/7/16 12:30:00
Dim ck As WinForm.TextBox = e.Form.Controls("输入查询姓名") With CurrentTable Dim r As Integer r = .FindRow("[姓名] = '" & ck.value & "'",0, True ) '从当前行开始查找 If r >= 0 Then '如果找到的话 .Position = r '定位到找到的行. Else MessageBox.Show("没有!", "提示") End If End With