关于vb模块函数的调用,请高手解答
请看看以下导出文本文件的模块函数,我应该怎么在按钮点击事件中实现调用。
Option Explicit
Public Function TabintoTxt(objConn As Object, TableName As String, Optional TextFileName As String)
Dim rs As New ADODB.Recordset
Set rs = New ADODB.Recordset
Dim i As Long
Dim WritStr As String
Dim Fid As Long
Dim lngCount As Long ' 计数。
If TextFileName = "" Then TextFileName = App.Path & "\" & TableName & ".txt"
If objConn.State = 0 Then objConn.Open
rs.Open "select * from " + TableName, objConn
Fid = FreeFile
rs.MoveFirst
Open TextFileName For Output As #Fid
WritStr = ""
For i = 0 To rs.Fields.Count - 1
WritStr = WritStr & "" & rs.Fields(i).Name & ","
Next
Prin
相关问答:
我有厂家做的ASP的监控录像(DVR)的局域网播放的源程序与控件,想要用ASP.net做一个视频回放的程序(利用他的控件)但不知如下去做,望各位指点。
先搞清楚他们的控件是怎么用的,
然后就直接用好了.
不过,如 ......
Printer.ScaleMode = 6
6表示毫米
Printer.PaperSize = vbPRPSA4
'初始坐标
x = 1
y = 4
'最大的线筐
Printer.DrawStyle = 0
Printer.Line (x, y)-(x + 132.5, y) ......
form1 中,我在Text1里输入1111111111
Dim str1 As String
Private Sub Command1_Click()
str1 = Me.Text1.Text
Combo1.AddItem str1
End Sub
点Command1,就写到Combo1的 下拉菜单里去了 ......
从网页通过inet控件的Inet1.GetChunk读取其代码,然后想转换为汉字,转换代码如下
Private Sub Inet1_StateChanged(ByVal State As Integer)
Dim strRecText As String
Dim st ......
要采集的页面:http://city.qzone.qq.com/html/user/searchpro.htm#mod=0&act=city&cd=120000&pg=1
我想把搜索出来的QQ都采集出来,该怎么做。看了下代码好像不是普通的那种,网址里把1改成2没用 ......