A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access auto numbers



 
 
Thread Tools Display Modes
  #1  
Old November 4th, 2009, 01:09 AM posted to microsoft.public.access.tablesdbdesign
ksgolfer
external usenet poster
 
Posts: 2
Default Access auto numbers

I have just started using access 2007. I used 2000 in the past. I need help
with handling auto numbers. In my 2000 data base I had a Serial Number field
that I had populated by auto number seeded from a table with a number
starting at 1000. I'm having a problem reconstructing a similar database
using auto number in that field. I can change the format to get the 4 digit
number, but when I run a query to find a certain serial number, I can't find
it unless I enter just the last 3 digits. How can I create a serial number
field starting at 1000 in stead of 1?

I am not up on Visual Basic coding. It would to build the serial number
using the format of the last 2 digits of the year and a 4 digit number, like
09-1001. Can anyone make this simple?
  #2  
Old November 4th, 2009, 07:01 AM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Access auto numbers


"ksgolfer" wrote in message
...
I have just started using access 2007. I used 2000 in the past. I need help
with handling auto numbers. In my 2000 data base I had a Serial Number
field
that I had populated by auto number seeded from a table with a number
starting at 1000. I'm having a problem reconstructing a similar database
using auto number in that field. I can change the format to get the 4
digit
number, but when I run a query to find a certain serial number, I can't
find
it unless I enter just the last 3 digits. How can I create a serial number
field starting at 1000 in stead of 1?

I am not up on Visual Basic coding. It would to build the serial number
using the format of the last 2 digits of the year and a 4 digit number,
like
09-1001. Can anyone make this simple?



  #3  
Old November 4th, 2009, 07:07 AM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Access auto numbers

hi ksgolfer,
see if this sample database from Rogers access library will help you.
The sample is about creating your own autonumbers.

http://www.rogersaccesslibrary.com/f...ts.asp?TID=395


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"ksgolfer" wrote in message
...
I have just started using access 2007. I used 2000 in the past. I need help
with handling auto numbers. In my 2000 data base I had a Serial Number
field
that I had populated by auto number seeded from a table with a number
starting at 1000. I'm having a problem reconstructing a similar database
using auto number in that field. I can change the format to get the 4
digit
number, but when I run a query to find a certain serial number, I can't
find
it unless I enter just the last 3 digits. How can I create a serial number
field starting at 1000 in stead of 1?

I am not up on Visual Basic coding. It would to build the serial number
using the format of the last 2 digits of the year and a 4 digit number,
like
09-1001. Can anyone make this simple?



  #4  
Old November 4th, 2009, 02:13 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Access auto numbers

Jeanette's offered a link to a way to build your own... take it!

The Access Autonumber is intended to be used as a unique identifier. It is
generally unfit for human consumption, and at some point, almost guaranteed
NOT to remain sequential.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"ksgolfer" wrote in message
...
I have just started using access 2007. I used 2000 in the past. I need help
with handling auto numbers. In my 2000 data base I had a Serial Number
field
that I had populated by auto number seeded from a table with a number
starting at 1000. I'm having a problem reconstructing a similar database
using auto number in that field. I can change the format to get the 4
digit
number, but when I run a query to find a certain serial number, I can't
find
it unless I enter just the last 3 digits. How can I create a serial number
field starting at 1000 in stead of 1?

I am not up on Visual Basic coding. It would to build the serial number
using the format of the last 2 digits of the year and a 4 digit number,
like
09-1001. Can anyone make this simple?



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.