Recent content by Aceavl

  1. A

    Update doesn't work everytime?

    Hi all, I solved it thanks to burrina! when I watched the RecordSet the query was returning 2 record in some instances and it updated the wrong record, that's why the record in question wasn't updated! Thank you for help!
  2. A

    Update doesn't work everytime?

    Hi all! JHB. I tried with DoEvents and no luck... burrina: I'll try your method and let you know if it worked. Thank you!
  3. A

    Update doesn't work everytime?

    Hi jdraw, A team is the seales persons (2 per team), we assign a team number to keep track of who has the items in their inventory. the other tables i have them but are not important to the issue. in the pic you can see the relationships. Thank you!
  4. A

    Update doesn't work everytime?

    Hi jdraw, it's an inventory. The items are assinged to Teams. this is to change the item from stock to a team or ftom team to team. the tables in question are: tblEquipos 'the teams table EquipoIdPk 'AutoNumber and IDPK Equipo 'the name of team tblInv 'Inventory table InvIdPk 'AutoNumber and...
  5. A

    Update doesn't work everytime?

    Hi all! I'm having a problem with an update query run from vba. it sometimes does what it's supposed to do and sometimes it doesn't... It just changes an ID to another strSql = "UPDATE tblInvEquipos SET EquipoIdFk=" & dblAsignarId & " WHERE InvEquiposIdPk=" & dblInvEquipoId & ""...
See more
Back
Top Bottom