Hi~
Is there a way in which you can force a data type with VBA?
I have a table that is imported into a database(97)from an application called Monarch. One of the fields has a letter before a number - Monarch extracts the letter and changes the field to text before importing. (Monarch will not allow for changes in data type.) If the fields data types between the two applications don't match Monarch will not export into the database so in Access the field data type is also set to Text. The field should really be numeric and not text.
I need to make calculations off of this field but access will not allow me to - due to invalid data type. I know I can manually change it but I would much rather have it automatically change with a code -- if that is at all possible.
Any ideas would be greatly appreciated!!
Is there a way in which you can force a data type with VBA?
I have a table that is imported into a database(97)from an application called Monarch. One of the fields has a letter before a number - Monarch extracts the letter and changes the field to text before importing. (Monarch will not allow for changes in data type.) If the fields data types between the two applications don't match Monarch will not export into the database so in Access the field data type is also set to Text. The field should really be numeric and not text.
I need to make calculations off of this field but access will not allow me to - due to invalid data type. I know I can manually change it but I would much rather have it automatically change with a code -- if that is at all possible.
Any ideas would be greatly appreciated!!