Hiya,

Is it possible to create a command button on a form and code it such
that it goes to a particular field and changes the data type property
of that filed from Auto Number to Number.

Many Thanks and Kind Regards,
Hussain

<hpaisawala (AT) gmail (DOT) com> wrote

What you are trying to accomplish that you could not do by manually
modifying the Table in Design View?

Larry Linson
Microsoft Access MVP

Larry Linson wrote:
Hiya Thanks for the reply.

No, the end user has no experience of using the access system and so
wouldn't know how to do it in design view. I want him to do everything
from a form. Also, it takes longer to do that.

Actually, if I explain you what I am trying to do, it might make it
easier for you to guide me. Basically, I have 4 tables from which I
filter data and then use append queries to use data from all four
tables and create new tables with various keys. However, to create
these new tables I have to put the data in the 4 tables and then
individually go in the design view of all four tables and change the
data type from autonumber to number because access doesnot allow the
new tables to have more than 1 autonumber filed.

Hussain wrote:

Thanks all who tried answering this question. I have found the solution
at:

http://support.microsoft.com/?kbid=210304

Many Thanks.