By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Command to change the data type of a field in a table

P: n/a
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

Sep 1 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<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

Sep 1 '06 #2

P: n/a

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.

Sep 4 '06 #3

P: n/a

Hussain wrote:
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.
Thanks all who tried answering this question. I have found the solution
at:

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

Many Thanks.

Sep 4 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.