module1.bas

针对我国目前企事业单位的不断增多,工会部门也相应的越来越多,而工会人员信息管理则变得越来越繁琐。由于需要统计大量的数据

Attribute VB_Name = "Module1"
Public UserName As String '记住登录用户
Public Identify As Integer '记录用户类型
'该函数用来将操作内容写入日志表中
Public Function LogPlug(ByVal txtObject As String, txtAction As String)
    Dim Sc As String
    Sc = "driver={Microsoft Access Driver (*.mdb)};dbq=" & App.Path & "\tradeunion.mdb"
    Set cn = New ADODB.Connection
    cn.Open Sc
        Dim OneQuerySql As String
        OneQuerySql = "select* from 日志表"
        Dim AdoRsTradeMem As New ADODB.Recordset
        If AdoRsTradeMem.State = adStateOpen Then
            AdoRsTradeMem.Close
        End If
    AdoRsTradeMem.Open OneQuerySql, cn, adOpenKeyset, adLockOptimistic
    AdoRsTradeMem.AddNew
    AdoRsTradeMem.Fields(0) = Format(Now, "YY-MM-DD hh:mm:ss")
    AdoRsTradeMem.Fields(1) = UserName
    AdoRsTradeMem.Fields(2) = txtObject
    AdoRsTradeMem.Fields(3) = txtAction

  
End Function

'该函数用来检查文本框输入的内容是否为空，后面的程序经常要使用所以定义在此
Public Function Testtxt(txt As String) As Boolean
    If Trim(txt) = "" Then
        Testtxt = False
    Else
        Testtxt = True
    End If
End Function