Since you have lots of parameters to pass - I would probably look up "ADO Command" and get really familiar with it. There's a fair amount of readily available code on how to wire up an ADODB Command object, set the various params to the right values, and execute it.
Otherwise - you can tackle it by essentially writing dynamic SQL calls to the passthrough query, and then using the DAO query.RunQuery to get it to execute.
----------------------------------------------------------------------------------
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?