Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.

I mean that I really know very little about codes like that and that I have
NO idea WHERE to paste that sub.

If someone could puh-leeeeease give me the step-by-step instructions I would
be so thankful.
--
~ Danny ~


"James A. Fortune" wrote:

> Danny Baird wrote:
> > Okay what I really need is an answer in simple step-by-step,
> > impossible-to-screw-up intructions for the following PROBLEM: Where do I
> > enter the minimum value for an AutoNumber? It starts at 1 which is obviously
> > inconvenient for a lot of applications.
> >
> > I need an automatic numbering system that starts at 10000, it doesn't matter
> > if a number is skipped because someone deletes a record, just as long as the
> > numbers are sequential and don't use any numbers before the minimum (10000).
> >
> > Please be patient with me and explain where I go to do the magic and what
> > tricks I'll need to perform because I'm very new to this.
> >
> > Thanks,
>
> I think Allen Browne did that here:
>
> http://allenbrowne.com/ser-26.html
>
> James A. Fortune
> MPAPoster@FortuneJames.com

Create an append query to append a dummy record to be deleted once you have
the database running. In the record to be added to the table have the value
of the autonumber field for the new record at 9999 and and some other value
in othe fields.
--
KARL DEWEY
Build a little - Test a little


"Danny Baird" wrote:

> Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.
>
> I mean that I really know very little about codes like that and that I have
> NO idea WHERE to paste that sub.
>
> If someone could puh-leeeeease give me the step-by-step instructions I would
> be so thankful.
> --
> ~ Danny ~
>
>
> "James A. Fortune" wrote:
>
> > Danny Baird wrote:
> > > Okay what I really need is an answer in simple step-by-step,
> > > impossible-to-screw-up intructions for the following PROBLEM: Where do I
> > > enter the minimum value for an AutoNumber? It starts at 1 which is obviously
> > > inconvenient for a lot of applications.
> > >
> > > I need an automatic numbering system that starts at 10000, it doesn't matter
> > > if a number is skipped because someone deletes a record, just as long as the
> > > numbers are sequential and don't use any numbers before the minimum (10000).
> > >
> > > Please be patient with me and explain where I go to do the magic and what
> > > tricks I'll need to perform because I'm very new to this.
> > >
> > > Thanks,
> >
> > I think Allen Browne did that here:
> >
> > http://allenbrowne.com/ser-26.html
> >
> > James A. Fortune
> > MPAPoster@FortuneJames.com

Okay, now how would I do that????

What you just said was a bit over my head.

I need step-by-step instructions!

Thanks,
--
~ Danny ~


"KARL DEWEY" wrote:

> Create an append query to append a dummy record to be deleted once you have
> the database running. In the record to be added to the table have the value
> of the autonumber field for the new record at 9999 and and some other value
> in othe fields.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Danny Baird" wrote:
>
> > Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.
> >
> > I mean that I really know very little about codes like that and that I have
> > NO idea WHERE to paste that sub.
> >
> > If someone could puh-leeeeease give me the step-by-step instructions I would
> > be so thankful.
> > --
> > ~ Danny ~
> >
> >
> > "James A. Fortune" wrote:
> >
> > > Danny Baird wrote:
> > > > Okay what I really need is an answer in simple step-by-step,
> > > > impossible-to-screw-up intructions for the following PROBLEM: Where do I
> > > > enter the minimum value for an AutoNumber? It starts at 1 which is obviously
> > > > inconvenient for a lot of applications.
> > > >
> > > > I need an automatic numbering system that starts at 10000, it doesn't matter
> > > > if a number is skipped because someone deletes a record, just as long as the
> > > > numbers are sequential and don't use any numbers before the minimum (10000).
> > > >
> > > > Please be patient with me and explain where I go to do the magic and what
> > > > tricks I'll need to perform because I'm very new to this.
> > > >
> > > > Thanks,
> > >
> > > I think Allen Browne did that here:
> > >
> > > http://allenbrowne.com/ser-26.html
> > >
> > > James A. Fortune
> > > MPAPoster@FortuneJames.com

Danny Baird wrote:
> Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.
>
> I mean that I really know very little about codes like that and that I have
> NO idea WHERE to paste that sub.
>
> If someone could puh-leeeeease give me the step-by-step instructions I would
> be so thankful.

Danny,

It is customary to reply to the messages from the original post rather
than starting a new post. The threads are easier to follow that way.

James A. Fortune
MPAPoster@FortuneJames.com

BACKUP your file first.
Start a new query in design view. Go to sql view (right click where the
tables normally go and select sql.) Type:
Alter Table yourtablename
add colum ID counter (1000,1)
(or whatever you want the numbers to be)
Switch to design view.
Change the query to a make-table query. Run it.

"Danny Baird" wrote:

> Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.
>
> I mean that I really know very little about codes like that and that I have
> NO idea WHERE to paste that sub.
>
> If someone could puh-leeeeease give me the step-by-step instructions I would
> be so thankful.
> --
> ~ Danny ~
>
>
> "James A. Fortune" wrote:
>
> > Danny Baird wrote:
> > > Okay what I really need is an answer in simple step-by-step,
> > > impossible-to-screw-up intructions for the following PROBLEM: Where do I
> > > enter the minimum value for an AutoNumber? It starts at 1 which is obviously
> > > inconvenient for a lot of applications.
> > >
> > > I need an automatic numbering system that starts at 10000, it doesn't matter
> > > if a number is skipped because someone deletes a record, just as long as the
> > > numbers are sequential and don't use any numbers before the minimum (10000).
> > >
> > > Please be patient with me and explain where I go to do the magic and what
> > > tricks I'll need to perform because I'm very new to this.
> > >
> > > Thanks,
> >
> > I think Allen Browne did that here:
> >
> > http://allenbrowne.com/ser-26.html
> >
> > James A. Fortune
> > MPAPoster@FortuneJames.com

Post your table structure - field names and datatype.
--
KARL DEWEY
Build a little - Test a little


"Danny Baird" wrote:

> Okay, now how would I do that????
>
> What you just said was a bit over my head.
>
> I need step-by-step instructions!
>
> Thanks,
> --
> ~ Danny ~
>
>
> "KARL DEWEY" wrote:
>
> > Create an append query to append a dummy record to be deleted once you have
> > the database running. In the record to be added to the table have the value
> > of the autonumber field for the new record at 9999 and and some other value
> > in othe fields.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "Danny Baird" wrote:
> >
> > > Very helpful J.A.F., but like I said I need someone to explain the WHERE to me.
> > >
> > > I mean that I really know very little about codes like that and that I have
> > > NO idea WHERE to paste that sub.
> > >
> > > If someone could puh-leeeeease give me the step-by-step instructions I would
> > > be so thankful.
> > > --
> > > ~ Danny ~
> > >
> > >
> > > "James A. Fortune" wrote:
> > >
> > > > Danny Baird wrote:
> > > > > Okay what I really need is an answer in simple step-by-step,
> > > > > impossible-to-screw-up intructions for the following PROBLEM: Where do I
> > > > > enter the minimum value for an AutoNumber? It starts at 1 which is obviously
> > > > > inconvenient for a lot of applications.
> > > > >
> > > > > I need an automatic numbering system that starts at 10000, it doesn't matter
> > > > > if a number is skipped because someone deletes a record, just as long as the
> > > > > numbers are sequential and don't use any numbers before the minimum (10000).
> > > > >
> > > > > Please be patient with me and explain where I go to do the magic and what
> > > > > tricks I'll need to perform because I'm very new to this.
> > > > >
> > > > > Thanks,
> > > >
> > > > I think Allen Browne did that here:
> > > >
> > > > http://allenbrowne.com/ser-26.html
> > > >
> > > > James A. Fortune
> > > > MPAPoster@FortuneJames.com