home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Hot Shareware 35
/
hot35.iso
/
ficheros
/
9UTI
/
WS32SHAR.ZIP
/
USER.FR_
/
USER.FR
Wrap
Text File
|
1998-03-28
|
20KB
|
613 lines
VERSION 5.00
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "tabctl32.ocx"
Object = "{BC496AED-9B4E-11CE-A6D5-0000C0BE9395}#2.0#0"; "SSDATB32.OCX"
Object = "{A5CC20C4-B5F5-11CD-98EC-0020AF234C9D}#4.1#0"; "cstext32.ocx"
Begin VB.Form frmUser
Caption = "Users"
ClientHeight = 3270
ClientLeft = 2895
ClientTop = 4305
ClientWidth = 6675
HelpContextID = 15000
LinkTopic = "Form1"
ScaleHeight = 3270
ScaleWidth = 6675
Tag = "Users Edit"
Begin VB.CommandButton btnEdit
Caption = "Delete"
Height = 315
Index = 4
Left = 120
TabIndex = 9
Tag = "Delete button"
ToolTipText = "Delete User"
Top = 2880
Width = 1155
End
Begin TabDlg.SSTab stCusTyp
Height = 2715
Left = 0
TabIndex = 10
Tag = "Edit Selection tab"
Top = 60
Width = 6675
_ExtentX = 11774
_ExtentY = 4789
_Version = 327681
Tabs = 2
Tab = 1
TabHeight = 520
TabCaption(0) = "&Single Record"
TabPicture(0) = "User.frx":0000
Tab(0).ControlEnabled= 0 'False
Tab(0).Control(0)= "lbl(0)"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "lbl(1)"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "lbl(2)"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "lbl(3)"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).Control(4)= "lbl(4)"
Tab(0).Control(4).Enabled= 0 'False
Tab(0).Control(5)= "clgUser(1)"
Tab(0).Control(5).Enabled= 0 'False
Tab(0).Control(6)= "clgUser(0)"
Tab(0).Control(6).Enabled= 0 'False
Tab(0).Control(7)= "txUser(0)"
Tab(0).Control(7).Enabled= 0 'False
Tab(0).Control(8)= "txUser(1)"
Tab(0).Control(8).Enabled= 0 'False
Tab(0).Control(9)= "txUser(2)"
Tab(0).Control(9).Enabled= 0 'False
Tab(0).ControlCount= 10
TabCaption(1) = "&Grid"
TabPicture(1) = "User.frx":001C
Tab(1).ControlEnabled= -1 'True
Tab(1).Control(0)= "ssgUser"
Tab(1).Control(0).Enabled= 0 'False
Tab(1).ControlCount= 1
Begin VB.TextBox txUser
DataField = "user_password"
DataSource = "datUser"
Height = 315
Index = 2
Left = -72300
MaxLength = 10
TabIndex = 5
Tag = "User Password"
ToolTipText = "Pass Word"
Top = 1680
Width = 2595
End
Begin VB.TextBox txUser
DataField = "user_refno"
DataSource = "datUser"
Height = 315
Index = 1
Left = -72300
MaxLength = 15
TabIndex = 4
Tag = "User Account number"
ToolTipText = "Account #"
Top = 1380
Width = 2595
End
Begin VB.TextBox txUser
DataField = "user_name"
DataSource = "datUser"
Height = 315
Index = 0
Left = -72300
MaxLength = 30
TabIndex = 3
Tag = "User Name"
ToolTipText = "User Name"
Top = 1080
Width = 2595
End
Begin SSDataWidgets_B.SSDBGrid ssgUser
Bindings = "User.frx":0038
Height = 1995
Left = 60
TabIndex = 11
Tag = "User Edit Grid"
ToolTipText = "User Definition"
Top = 540
Width = 6540
_Version = 131078
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
SelectTypeCol = 0
SelectTypeRow = 1
RowHeight = 423
Columns.Count = 5
Columns(0).Width= 1482
Columns(0).Caption= "User #"
Columns(0).Name = "user_no"
Columns(0).CaptionAlignment= 0
Columns(0).DataField= "user_no"
Columns(0).DataType= 3
Columns(0).FieldLen= 256
Columns(1).Width= 4630
Columns(1).Caption= "User Name"
Columns(1).Name = "user_name"
Columns(1).CaptionAlignment= 0
Columns(1).DataField= "user_name"
Columns(1).DataType= 8
Columns(1).FieldLen= 256
Columns(2).Width= 2328
Columns(2).Caption= "User Acct #"
Columns(2).Name = "user_refno"
Columns(2).CaptionAlignment= 0
Columns(2).DataField= "user_refno"
Columns(2).DataType= 8
Columns(2).FieldLen= 256
Columns(3).Width= 3200
Columns(3).Caption= "Password"
Columns(3).Name = "user_password"
Columns(3).CaptionAlignment= 0
Columns(3).DataField= "user_password"
Columns(3).DataType= 8
Columns(3).FieldLen= 256
Columns(4).Width= 2355
Columns(4).Caption= "Security Level"
Columns(4).Name = "user_securitylvl"
Columns(4).Alignment= 1
Columns(4).CaptionAlignment= 1
Columns(4).DataField= "user_securitylvl"
Columns(4).DataType= 3
Columns(4).FieldLen= 256
UseDefaults = 0 'False
_ExtentX = 11536
_ExtentY = 3519
_StockProps = 79
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin CSTextLibCtl.silgEdit clgUser
Bindings = "User.frx":004A
Height = 315
Index = 0
Left = -72300
TabIndex = 2
TabStop = 0 'False
Tag = "User Number"
ToolTipText = "User Number"
Top = 780
Width = 2595
_Version = 262145
_ExtentX = 4577
_ExtentY = 556
_StockProps = 125
Text = " 1"
ForeColor = -2147483640
BackColor = 14737632
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.26
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BorderEffect = 2
DataProperty = 2
ReadOnly = -1 'True
Modified = 0 'False
HideSelection = -1 'True
RawData = "1"
Text = " 1"
StartText.x = 3
StartText.y = 4
FirstVisPos = 0
HiAnchor = 0
HiNew = 0
CaretHeight = 13
CurNumDataChars = 0
MaxDataChars = 0
FirstDataPos = 0
CurPos = 0
MaxLen = 0
DataReadOnly = 0 'False
Mask = ""
Justification = 2
Undo = 1
Data = 1
DataField = "user_no"
End
Begin CSTextLibCtl.silgEdit clgUser
Bindings = "User.frx":005C
Height = 315
Index = 1
Left = -72300
TabIndex = 6
Tag = "User Security Level"
ToolTipText = "User Security Level"
Top = 1980
Width = 2595
_Version = 262145
_ExtentX = 4577
_ExtentY = 556
_StockProps = 125
Text = " 1"
ForeColor = -2147483640
BackColor = 16777215
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.26
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BorderEffect = 2
DataProperty = 2
Modified = 0 'False
HideSelection = -1 'True
RawData = "1"
Text = " 1"
StartText.x = 3
StartText.y = 4
FirstVisPos = 0
HiAnchor = 0
HiNew = 0
CaretHeight = 13
CurNumDataChars = 0
MaxDataChars = 0
FirstDataPos = 0
CurPos = 0
MaxLen = 0
DataReadOnly = 0 'False
Mask = ""
Justification = 2
Undo = 1
Data = 1
DataField = "user_securitylvl"
End
Begin VB.Label lbl
BackColor = &H00FFFFC0&
BorderStyle = 1 'Fixed Single
Caption = "User Security Level"
Height = 285
Index = 4
Left = -73800
TabIndex = 16
Top = 1980
Width = 1515
End
Begin VB.Label lbl
BackColor = &H00FFFFC0&
BorderStyle = 1 'Fixed Single
Caption = "User Password"
Height = 285
Index = 3
Left = -73800
TabIndex = 15
Top = 1680
Width = 1515
End
Begin VB.Label lbl
BackColor = &H00FFFFC0&
BorderStyle = 1 'Fixed Single
Caption = "User Account #"
Height = 285
Index = 2
Left = -73800
TabIndex = 14
Top = 1380
Width = 1515
End
Begin VB.Label lbl
BackColor = &H00FFFFC0&
BorderStyle = 1 'Fixed Single
Caption = "User Name"
Height = 285
Index = 1
Left = -73800
TabIndex = 13
Top = 1080
Width = 1515
End
Begin VB.Label lbl
BackColor = &H00FFFFC0&
BorderStyle = 1 'Fixed Single
Caption = "User Number"
Height = 285
Index = 0
Left = -73800
TabIndex = 12
Top = 780
Width = 1515
End
End
Begin VB.Data datUser
Caption = "Cat"
Connect = "Access"
DatabaseName = ""
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 240
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = ""
Top = 0
Visible = 0 'False
Width = 1140
End
Begin VB.CommandButton btnEdit
Caption = "&New"
Height = 315
Index = 3
Left = 1440
TabIndex = 1
Tag = "New Button"
ToolTipText = "Create New User"
Top = 2880
Width = 1155
End
Begin VB.CommandButton btnEdit
Caption = "E&dit "
Height = 315
Index = 0
Left = 2760
TabIndex = 0
Tag = "Edit Button "
ToolTipText = "Edit User"
Top = 2880
Width = 1155
End
Begin VB.CommandButton btnEdit
Cancel = -1 'True
Caption = "&Close"
Height = 315
Index = 2
Left = 5400
TabIndex = 8
Tag = "Close button"
ToolTipText = "Close User Edit"
Top = 2880
Width = 1155
End
Begin VB.CommandButton btnEdit
Caption = "&Post"
Height = 315
Index = 1
Left = 4140
TabIndex = 7
Tag = "Post button"
ToolTipText = "Post User"
Top = 2880
Width = 1155
End
End
Attribute VB_Name = "frmUser"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Attribute VB_Ext_KEY = "RVB_UniqueId" ,"3461E5F10250"
Option Explicit
'##ModelId=3461E5F10323
Private Sub btnEdit_Click(Index As Integer)
Dim Persist As New CPersist
Dim Rs As Recordset, iErr As Integer
Static flgEdit As Integer
Dim Er As New CErr, iErResponse As Integer
On Error GoTo EdErr
Select Case Index
Case 0 'edit
enableEdit
iErr = Persist.EditRecord(datUser, Rs)
flgEdit = True
Case 1 'post
If flgEdit = True Then
iErr = Persist.PostRecord(datUser, Rs)
disableFields
flgEdit = False
End If
If btnEdit(0).Enabled = True Then btnEdit(0).SetFocus
Case 2 'close
disableFields
flgEdit = False
Unload frmUser
Case 3 'new
enableEdit
iErr = Persist.NewRecord(datUser, Rs)
flgEdit = True
Case 4 'delete
iErr = Persist.DeleteRecord(datUser, Rs)
disableFields
flgEdit = False
End Select
Set Persist = Nothing
Exit Sub
EdErr:
iErResponse = Er.Show("User btnEdit_Click")
If iErResponse = gliResume Then
Resume
ElseIf iErResponse = gliResumeNext Then
Resume Next
Else
Exit Sub
End If
End Sub
'##ModelId=3461E5F20035
Private Sub cxtUser_Change(Index As Integer)
End Sub
Private Sub datUser_Error(DataErr As Integer, Response As Integer)
Dim Er As New CErr, iErResponse As Integer
On Error GoTo dcErr
Exit Sub
dcErr:
iErResponse = Er.Show("User datUser")
If iErResponse = gliResume Then
Resume
ElseIf iErResponse = gliResumeNext Then
Resume Next
Else
Exit Sub
End If
End Sub
'##ModelId=3461E5F20125
Private Sub Form_Activate()
disableFields
stCusTyp.Tab = 0
End Sub
'##ModelId=3461E5F2019E
Private Sub Form_Load()
Dim Win As New CWindow
Dim dlgResponse, dlgDef, dlgMsg, dlgTitle
On Error GoTo fLErr
Win.Center Me
Exit Sub
fLErr:
Select Case Err
'Case 3061
'Resume Next 'consider taking out if Refresh not used.
Case Else
dlgTitle = "Form Customer Type Load Error"
dlgDef = vbRetryCancel + vbExclamation
dlgMsg = "ERROR " & Err & " occurred. " & Error$ & "."
dlgResponse = MsgBox(dlgMsg, dlgDef, dlgTitle)
End Select
If dlgResponse = vbRetry Then
Resume
ElseIf dlgResponse = vbCancel Then
Exit Sub
End If
End Sub
'##ModelId=3461E5F20216
Public Sub disableFields()
Dim i As Integer
Dim Er As New CErr, iErResponse As Integer
On Error GoTo DaErr
btnEdit(2).Enabled = True
btnEdit(0).Enabled = True
btnEdit(1).Enabled = False
btnEdit(3).Enabled = True
For i = 0 To 2
txUser(i).Enabled = False
Next i
For i = 0 To 1
clgUser(i).Enabled = False
Next i
Exit Sub
DaErr:
iErResponse = Er.Show("User disableFields")
If iErResponse = gliResume Then
Resume
ElseIf iErResponse = gliResumeNext Then
Resume Next
Else
Exit Sub
End If
End Sub
'##ModelId=3461E5F20270
Public Sub enableEdit()
Dim i As Integer
Dim Er As New CErr, iErResponse As Integer
On Error GoTo EfErr
btnEdit(2).Enabled = True
btnEdit(0).Enabled = False
btnEdit(1).Enabled = True
btnEdit(3).Enabled = False
For i = 0 To 2
txUser(i).Enabled = True
Next i
For i = 0 To 1
clgUser(i).Enabled = True
Next i
Exit Sub
EfErr:
iErResponse = Er.Show("User enableEdit")
If iErResponse = gliResume Then
Resume
ElseIf iErResponse = gliResumeNext Then
Resume Next
Else
Exit Sub
End If
End Sub
'##ModelId=34A9B718008A
Public Sub Display(DbName As String)
Dim Persist As New CPersist
Dim dlgResponse, dlgDef, dlgMsg, dlgTitle
On Error GoTo fDErr
If Persist.Connect(datUser, "Users", DbName) = True Then Exit Sub
Me.Show 1
Set Persist = Nothing
Exit Sub
fDErr:
Select Case Err
'Case 3061
'Resume Next 'consider taking out if Refresh not used.
Case Else
dlgTitle = "Form User Display Error"
dlgDef = vbRetryCancel + vbExclamation
dlgMsg = "ERROR " & Err & " occurred. " & Error$ & "."
dlgResponse = MsgBox(dlgMsg, dlgDef, dlgTitle)
End Select
If dlgResponse = vbRetry Then
Resume
ElseIf dlgResponse = vbCancel Then
Exit Sub
End If
End Sub