My question is similar to question 21687496 but not exactly the same. What I'm trying to do is actually simpler but I'm still having trouble.
All I want to do is execute a stored procedure that inserts one row in a table using a passthrough query. The SP has one parameter that must be passed in and an integer return code that must be passed back, indicating whether it succeeded or failed.
The examples only confuse me because they are doing different things and not passing back a return value.
If somebody could post the passthrough query as well as the VBA code I would be very appreciative.