September 11, 2007 at 12:24 pm
HOW CAN I KNOW (BY CODE) WHEN A Passthrough QUERY
ENDS WITH ERROR OR WITH NO RECORDS RETURNED?
THANKS
September 11, 2007 at 2:51 pm
Hello,
What kind of technology do you use ADO,DAO?
Anytime my passthrough gave an error Access notified me, unless on error resume setting is on. (in order to process the error in code)
You can find if a passthrough query returned records with your recordset. if rs.eof=false then rs.movelast rs.movefirst
msgbox rs.recordcount
September 11, 2007 at 5:26 pm
If you're talking about invoking a saved "pass-through" query, it will generate an error any time the code being passed through throws an error, OR if it returns no records and the query property Returns Records is set to True.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply