Can anyone tell me how I can reset the Autonumber field in my table?

I wish to produce a form which refers to info in a particular table.
The table is called Test. The thing is, I also have a second table
called TestVersion. TestVerson has a field containing the ID of a row
in the Test table. Each test has one or more version. So, for my Test

I have a report that lists ~20 items in a subreport.
These items i have sorted presently by aphabetical order.
I would like to be able to allow the user to define a sort order like the
drag and drop method used when setting the tab order of controls on a form.

Is there a convenient way to change an autonumber field to a number
field? I tried using the table design view but received the error:
"You can't change the data type or field size of this field; it is
part of one or more relationships. If you want to change the data type

Am i able to put a buttom on a form that says Delete and one that says
Close.
So after people finish entering in details through the form they can
click on a 'Close' button.

I'm trying to open an access db and upon loading or opening I get Run
Time Error 2465 Can not find field 'cmdLock' referred to in your
expression.  When I go to Debug I see it highlight the line in
question:

I have a form where the user updates information in fields on a form that is
set to Continuous Forms to mimic a data sheet. When it is necessary to add
additional information, the user clicks a button that opens a seperate form
for additional info that is not a part of every ...

I have a large table (Tbl) that contains 450 000 records and 200 fields.  
There are 5 Departments in it (feild Dept) and I want to create 5 tables from
it.
I have been able to do this using the following code:

I have a maintenance collection data base that was working perfectly. The
data is stored on a server so everyone can access it. I had the data entry
form open and was in the middle of putting my data in the server kicked me
off. I thought no big deal. I reopened it and was going ...

This is totally new to me...but I thought maybe it would create less stress
for me, than trying to deal with Dell technical support with whom I had some
very difficult language barriers with and every time they did one thing to
the computer something else would happen to it.  ...

I would like to know if there is a way to print an individual record or use
the ID key…. Perhaps a command button that asks what record or id key to
print and then print only that report or form would be sent to the printer… I
can print now but all my records print every time… ...

On a form I have a button for exporting information in a very small query
and I get the above error. I have tried compiling, compacting and then
exporting but I still get the message.
cheers

When I open Word 2007 a previously saved document opens.  How do I open Word
2007 to a new blank document?

Hi, I am using Access 2000 and i have a "Meetings" form with a subform based
on a query.
The subform works fine with filter and sort criteria entered on the query. I
would like to use an Option Group on the Meetings form to change filter and

"Field Size" from 12 to 14...on a Thin Client administered
by another Company...Access 2003.
I've left a message for the Company.
Any ideas why?