{SOLVED} Access (Auto Number)

123mike123 · 12-Mar-2001, 03: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** · 12-Mar-2001, 04:07 PM #2

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 · 12-Mar-2001, 04:16 PM #3

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

Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming gpu hard drive hardware hdmi internet laptop malware memory monitor motherboard netgear network printer problem ram registry router security slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

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

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!