📄 frmmainexe.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Begin VB.Form frmMainEXE
BorderStyle = 3 'Fixed Dialog
Caption = "金狼数据库(Access)"
ClientHeight = 6540
ClientLeft = 45
ClientTop = 330
ClientWidth = 8265
Icon = "frmMainEXE.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 6540
ScaleWidth = 8265
StartUpPosition = 2 'CenterScreen
Begin VB.CommandButton cmdSave
Caption = "保存(&S)"
Enabled = 0 'False
Height = 350
Left = 2700
TabIndex = 13
Top = 6090
Width = 1200
End
Begin VB.CommandButton cmdExit
Cancel = -1 'True
Caption = "关闭(&E)"
Height = 350
Left = 7005
TabIndex = 12
Top = 6090
Width = 1200
End
Begin VB.CommandButton cmdOpen
Caption = "打开(&O)"
Height = 350
Left = 60
TabIndex = 11
Top = 6090
Width = 1200
End
Begin VB.PictureBox picMain
AutoRedraw = -1 'True
BorderStyle = 0 'None
ClipControls = 0 'False
Height = 5895
Left = 60
ScaleHeight = 5895
ScaleWidth = 8145
TabIndex = 1
Top = 60
Width = 8145
Begin VB.PictureBox picSplit
Appearance = 0 'Flat
BackColor = &H00E0E0E0&
BorderStyle = 0 'None
ForeColor = &H80000008&
Height = 495
Left = 7620
ScaleHeight = 495
ScaleWidth = 495
TabIndex = 10
Top = 5370
Visible = 0 'False
Width = 495
End
Begin VB.PictureBox picDetails
AutoRedraw = -1 'True
ClipControls = 0 'False
Height = 2535
Left = 5760
ScaleHeight = 2475
ScaleWidth = 2235
TabIndex = 6
Top = 60
Width = 2295
Begin ComctlLib.ListView lvDetails
Height = 1455
Left = 0
TabIndex = 9
ToolTipText = "Details properties of individual items"
Top = 360
Width = 1935
_ExtentX = 3413
_ExtentY = 2566
View = 3
Arrange = 1
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
_Version = 327682
ForeColor = -2147483640
BackColor = -2147483643
Appearance = 0
NumItems = 2
BeginProperty ColumnHeader(1) {0713E8C7-850A-101B-AFC0-4210102A8DA7}
Key = ""
Object.Tag = ""
Text = "属性"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(2) {0713E8C7-850A-101B-AFC0-4210102A8DA7}
SubItemIndex = 1
Key = ""
Object.Tag = ""
Text = "说明"
Object.Width = 5292
EndProperty
End
Begin VB.PictureBox picDetailsBar
BackColor = &H00800000&
BorderStyle = 0 'None
Height = 255
Left = 0
ScaleHeight = 255
ScaleWidth = 1935
TabIndex = 7
Top = 0
Width = 1935
Begin VB.Label lblDetails
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000010&
BackStyle = 0 'Transparent
Caption = "信息"
ForeColor = &H8000000E&
Height = 195
Left = 120
TabIndex = 8
Top = 0
Width = 360
End
End
End
Begin VB.PictureBox picData
AutoRedraw = -1 'True
ClipControls = 0 'False
Height = 2535
Left = 0
ScaleHeight = 2475
ScaleWidth = 1995
TabIndex = 2
Top = 120
Width = 2055
Begin ComctlLib.TreeView tvwData
Height = 1455
Left = 30
TabIndex = 5
ToolTipText = "The layout of the Database"
Top = 870
Width = 1935
_ExtentX = 3413
_ExtentY = 2566
_Version = 327682
HideSelection = 0 'False
Indentation = 459
LabelEdit = 1
LineStyle = 1
Style = 7
Appearance = 0
End
Begin VB.PictureBox picDataBar
BackColor = &H00800000&
BorderStyle = 0 'None
Height = 255
Left = 0
ScaleHeight = 255
ScaleWidth = 1935
TabIndex = 3
Top = 0
Width = 1935
Begin VB.Label lblData
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000010&
BackStyle = 0 'Transparent
Caption = "数据库(Access)"
ForeColor = &H8000000E&
Height = 195
Left = 120
TabIndex = 4
Top = 0
Width = 1155
End
End
End
Begin VB.Image imgSplit
Height = 2535
Left = 3660
MousePointer = 9 'Size W E
Top = 0
Width = 60
End
End
Begin VB.CommandButton cmdCopy
Caption = "拷贝(&C)"
Enabled = 0 'False
Height = 350
Left = 1380
TabIndex = 0
Top = 6090
Width = 1200
End
Begin MSComDlg.CommonDialog cmData
Left = 4560
Top = 3960
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin ComctlLib.ImageList imlTree
Left = 5160
Top = 3840
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 8421376
_Version = 327682
BeginProperty Images {0713E8C2-850A-101B-AFC0-4210102A8DA7}
NumListImages = 6
BeginProperty ListImage1 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":014A
Key = "Field"
EndProperty
BeginProperty ListImage2 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":0324
Key = "dbOpen"
EndProperty
BeginProperty ListImage3 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":04FE
Key = "Index"
EndProperty
BeginProperty ListImage4 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":06D8
Key = "Relation"
EndProperty
BeginProperty ListImage5 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":08B2
Key = "Table"
EndProperty
BeginProperty ListImage6 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmMainEXE.frx":0A8C
Key = "Query"
EndProperty
EndProperty
End
End
Attribute VB_Name = "frmMainEXE"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
' ==============================================================
' Project: DatabaseCoder 1.3
' Type: Add-In
' Author: edward moth
' Copyright: 1999-2000 qbd software ltd
'
' FACTORS:
' Fun Factor: Nil
' Usefulness: Fair to Middling - Dull code automation
' CoolCode: Minimal to Non-existent although we like the
' Information_SQL routine - simple but effective
'
' What exactly does it do edward?
' Looks at an Access97 database, yawns for a second or two.
' Shows a pretty TreeView of the database structure and allows
' you to click on items and get the exciting (not) lowdown on
' them. Then it churns out dull code to create the database
' from scratch and either copies it to the clipboard or saves it
' as a standard module.
'
' See the README.TXT file under RELATED DOCUMENTS for further
' Information
'
' ==============================================================
' Module: frmMain
' Purpose: Front-end/Does the work
' ==============================================================
Option Explicit
Private Type qtSplitterMove
sLeft As Single
sRight As Single
bMove As Boolean
End Type
Private sText As String
Private sQuery As String
Private qSplit As qtSplitterMove ' Properties for the splitters
Private eWindowState As FormWindowStateConstants
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdCopy_Click()
On Error GoTo InsertErr
If qDB.Queries Then
Clipboard.SetText sText & sQuery, vbCFText
Else
Clipboard.SetText sText, vbCFText
End If
Exit Sub
InsertErr:
MsgBox "An error occured while trying to create code module." & vbCrLf & "Error: " & Err.Description
cmdCopy.Enabled = False
End Sub
Private Sub cmdOpen_Click()
Dim bProgress As Boolean
Information_Clear
bProgress = Database_Open
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -