Flo04 de Agosto del 2004
Preguntatoy haciendo un proyecto de la unviersidad y pues tengo problemas para crear el boton de actualizar todos los demas funcionan referenciandolos a una base de datos de access usando ado y alli en la base de datos se van hacia el query llamado proyecto aqui esta el codigo necesito es crear el actualizar segun los codigos que aqui puse espero me puedan ayudar.
Private Sub Actualizar_Click()
On Error GoTo maneja
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER =" & Text1.Text
Set rs = cmd.Execute
rs.Update
MsgBox "no hay registro"
Exit Sub
maneja:
MsgBox "ha ocurrido un error en tiempo de ejecucion" & Err.Number & "-" & Err.Description
Resume Next
End Sub
Private Sub Borrar_Click()
On Error GoTo maneja
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "delete * from ER where ER = " & Text1.Text
Set rs = cmd.Execute
MsgBox "se borro un registro"
Exit Sub
maneja:
MsgBox "ha ocurrido un error en tiempo de ejecucion" & Err.Number & "-" & Err.Description
Resume Next
End Sub
Private Sub Consultar_Click()
On Error GoTo maneja
If Text1.Text = "" Then
MsgBox ("introdusca un numero de ER para Poder Consultar")
Text1.SetFocus
Else
Text6.Text = ""
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER = " & Text1.Text
Set rs = cmd.Execute
If Not rs.EOF Then
Text1.Text = rs.Fields("ER").Value
Text2.Text = rs.Fields("departamento").Value
Text6.Text = rs.Fields("codigo activo").Value
Text9.Text = rs.Fields("avaluo1").Value
Else
MsgBox "no hay registro"
End If
End If
Exit Sub
maneja:
End Sub
Private Sub Grabar_Click()
On Error GoTo manejaerror
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER=" & Text1.Text
Set rs2 = cmd.Execute
If Not rs2.EOF Then
MsgBox "El registro a insertar ya existe"
Text1.Text = ""
Text1.SetFocus
Else
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockBatchOptimistic
rs.Open "select * from proyecto where 1 = 2", con
rs.AddNew
rs("ER").Value = Text1.Text
rs("departamento").Value = Text2.Text
rs.ActiveConnection = con
rs.UpdateBatch
MsgBox "registro guardando exitosamente"
End If
manejaerror:
If Err.Number <> 0 Then
msgboxerr.descripcion
End If
Exit Sub
maneja:
Resume Next
End Sub
Private Sub Actualizar_Click()
On Error GoTo maneja
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER =" & Text1.Text
Set rs = cmd.Execute
rs.Update
MsgBox "no hay registro"
Exit Sub
maneja:
MsgBox "ha ocurrido un error en tiempo de ejecucion" & Err.Number & "-" & Err.Description
Resume Next
End Sub
Private Sub Borrar_Click()
On Error GoTo maneja
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "delete * from ER where ER = " & Text1.Text
Set rs = cmd.Execute
MsgBox "se borro un registro"
Exit Sub
maneja:
MsgBox "ha ocurrido un error en tiempo de ejecucion" & Err.Number & "-" & Err.Description
Resume Next
End Sub
Private Sub Consultar_Click()
On Error GoTo maneja
If Text1.Text = "" Then
MsgBox ("introdusca un numero de ER para Poder Consultar")
Text1.SetFocus
Else
Text6.Text = ""
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
con.Open "dsn=bienes2;uid=sa;pwd;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER = " & Text1.Text
Set rs = cmd.Execute
If Not rs.EOF Then
Text1.Text = rs.Fields("ER").Value
Text2.Text = rs.Fields("departamento").Value
Text6.Text = rs.Fields("codigo activo").Value
Text9.Text = rs.Fields("avaluo1").Value
Else
MsgBox "no hay registro"
End If
End If
Exit Sub
maneja:
End Sub
Private Sub Grabar_Click()
On Error GoTo manejaerror
Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Set con = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset
con.Open "dsn=bienes2;uid=sa;pwd=;"
cmd.ActiveConnection = con
cmd.CommandText = "select * from proyecto where ER=" & Text1.Text
Set rs2 = cmd.Execute
If Not rs2.EOF Then
MsgBox "El registro a insertar ya existe"
Text1.Text = ""
Text1.SetFocus
Else
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockBatchOptimistic
rs.Open "select * from proyecto where 1 = 2", con
rs.AddNew
rs("ER").Value = Text1.Text
rs("departamento").Value = Text2.Text
rs.ActiveConnection = con
rs.UpdateBatch
MsgBox "registro guardando exitosamente"
End If
manejaerror:
If Err.Number <> 0 Then
msgboxerr.descripcion
End If
Exit Sub
maneja:
Resume Next
End Sub
