Recent content by esther-perkins

Dear Pat! Thanks so much for your solution -- I tried the ALTER TABLE and ALTER COLUMN statement as a Run SQL action in my macro and it worked like a charm! Esther.

Dear Fofa, Thanks for your reply... I understand that in an ideal world all the data types of the fields would stay the same and not need to be changed throughout the process, but I'll give you a sketch of my problem: I use ODBC to extract data fields from a system which has been configured by...

If not, that's bad news for us. I understand that the data type applies to the whole column.... For example, let's say I've got a make-table query which contains a function which outputs a text string when what I need for my end product is a date/time formatted field (I have returns to do at...

sorry I mean field data type not format...

Thanks for replying Fofa. I need to change the format of certain fields in a table, for example, change a text format to a date/time format. So yes, the format is a field property. I looked at the SETVALUE macro action, and am not sure what to put down for the item or expression. If my...

Hi UK SOLDIER, Not sure if someone's already posted you a reply on this, but basically you name your macro AUTOEXEC. When the data base opens it will automatically scan for this and open it first.

Hi, Is there anyone out there who knows how to change the format of a table field in a macro? I have lots of macros which need to be halted in order to change the format of some table fields before I can proceed... Try though i might, I can't work out how to automate this process in a macro...