PC Pals Forum
Technical Help & Discussion => Website Design & Programming => Topic started by: davypipes on March 04, 2005, 14:21
-
am getting this error everytime i cancell any update i do in my form:
error "3704"
"operation not allowed when object is closed"
heres the code snippet:
Private Sub cmdcancel_Click()
'dataenv is my dataenvironment connected to a access dbse
With dataenv.rssale
.CancelUpdate
End With
End Sub
any ideas on wats wrong?
and another thing...emmm..is it a good idea to trap error numbers and use them for validation? eg:
errornum=Err.number
if errornum=1234567 then
msgbox(please enter all required values)
end if
will a different number be generated on a different machine?hence not doing the validation ?
-
Sorry for the delay, Davy. Hopefully someone will be able to help you with this soon.
-
oooh thanks simon...its wasnt that argent!! anyway i was able(with my friends help!) to get the root of the problem!! u see i had called the wrong
table ie:
With dataenv.rssale
'should have benn..
With dataenv.rsprofiles
...so theres the bugga, but about the error number...well i still havenmt gotten any info on the adv/disdvantages of using them.