ACCESS FEED: RE: [MS_AccessPros] Auto Numbers

Rabu, 10 April 2013

RE: [MS_AccessPros] Auto Numbers

Jay-

Further to Duane's comments - You can change AutoNumber to Number, Long
Integer, but you can't go the other way directly if there is data in the
table. To take a table containing data that has a Long Integer field and
convert that field to AutoNumber, do:

1) Select the table in the DB Window / Nav Pane and copy it to the
clipboard.

2) Paste - structure only - into a new table.

3) Open the new table in Design View and change to AutoNumber.

4) Paste-Append the data on the clipboard to the new table.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, April 10, 2013 5:13 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] 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
<mailto:AccessDevelopers%40yahoogroups.com> ;
MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> From: jay@thebeckhams.us <mailto:jay%40thebeckhams.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
>
>
>

[Non-text portions of this message have been removed]