Deshabilitar botones
Publicado por Sebastian Crescenzi (10 intervenciones) el 31/01/2006 03:02:36
Estoy programando una agenda. Lo que necesito saber es como hago para que cuando la base de datos(Está hecha en Access)esté vacía me deshabilite botones(command, toolbarbutton), y que aparezca un msgob que me lo informe.
Otro tema es que quiero que haya campos que sean obligatorios(por ejemplo, nombre; apellido...)
Acá mando el código de lo que hice hasta ahora:
Private Sub acerca_Click()
Form3.Show
End Sub
Private Sub Command1_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveFirst
If Data1.Recordset.BOF = True Then
Data1.Recordset.MoveFirst
End If
End Sub
Private Sub Command2_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveNext
If Data1.Recordset.EOF = True Then
Data1.Recordset.MoveLast
End If
End Sub
Private Sub Command3_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF = True Then
Data1.Recordset.MoveFirst
End If
End Sub
Private Sub Command4_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveLast
End Sub
Private Sub ToolbarButton1_Click()
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Text7.Enabled = True
Text8.Enabled = True
Text9.Enabled = True
Text10.Enabled = True
Text11.Enabled = True
Text12.Enabled = True
Text13.Enabled = True
Text17.Enabled = True
Text16.Enabled = True
If Text1.Enabled = True Then
Data1.Recordset.AddNew
Else
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
End If
End Sub
Private Sub ToolbarButton2_Click()
op = MsgBox("Guardar los cambios", vbYesNo, "Guardar")
If op = vbYes Then
Data1.Recordset.MoveFirst
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
MsgBox Data1.Recordset.RecordCount
End If
End Sub
Private Sub ToolbarButton3_Click()
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Text7.Enabled = True
Text8.Enabled = True
Text9.Enabled = True
Text10.Enabled = True
Text11.Enabled = True
Text12.Enabled = True
Text13.Enabled = True
Text17.Enabled = True
Text16.Enabled = True
End Sub
Private Sub ToolbarButton4_Click()
op = MsgBox("¿Está seguro?", vbYesNo, "Eliminar")
If op = vbYes Then
Data1.Recordset.Delete
MsgBox Data1.Recordset.RecordCount
Data1.Refresh
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
End If
End Sub
Private Sub ToolbarButton5_Click()
Form3.Show
End Sub
Private Sub ToolbarButton6_Click()
End
End Sub
Espero que alguien pueda darme una idea de como hacerlo, desde ya muchas gracias
Otro tema es que quiero que haya campos que sean obligatorios(por ejemplo, nombre; apellido...)
Acá mando el código de lo que hice hasta ahora:
Private Sub acerca_Click()
Form3.Show
End Sub
Private Sub Command1_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveFirst
If Data1.Recordset.BOF = True Then
Data1.Recordset.MoveFirst
End If
End Sub
Private Sub Command2_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveNext
If Data1.Recordset.EOF = True Then
Data1.Recordset.MoveLast
End If
End Sub
Private Sub Command3_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF = True Then
Data1.Recordset.MoveFirst
End If
End Sub
Private Sub Command4_Click()
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
Data1.Recordset.MoveLast
End Sub
Private Sub ToolbarButton1_Click()
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Text7.Enabled = True
Text8.Enabled = True
Text9.Enabled = True
Text10.Enabled = True
Text11.Enabled = True
Text12.Enabled = True
Text13.Enabled = True
Text17.Enabled = True
Text16.Enabled = True
If Text1.Enabled = True Then
Data1.Recordset.AddNew
Else
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
End If
End Sub
Private Sub ToolbarButton2_Click()
op = MsgBox("Guardar los cambios", vbYesNo, "Guardar")
If op = vbYes Then
Data1.Recordset.MoveFirst
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
MsgBox Data1.Recordset.RecordCount
End If
End Sub
Private Sub ToolbarButton3_Click()
Text1.Enabled = True
Text2.Enabled = True
Text3.Enabled = True
Text4.Enabled = True
Text5.Enabled = True
Text6.Enabled = True
Text7.Enabled = True
Text8.Enabled = True
Text9.Enabled = True
Text10.Enabled = True
Text11.Enabled = True
Text12.Enabled = True
Text13.Enabled = True
Text17.Enabled = True
Text16.Enabled = True
End Sub
Private Sub ToolbarButton4_Click()
op = MsgBox("¿Está seguro?", vbYesNo, "Eliminar")
If op = vbYes Then
Data1.Recordset.Delete
MsgBox Data1.Recordset.RecordCount
Data1.Refresh
Text1.Enabled = False
Text2.Enabled = False
Text3.Enabled = False
Text4.Enabled = False
Text5.Enabled = False
Text6.Enabled = False
Text7.Enabled = False
Text8.Enabled = False
Text9.Enabled = False
Text10.Enabled = False
Text11.Enabled = False
Text12.Enabled = False
Text13.Enabled = False
Text17.Enabled = False
Text16.Enabled = False
End If
End Sub
Private Sub ToolbarButton5_Click()
Form3.Show
End Sub
Private Sub ToolbarButton6_Click()
End
End Sub
Espero que alguien pueda darme una idea de como hacerlo, desde ya muchas gracias
Valora esta pregunta


0