Can anyone help?
I have set up a number of make table queries from one data source table.
From the new tables I then select the records and copy and paste these into other tables
This operation is all automated using a defined macro and works fine.
The problem I have is when the macro is running I have to keep answering messages i.e do you want to paste 10 new records etc. The answer is always yes so is there some way so these message boxes can be automatically defaulted to pressing the yes button or bypassed completely.
I have set up a number of make table queries from one data source table.
From the new tables I then select the records and copy and paste these into other tables
This operation is all automated using a defined macro and works fine.
The problem I have is when the macro is running I have to keep answering messages i.e do you want to paste 10 new records etc. The answer is always yes so is there some way so these message boxes can be automatically defaulted to pressing the yes button or bypassed completely.