-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsubjectaddf3.frm
461 lines (434 loc) · 12.9 KB
/
subjectaddf3.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
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form Form3
BackColor = &H00008000&
BorderStyle = 1 'Fixed Single
Caption = "Timetable Management System - Subject Details Form"
ClientHeight = 5790
ClientLeft = 585
ClientTop = 1965
ClientWidth = 8760
LinkTopic = "Form3"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5790
ScaleWidth = 8760
Begin VB.CommandButton remove
Caption = "DEL"
Height = 495
Left = 5760
TabIndex = 15
Top = 3480
Width = 495
End
Begin VB.PictureBox Picture1
BackColor = &H00008000&
BorderStyle = 0 'None
Height = 615
Left = 6240
OLEDropMode = 1 'Manual
Picture = "subjectaddf3.frx":0000
ScaleHeight = 615
ScaleWidth = 735
TabIndex = 11
ToolTipText = "To Main Menu"
Top = 120
Width = 735
End
Begin VB.CommandButton cmdMPrevious
Caption = "<<"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5760
TabIndex = 10
ToolTipText = "Move Previous"
Top = 1680
Width = 495
End
Begin VB.CommandButton cmdMFirst
Caption = "|<<"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5760
TabIndex = 9
ToolTipText = "Move First"
Top = 2280
Width = 495
End
Begin VB.CommandButton cmdMLast
Caption = ">>|"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5760
TabIndex = 8
ToolTipText = "Move last"
Top = 2880
Width = 495
End
Begin VB.CommandButton cmdMNext
Caption = ">>"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 5760
TabIndex = 7
ToolTipText = "Move Next"
Top = 1080
Width = 495
End
Begin VB.TextBox txtFaculty
Height = 285
Left = 2520
TabIndex = 6
Top = 2640
Width = 2295
End
Begin VB.TextBox txtSub
Height = 285
Left = 2520
TabIndex = 5
Top = 2040
Width = 2295
End
Begin VB.TextBox txtSubID
Height = 285
Left = 2520
TabIndex = 4
Top = 1320
Width = 735
End
Begin VB.CommandButton cmdNext
Caption = "Next"
BeginProperty Font
Name = "Calisto MT"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 4320
TabIndex = 3
Top = 3840
Width = 1095
End
Begin VB.CommandButton cmdUpdate
Caption = "Update"
BeginProperty Font
Name = "Calisto MT"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3120
TabIndex = 2
Top = 3840
Width = 1095
End
Begin VB.CommandButton cmdAddnew
Caption = "Add New"
BeginProperty Font
Name = "Calisto MT"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1920
TabIndex = 1
Top = 3840
Width = 1095
End
Begin MSAdodcLib.Adodc Adodc1
Height = 735
Left = 2040
Top = 4560
Width = 3735
_ExtentX = 6588
_ExtentY = 1296
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\projectsave\timetable.mdb;Persist Security Info=False"
OLEDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\projectsave\timetable.mdb;Persist Security Info=False"
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = "select * from subjectentry"
Caption = "Adodc1"
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
_Version = 393216
End
Begin VB.Line Line2
BorderColor = &H0000FF00&
X1 = 480
X2 = 480
Y1 = 240
Y2 = 4920
End
Begin VB.Line Line1
BorderColor = &H0000FF00&
X1 = 120
X2 = 6960
Y1 = 840
Y2 = 840
End
Begin VB.Label Label3
BackColor = &H00008000&
Caption = "Faculty :"
BeginProperty Font
Name = "Cambria"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Index = 1
Left = 1080
TabIndex = 14
Top = 2640
Width = 1245
End
Begin VB.Label Label2
Alignment = 2 'Center
AutoSize = -1 'True
BackColor = &H00008000&
Caption = "Subject ID :"
BeginProperty Font
Name = "Cambria"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 1080
TabIndex = 13
Top = 1320
Width = 1185
End
Begin VB.Label Label3
BackColor = &H00008000&
Caption = "Subject :"
BeginProperty Font
Name = "Cambria"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Index = 0
Left = 1080
TabIndex = 12
Top = 2040
Width = 1245
End
Begin VB.Label Label1
Alignment = 2 'Center
AutoSize = -1 'True
BackColor = &H00008000&
Caption = "Subject Details"
BeginProperty Font
Name = "Forte"
Size = 24
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H8000000B&
Height = 525
Left = 720
TabIndex = 0
Top = 240
Width = 3105
End
Begin VB.Menu mnuFile
Caption = "&File"
Begin VB.Menu mnuStaffTT
Caption = "View &Staff Time Table"
End
Begin VB.Menu mnuClassTT
Caption = "View &Class Time Table"
End
Begin VB.Menu mnuLabTT
Caption = "View &Lab Time Table"
End
End
Begin VB.Menu mnuEdit
Caption = "&Edit"
Begin VB.Menu mnuSubD
Caption = "S&ubject Details"
End
Begin VB.Menu mnuStaffD
Caption = "S&taff Details"
End
Begin VB.Menu mnuCTT
Caption = "C&reate Timetable"
End
End
Begin VB.Menu mnuClose
Caption = "&Close"
End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public Sub clear()
txtSubID.Text = ""
txtSub.Text = ""
txtFaculty.Text = ""
End Sub
Private Sub cmdAddnew_Click()
Dim aa As Integer
If txtSubID.Text <> "" And txtSub.Text <> "" And txtFaculty.Text <> "" Then
aa = MsgBox("Are You sure to add data", vbOKCancel, "Add Message")
If aa = 1 Then
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields(0) = txtSubID.Text
Adodc1.Recordset.Fields(1) = txtSub.Text
Adodc1.Recordset.Fields(2) = txtFaculty.Text
Adodc1.Recordset.Update
aa = MsgBox("Data successfully inserted", vbOKOnly, "Success Message")
clear
Adodc1.Refresh
End If
End If
End Sub
Private Sub cmdMFirst_Click()
Adodc1.Recordset.MoveFirst
txtSubID.Text = Adodc1.Recordset.Fields(0)
txtSub.Text = Adodc1.Recordset.Fields(1)
txtFaculty.Text = Adodc1.Recordset.Fields(2)
End Sub
Private Sub cmdMLast_Click()
Adodc1.Recordset.MoveLast
txtSubID.Text = Adodc1.Recordset.Fields(0)
txtSub.Text = Adodc1.Recordset.Fields(1)
txtFaculty.Text = Adodc1.Recordset.Fields(2)
End Sub
Private Sub cmdMNext_Click()
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF = True Then
Adodc1.Recordset.MoveLast
End If
txtSubID.Text = Adodc1.Recordset.Fields(0)
txtSub.Text = Adodc1.Recordset.Fields(1)
txtFaculty.Text = Adodc1.Recordset.Fields(2)
End Sub
Private Sub cmdMPrevious_Click()
Adodc1.Recordset.MovePrevious
If Adodc1.Recordset.BOF = True Then
Adodc1.Recordset.MoveFirst
End If
txtSubID.Text = Adodc1.Recordset.Fields(0)
txtSub.Text = Adodc1.Recordset.Fields(1)
txtFaculty.Text = Adodc1.Recordset.Fields(2)
End Sub
Private Sub cmdNext_Click()
Form4.Show
Unload Form3
End Sub
Private Sub cmdUpdate_Click()
Adodc1.Recordset.Fields(0) = txtSubID.Text
Adodc1.Recordset.Fields(1) = txtSub.Text
Adodc1.Recordset.Fields(2) = txtFaculty.Text
Adodc1.Recordset.Update
End Sub
Private Sub Form_Load()
Adodc1.RecordSource = "select * from subjectentry;"
Adodc1.Refresh
End Sub
Private Sub mnuClose_Click()
Dim a As Integer
a = MsgBox("Do you want to exit ?", vbOKCancel, "Message")
If a = 1 Then
End
Else
Exit Sub
End If
End Sub
Private Sub Picture1_Click()
Unload Me
Form2.Show
End Sub
Private Sub remove_Click()
Adodc1.Recordset.Delete
End Sub