-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathFixtureItem.frm
323 lines (319 loc) · 9.5 KB
/
FixtureItem.frm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
VERSION 5.00
Begin VB.Form FixtureItem
BackColor = &H00FFFFFF&
Caption = "Fixture Components"
ClientHeight = 3345
ClientLeft = 45
ClientTop = 330
ClientWidth = 14775
ControlBox = 0 'False
LinkTopic = "Form7"
ScaleHeight = 3345
ScaleWidth = 14775
StartUpPosition = 3 'Windows Default
Begin VB.CheckBox TBStock
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Force Toolboss Stock"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 7080
TabIndex = 18
Top = 1200
Width = 2895
End
Begin VB.TextBox DetailNumberTxt
Height = 375
Left = 9720
TabIndex = 3
Top = 720
Width = 975
End
Begin VB.CommandButton RefreshBTN
Caption = "Refresh List"
Height = 375
Left = 6240
TabIndex = 16
Top = 240
Width = 1455
End
Begin VB.TextBox QtyOnHandTXT
BackColor = &H80000000&
Height = 375
Left = 2760
Locked = -1 'True
TabIndex = 6
TabStop = 0 'False
Top = 720
Width = 975
End
Begin VB.TextBox AdditionalNotesTXT
Height = 615
Left = 2760
TabIndex = 1
Top = 2160
Width = 3495
End
Begin VB.TextBox QuantityTXT
Height = 375
Left = 9720
TabIndex = 2
Top = 240
Width = 975
End
Begin VB.TextBox CribNumberIDTXT
Height = 375
Left = 0
TabIndex = 12
Top = 2520
Visible = 0 'False
Width = 975
End
Begin VB.ComboBox ItemNumberCOMBO
Height = 315
Left = 2760
TabIndex = 0
Text = "ItemNumberCOMBO"
Top = 240
Width = 3495
End
Begin VB.TextBox ManufacturerTXT
BackColor = &H80000000&
Height = 375
Left = 2760
Locked = -1 'True
TabIndex = 11
TabStop = 0 'False
Top = 1680
Width = 3495
End
Begin VB.TextBox ItemGroupTXT
BackColor = &H80000000&
Height = 375
Left = 2760
Locked = -1 'True
TabIndex = 10
TabStop = 0 'False
Top = 1200
Width = 3495
End
Begin VB.CommandButton CancelBTN
Cancel = -1 'True
Caption = "Cancel"
Height = 615
Left = 9360
TabIndex = 5
Top = 2280
Width = 1455
End
Begin VB.CommandButton UpdateBTN
Caption = "Update"
Default = -1 'True
Height = 615
Left = 7680
TabIndex = 4
Top = 2280
Width = 1455
End
Begin VB.Label Label4
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Detail Number:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 7920
TabIndex = 17
Top = 720
Width = 1695
End
Begin VB.Label Label8
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Qty On Hand:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 480
TabIndex = 15
Top = 720
Width = 2175
End
Begin VB.Label Label2
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Additional Notes:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 720
TabIndex = 14
Top = 2160
Width = 1935
End
Begin VB.Label Label5
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Quantity:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 8400
TabIndex = 13
Top = 240
Width = 1215
End
Begin VB.Label Label3
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Item Group:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 960
TabIndex = 9
Top = 1200
Width = 1575
End
Begin VB.Label Label1
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Item Number:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 960
TabIndex = 8
Top = 240
Width = 1575
End
Begin VB.Label Label7
Alignment = 1 'Right Justify
BackColor = &H00808080&
Caption = "Manufacturer:"
BeginProperty Font
Name = "Gill Sans MT"
Size = 11.25
Charset = 0
Weight = 700
Underline = -1 'True
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00000000&
Height = 375
Left = 960
TabIndex = 7
Top = 1680
Width = 1575
End
Begin VB.Shape Shape1
FillColor = &H00808080&
FillStyle = 0 'Solid
Height = 2895
Left = 120
Shape = 4 'Rounded Rectangle
Top = 120
Width = 12255
End
End
Attribute VB_Name = "FixtureItem"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Cl As New Class1
Private Sub CancelBTN_Click()
MDIForm1.TabDock.FormHide "Fixture Details"
End Sub
Private Sub Form_GotFocus()
ItemNumberCOMBO.SetFocus
End Sub
Private Sub ItemNumberCOMBO_GotFocus()
If Not fixturetoolexists Then
Cl.ShowDropDownCombo ItemNumberCOMBO
End If
End Sub
Private Sub ItemNumberCOMBO_LostFocus()
ValidateFixtureItemNumber
End Sub
Private Sub RefreshBTN_Click()
PopulateItemList
End Sub
Private Sub UpdateBTN_Click()
If Not ValidateFixtureItemNumber Then
Exit Sub
End If
If Not IsNumeric(QuantityTXT.Text) Then
MsgBox ("Invalid Quantity")
Exit Sub
End If
If Not IsNumeric(DetailNumberTxt.Text) Then
MsgBox ("Invalid Detail Number")
Exit Sub
End If
If fixturetoolexists Then
UpdateFixtureDetails
Else
AddFixtureSub
End If
ClearFixtureFields
MDIForm1.TabDock.FormHide "Fixture Details"
RefreshReport
End Sub