我想请问一下这个模块为什么会出错?
错误提示为
此句Public Function TransactSQL(ByVal sql As String) As ADODB.Recordset
用户定义类型未定义完整代码如下:Public gUserName As String '保存用户名称
Public flag As Integer '添加和修改的标志
Public gSQL As String '保存SQL语句
Public kqsql As String '保存查询考勤结果SQL语句
Public kqsql2 As String '保存查询其他考勤结果SQL语句
Public ArecordID As Integer '保存上下班记录编号
Public LrecordID As Integer '保存请假记录编号
Public OrecordID As Integer '保存加班记录编号
Public ErecordID As Integer '保存出差记录编号
Public iflag As Integer '数据库是否打开标志
Public Function TransactSQL(ByVal sql As String) As ADODB.Recordset
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strConnection As String
Dim strArray() As String
Set con = New ADODB.Connection '创建连接
Set rs = New ADODB.Recordset '创建记录集
On Error GoTo TransactSQL_Error
strConnection = "Provider=Microsoft.jet.oledb.4.0;Data Source=" & App.Path & "\Person.mdb"
strArray = Split(sql)
con.Open strConnection '打开连接
If StrComp(UCase$(strArray(0)), "select", vbTextCompare) = 0 Then
rs.Open Trim$(sql), con, adOpenKeyset, adLockOptimistic
Set TransactSQL = rs '返回记录集
iflag = 1
Else
con.Execute sql '执行命令
iflag = 1
End If
TransactSQL_Exit:
Set rs = Nothing
Set con = Nothing
Exit Function
TransactSQL_Error:
MsgBox "查询错误:" & Err.Description
iflag = 2
Resume TransactSQL_Exit
End FunctionPublic Sub TabToEnter(Key As Integer)
If Key = 13 Then '判断是否为回车键
SendKeys "{TAB}" '转换为Tab键
End If
End SubSub main()
Dim fLogin As New frmLogin
fLogin.Show vbModual '显示窗体
End Sub在线等答案 希望回答的朋友能一直关注本贴
错误提示为
此句Public Function TransactSQL(ByVal sql As String) As ADODB.Recordset
用户定义类型未定义完整代码如下:Public gUserName As String '保存用户名称
Public flag As Integer '添加和修改的标志
Public gSQL As String '保存SQL语句
Public kqsql As String '保存查询考勤结果SQL语句
Public kqsql2 As String '保存查询其他考勤结果SQL语句
Public ArecordID As Integer '保存上下班记录编号
Public LrecordID As Integer '保存请假记录编号
Public OrecordID As Integer '保存加班记录编号
Public ErecordID As Integer '保存出差记录编号
Public iflag As Integer '数据库是否打开标志
Public Function TransactSQL(ByVal sql As String) As ADODB.Recordset
Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strConnection As String
Dim strArray() As String
Set con = New ADODB.Connection '创建连接
Set rs = New ADODB.Recordset '创建记录集
On Error GoTo TransactSQL_Error
strConnection = "Provider=Microsoft.jet.oledb.4.0;Data Source=" & App.Path & "\Person.mdb"
strArray = Split(sql)
con.Open strConnection '打开连接
If StrComp(UCase$(strArray(0)), "select", vbTextCompare) = 0 Then
rs.Open Trim$(sql), con, adOpenKeyset, adLockOptimistic
Set TransactSQL = rs '返回记录集
iflag = 1
Else
con.Execute sql '执行命令
iflag = 1
End If
TransactSQL_Exit:
Set rs = Nothing
Set con = Nothing
Exit Function
TransactSQL_Error:
MsgBox "查询错误:" & Err.Description
iflag = 2
Resume TransactSQL_Exit
End FunctionPublic Sub TabToEnter(Key As Integer)
If Key = 13 Then '判断是否为回车键
SendKeys "{TAB}" '转换为Tab键
End If
End SubSub main()
Dim fLogin As New frmLogin
fLogin.Show vbModual '显示窗体
End Sub在线等答案 希望回答的朋友能一直关注本贴
解决方案 »
- vb listview控件 的 一个 问题 ?
- DLL的问题
- 【CSDN】【散分问题,请问如何判断树型节点是未结点,如何取得此结点的层次数,如何依次取得此结点所在路径的所有结贴名称】
- 记得有些开发人员平时可以上网,但不能使用QQ,是这么回事吗?我两了解开发人员的网络环境,决心给大家造福啊。
- 那一种编程语言快?
- 哪里有文本比对的VB控件或dll或exe或源码?
- VB怎么读取其它程序(EXE)的数据
- printer对象的问题(在线等待.....)
- 谁有酒店管理的类似程序代码,课程设计用,谢谢啊~
- vb可以编dos下用的程序吗?
- OLEDragDrop问题
- 100 分提問關於VB的Resource File (資源文件)
Sub main()
Dim fLogin As New frmLogin
fLogin.Show vbModual '显示窗体
End Sub
------------------------------------------------ Dim fLogin As New frmLogin 用户定义类型未定义
Sub main()
Dim frm As Form
set frm=New frmLogin
frm.show 1
End Sub
方法为:工程--引用--Microsoft ActiveX Data Objects XX
如果还不明白就问,我会关注此贴的:)