Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: madhula
  • Content: Threads
  • Order by date
  1. madhula

    Problem with deleting record

    HI, I am using the following function to delete a record from sysDeptDef table which is not present in ups_new table. I have two rows for the same deptid but diff attid. when i use the delete command the two rows get deleted but when the loop executes it cannot find the deptid so it fails.can...
  2. madhula

    Runtime error 3134

    Dim CurrentLevel As Integer Dim CurrentDeptId As Variant Dim LevelUp1 As String Dim LevelUp2 As String Dim LobId As String Dim AttId As Integer Dim Oc_Id As Integer Dim LevelCheck As Boolean Set rst_check = dbs.OpenRecordset("Select dept_level,deptid from...
  3. madhula

    insert record

    Dim CurrentLevel As Integer Dim CurrentDeptId As Variant Dim LevelUp1 As Variant Dim LevelUp2 As Variant Dim LobId As Variant Dim AttId As Integer Dim Oc_Id As Integer Dim LevelCheck As Boolean Set rst_check = dbs.OpenRecordset("Select dept_level,deptid from...
  4. madhula

    If not conditional loop

    HI, It has been long time i used Acess. I am trying to check a condition and edit the recordset. there are two recordset rst_local and rst_pplops.I compare the records from each recordset and edit one of them. The condition is If rst_pplpos("Deptid")=rst_local("DeptId") And...

Part and Inventory Search

Back
Top