Manual de usuario Cinthya Pérez Ledesma

Cinthya PĂŠrez Ledesma

Manual de usuario Proyecto: Empresa Operadora de Colegios la Salle

ÍNDICE Access .............................................................................................................................................. 2 Diseño de tabla .............................................................................................................................. 2 Tabla.............................................................................................................................................. 2 Visual Basic ...................................................................................................................................... 3 Clave: ............................................................................................................................................ 3 Menú:............................................................................................................................................. 3 Altas: .......................................................................................................................................... 4 Bajas: ......................................................................................................................................... 4 Cambios: .................................................................................................................................... 5

Access Dise単o de tabla

Tabla

Visual Basic Clave: Private Sub Command1_Click() Dim a As Integer a = Val(Text1) If a = 1298 Then Clave.Hide Menú.Show MsgBox "¡BIENVENIDO!" Else MsgBox "ERROR!!!"

Text1 = " " Text1.SetFocus End If End Sub

Menú: Private Sub bc1_Click() Menú.Hide Altas.Show End Sub Private Sub bc2_Click() Menú.Hide Bajas.Show End Sub Private Sub bc3_Click() Menú.Hide Cambios.Show End Sub Private Sub bc4_Click() Menú.Hide Clave.Show End Sub

Altas:

Private Sub bc1_Click() Altas.Hide Menú.Show End Sub Private Sub bc2_Click() Adodc1.Recordset.AddNew End Sub

Bajas:

Private Sub bc2_Click() Bajas.Hide Menú.Show End Sub Private Sub Command1_Click() Adodc1.Recordset.Delete End Sub

Cambios:

Private Sub Command1_Click() Cambios.Hide MenĂş.Show End Sub Private Sub Command2_Click() Adodc1.Recordset.Update End Sub