How to suppress an error message

[gord2]

Hi all,

In Access 2002, how to use program code to suppress the following error message:

"Error #2448 with message: You can’t assign a value to this object."

Thank you.

 

[PHV]

Why not posting the code raising this error ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davejam]

why do you need to suppress this, should you not work out what is causing it and fix!!!

but to get around this error you could simply have the following within your sub

private sub testCode()
on error goto errHere

'*** your code here ***

exit sub
errHere:
if err.number <> 2448 then msgbox err.description
end sub


this will give you an error message for anything other than 2448

if you want it to continue with your code from the point it errorred you could always add a bit extra

errHere:
if err.number = 2448 then
resume next
else
msgbox err.description
end if

why are you getting the error should be the first question you ask yourself??

daveJam

even my shrink says its all your f#@/ing fault

 

[Remou]

It is generally better to come up with a way to avoid the error, if that is impossible, use an error handler (On Error GoTo ...)

 

[gord2]

Thank you all the quick response. Will check the error handler.

I am modifying someone's code temporarily. I just needed a quick fix.