Public Type emptype
em_id As String
em_name As String
End Type
Dim employees As New Collection
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Public Sub openTable()
Dim employee As emptype
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "provider=sqloledb.1;data source=.;user id=sa;password=lide;initial catalog=northwind"
conn.Open
rs.Open "employees", conn, adOpenKeyset, adLockPessimistic For i = 1 To rs.RecordCount
employee.em_id = rs.Fields(0)
employee.em_name = rs.Fields(1)
employees.Add employee, employee.em_id
rs.MoveNext
Next
End Sub上面报错为“只有在公共模块中用户自定义数据类型才可以与变体类型转换”不过,我放在公共模块中仍不行,为什么?怎么做?
em_id As String
em_name As String
End Type
Dim employees As New Collection
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Public Sub openTable()
Dim employee As emptype
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "provider=sqloledb.1;data source=.;user id=sa;password=lide;initial catalog=northwind"
conn.Open
rs.Open "employees", conn, adOpenKeyset, adLockPessimistic For i = 1 To rs.RecordCount
employee.em_id = rs.Fields(0)
employee.em_name = rs.Fields(1)
employees.Add employee, employee.em_id
rs.MoveNext
Next
End Sub上面报错为“只有在公共模块中用户自定义数据类型才可以与变体类型转换”不过,我放在公共模块中仍不行,为什么?怎么做?
解决方案 »
- VBA里调MSComm
- filecopy 如何实现自动覆盖已有的文件呀?(默认是跳过呀)
- 请教各位大侠关于OLEDragDrop获取IE超级链接和文本的问题
- 如何利用api向其他窗口(程序)发送键盘消息?
- adodc1 怎么使用SQL语句命令,Update成批更新数据或成批删除数据.
- vb中如何抓违例?
- 请教:怎样才能取得一个“列表/菜单”框的值?
- Windows2000Professional支持VB6吗?
- 在工程浏览列表中有Project1(Project1),Form1(Form1),不知道()中的Project1,form1和前面的Project1,form1有什么区别,前面的可以该name属性,后面不知怎么改?
- 192分!急!急!急!能不能为RichTextBox加入背景图片,或将其背景设为透明。先谢了!
- 在RichTextBox中粘贴时,如果将图像和文本一齐粘贴到RTF中.
- 數據庫通配查詢﹐ 那位大哥回答一下
Public Type emptype
em_id As String
em_name As String
End Type
添加进去。
或者不添加模块,将它改为:
Private Type emptype
em_id As String
em_name As String
End Type
这样的话只能在当前窗体中使用
employees.Add employee.em_name, employee.em_id
2、我是要添加一个员工对象到集合中,不仅要有姓名,还要ID;
3、就算放在类模块中,问题仍是一样(当然这可以再做一个员工对象的类来解决,不过现在只想用自定义来做,MS的文档认为是行的)。请大家帮一下忙!!!