ACCESS FEED: Re: [MS_AccessPros] Access 2003 - Need to AutoNumber starting with 000001...HELP

Kamis, 01 September 2011

Re: [MS_AccessPros] Access 2003 - Need to AutoNumber starting with 000001...HELP

Hmmm, well I need it to be my PK #. Is that possible, to be a PK # and display as a 000001?

Thanks,

Florence

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Hi Florence
>
>
>
> An Auto Number is not going to work for you unless you just need it to *display*
> in forms and reports with leading zeros.
>
>
>
> AutoNumbers are Long data types which means they are numbers. Only text data
> types can have leading zeros.
>
>
>
> So the question is: "Do you want numbers or text?" The numbers would be easier
> to maintain because you can take advantage of the automatic incrementing.
>
>
>
> Let us know so we can proceed to a viable solution for you.
>
>
>
> And thanks for visiting my site and using the link.
>
>
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT <http://thatlldoit.com> http://thatlldoit.com
> MS Access MVP
> <http://mvp.support.microsoft.com/profile/Bill.Mosca>
> http://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of florenceps1217
> Sent: Thursday, September 01, 2011 11:19 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Access 2003 - Need to AutoNumber starting with
> 000001...HELP
>
>
>
>
>
> I'm creating a db in Access 2003 where they want the autonumbers to start with
> six numerals as follows: 000001. Have been looking all morning for an answer.
>
> Can anyone help me?
>
> Thank you.
>
> FlorencePS
>
> PS: And thank you, Bill Mosca, for having this link on your website. Much
> appreciated.
>
> ._,___
>
>
>
> [Non-text portions of this message have been removed]
>