Snamelisch
Programmer
Hello, I am Marc Schillemans (Dutch). I am an experienced programmer in Visual Basic, but I can't solve the next problem.
Question in short: I like to clear a partially filled form of new record without losing the current Record ID.
Short description:
A user enters data in a form, but while doing this decides he wants to stop. He then closes the accessform or goes back to another record. The form is cleared, but the recordID is lost. It is not a real problem, but the users dislike it very much and I think there is good solution for this situation.
(By the way: I don't want any workarounds like using a counterField in the Recordsets)
Long description:
I use an accessform to fill data into my database. Because I needed to add some extra check-ups I choose to take control over the moving between record, deleting and creating new records. So there are 'Home-made'-buttons (Next, Previous and New) on the form.
On the form there is also a control (lets call it RecordID-control) that shows the current RecordID (in this case a number). This is very handy for the users. As normal I use Autonumbering for handeling the RecordID-numbering.
If a user enters data in one of the controls. The new RecordID is shown in the RecordID-control (as it should). For some important reason the can user decide to stop entering data and do something else. He can look on other records (using the back and forward buttons) or even close the access-application.
To prevent data-corruption the newly created record must therefore be cleared.
Now I simply want to do this without losing a RecordIDNumber, so the numbering stays logical.
There must be a way to delete the new record, without losing the ID. Or even better: Prevent the newly created record to update to the record, as if it never excisted.
As written before, I think the solution should be possible and it is probably extremely simply, but I really cannot find it.
Thanks for answering my question.
BSc Marc Schillemans, Crams, The Netherlands
Question in short: I like to clear a partially filled form of new record without losing the current Record ID.
Short description:
A user enters data in a form, but while doing this decides he wants to stop. He then closes the accessform or goes back to another record. The form is cleared, but the recordID is lost. It is not a real problem, but the users dislike it very much and I think there is good solution for this situation.
(By the way: I don't want any workarounds like using a counterField in the Recordsets)
Long description:
I use an accessform to fill data into my database. Because I needed to add some extra check-ups I choose to take control over the moving between record, deleting and creating new records. So there are 'Home-made'-buttons (Next, Previous and New) on the form.
On the form there is also a control (lets call it RecordID-control) that shows the current RecordID (in this case a number). This is very handy for the users. As normal I use Autonumbering for handeling the RecordID-numbering.
If a user enters data in one of the controls. The new RecordID is shown in the RecordID-control (as it should). For some important reason the can user decide to stop entering data and do something else. He can look on other records (using the back and forward buttons) or even close the access-application.
To prevent data-corruption the newly created record must therefore be cleared.
Now I simply want to do this without losing a RecordIDNumber, so the numbering stays logical.
There must be a way to delete the new record, without losing the ID. Or even better: Prevent the newly created record to update to the record, as if it never excisted.
As written before, I think the solution should be possible and it is probably extremely simply, but I really cannot find it.
Thanks for answering my question.
BSc Marc Schillemans, Crams, The Netherlands
