Applications Hanging During Merge

macropod · #11 04-03-2016, 07:41 PM

Quote:

Originally Posted by JennEx

With:

Code:

StrSQL = "SELECT * FROM [CORE$]

Word just kept opening mail merge documents over and over, mergiing without headers and footers and reports of 135 calculation errors (there are only 31 records in my database). I had to <CTRL><ALT><DEL> to end Excel to stop the Word reports from being created non stop.

I can't see how it's possible for the 'over and over' to occur, as there's no looping in the code - just a single merge to a new file. All you should have ended up with is a single file with outputs for your 31 records. Did you just run the macro on its own, or did you call it from another one? The lack of separate headers and footers is because you're doing a Directory merge, which has only a single Section and hence, a single header & footer.

Quote:

Originally Posted by JennEx

With just:

Code:

StrSQL = "SELECT * FROM [CORE$] " & _
              "ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"

Received the mysterious select table prompt with the DATA1.xls worksheet.

Evidently, then, there's a problem with this part of the SQL:
"ORDER BY [START] ASC, [COMPLEX] ASC, [UNIT] ASC"
Do the START, COMPLEX & UNIT fields you're trying to order by exist in the data source (Aug-30 (Sun) schedule_3.xlsx)?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sharing data between Office applications	mdavies	Office	1	11-26-2013 02:55 PM
All Office Applications lock up when saving	abreeden	Office	1	05-18-2012 08:02 PM
VB Applications?	RiverStyx	Office	1	05-30-2011 08:31 PM
Change skin color of applications?	Jack R	Office	0	07-04-2010 04:25 AM
How many Word applications are running GetObject	stevecarr	Word	0	01-09-2006 07:41 AM