Prev: hola
Next: Invoicing database design
From: ksgolfer on 3 Nov 2009 19:09 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?
From: Jeanette Cunningham on 4 Nov 2009 01:01 "ksgolfer" <ksgolfer(a)discussions.microsoft.com> wrote in message news:7C4E7BD2-4C22-4FEE-93D2-50CD6FB80BFF(a)microsoft.com... >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?
From: Jeanette Cunningham on 4 Nov 2009 01:07 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/forum/forum_posts.asp?TID=395 Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "ksgolfer" <ksgolfer(a)discussions.microsoft.com> wrote in message news:7C4E7BD2-4C22-4FEE-93D2-50CD6FB80BFF(a)microsoft.com... >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?
From: Jeff Boyce on 4 Nov 2009 08:13 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" <ksgolfer(a)discussions.microsoft.com> wrote in message news:7C4E7BD2-4C22-4FEE-93D2-50CD6FB80BFF(a)microsoft.com... >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?
|
Pages: 1 Prev: hola Next: Invoicing database design |