I have a? MS Access 2007? database which I use on a weekly basis where presently all fields are set (when the database is established each week) to the "Memo" data type.
I require a macro (that might itself include a VBA module) that would:
1)allow specific fields in specific tables to be set to either "date/time", "Currency" or "Double" datatypes.?
2) change all remaining field types in all tables of the database to "Text" (i.e. "Text" becomes the default).
I don't require you to work on my database. ? I just need the macro so I can then specify the various tables and fields myself.