Thread: [Solved] Macro Without a Prompt in Access 2007?

Hi Everyone,

I created a macro to open a query that creates a new table in Access 2007. I want it to be automated so it runs by itself, but when i run the macro its giving me prompt?

Does anyone knows how can i bypass this prompt so i dont need to be present answering access saying "yes" three times.

Would really appreciate your help.

Thank you.