Search results

sorry i dont know what you mean by - split?

i havent tried much yet since it only happens on other peopels computers im going to try using my own email to send on another comp and see what happens - i onlly asked in case there was a simple obvious answer thanks again

it gives that momentary message which i can only presume says its outputting the email (it only appears for a split second) and the routine seems to work fine -- except that the email never gets sent and isnt in outlook at all im working on the other error handlers and wont make that mistake...

thats done the trick - i changed the code for all the other buttons too - i guess i was being too vague?? thanks very much for your help in this matter - it was becoming very frustrating - thank you all one last question -- can anyone figure out a reason why the email routine only seems to work...

this is where the error occurs it only happens if the box is ticked and the message is displayed if unticked the routine works fine and an email is sent or letter printed

the error occurs when a letter button is clicked and there is a corresponding tickbox ticked - this invokes a message (to stop a duplicate letter being sent) when the message box is closed the error message appears and the program shuts down - it happens for all four boxes

husky everything works fine in the normal version the error only occurs in runtime - thats why i find it hard to pinpoint where its wrong since as you say if the error occured in the normal versiopn at least id get a messasge and the problematic line highlighted

i have attached a full empty version

there are 14 excluding one liners that recalc and set proper case etc.

altogether around 270

thanks for your help so far - but i was kind of looking for an answer - rather than replies

no but when that procedure is satisfied then i presume the program stops there since it isnt asked to do any more? th message box appears to inform of the situation then closes and the program goes no further??

but it still stops the program

and i took that to be the code within the subroutine

i put my error handler just below where i know the error occurs so as not to confuse it with the rest of the code -- are you saying it should go as the last line? - i tried this but it doesnt give an error message of any kind and when i OK the message it carries on the procedure and prints the...

now im beginning to feel paranoid - ive read the links and dont see what im doing wrong other than the error handling is placed in the wrong part of the code

this is the routine in its entireity the error appears after the OK button is clicked in the message box

i already tried this - PROC_ERR: MsgBox "Error: (" & Err.Number & ") " & Err.Description, vbCritical but even in the runtime version it gives - Error(0) which i presume no error?

i understand what error handlers should do but not too familliar - i would suppose that before you can overcome an error you first have to ascertain what the error might be?

the error message just says that it has encountered a runtime error and will shut down - thats what i mean about not being able to know why the error occurs and because its runtime it doesnt debug to the code