Larry Linson wrote:
<hp********@gmail.comwrote
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.
What you are trying to accomplish that you could not do by manually
modifying the Table in Design View?
Larry Linson
Microsoft Access MVP
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.