2 things - SetWarnings? and Running a saved Import

[DC27]

Hi,

I'm using Access 2007 and two things I used to know how to do I have either forgotten or can no longer find.

From within a macro I used to "setwarnings" to off so I wouldn’t keep having to click "yes" or "ok" - is there a different way of doing this from within a macro?

Secondly, I want to run a saved import from within the macro - any ideas?

Can’t believe either of those is too hard..#!

TIA

David

 

[Singh400]

IIRC you can still you setwarnings = off in Access 2007, but you need to enable "show all macro operations".

 

[DC27]

that's sorted both thank you

 

[DC27]

is there a way of marking the thread as "answered"?