frmdeltab.frm

用户MODBUS规约通信编程,起参考作用.

VERSION 5.00
Object = "{D959C709-8613-11D1-9840-002078110E7D}#1.0#0"; "as97Popup.ocx"
Object = "{C7AE747C-B9E4-11D7-B0E3-D8165009166E}#7.0#0"; "XPForm.ocx"
Begin VB.Form frmdeltab 
   BorderStyle     =   0  'None
   Caption         =   "选择表清空"
   ClientHeight    =   3195
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   4680
   Icon            =   "frmdeltab.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   ShowInTaskbar   =   0   'False
   StartUpPosition =   3  '窗口缺省
   Begin VB.ComboBox Combo1 
      Height          =   300
      Left            =   2280
      TabIndex        =   0
      Top             =   720
      Width           =   1335
   End
   Begin as97Popup.asPopup asPopup2 
      Height          =   375
      Left            =   2400
      Top             =   2280
      Width           =   1215
      _ExtentX        =   2143
      _ExtentY        =   661
      Caption         =   "退出"
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ScaleWidth      =   81
      ScaleMode       =   0
      ScaleHeight     =   25
   End
   Begin as97Popup.asPopup asPopup1 
      Height          =   375
      Left            =   1080
      Top             =   2280
      Width           =   975
      _ExtentX        =   1720
      _ExtentY        =   661
      Caption         =   "确定"
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ScaleWidth      =   65
      ScaleMode       =   0
      ScaleHeight     =   25
   End
   Begin XP窗体控件.XPForm XPForm1 
      Height          =   810
      Left            =   1920
      Top             =   600
      Width           =   2535
      _ExtentX        =   4471
      _ExtentY        =   1429
      Caption         =   "选择表清空"
      Icon            =   "frmdeltab.frx":0CCA
      AlwaysOnTop     =   0   'False
      ShowFormSize    =   0   'False
   End
   Begin VB.Label Label1 
      Caption         =   "选择表"
      Height          =   255
      Left            =   1080
      TabIndex        =   1
      Top             =   840
      Width           =   615
   End
End
Attribute VB_Name = "frmdeltab"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub asPopup1_Click(Cancel As Boolean)
On Error GoTo my_error:
 s = MsgBox("确认清空以前的数据记录！", vbYesNo + vbQuestion, "确认")
 If s = vbYes Then
 Dim db2 As Connection
 Set db2 = New Connection
 db2.CursorLocation = adUseClient
 db2.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & fullpath("jk.mdb")
 
 If Combo1.Text = "棒号设置表" Then
 string1 = "delete from 棒号设置表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "地点设置表" Then
 string1 = "delete from 地点设置表"
 db2.Execute string1

 End If
If Combo1.Text = "计划次数表" Then
 string1 = "delete from 计划次数表"
 db2.Execute string1

 End If
 
 
 
 If Combo1.Text = "读入表" Then
 string1 = "delete from 读入表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "巡检结果表" Then
 string1 = "delete from 巡检结果表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "密码表" Then
 string1 = "delete from 密码表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "人员设置表" Then
 string1 = "delete from 人员设置表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "事件设置表" Then
 string1 = "delete from 事件设置表"
 db2.Execute string1

 End If
 
 If Combo1.Text = "计划设置表" Then
 string1 = "delete from 计划设置表"
 db2.Execute string1

 End If
 
 frmmsg.msg.MsgChar = "数据记录清空成功!"
 frmmsg.Show
 End If
  
Exit Sub

my_error:
   frmmsg.msg.MsgChar = Err.Description
  frmmsg.Show
End Sub

Private Sub asPopup2_Click(Cancel As Boolean)
Unload Me

End Sub

Private Sub Form_Load()
XPForm1.Make

Combo1.AddItem "棒号设置表"
Combo1.AddItem "地点设置表"
Combo1.AddItem "人员设置表"
Combo1.AddItem "事件设置表"
Combo1.AddItem "计划设置表"
Combo1.AddItem "计划次数表"
Combo1.AddItem "巡检结果表"
Combo1.AddItem "密码表"




End Sub