[mso] Re: Autonumbers in Access
- From: "Leeba Friedman" <leebaf@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 3 Jul 2003 18:48:09 +0200
My auto number was changed to random because I made a replication (which
messed me up badly). With replication all auto numbers turn to random
and you can't change it back. I ended up redoing it which is a lot of
work but not terrible.
Maybe someone knows I changed a field named idcode to number (it was
autonumber) and built another one idcode1 to have autonumber. The
problem is I have in other tables the same idcode but not all of them.
Is there a quick way to change them to idcode1. for example idcode was
123 and is now 324 but there are 4000 records to change more or less.
Thank you all,
Leeba
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Colli, Anthony G
Sent: Thursday, July 03, 2003 4:54 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Autonumbers in Access
Leeba-
By it's nature autonumber is not random so I am not exactly sure what
your asking. Autonumber can start at any number and increment by any
interval so maybe this is what you need? I am sure it can be constrained
to certain limits too, but I have never needed that functionality.
You can create random numbers too. These can be constrained to any
upper/lower limits, but computers are not very random, they like
explicit instructions.
-Anthony
-----Original Message-----
From: Leeba Friedman [ mailto:leebaf@xxxxxxxxxxxx]
Sent: Thursday, July 03, 2003 4:18 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Autonumbers in Access
HI. I have a question. Is it possible to have an auto number (random)
within specific bounds, For example, up to 4 digits.
Leeba
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
