Mark Tangard wrote in message ...
Mark,

You mentioned that you have a few Do loops in your code - are any of
them conditional on completion of another do loop? I ran into a very
similar situation with some code on an Access form, and it was
basically making itself believe it was in an endless loop, even though
it wasn't. I would get all sorts of nonsensical error messages, and
this was code that had worked just fine up until that point. Beacuse
stepping through it slowed everything down, it worked then, but not
when I let it run through. I had to put in some flags to control
processing, which seemed to do the trick. Not at all an elegant
solution, bu there was some time pressure.

JCN


Hi Robin,

Both good ideas, but both already tried. I stepped through the
Initialize routine early on with no problems. In fact, I stepped
through the *whole thing* -- no mean feat with the loops & all --
and nary a whispered complaint.

I did the module export/import manually. (I have the code cleaner
for Word, wasn't sure if there's one for Excel, but I've noticed
manual export/import in Word actually seems to clean *better* than
the cleaner. I'll check Rob's now that I know where to find it.
Thanks.

--
Mark Tangard , Microsoft Word MVP
"Life is nothing if you're not obsessed." --John Waters

Robin Hammond wrote:

Mark,

If it is failing on the frm.show command there may be something in your
form_initialise code that it doesn't like even though the debugger appears
to stop on the show line. Try stepping the code from the .show line as a
first suggestion.

Second suggestion - sometimes VBA spits the dummy when adding just one more
element to a form. There don't appear to be any obvious preconditions for
this, but a lot of deleted elements on the form may be causing it. Get Rob
Bovey's code cleaner (from www.appspro.com I think) and run that on your
code. It will export all your forms and modules as text files, then reimport
them, removing any legacy items.

--
Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

"Mark Tangard" wrote in message
...
Yes, I always have that. And it compiles without a peep. ;-(

--
Mark Tangard , Microsoft Word MVP
"Life is nothing if you're not obsessed." --John Waters




Ed Ferrero wrote:

Hi Mark,

Do you have Option Explicit at start of all modules?
Try compiling after you insert that statement.

--
Ed Ferrero
http://edferrero.m6.net