Overwrite previous record with VBA code
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked.
Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
Software/Hardware used:
Software/Hardware used:
ASKED:
May 13, 2008 1:28 PM
UPDATED:
May 21, 2008 5:21 PM
Answer Wiki:
Hello Battler,
you can query your last record (<b>SELECET MAX(ID) as LASTID FROM TABLE</b>) and then perform a <b>DELETE FROM TABLE WHERE ID=LASTID-1</b>.
Bye
Or maybe an UPDATE SQL sentence:
UPDATE theTable SET theName = "Battler Guy" WHERE id = (SELECT MAX(ID) ...)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
