|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 19th, 2006, 10:06 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
4 digit auto number
I am looking for help to start off my "Project Number" field with and auto
four digit number, Can someone please help? 
|
|
#2
January 19th, 2006, 10:42 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
4 digit auto number
raj wrote:
I am looking for help to start off my "Project Number" field with and auto four digit number, Can someone please help? AutoNumbers are generally not a good idea for anything but "behind the scenes" usage, but to do what you want you can use an append query to append one row to your table with the value 999 for the AutoNumber field, then immediately delete that record afterwards. The next record added after that will be 1000. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
|
|
#3
January 19th, 2006, 11:06 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
4 digit auto number
I think I understand but since I'm a newbie, can someone explain or provide
an example? Thank you! "Rick Brandt" wrote: raj wrote: I am looking for help to start off my "Project Number" field with and auto four digit number, Can someone please help? AutoNumbers are generally not a good idea for anything but "behind the scenes" usage, but to do what you want you can use an append query to append one row to your table with the value 999 for the AutoNumber field, then immediately delete that record afterwards. The next record added after that will be 1000. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
|
|
#4
January 21st, 2006, 08:54 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
4 digit auto number
Raj,
Using the query designer... 1. Make a new query. Do not add any tables to the top panel of the query design window. 2. Type 999 into the Field row of the first column of the grid. 3. Make it an Append Query (select Append from the Query menu), and nominate your table as the table to append to. 4. In the Append To row in the first column of the grid, enter your Autonumber field. 5. Run the query (click the toolbar button with the red ! icon). 6. Close and don't save the query. 7. Open the table datasheet and delete the newlay appended record. -- Steve Schapel, Microsoft Access MVP raj wrote: I think I understand but since I'm a newbie, can someone explain or provide an example? Thank you!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I change a field property from text to Auto number? | Joyce | General Discussion | 5 | October 21st, 2005 05:55 PM |
| Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
| 16 digit number wont keep alteration unless format cell to text | Croc001 | General Discussion | 3 | March 30th, 2005 09:12 AM |
| Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
| 18 digit number | kit | Worksheet Functions | 2 | December 9th, 2003 11:58 PM |
Linear Mode
