Hi,

I have a command button on a form and when the user clicks it, a macro is fired which imports a spreadsheet to a table (TransferSpreadsheet action).
What i want is if there already is some data in the table, it should be deleted. So i added the 'RunSQL' action before the 'TransferSpreadsheet' action.
It does the work but i don't want the "Do u want to delete row(s)" message to pop up before the user. Is that a way to do that ?

Thanks

DoCmd.SetWarnings False

DoCmd.RunSQL ...

DoCmd.SetWarnings True

Did that help?



mmcdonal