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
<[EMAIL PROTECTED]> 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]
>
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.
