setwarnings

[tbeers]

I am a fairly experienced access user and just switched from 2003 to Access 2007. Yeah yeah, I know.

At any rate, I created a a quick little macro to grind down duplicate entries from three different tables. the macro works fine and does everything I need it to do. However, everytime it runs a different query I get the warning messages, hit enter and continue on to the next query. I used to solve this with the setwarnings command. Now the setwarnings command is not even in the list. Is this normal for Access 2007? Do I need to code it in?

thanks

-Tom

[Denburt]

It does still work in 2007 however in 2007 there are a few differences, for one when using vba it turns itself back on after the code runs. I think this link explains things better than I can hope it helps and if you have any further questions let us know:

http://msdn2.microsoft.com/en-us/library/bb177386.aspx

[tbeers]

It does still work in 2007 however in 2007 there are a few differences, for one when using vba it turns itself back on after the code runs. I think this link explains things better than I can hope it helps and if you have any further questions let us know:

http://msdn2.microsoft.com/en-us/library/bb177386.aspx

Thanks for your help but the command setwarnings isn't in the dropdown list in the macro design page....

Must I code it?

-Tom

[Anjin]

Thanks for your help but the command setwarnings isn't in the dropdown list in the macro design page....

Must I code it?

-Tom

Tom,

In the ribbon when editting a macro you should see an option for "Show all Actions." Activate the option by clicking on it. It should change to a highlighted state. The under "Action" you will see a more comprehensive list of options.

Khan

[Denburt]

Wow thanks Anjin I looked in there a couple of times and thought he was going to need to hard code it but hey I see it is still right there. Strange design they came up with but it does make some things a little more interesting.

Thanks again