AutoNumber For Dummies!

D

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.
 
K

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.
 
D

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,
 
J

James A. Fortune

Danny said:
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.
Click to expand...

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
[email protected]
 
G

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.
 
Top