You'll have to generate it elsewhere and update the table. If
Access has
GUID columns (I don't think it does), one pretty easy way
would be to take
the rightmost 5 characters of a GUID cast to a string. I
think you're going
to be stuck doing it yourself, though. Or downloading a copy
of SQL Server
Express... ;)
"Jason Cook" <jason@gcstulsa.com> wrote in message
news:fa580k$sl2$1@forums.macromedia.com...
> How do I generate a 5-digit alphanumeric code for each
of the 500 records
> in my database and write those values into my new
TheCode field (which is
> currently blank)?
>
1
Reply
AdChoices