AutoNumber For Dummies!

[Danny Baird]

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.

 

[KARL DEWEY]

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.

 

[Danny Baird]

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

What you just said was a bit over my head.

I need step-by-step instructions!

Thanks,

 

[James A. Fortune]

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
(e-mail address removed)

 

[Golfinray]

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.

 

[KARL DEWEY]

Post your table structure - field names and datatype.