Search results

Thanks, Actually I've done exactly this by replacing the Autonumber with just a number and then i check each time the last record and add 1 to it. I only have some doubts what will happen when the Data base becomes too big, but for feew records of testing it works just fine. Nir.

I have encountered the following "problem" - When the key field is AutoNumber, the number is generated whenever I type something in thet record. If I regret and delete all record content, the key number is "lost". The record does not appear in the table but the next record will be indexed as if...

Thanks Thanks guys. It's working nicely. :)

hi I am building an application in which the user has to enter a ProjectName that is a key (no duplicate). For that I wish to validate the entered value in the Field level (I thank everybody that bothered to respond to my previous thread). I've wrote this piece of code ...

I wish to validate field value on a form before leaving to the next control, and remain in the control until input is validated. Help on this will be highly appreciated.