eed
09-24-2004, 12:06 PM
Okay, so I have two procedures to automate some mail merges of Access data with Word templates. Both procedures work very smoothly -- when the database contains data for the user-specified parameters.
When the database does not contain the user-requested dataset, ONE procedure handles the errors very smoothly, and the other totally chokes, leaving MS Word (and the template file) in a state of disarray.
I created the second procedure by just copying and modifying the first, so I can't figure out where lies the discrepancy that is causing the different behaviors. I would like the second procedure to handle the errors smoothly and quietly the way the first procedure does.
A mostly stripped sample version of my database is attached; it should allow you to test and see if you observe the same differences in behavior that I did. Thanks in advance for any suggestions on how I can make the second procedure behave like the first!!
<<problem solved: attached db removed 9-27 for privacy concerns. --eed>>
When the database does not contain the user-requested dataset, ONE procedure handles the errors very smoothly, and the other totally chokes, leaving MS Word (and the template file) in a state of disarray.
I created the second procedure by just copying and modifying the first, so I can't figure out where lies the discrepancy that is causing the different behaviors. I would like the second procedure to handle the errors smoothly and quietly the way the first procedure does.
A mostly stripped sample version of my database is attached; it should allow you to test and see if you observe the same differences in behavior that I did. Thanks in advance for any suggestions on how I can make the second procedure behave like the first!!
<<problem solved: attached db removed 9-27 for privacy concerns. --eed>>