Clicking on a dialog box with VBA

[robbeh]

I am writing some VBA to import data from an excel file. The seudo code looks like:



Copy "tablename" table to "tablename-backup"
Delete contents of "tablename"
Import contents of Excel file into the blank "tablename"

To run the backup I am using DoCmd.CopyObject, "tablename-backup", acTable, "tablename"

Works great on initial run but once the table is created I am getting a "Do you want to overwrite" dialog pop up box on subsequent runs.

How can I write the code for:

IF dialog popup box, slecet "Yes"?

Thanks!

[Missinglinq]

Not aware of any way to do this, but in code you can turn off these warnings temporarily by using this code:

DoCmd.SetWarnings False  'Turn warnings off
   'Code here to do whatever is throwing up the warning
DoCmd.SetWarnings True    'Turn warnings back on

Be sure to turn them back on after the triggering event. There may be times when you want to know when Access is going to do something; it may be something you didn't intend!

Linq ;0)>

[robbeh]

Not aware of any way to do this, but in code you can turn off these warnings temporarily by using this code:

DoCmd.SetWarnings False  'Turn warnings off
   'Code here to do whatever is throwing up the warning
DoCmd.SetWarnings True    'Turn warnings back on

Be sure to turn them back on after the triggering event. There may be times when you want to know when Access is going to do something; it may be something you didn't intend!

Linq ;0)>

Thank you, this worked like a charm.

[Missinglinq]

Glad we could help!

Linq ;0)>