Prompt a user in a Macro

[qrk10000]

Hello, I have set up a Macro that automates the file import process for my users. As part of this Macro, it deletes the old file and replaces it with the new imported file. I would like to set something up that warns them before proceeding, such as "Clicking 'Yes' will delete the existing file." I have been able to set up this warning but am unable to figure out how to prompt the user to select 'Yes' or 'No'. Is there a way to do this in a Macro?

Thanks in advance for your help.

 

[ColinEssex]

Create the Yes/No MessageBox in VB code then run the code in the macro.

Col

 

[qrk10000]

Is this relatively simple to do? I am not very proficient in VB.

 

[qrk10000]

Is there a place I could get some sample code for this?

 

[ColinEssex]

Is there a place I could get some sample code for this?

I know its a surprise, but Access help has an example, plus how to do the yes/no buttons, message style and different icons.

Col