(re-posting, as my original reply hasn't appeared)
BD said:
I am importing through an Access visual basic menu that was setup before my
time. Every month it has worked but this month I imported two files at
the
same time, like usual, and it gives me the error message "0 CMD Continue
Click,". It doesn't upload the file and it makes one of the excel files
unreadable and unable to try again.
That doesn't look at all like a built-in Access or VBA error message. I'd
guess it's a message that is displayed by user-written code, so the logical
thing to do would be to look for the code that displays it and figure out
how that code would be reached. My guess would be that 0 is not part of the
literal message text, but rather an error code that is being displayed. If
it's the current value of Err.Number, that would indicate that by the time
the message is displayed any system-generated error has actually been
cleared. So look in the code for "CMD Continue Click", or
"CMD_Continue_Click", or something like that. Do you have a command button
with the caption "Continue"? That might be the place to start.
If you can't find that, set a breakpoint in the code at the place where you
start the import process, then trigger the code and and step through it from
the breakpoint line by line to see what happens.
