John-
If you already have an AutoNumber PKey, then you'll have to maintain this
"sequence" field in code. You can use DMax in the BeforeUpdate event of the
form when on a new record (Me.NewRecord = True) to find out the previous high
number and add 1.
Why only up to 1000? Do you start over again after 1000?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John S Moss
Sent: Saturday, November 26, 2011 3:08 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Increment Number
Yes, the auto-number is the Primary Key.
All I need to to auto-increment a number field from 1 up to 1000. My
client wants a sequential Box Number for each box shipped. If there's a
better or easier way to achieve the same result, please let me know.
Thanks.
On 11/26/2011 1:07 AM, John Viescas wrote:
>
> John-
>
> The COUNTER data type is the equivalent of the Access AutoNumber. Do you
> already have an AutoNumber in the table? If so, what is its purpose?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>] On Behalf Of yshopper
> Sent: Friday, November 25, 2011 11:59 PM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Increment Number
>
> I tried using an AutoNumber but the error says "Access allows only one
> autonumber field per table"
>
> I tried using Text data type, Number data type, nothing works.
>
> Any other ideas?
>
> Thanks for any help.
>
> John
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "Clive"
> <zctek@...> wrote:
> >
> > Hi John,
> >
> > The FieldType must be of Type: AutoNumber which you
> > can select from the DropDown in the 2nd column of the
> > table in DesignView.
> > It will create FieldSize of LongInteger.
> >
> > If you link to an AutoNumber field then the linking
> > field must also be a LongInteger.
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>, "yshopper"
> <jlinux@> wrote:
> > >
> > > I am trying to change a field type so that the Number increments 1
> for each
> new record. After I go to Query Design, Close Table box, Click Data
> Definition
> and type in
> > >
> > > "Alter TABLE tbl_Items Alter Column BoxNumber COUNTER (1000,1)"
> > >
> > > I get the error "Invalid Field Data type"
> > >
> > > How can I fix this? I've tried changing the Data Type using Number
> and Text,
> but both result in the same error.
> > >
> > > Thanks,
> > > John
> > >
> >
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar