Dim Cn As New Connection '声明一个连接
Dim Rs As New Recordset '声明一个记录集
Private Sub Form_Load()
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\数据库\数据库.mdb;Persist Security Info=False"
Set Rs = NothingRs.Open "select distinct 发货打印日期 from sjk", Cn, adOpenKeyset, adLockOptimisticDo While Rs.EOF = FalseCombo1.AddItem Rs.Fields("发货打印日期")Rs.MoveNextLoop
End Sub
这代码有问题 高手帮看看呗!
Dim Rs As New Recordset '声明一个记录集
Private Sub Form_Load()
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\数据库\数据库.mdb;Persist Security Info=False"
Set Rs = NothingRs.Open "select distinct 发货打印日期 from sjk", Cn, adOpenKeyset, adLockOptimisticDo While Rs.EOF = FalseCombo1.AddItem Rs.Fields("发货打印日期")Rs.MoveNextLoop
End Sub
这代码有问题 高手帮看看呗!
dim RS As ADODB.Recordset 'ADO数据记录集变量
Set CN = New ADODB.Connection
Set RS = New ADODB.Recordset
无效使用 NULL
出现了这个啊 ,这是怎么回事呢??
Dim Cn As New Connection '声明一个连接
Dim Rs As New Recordset '声明一个记录集
Private Sub Form_Load()
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\数据库\数据库.mdb;Persist Security Info=False"
'Set Rs = Nothing'去掉 Rs.Open "select distinct 发货打印日期 from sjk", Cn, adOpenKeyset, adLockOptimistic Do While Rs.EOF = False Combo1.AddItem Rs.Fields("发货打印日期") Rs.MoveNext Loop
End Sub
Dim Cn As New ADODB.Connection '声明一个连接 !!!!!!!!!
Dim Rs As New ADODB.Recordset '声明一个记录集
Private Sub Form_Load()
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\数据库\数据库.mdb;Persist Security Info=False"
'Set Rs = Nothing'去掉 Rs.Open "select distinct 发货打印日期 from sjk", Cn, adOpenKeyset, adLockOptimistic Do While Rs.EOF = False Combo1.AddItem Rs.Fields("发货打印日期") Rs.MoveNext Loop
End SubEnd Sub