DS said:If you start a record, but decide to cancel it. What is the syntax to
delete all traces of it. I need to be able to hit cancel..lets say
its record 10...so that the next time I open a new record I'll be
able to use record 10.
Clueless.
Thanks
DS
Actually, I am using AutoNumber, is there a way to mark it as cancelled,Rick said:If you're talking about an AutoNumber then you can't. Once you start a record
that number is consumed. Any time you care about the value in any way other
than uniqueness do not use an AutoNumber.
I'm Actually using a touch screen so the users have no access to aRick said:You could add a Yes/No field called "Cancelled" and set that to true to indicate
that a record was cancelled, but you would need to do that *instead of* actually
cancelling with the Escape key. If a user actually uses the escape key to
cancel a record then you will still be missing a number.
If the idea is to end up with an unbroken sequence of incrementing numbers then
there are numerous (completely normal) operations that will break this if you
use an AutoNumber.
DS said:If you start a record, but decide to cancel it. What is the syntax to
delete all traces of it. I need to be able to hit cancel..lets say its
record 10...so that the next time I open a new record I'll be able to use
record 10.
Clueless.
Thanks
DS
Rick Brandt said:If you're talking about an AutoNumber then you can't. Once you start a
record that number is consumed. Any time you care about the value in any
way other than uniqueness do not use an AutoNumber.
DS said:Actually, I am using AutoNumber, is there a way to mark it as cancelled,
then go on to the next time. I don't really care about the number itself,
as long as I can see that it was cancelled, thats enough for me. So I
still need to know how to cancel it.
Thanks
DS
Rick Brandt said:You could add a Yes/No field called "Cancelled" and set that to true to
indicate that a record was cancelled, but you would need to do that
*instead of* actually cancelling with the Escape key. If a user actually
uses the escape key to cancel a record then you will still be missing a
number.
If the idea is to end up with an unbroken sequence of incrementing numbers
then there are numerous (completely normal) operations that will break
this if you use an AutoNumber.
DS said:I'm Actually using a touch screen so the users have no access to a
keyboard. The cancel idea sounds good. Thanks
DS