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.
