RE: [AccessDevelopers] Auto Numbers

Jay,

There are some of us who subscribe to multiple groups so posting the same question across more than one group is a bit annoying. If you don't get an answer in one group, then it might be appropriate to either clarify your question or post to another group.

Apparently your profile number field is an Autonumber (based on your message subject). If this is the case, you can't change the numbers or fill in the gaps. If you feel compelled to do this, then you aren't using the autonumber correctly.

Duane Hookom MVP
MS Access
________________________________
> To: AccessDevelopers@yahoogroups.com; MS_Access_Professionals@yahoogroups.com
> From: jay@thebeckhams.us
> Date: Tue, 9 Apr 2013 19:26:38 -0400
> Subject: [AccessDevelopers] Auto Numbers
>
>
>
> I have an existing table with a profile number I want to generate on
> additions to the table automatically. The numbers are between 1 and
> 1500 with some missing numbers. I tried just change the profile (is
> also the Key) and it won't let me.
>
>
>
> How can I take care of this?
>
>
>
> Thanks
>
>
>
> Jay Beckham
>
>
>
> Berkeley Springs, WV
>
>
>
> Inch by Inch, Anything's A Cinch… Robert Schuller.
>
>
>
> "Doing what you love is Freedom. Loving what you do is Happiness"
>
> From a Chinese Fortune Cookie
>
>
>
>
>
>
>

------------------------------------


Please zip all files prior to uploading to Files section.Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessDevelopers/join
(Yahoo! ID required)

<*> To change settings via email:
AccessDevelopers-digest@yahoogroups.com
AccessDevelopers-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/