📄 del.frm
字号:
VERSION 5.00
Begin VB.Form Form15
BorderStyle = 1 'Fixed Single
Caption = " 清空数据库"
ClientHeight = 2505
ClientLeft = 4185
ClientTop = 3180
ClientWidth = 4020
Icon = "del.frx":0000
LinkTopic = "Form15"
MaxButton = 0 'False
Picture = "del.frx":0442
ScaleHeight = 2505
ScaleWidth = 4020
Begin VB.Data Data2
Caption = "Data2"
Connect = "Access"
DatabaseName = "C:\人事管理系统\data\rsda.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 0
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "gzb"
Top = 2160
Visible = 0 'False
Width = 1215
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "C:\人事管理系统\data\rsda.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 0
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "rsda"
Top = 1920
Visible = 0 'False
Width = 1215
End
Begin VB.Timer Timer1
Left = 1800
Top = 0
End
Begin VB.CommandButton Command2
Height = 495
Left = 2400
Picture = "del.frx":2473
Style = 1 'Graphical
TabIndex = 3
Top = 360
Width = 1095
End
Begin VB.CommandButton Command1
DisabledPicture = "del.frx":4741
Height = 495
Left = 600
Picture = "del.frx":6DE7
Style = 1 'Graphical
TabIndex = 2
Top = 360
Width = 1095
End
Begin VB.Image Image25
Height = 195
Left = 0
Picture = "del.frx":948D
Stretch = -1 'True
Top = 2280
Visible = 0 'False
Width = 90
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = " 0%"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000E&
Height = 375
Left = 120
TabIndex = 4
Top = 1200
Width = 615
End
Begin VB.Image Image24
Height = 195
Left = 3360
Picture = "del.frx":9A4F
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image23
Height = 195
Left = 3240
Picture = "del.frx":A011
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image22
Height = 195
Left = 3120
Picture = "del.frx":A5D3
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image21
Height = 195
Left = 3000
Picture = "del.frx":AB95
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image20
Height = 195
Left = 2880
Picture = "del.frx":B157
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image19
Height = 195
Left = 2760
Picture = "del.frx":B719
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image18
Height = 195
Left = 2640
Picture = "del.frx":BCDB
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image17
Height = 195
Left = 2520
Picture = "del.frx":C29D
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image16
Height = 195
Left = 2400
Picture = "del.frx":C85F
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image15
Height = 195
Left = 2280
Picture = "del.frx":CE21
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image14
Height = 195
Left = 2160
Picture = "del.frx":D3E3
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image13
Height = 195
Left = 2040
Picture = "del.frx":D9A5
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image12
Height = 195
Left = 1920
Picture = "del.frx":DF67
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image11
Height = 195
Left = 1800
Picture = "del.frx":E529
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image10
Height = 195
Left = 1680
Picture = "del.frx":EAEB
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image9
Height = 195
Left = 1560
Picture = "del.frx":F0AD
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image8
Height = 195
Left = 1440
Picture = "del.frx":F66F
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image7
Height = 195
Left = 1320
Picture = "del.frx":FC31
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image6
Height = 195
Left = 1200
Picture = "del.frx":101F3
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image5
Height = 195
Left = 1080
Picture = "del.frx":107B5
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image4
Height = 195
Left = 960
Picture = "del.frx":10D77
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image3
Height = 195
Left = 840
Picture = "del.frx":11339
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image2
Height = 195
Left = 720
Picture = "del.frx":118FB
Stretch = -1 'True
Top = 1200
Width = 90
End
Begin VB.Image Image1
Height = 195
Left = 3720
Picture = "del.frx":11EBD
Stretch = -1 'True
Top = 1200
Visible = 0 'False
Width = 90
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = " 警告: 此操作将删除数据库中的所有纪录, 请慎重进行此操作,删除后纪录将不能恢复."
BeginProperty Font
Name = "楷体_GB2312"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000E&
Height = 495
Left = 120
TabIndex = 1
Top = 1920
Width = 4095
End
Begin VB.Label Label1
BackColor = &H80000009&
BorderStyle = 1 'Fixed Single
Height = 375
Left = 600
TabIndex = 0
Top = 1080
Width = 2955
End
End
Attribute VB_Name = "Form15"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim a As Integer, c As Integer, e As Double
Private Sub ima()
Image2.Picture = Image1.Picture
Image3.Picture = Image1.Picture
Image4.Picture = Image1.Picture
Image5.Picture = Image1.Picture
Image6.Picture = Image1.Picture
Image7.Picture = Image1.Picture
Image8.Picture = Image1.Picture
Image9.Picture = Image1.Picture
Image10.Picture = Image1.Picture
Image11.Picture = Image1.Picture
Image12.Picture = Image1.Picture
Image13.Picture = Image1.Picture
Image14.Picture = Image1.Picture
Image15.Picture = Image1.Picture
Image16.Picture = Image1.Picture
Image17.Picture = Image1.Picture
Image18.Picture = Image1.Picture
Image19.Picture = Image1.Picture
Image20.Picture = Image1.Picture
Image21.Picture = Image1.Picture
Image22.Picture = Image1.Picture
Image23.Picture = Image1.Picture
Image24.Picture = Image1.Picture
Command1.Enabled = False
MsgBox " 数据库以清空"
End Sub
Private Sub Command1_Click()
Form10.Hide
Form13.Hide
Timer1.Interval = 100
a = 2
c = Data1.Recordset.RecordCount
e = Fix(c / 25)
If c < 25 Then
e = 1
End If
End Sub
Private Sub Command2_Click()
Form2.Show
Unload Me
End Sub
Private Sub Form_Activate()
If Data1.Recordset.RecordCount = 0 Then
Command1.Enabled = False
Else
Command1.Enabled = True
Data1.Recordset.MoveLast
Data2.Recordset.MoveLast
Data1.Recordset.MoveFirst
Data2.Recordset.MoveFirst
End If
End Sub
Private Sub Form_Load()
Image2.Picture = Image25.Picture
Image3.Picture = Image25.Picture
Image4.Picture = Image25.Picture
Image5.Picture = Image25.Picture
Image6.Picture = Image25.Picture
Image7.Picture = Image25.Picture
Image8.Picture = Image25.Picture
Image9.Picture = Image25.Picture
Image10.Picture = Image25.Picture
Image11.Picture = Image25.Picture
Image12.Picture = Image25.Picture
Image13.Picture = Image25.Picture
Image14.Picture = Image25.Picture
Image15.Picture = Image25.Picture
Image16.Picture = Image25.Picture
Image17.Picture = Image25.Picture
Image18.Picture = Image25.Picture
Image19.Picture = Image25.Picture
Image20.Picture = Image25.Picture
Image21.Picture = Image25.Picture
Image22.Picture = Image25.Picture
Image23.Picture = Image25.Picture
Image24.Picture = Image25.Picture
a = 2
End Sub
Private Sub Timer1_Timer()
Dim q As Integer
q = 0
If a = 2 Then
Image2.Picture = Image1.Picture
Label3.Caption = " 4%"
Do Until q > e - 1
Data1.Recordset.MoveFirst
Data2.Recordset.MoveFirst
Data1.Recordset.Delete
Data2.Recordset.Delete
If Data1.Recordset.RecordCount = 0 Then
Call ima
Label3.Caption = "100%"
Timer1.Enabled = False
End If
q = q + 1
Loop
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -