Macro Override Command 2

[Jackcess]

Hi everyone. I have this macro that runs a Make Table Query. When the query kicks off, it always gives me the warning message about how the table will be deleted etc etc. Is there anyway to automatically select "Yes" everytime so that the user does not have to sit there and click through buttons?

Thanks in advance!

Jack

 

[HitechUser]

Jackcess,

Here you go..

http://msdn.microsoft.com/library/d...chowHideWarningMessagesWhenRunMacroMacroS.asp

I hope this helps

 

[TheAceMan1]

How are ya Jackcess . . . . .

To turn off [purple]ActionQuery Warnings[/purple] in VBA:

[blue]   DoCmd.SetWarnings False
   [green]'Your Code[/green]
   DoCmd.SetWarnings True[/blue]

To [purple]permanently turn off ActionQuery Warnings[/purple]:

In the Database window, click [blue]Tools[/blue] - [blue]Options[/blue] - [blue]Edit/Find Tab[/blue]. In the [purple]Confirm section[/purple], uncheck [purple]Action queries.[/purple]

See Ya! . . . . . .