Access, vb and rnd
I am trying to get a random number as my key, but always a positive and always 6 digits (and obveously no duplicates).
I have read on forums that this can be done with visual basic - I have the script and I can open the vb editor in access - but thats me stuck!!
WHERE do i write the script in vb editor, and HOW do i then use this script in my access table?
Could someone hold my hand (virtually that is, no funny emails please!) and walk me through.
My head hurts!