Hiding append query confirm dialogue 2

[cruz610]

Is there a way to do this? I tried using the execute command but it says "Too few parameters. Expected 1". Any ideas? This is being executed when a button is clicked on a form

 

[scriverb]

To supress the access processing messages use the following:

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryyourqueryname"
DoCmd.SetWarnings True

Now the message that you indicated above tells me that there is something wrong with your query. Try the above and run it. If you still have this error about the parameters you have a problem with your query. We will have to see your SQL code to fix it.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[cruz610]

That works perfectly However, at the end of it all I get an error message saying "Application-defined or object-defined error." Nothing else. Any idea how to get rid of this final error? The queries run perfectly, dunno why its giving me this error. I am having a bunch of subforms requeried afterwards, perhaps thats why?

 

[scriverb]

Try running the query from the database window. You obviously have a problem with the query even though it is finishing. This error in SQL coding should be cleared before you release your program.


[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[TheAceMan1]

How are ya cruz610 . . . . .

To permanently turn off the action query confirmation, click [blue]Tools - Options - Edit/Find Tab[/blue]. In the [blue]Confirm[/blue] section, uncheck [purple]Action queries[/purple].

See Ya! . . . . . .

 

[cruz610]

Great tips from both of you. scriverb, actually there is nothing wrong with the queries. I was doing some reading and it seems that the requery commands at the end of it all was causing it. Found a better way to do it though; I decided to bookmark the record # then requery the whole and goto the bookmarked record. Works better IMO. Thanks for all your help!