Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DoCmd.OpenQuery delivers a code to detect if succesfull?

Status
Not open for further replies.

patyavila

Technical User
Apr 29, 2004
28
US
I'm writing code for interface with an EDI application. When importing/exporting data I run several queries one after the other and need to somehow track the results of each. I will like to continue executing code only if the previous qry was successful not only because it didn't fail but also in terms of the number of records added/deleted, 'cause the next query will have to deliver results related to that quantity. I think OnError is not exactly what I need, but I might be wrong. Appreciate any help [2thumbsup]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top