Beginner's Append Query Problem

[p.numminen]

I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
but I couldn't choose the table to which I would have appended because
that table wasn't on the list in the Append dialog box. Why is this
and how to fix?

 

[John W. Vinson]

I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
but I couldn't choose the table to which I would have appended because
that table wasn't on the list in the Append dialog box. Why is this
and how to fix?

Did you create and save the table? It's not going to be there all by itself...

as the website says:

Create a temporary table with just one field, a Number field; set its
FieldSize property to Long Integer and give it the same name as the AutoNumber
field in the table whose value you want to change.


John W. Vinson [MVP]