There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
antivirus audio avg avg 8 backup bios boot browser bsod computer cpu crash css desktop driver dvd email error excel explorer firefox firefox 3 freeze game graphics hard drive hardware help please hijackthis hjt install internet internet explorer itunes javascript keyboard lan laptop malware missing monitor msn network networking openoffice outlook outlook 2003 outlook express php popups problem router screen seo slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp wireless word
Archive: Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications > Archive: Business Applications >
{SOLVED} Access (Auto Number)


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
123mike123's Avatar
Junior Member with 2 posts.
 
Join Date: Mar 2001
12-Mar-2001, 02:55 PM #1
Hello!
I have a problem with MS Access. I need the Auto_Number to start from 6000, And every new record that is saved should have a sequential number.

Many Thanks
Anne Troy's Avatar
Computer Specs
Administrator with 11,442 posts.
 
Join Date: Feb 1999
Location: Allentown, PA
Experience: Microsoft Word MVP
12-Mar-2001, 03:07 PM #2
Welcome to TSG!
Then here's what you do.

Create your autonumber field. Now, in the design view, bottom part, Format, put this:

6000

Pretty nifty, huh?
123mike123's Avatar
Junior Member with 2 posts.
 
Join Date: Mar 2001
12-Mar-2001, 03:16 PM #3
Thanks Dreamboat !!!
Many thanks for your reply and help, as i'm sure you know, it worked perfectly!!!!
Hope i'm able to help you in the future.

Cheers

Mike
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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 Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 07:39 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.