Macros is not stepping through...

[Gary A. Hollenbeck]

I have a macro that ..

1. Transfers an excel spreadsheet to a temporary table using the
transferspreadsheet function.
2. Action Query that appends a primary table with the new records in the
temporary table.
3. Action Query that updates changed records in the primary table from the
temporary table.
4. Deletes the temporary table.

Each of the above actions are successful when run individually. However,
when I run the macro it stops after the first action every time. No matter
what the first step is, it stops. Is there something I have forgotten to
do. Something I need to enable. I have had this working before in a
previous database with no problem.

thanks,

Gary Hollenbeck
Production Manager
The Door Stop

 

[Steve Schapel]

Gary,

I can't think of any explanation for this. Maybe if you could post back
with full details of your macro, including actions and argument
settings, someone may be able to spot the problem.

 

[Gary A. Hollenbeck]

Steve,

Thanks for the recommendation!

I am completely unable to get any macro to step through each of its actions.

I have a number of them that have always worked before. Mostly simple
stuff, like multiple OpenReport's with a "print argument. Can't be much
simpler. Access just refuses to run more than the first action.

Thought it might be because of the most recent XP update from MS, so I
updated my office with the latest. Still to no avail, the macros will not
step through. I have not tried converting them to VBA and running from
there yet. Still wouldn't solve the problem.

Thanks for any help possible.

Gary