how to add a new field from the old field in vb code

[lg5050]

Hi need help to create a new field programmatically, transfer all the data from the old field into it and then deleting the old field. because my field is a text field and i want it to be a number field. I think i can add a new field and delete the old field. But i don't know how to do the vb code part as in where to find it and where to put it. Any help please!!

 

[Galaxiom]

Wanting to code this process suggests you are expecting to do it routinely when the database is in use. If so that is a very bad idea.

Either that or you have very many tables.

Tell us why you think you need this.

 

[JHB]

..But i don't know how to do the vb code part as in where to find it and where to put it. Any help please!!

If you really want to do it, then it is explained in the below link, (Alter table).
http://msdn.microsoft.com/en-us/library/bb177883(v=office.12).aspx

 

[lg5050]

Thank i will try that.

 

[smig]

Why not changing the field's name and type ?

 

[lg5050]

this database has over 40,000 some records and some of the fields have numbers and i trying to change them from text to number but if i change it delete the decimal point into a whole number and i don't want that.

 

[smig]

If it has a decimap point set it either to single or double.
Integer won't accept fractions