Hi,

I have this syntax which imports data from an excel sheet, and then runs an update on it to alter some of the data so that it conform... but when it runs, I get popup messages that say 'You are about to run an update query...' which I need to press yes, and then another window that says 'You are about to update ... records', which I also have to press yes.

Is there a way for these popups NOT to show up, and simply have it perform the actions?

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "MigData", TxtFilename, True
    DoCmd.OpenQuery "Update_MigData"

Yes.

DoCmd.SetWarnings False
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "MigData", TxtFilename, True
DoCmd.OpenQuery "Update_MigData"
DoCmd.SetWarnings True

This turns these types of warnings off and on. Remember to turn them back on at the end of your subs.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Hey,

Thank you that worked great...