Command to change the data type of a field in a table - 09-01-2006 , 05:06 AM
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,
Re: Command to change the data type of a field in a table - 09-01-2006 , 12:23 PM
<hpaisawala (AT) gmail (DOT) com> wrote
modifying the Table in Design View?
Microsoft Access MVP
Re: Command to change the data type of a field in a table - 09-04-2006 , 04:49 AM
Larry Linson wrote:
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.
Re: Command to change the data type of a field in a table - 09-04-2006 , 05:42 AM