Option ExplicitPublic StrConn As String
Public Sub RsCol_into_Dcb(StrTableName As String, StrColName As String, StrWhere As String, Dcb As DataCombo)Dim Conn As New ADODB.Connection
If Conn.State = 1 Then Conn.Close
Conn.Open StrConnDim Rs As New ADODB.Recordset
Rs.Open "select " & StrColName & " from " & StrTableName & " " & StrWhere, Conn
If Rs.EOF = False Then
Set Dcb.RowSource = Rs
Dcb.ListField = StrColName
End IfEnd Sub主要是说Dcb As DataCombo不是全局的,可是我就是想要这样的效果,如何写呢?
Public Sub RsCol_into_Dcb(StrTableName As String, StrColName As String, StrWhere As String, Dcb As DataCombo)Dim Conn As New ADODB.Connection
If Conn.State = 1 Then Conn.Close
Conn.Open StrConnDim Rs As New ADODB.Recordset
Rs.Open "select " & StrColName & " from " & StrTableName & " " & StrWhere, Conn
If Rs.EOF = False Then
Set Dcb.RowSource = Rs
Dcb.ListField = StrColName
End IfEnd Sub主要是说Dcb As DataCombo不是全局的,可是我就是想要这样的效果,如何写呢?
解决方案 »
- 怎样定义带后缀的动态数组
- 请问如何用SHELLEXECUTE的返回值来关闭由SHELLEXECUTE启动的程序?
- 简单问题
- 打包问题,在线等候!
- VB在oracle存取文档时报错“实时错误 -2147467259(80004005) 未指定的错误”
- 如何得到当前操作系统所在的硬盘分区(只需获得盘符就可以)
- 请问在MDI窗体中打开多个窗口,如何让其中的一个永远位于最低??
- 日期查询的问题。实在是简单,但对我这个初学者来说:难!
- 请问。。。。(困扰多年了。。帮帮忙吧)
- VB6支持Access2000吗?
- 建了一个最简单的库,执行:实时错误3001:参数类型不正确,或不在可以接受的范围之内,或与其它参数冲突!
- 如何访问加密的ACCESS数据库?
Dcb.ListField = StrColNamefrm1用你dcb所在的窗体名引入就ok了
可以就返回一个记录集啊在得到纪录以后,在设置datacombo 不是挺好的嘛