module1.bas

来自「这是一个仓库管理系统做不全」· BAS 代码 · 共 26 行

Attribute VB_Name = "Module1"
Public h As Integer
Public Sub lian(str As String, cn, rs)
Set cn = New Connection
With cn
  .Provider = "sqloledb"
  .ConnectionString = "user id=sa;pwd=123;data source=(local);initial catalog=skcgl"
  .Open
  End With
Set rs = New Recordset
With rs
Set .ActiveConnection = cn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.Open str, cn, adOpenKeyset, adUseClient
End With
End Sub
Public Sub sh()
Unload Form2
Unload Form3
Unload Form4
Unload Form5
Unload Form6
Unload Form7
End Sub