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: [MS_AccessPros] 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
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar