Disable message prompts.

[Chelsea7]

Hello everyone,

I created a form where it automates an excel file import. I tring to emliminate all the warning prompts like overwite file etc. I unchecked them under the tools menu, options and under the Edit/Find tab. However, I still get a prompt for file deletions. Is there anyway I can disable this so that the user will not have to answer the question?

Thanks,
Chelsea

 

[fneily]

In a macro or VBA code, have you looked at DoCmd.SetWarnings and DoCmd.Echo? Try setting them to No(Macro), False(Code).

 

[Chelsea7]

That worked thank you.