Search results

  1. A

    Audit Trail Failing after Using Tab

    Hi team I am facing problem with the code This Audit trail only works when row is changed I want it to work when we move from the record. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim ctl As String Dim db As Database Dim rs As Recordset Dim strsql As String Dim uname As String...
  2. A

    looping Problem

    Very new to Access and VBA I am getting a looping problem need your dear help please? Public Function updatetable1() Dim db As dao.Database Dim rs1 As Recordset Set db = CurrentDb() Set rs1 = db.OpenRecordset("Singapore_Access_Tracker") rs1.MoveFirst Do Until rs1.EOF srno1 = rs1![sr no]...
  3. A

    Macro in form

    this Dumb thing is really bothering me. I have a VBA code which works fine in a form_tracker. But the Vba code does not work the same form tracker is used as a subform. help appreciated guys please.. Here is the code Private Sub Experience_Key_Exit(Cancel As Integer) 'On Error Resume...
Back
Top Bottom