Complex Macro Not Finishing - What Should I Try Next? (1 Viewer)

A

amazonmike

Guest
I'm creating a database to sort web page hit data that's being imported from a delimited text file. I've borrowed a macro from an identical database to import the data. This macro sets into motion several other macros and queries which validate and edit the data into usable form. But the problem is that it never finishes. Once it gets past the date validation Action, nothing happens. The Actions that follow it are: Send Keys, Go To Control, Set Value, Run Macro, OpenQuery (5 consecutive), and OpenForm.
I've tried using the step through function to troubleshoot, but with no results. We also tried inserting message boxes to inform us when each action was finished, but only one appeared, and then never again. I've already removed and renamed references to the other database.
 

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 20:35
Joined
Feb 19, 2002
Messages
43,371
Try breaking the macro into smaller pieces to help you identify where the problem is occuring.
 

Users who are viewing this thread

Top Bottom