Hi Guys,
Is it possible to write vba code that will clear data from the memo fields from all the tables in the database.
One way will be writing queries for each table and updating memo fields to null. But this way if I have 50 tables in the database then I will need to write down 50 queries to clear out memo fields.
Is there any shortcut to that?
Thanks
Is it possible to write vba code that will clear data from the memo fields from all the tables in the database.
One way will be writing queries for each table and updating memo fields to null. But this way if I have 50 tables in the database then I will need to write down 50 queries to clear out memo fields.
Is there any shortcut to that?
Thanks