mod1.bas

这是个库存管理系统

Attribute VB_Name = "Mod1"
Public adoCon As New ADODB.Connection      '定义一个数据连接
Public adoRs As New ADODB.Recordset        '定义一个数据集对象
Public adoRs1 As New ADODB.Recordset        '定义一个数据集对象

Public Name1 As String
Public StrNums As Integer
Public Temps    '定义一个变体类型的公共变量
'声明一个API函数，用于实现使窗体置前还是取消窗体置前的功能
Public Declare Function SetWindowPos Lib "user32" (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal x As Long, ByVal y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long) As Long
Public rtn
Public TWidth As Long
Public THeigth As Long

Public Sub main()            '定义一个公共主函数，用于连接数据库
Dim temp As String
temp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db_kcgl.mdb;Persist Security Info=False"
adoCon.Open (temp)
End Sub
Public Sub WHScreen()     '获得屏幕分辨率
   TWidth = Screen.Width \ Screen.TwipsPerPixelX
   THeigth = Screen.Height \ Screen.TwipsPerPixelY
End Sub