records. The ID field(autonumber) went from 1 to 2890.
I then created a new db with this data. When I added a record it
numbered it 45679876. The next record was numbered 45679877. So why is
it adding numbers in this range? Is there a way to continue from 2890?
Gary
--- In [email protected], "Squires, Neil" <[EMAIL PROTECTED]> wrote:
>
> Gary,
>
> After you pass the number 9999, there needs to be some place to go.
Long integers can grow a lot bigger that 10,000. Otherwise they
would not make good UID's.
>
> Neil Squires
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
> Behalf Of Gary
> Sent: Tuesday, May 30, 2006 2:46 PM
> To: [email protected]
> Subject: [ms_access] Re: Autonumber Problems
>
>
> I only have "Increment" and "Random" in the Autonumber field
> properties. I'm using Access 2000. THe field is defined as "Integer
Long".
>
> The number it adds is in sequence, if I enter two in a row. But they
> are 8 digits versus the 4 digit number I set up.
>
> Gary
> --- In [email protected], Brett Collings
> <brett.collings012@> wrote:
> >
> > Gary, your Autonumber default is set to "random" instead of
> "sequential".
> >
> > Open the table in design mode , click on the autonumber field and
> you'll
> > see where to change it in the botttom of the design form in the
> properties
> >
> > Brett
> >
> > Gary wrote:
> >
> > > I created a DB and inported my data from XLS. I have a field
called ID
> > > that is autonumbered. When I try and add a new record I get a number
> > > like "45872568" instead of the next number in sequence like "2785".
> > >
> > > Could someone help me figure out what I did wrong. I'm using
> Access 97.
> > >
> > > Gary
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > SPONSORED LINKS
> > > Microsoft access database
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA>
>
> > > Database development software
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w>
>
> > > Database management software
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg>
>
> > >
> > > Database software
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg>
>
> > > Inventory database software
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw>
>
> > > Membership database software
> > >
>
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg>
>
> > >
> > >
> > >
> > >
> ------------------------------------------------------------------------
> > > YAHOO! GROUPS LINKS
> > >
> > > * Visit your group "ms_access
> > > <http://groups.yahoo.com/group/ms_access>" on the web.
> > >
> > > * To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > >
> <mailto:[EMAIL PROTECTED]>
> > >
> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > > Service <http://docs.yahoo.com/info/terms/>.
> > >
> > >
> > >
> ------------------------------------------------------------------------
> > >
> >
> > -------------------------------
> > This email message and any attachment(s) is intended only for the
> > person(s) or entity(entities) to whom it is addressed. The
> > information it contains may be classified as IN CONFIDENCE and may be
> > legally privileged. If you are not the intended recipient any use,
> > disclosure or copying of the message or attachment(s) is strictly
> > prohibited. If you have received this message in error please
> > notify us immediately and destroy it and any attachment(s).
> > Thank you. The Ministry of Social Development accepts no
> > responsibility for changes made to this message or to any
> > attachment(s) after transmission from the Ministry.
> > -------------------------------
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
