Auto Number "Olan Gotcher" <olan[ at ]jographix.com> 26.09.2006 00:13:53 I have imported a old data base into Access 2003 and have a auto-number field that was being used in the old file. It is a membership number and needs to increment by one for each new member. I need to give it a starting number (for instance 8650) and have it go on from there but I have not been able to get it to do that. It always wants to start at 1 and continue from that point. I know there must be a way to do this but as of now I have not figured it out. I am just entering the numbers manually at this point but would really like to have Access put that number in automatically. Thanks Olan Gotcher

Re: Auto Number "Fred Boer" <fredboer1[ at ]NOyahooSPAM.com> 26.09.2006 01:22:22 Dear Olan: It sounds like you want a custom autonumber field. There is a helpful sample database here that presents a solution: http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb HTH Fred Boer "Olan Gotcher" <olan[ at ]jographix.com> wrote in message news:45186449$0$4818$6d36acad[ at ]fe2.nntpserver.com... [Quoted Text] > I have imported a old data base into Access 2003 and have a auto-number > field that was being used in the old file. It is a membership number and > needs to increment by one for each new member. I need to give it a starting > number (for instance 8650) and have it go on from there but I have not been > able to get it to do that. It always wants to start at 1 and continue from > that point. I know there must be a way to do this but as of now I have not > figured it out. I am just entering the numbers manually at this point but > would really like to have Access put that number in automatically. > > Thanks > Olan Gotcher > >

Re: Auto Number "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 26.09.2006 21:30:43 Olan: I answered this for you a few days ago, when you asked in microsoft.public.access.devtoolkits. Was there something you didn't understand about that answer? If so, you never posted any follow-up questions to that newsgroup (which would have been appropriate than starting a new thread in another newsgroup...) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Olan Gotcher" <olan[ at ]jographix.com> wrote in message news:45186449$0$4818$6d36acad[ at ]fe2.nntpserver.com... [Quoted Text] >I have imported a old data base into Access 2003 and have a auto-number >field that was being used in the old file. It is a membership number and >needs to increment by one for each new member. I need to give it a >starting number (for instance 8650) and have it go on from there but I have >not been able to get it to do that. It always wants to start at 1 and >continue from that point. I know there must be a way to do this but as of >now I have not figured it out. I am just entering the numbers manually at >this point but would really like to have Access put that number in >automatically. > > Thanks > Olan Gotcher >

Re: Auto Number "Olan Gotcher" <olan[ at ]jographix.com> 27.09.2006 12:28:31 For some reason I never saw it come up on the message group. I am not sure what was going on but in my newsgroup messages it never went past 9/22/06 so I never saw my message or any reply. I tried another message group to see if that would work and it seems to have helped but it is still very slow in getting updates for me to read. I am sorry if you answered it in the other group, but I never got the answer. I will try to find your answer in the other group. Olan Gotcher "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:%234ROHMb4GHA.3604[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > Olan: I answered this for you a few days ago, when you asked in > microsoft.public.access.devtoolkits. Was there something you didn't > understand about that answer? If so, you never posted any follow-up > questions to that newsgroup (which would have been appropriate than > starting a new thread in another newsgroup...) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Olan Gotcher" <olan[ at ]jographix.com> wrote in message > news:45186449$0$4818$6d36acad[ at ]fe2.nntpserver.com... >>I have imported a old data base into Access 2003 and have a auto-number >>field that was being used in the old file. It is a membership number and >>needs to increment by one for each new member. I need to give it a >>starting number (for instance 8650) and have it go on from there but I >>have not been able to get it to do that. It always wants to start at 1 >>and continue from that point. I know there must be a way to do this but >>as of now I have not figured it out. I am just entering the numbers >>manually at this point but would really like to have Access put that >>number in automatically. >> >> Thanks >> Olan Gotcher >> > >

Re: Auto Number "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 27.09.2006 13:07:58 What I posted then: "If you can live with gaps in the numbering, and assuming you've got the existing members in a table already, create a second table that's identical to the existing one, but make the MembershipID an Autonumber field. Create an Append query that takes the data from the existing table and appends it to the new query. The next member you add to the new table will be one more than the last number in the table. "If you can't live with gaps in the numbering, don't use an Autonumber field. Rather, you'll have to "roll your own", by doing a DMax call to the table to determine the current highest number, then adding one to it." -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Olan Gotcher" <olan[ at ]jographix.com> wrote in message news:451a61e7$0$4826$6d36acad[ at ]fe2.nntpserver.com... [Quoted Text] > For some reason I never saw it come up on the message group. I am not > sure what was going on but in my newsgroup messages it never went past > 9/22/06 so I never saw my message or any reply. I tried another message > group to see if that would work and it seems to have helped but it is > still very slow in getting updates for me to read. I am sorry if you > answered it in the other group, but I never got the answer. I will try to > find your answer in the other group. > > Olan Gotcher > > "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message > news:%234ROHMb4GHA.3604[ at ]TK2MSFTNGP03.phx.gbl... >> Olan: I answered this for you a few days ago, when you asked in >> microsoft.public.access.devtoolkits. Was there something you didn't >> understand about that answer? If so, you never posted any follow-up >> questions to that newsgroup (which would have been appropriate than >> starting a new thread in another newsgroup...) >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "Olan Gotcher" <olan[ at ]jographix.com> wrote in message >> news:45186449$0$4818$6d36acad[ at ]fe2.nntpserver.com... >>>I have imported a old data base into Access 2003 and have a auto-number >>>field that was being used in the old file. It is a membership number and >>>needs to increment by one for each new member. I need to give it a >>>starting number (for instance 8650) and have it go on from there but I >>>have not been able to get it to do that. It always wants to start at 1 >>>and continue from that point. I know there must be a way to do this but >>>as of now I have not figured it out. I am just entering the numbers >>>manually at this point but would really like to have Access put that >>>number in automatically. >>> >>> Thanks >>> Olan Gotcher >>> >> >> > >

Re: Auto Number "Olan Gotcher" <olan[ at ]jographix.com> 27.09.2006 13:56:25 Thank you very much for the help. I will give this a shot and see if I can use your idea. Olan Gotcher "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:efRo1Xj4GHA.3600[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > What I posted then: > > "If you can live with gaps in the numbering, and assuming you've got the > existing members in a table already, create a second table that's > identical > to the existing one, but make the MembershipID an Autonumber field. Create > an Append query that takes the data from the existing table and appends it > to the new query. The next member you add to the new table will be one > more > than the last number in the table. > > "If you can't live with gaps in the numbering, don't use an Autonumber > field. > Rather, you'll have to "roll your own", by doing a DMax call to the table > to > determine the current highest number, then adding one to it." > > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Olan Gotcher" <olan[ at ]jographix.com> wrote in message > news:451a61e7$0$4826$6d36acad[ at ]fe2.nntpserver.com... >> For some reason I never saw it come up on the message group. I am not >> sure what was going on but in my newsgroup messages it never went past >> 9/22/06 so I never saw my message or any reply. I tried another message >> group to see if that would work and it seems to have helped but it is >> still very slow in getting updates for me to read. I am sorry if you >> answered it in the other group, but I never got the answer. I will try >> to find your answer in the other group. >> >> Olan Gotcher >> >> "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message >> news:%234ROHMb4GHA.3604[ at ]TK2MSFTNGP03.phx.gbl... >>> Olan: I answered this for you a few days ago, when you asked in >>> microsoft.public.access.devtoolkits. Was there something you didn't >>> understand about that answer? If so, you never posted any follow-up >>> questions to that newsgroup (which would have been appropriate than >>> starting a new thread in another newsgroup...) >>> >>> -- >>> Doug Steele, Microsoft Access MVP >>> http://I.Am/DougSteele >>> (no private e-mails, please) >>> >>> >>> "Olan Gotcher" <olan[ at ]jographix.com> wrote in message >>> news:45186449$0$4818$6d36acad[ at ]fe2.nntpserver.com... >>>>I have imported a old data base into Access 2003 and have a auto-number >>>>field that was being used in the old file. It is a membership number >>>>and needs to increment by one for each new member. I need to give it a >>>>starting number (for instance 8650) and have it go on from there but I >>>>have not been able to get it to do that. It always wants to start at 1 >>>>and continue from that point. I know there must be a way to do this but >>>>as of now I have not figured it out. I am just entering the numbers >>>>manually at this point but would really like to have Access put that >>>>number in automatically. >>>> >>>> Thanks >>>> Olan Gotcher >>>> >>> >>> >> >> > >