Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Increasing number in Customer ID field

Discussion in 'Information Technology' started by Ningle, Jul 28, 2006.

  1. Ningle

    Ningle
    Expand Collapse
    Guest

    Many thanks Joseph Meehan & Ofer Cohen for your replies.

    I should have mentioned in my original question that this is the first time
    I've created a database so am still very new to it all. I've just tried
    searching through Access help & here on the discussion boards about DMax
    function to try and learn about it (what and where to enter etc etc) and I've
    got to admit I'm not quite grasping it.

    A number of replies here have talked about code but I'm afraid to say I
    don't know how or where to put this?

    Any other pointers or is it likely this is something beyond someone of my
    experience can do?

    Many thanks again

    "Ofer Cohen" wrote:

    > Check this link on how to do that using the form
    >
    > http://www.databasedev.co.uk/automatically_increment_value.html
    >
    > about the number, you can use
    >
    > Format([FieldName],"000000")
    >
    >
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Ningle" wrote:
    >
    > > I am almost finished creating a new database which has a table with Customer
    > > Details. The primary key of the table is my Customer ID and I need this to
    > > increase my 1 each time I enter a new record.
    > >
    > > I have looked into autonumber but the problem I'm having is that I have
    > > existing records from my current database that I will be transferring over,
    > > which I can't change the ID of. Over time we have deleted records here and
    > > there so there are also gaps in the sequence.
    > >
    > > How can I set up my new database to accept the existing Customer ID numbers
    > > but start "autonumbering" from a certain point onward?
    > >
    > > Also, any tips on how I can get the Customer ID field to show my number as a
    > > six digit number (ie. 1215 would be shown as 001215)?
    > >
    > > thanks for any help
     
  2. Loading...


  3. Ningle

    Ningle
    Expand Collapse
    Guest

    Please ignore this as I continued searching and have now figured this out!!

    Huge thanks to Joseph & Ofer

    "Ningle" wrote:

    > Many thanks Joseph Meehan & Ofer Cohen for your replies.
    >
    > I should have mentioned in my original question that this is the first time
    > I've created a database so am still very new to it all. I've just tried
    > searching through Access help & here on the discussion boards about DMax
    > function to try and learn about it (what and where to enter etc etc) and I've
    > got to admit I'm not quite grasping it.
    >
    > A number of replies here have talked about code but I'm afraid to say I
    > don't know how or where to put this?
    >
    > Any other pointers or is it likely this is something beyond someone of my
    > experience can do?
    >
    > Many thanks again
    >
    > "Ofer Cohen" wrote:
    >
    > > Check this link on how to do that using the form
    > >
    > > http://www.databasedev.co.uk/automatically_increment_value.html
    > >
    > > about the number, you can use
    > >
    > > Format([FieldName],"000000")
    > >
    > >
    > >
    > > --
    > > Good Luck
    > > BS"D
    > >
    > >
    > > "Ningle" wrote:
    > >
    > > > I am almost finished creating a new database which has a table with Customer
    > > > Details. The primary key of the table is my Customer ID and I need this to
    > > > increase my 1 each time I enter a new record.
    > > >
    > > > I have looked into autonumber but the problem I'm having is that I have
    > > > existing records from my current database that I will be transferring over,
    > > > which I can't change the ID of. Over time we have deleted records here and
    > > > there so there are also gaps in the sequence.
    > > >
    > > > How can I set up my new database to accept the existing Customer ID numbers
    > > > but start "autonumbering" from a certain point onward?
    > > >
    > > > Also, any tips on how I can get the Customer ID field to show my number as a
    > > > six digit number (ie. 1215 would be shown as 001215)?
    > > >
    > > > thanks for any help
     

Share This Page