PC Review


Reply
Thread Tools Rate Thread

Change the initial number for AutoNumber to begin with

 
 
Jennifer
Guest
Posts: n/a
 
      11th Mar 2004
Can someone explain how I change my autonumber's beginning
number? I don't want 1, I want 400,000. I tried doing it
through Access help (with my program) and it didn't work!

I created a new table, Table1, with same field name that I
want to change (Invoice#)and added 399999 as a long
integer. Then I created a query with Invoice# field from
Table1, dragged Invoive# from top of query to Invoice#
field in list below, datasheet, run, design. After this I
understood I was supposed to delete Table1 and after this
I'm lost...
Thanks in advance for the help!
 
Reply With Quote
 
 
 
 
StCyrM
Guest
Posts: n/a
 
      11th Mar 2004
Hi Jennifer

The following procedure will do it for you.

Best regards
Maurice


By design, Microsoft Access always numbers AutoNumber fields beginning
with the number 1. You cannot edit an AutoNumber field or change its
starting value.

However, you can force Microsoft Access to number an AutoNumber field with
a number you choose by following these general steps:

- Copy the design of the original table in which you want to set the
starting AutoNumber value to a new table.


- Change the AutoNumber field in the new table to a Number field with a
FieldSize property of Long Integer.

- Add a record to the new table, and set the Number field to a value that
is one less than the starting number you want for your original table.
For example, if you want the AutoNumber field to start at 100, type 99
in the Number field of the new table.

- Use an append query to add a this new record to your original table.
This action forces Microsoft Access to number any new AutoNumber
fields with your number plus 1.




>Can someone explain how I change my autonumber's beginning
>number? I don't want 1, I want 400,000. I tried doing it
>through Access help (with my program) and it didn't work!
>
>I created a new table, Table1, with same field name that I
>want to change (Invoice#)and added 399999 as a long
>integer. Then I created a query with Invoice# field from
>Table1, dragged Invoive# from top of query to Invoice#
>field in list below, datasheet, run, design. After this I
>understood I was supposed to delete Table1 and after this
>I'm lost...
>Thanks in advance for the help!
>
>
>
>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook hnags after initial launch. Name and Initial dialog box di Francis Microsoft Outlook Installation 8 4th Jun 2008 07:39 PM
Can I Begin Autonumber >1 =?Utf-8?B?QmVu?= Microsoft Access 2 17th Nov 2005 02:39 PM
Remove middle initial from "first name middle initial" =?Utf-8?B?SnVzdGluIEYu?= Microsoft Excel Misc 15 26th Sep 2005 06:13 PM
How do I change the auto number to begin with the number I want? =?Utf-8?B?TWljaGVsbGU=?= Microsoft Access 4 5th Aug 2005 04:04 PM
Autonumber Begin at 00101 DD Microsoft Access Database Table Design 1 4th May 2004 12:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:27 AM.