Hello, Am trying to generate a secret code for each data that is entered into a datbase (the secret code column is the primary key), pls how can i generate this code, any formular or format?, i need help.
from other threads, I'm assuming your using MSAccess. The 'Sequence' functionality Bear mentioned above can also be accomplished in MSAccess. Just set the column you want as the primary key's data type to 'AutoNumber'. As an autonumber field, you never insert or update values in it. Access does everything for you.
I can't take it! You are too smart for me! Here is the tiny ad:
Gift giving made easy with the permaculture playing cards