Hi all, I'm new and to asp needed some help here.
I got a problem which i uploaded on http://n.domaindlx.com/hayley/PMS_Page.asp
which will be helpful to my question.

I'm able to key the data in the last row in ms access, E34002, however after saving it, I'm unable to display the records.

Below is part of the code where the fault is:

Function TD_Prop
    if rs("Schedule")="" then
    TD_Prop = "EquipmentHead"
    else
    TD_Prop="EquipmentItem"
    end if
end function

Error Type given was:
(0x80020009)
Exception occurred.
PMS_List.asp, line 4

Line 4 is actually if rs("Schedule")="" .
Is anyone able to help me solve this?

Hayley,

Check out www.aspfaq.com/show.asp?id=2421 which has a comprehensive list on the various reasons which would throw this error. Hope it helps!

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Hi Vadivel,

Thanks for the advice. Had seen the pages but think it's not exactly related to the error. Wonder if I end the code properly...