📄 frmadddoctorvisits.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{935C9182-411B-4FFB-9512-97C8745743BC}#2.4#0"; "AResize.ocx"
Begin VB.Form frmAddDoctorVisits
BackColor = &H00FF8080&
Caption = "Visit Details"
ClientHeight = 9240
ClientLeft = 1275
ClientTop = 1455
ClientWidth = 8835
BeginProperty Font
Name = "Verdana"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Icon = "frmAddDoctorVisits.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 9240
ScaleWidth = 8835
WindowState = 2 'Maximized
Begin VB.Frame Frame1
BackColor = &H00FF8080&
Height = 7575
Left = 480
TabIndex = 31
Top = 840
Visible = 0 'False
Width = 7935
Begin VB.CommandButton cmdExit
BackColor = &H00FFFFFF&
Caption = "&Cancel"
Height = 975
Left = 4440
Picture = "frmAddDoctorVisits.frx":57E2
Style = 1 'Graphical
TabIndex = 34
Top = 6480
Width = 1095
End
Begin VB.CommandButton cmdOK
BackColor = &H00FFFFFF&
Caption = "&OK"
Height = 975
Left = 2760
Picture = "frmAddDoctorVisits.frx":5C2E
Style = 1 'Graphical
TabIndex = 33
Top = 6480
Width = 1095
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 5055
Left = 600
TabIndex = 32
Top = 600
Width = 7095
_ExtentX = 12515
_ExtentY = 8916
_Version = 393216
BackColorBkg = 12632256
AllowBigSelection= 0 'False
HighLight = 2
SelectionMode = 1
End
End
Begin VB.CommandButton cmdAdd
BackColor = &H00FFFFFF&
Caption = "&Add"
Height = 780
Left = 1680
Picture = "frmAddDoctorVisits.frx":6104
Style = 1 'Graphical
TabIndex = 16
Top = 7080
Width = 1095
End
Begin VB.CommandButton cmdEdit
BackColor = &H00FFFFFF&
Caption = "&Edit"
Height = 780
Left = 2880
Picture = "frmAddDoctorVisits.frx":65B3
Style = 1 'Graphical
TabIndex = 17
Top = 7080
Width = 1095
End
Begin VB.CommandButton cmdPatient
Caption = "..."
Height = 315
Left = 6720
TabIndex = 7
Top = 3360
Visible = 0 'False
Width = 495
End
Begin VB.CommandButton cmdDoc
Caption = "..."
Height = 315
Left = 6720
TabIndex = 5
Top = 2760
Visible = 0 'False
Width = 495
End
Begin VB.ComboBox cmbPatientID
Height = 315
Left = 4200
Style = 2 'Dropdown List
TabIndex = 24
Top = 3360
Visible = 0 'False
Width = 2415
End
Begin VB.ComboBox cmbDoctorID
Height = 315
Left = 4200
Style = 2 'Dropdown List
TabIndex = 23
Top = 2760
Visible = 0 'False
Width = 2415
End
Begin MSComCtl2.DTPicker DTPTime1
Height = 375
Left = 4200
TabIndex = 1
Top = 2160
Visible = 0 'False
Width = 2415
_ExtentX = 4260
_ExtentY = 661
_Version = 393216
Format = 46006274
CurrentDate = 38355
End
Begin MSComCtl2.DTPicker DTPDate1
Height = 375
Left = 4200
TabIndex = 22
Top = 1560
Visible = 0 'False
Width = 2415
_ExtentX = 4260
_ExtentY = 661
_Version = 393216
Format = 46006273
CurrentDate = 38355
End
Begin VB.TextBox txtFields
DataField = "Description"
Height = 990
Index = 5
Left = 4200
Locked = -1 'True
MultiLine = -1 'True
TabIndex = 10
Top = 4440
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "PAtient_ID"
Height = 285
Index = 4
Left = 4200
Locked = -1 'True
TabIndex = 6
Top = 3360
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "Doctor_ID"
Height = 285
Index = 3
Left = 4200
Locked = -1 'True
TabIndex = 4
Top = 2760
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "Visit_Time"
Height = 285
Index = 2
Left = 4200
Locked = -1 'True
TabIndex = 3
Top = 2145
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "Visit_Date"
Height = 285
Index = 1
Left = 4200
Locked = -1 'True
TabIndex = 2
Top = 1560
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "Visit_ID"
Height = 285
Index = 0
Left = 4200
Locked = -1 'True
TabIndex = 0
Top = 1020
Width = 2415
End
Begin VB.ComboBox cmbAdmitID
Height = 315
Left = 4200
Style = 2 'Dropdown List
TabIndex = 35
Top = 3840
Visible = 0 'False
Width = 2415
End
Begin VB.TextBox txtFields
DataField = "Admission_ID"
Height = 285
Index = 6
Left = 4200
Locked = -1 'True
TabIndex = 8
Top = 3840
Width = 2415
End
Begin VB.CommandButton cmdCancel
BackColor = &H00FFFFFF&
Caption = "&Cancel"
Height = 780
Left = 2880
Picture = "frmAddDoctorVisits.frx":6A58
Style = 1 'Graphical
TabIndex = 38
Top = 7080
Visible = 0 'False
Width = 1095
End
Begin VB.CommandButton cmdUpdate
BackColor = &H00FFFFFF&
Caption = "&Update"
Height = 780
Left = 1680
Picture = "frmAddDoctorVisits.frx":6F5C
Style = 1 'Graphical
TabIndex = 21
Top = 7080
Visible = 0 'False
Width = 1095
End
Begin VB.CommandButton cmdClose
BackColor = &H00FFFFFF&
Caption = "&Close"
Height = 780
Left = 6600
Picture = "frmAddDoctorVisits.frx":740A
Style = 1 'Graphical
TabIndex = 20
Top = 7080
Width = 1095
End
Begin VB.CommandButton cmdRefresh
BackColor = &H00FFFFFF&
Caption = "&Refresh"
Height = 780
Left = 5280
Picture = "frmAddDoctorVisits.frx":7916
Style = 1 'Graphical
TabIndex = 19
Top = 7080
Width = 1095
End
Begin VB.CommandButton cmdDelete
BackColor = &H00FFFFFF&
Caption = "&Delete"
Height = 780
Left = 4080
Picture = "frmAddDoctorVisits.frx":7DBC
Style = 1 'Graphical
TabIndex = 18
Top = 7080
Width = 1095
End
Begin VB.CommandButton cmdFirst
BackColor = &H00FFFFFF&
Height = 540
Left = 1440
Picture = "frmAddDoctorVisits.frx":8275
Style = 1 'Graphical
TabIndex = 11
Top = 6000
UseMaskColor = -1 'True
Width = 585
End
Begin VB.CommandButton cmdPrevious
BackColor = &H00FFFFFF&
Height = 540
Left = 2145
Picture = "frmAddDoctorVisits.frx":874B
Style = 1 'Graphical
TabIndex = 12
Top = 6000
UseMaskColor = -1 'True
Width = 585
End
Begin VB.CommandButton cmdNext
BackColor = &H00FFFFFF&
Height = 540
Left = 6600
Picture = "frmAddDoctorVisits.frx":8C2C
Style = 1 'Graphical
TabIndex = 14
Top = 6000
UseMaskColor = -1 'True
Width = 585
End
Begin VB.CommandButton cmdLast
BackColor = &H00FFFFFF&
Height = 540
Left = 7320
Picture = "frmAddDoctorVisits.frx":9107
Style = 1 'Graphical
TabIndex = 15
Top = 6000
UseMaskColor = -1 'True
Width = 585
End
Begin VB.CommandButton cmdAdmission
Caption = "..."
Height = 315
Left = 6720
TabIndex = 9
Top = 3840
Visible = 0 'False
Width = 495
End
Begin ActiveResizeCtl.ActiveResize ActiveResize1
Left = 0
Top = 0
_ExtentX = 847
_ExtentY = 847
Resolution = 4
ScreenHeight = 1024
ScreenWidth = 1280
ScreenHeightDT = 1024
ScreenWidthDT = 1280
FormHeightDT = 9750
FormWidthDT = 8955
FormScaleHeightDT= 9240
FormScaleWidthDT= 8835
ResizeFormBackground= -1 'True
ResizePictureBoxContents= -1 'True
End
Begin VB.Label lblStatus
Alignment = 2 'Center
BackColor = &H00FFFFFF&
BorderStyle = 1 'Fixed Single
Height = 405
Left = 2880
TabIndex = 13
Top = 6120
Width = 3480
End
Begin VB.Shape Shape4
BackColor = &H00FFFFFF&
BorderColor = &H00FFFFFF&
Height = 855
Left = 960
Shape = 4 'Rounded Rectangle
Top = 5880
Width = 7335
End
Begin VB.Shape Shape3
BackColor = &H00FFFFFF&
BorderColor = &H00FFFFFF&
Height = 1095
Left = 1440
Shape = 4 'Rounded Rectangle
Top = 6960
Width = 6495
End
Begin VB.Shape Shape2
BorderColor = &H00FFFFFF&
Height = 4695
Left = 1200
Shape = 4 'Rounded Rectangle
Top = 840
Width = 6735
End
Begin VB.Label Label1
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H00FF8080&
Caption = "Doctor Visits"
BeginProperty Font
Name = "Verdana"
Size = 18
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FFFFFF&
Height = 435
Left = 3360
TabIndex = 37
Top = 240
Width = 2550
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Admission ID:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 6
Left = 2280
TabIndex = 36
Top = 3840
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Description:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 5
Left = 2280
TabIndex = 30
Top = 4440
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Patient ID:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 4
Left = 2280
TabIndex = 29
Top = 3360
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Doctor ID:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 3
Left = 2280
TabIndex = 28
Top = 2760
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Visit Time:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 2
Left = 2280
TabIndex = 27
Top = 2160
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Visit Date:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 1
Left = 2280
TabIndex = 26
Top = 1575
Width = 1815
End
Begin VB.Label lblLabels
BackColor = &H00FF8080&
Caption = "Visit ID:"
ForeColor = &H00FFFFFF&
Height = 255
Index = 0
Left = 2280
TabIndex = 25
Top = 1020
Width = 1815
End
End
Attribute VB_Name = "frmAddDoctorVisits"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim WithEvents adoPrimaryRS As Recordset
Attribute adoPrimaryRS.VB_VarHelpID = -1
Dim mbChangedByCode As Boolean
Dim mvBookMark As Variant
Dim mbEditFlag As Boolean
Dim mbAddNewFlag As Boolean
Dim mbDataChanged As Boolean
Dim IDType As Integer
Private Sub cmbPatientID_Click()
Dim rsAddAdmitID As Recordset
Set rsAddAdmitID = New ADODB.Recordset
cmbAdmitID.clear
rsAddAdmitID.Open "select * from Admission_Details where Patient_ID='" & cmbPatientID & "'", cnPatients, adOpenDynamic, adLockReadOnly
While rsAddAdmitID.EOF = False
cmbAdmitID.AddItem rsAddAdmitID(0)
rsAddAdmitID.MoveNext
Wend
rsAddAdmitID.Close
End Sub
Private Sub cmdDoc_Click()
Frame1.Caption = "Doctor Details"
Frame1.Visible = True
IDType = 0
Dim RowNo As Integer
Dim rsDoctor As New Recordset
Set rsDoctor = New ADODB.Recordset
rsDoctor.Open "Select * from Doctor_Details", cnPatients, adOpenDynamic, adLockReadOnly
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -