M
M Skabialka
The following expressions and others like them have all worked fine for two
years in Access 2000.
Forms!frmLevelAssessment.Controls("C" & Trim(Str([RiskConsequence])) & "P" &
Trim(Str(RiskProbability))) = "X"
Forms!frmevaluation!frmCube1.Controls(Forms!frmevaluation!OldRiskFactor) =""
Forms!frmevaluation!frmCube1.Controls(Me!RiskFactor) = "X"
The value of RiskFactor is similar to "C3P2" which is a field name on
frmCube1 which shows a 5x5 cube with 25 fields where one X is placed.
Now they all suddenly give me this error:
You entered an expression that has an invalid reference to the property
Form/Report. 2455
The form hasn't changed in months, I haven't changed any references or
upgraded Office 2000, or done any patches recently, only Windows 2000
security patches which shouldn't have any bearing on this. Microsoft's site
suggests it is a "dirty" property problem, but I don't think it is; it has
worked forever. The help files don't help either.
I totally removed Office 2000 from the PC, then reinstalled it, followed by
SP1 and SR3.
I ran the System File Checker which found no problems.
I then looked at a year old backup of the database to see if my current
references had changed. They hadn't.
I've tried a copy of the dB from another PC, the old version (which had no
problems) and the newest one. But I am still getting the same error for any
copy of the db I have:
You entered an expression that has an invalid reference to the property
Form/Report. 2455
The only thing I did recently was to do some Windows Updates last week just
prior to this happening. I was able to use spuninst to get rid of one but
that didn't fix the problem.
I am hoping I don't have to reinstall Windows. This was a Win98SE PC,
formatted and started over with Win2K Pro 6 months ago. (dB was on a since
retired PC.) I am told you cannot reinstall Windows over itself; and the
one time I tried it I had to borrow ERD Commander to fix the PC because it
became totally fried, not bootable even!
Does Win 2000 Pro have a system restore - I couldn't find it, just the "last
known good configuration" but I've tried a lot of things in the last few
days, hard to tell what this "last known good" one would consist of....
Should I uninstall those Windows Updates done last week - how is this done?
(Also posted to microsoft.public.access.forms but no fix yet)
I don't have the luxury of being able to get another PC - any ideas please?
Thanks,
Mich
years in Access 2000.
Forms!frmLevelAssessment.Controls("C" & Trim(Str([RiskConsequence])) & "P" &
Trim(Str(RiskProbability))) = "X"
Forms!frmevaluation!frmCube1.Controls(Forms!frmevaluation!OldRiskFactor) =""
Forms!frmevaluation!frmCube1.Controls(Me!RiskFactor) = "X"
The value of RiskFactor is similar to "C3P2" which is a field name on
frmCube1 which shows a 5x5 cube with 25 fields where one X is placed.
Now they all suddenly give me this error:
You entered an expression that has an invalid reference to the property
Form/Report. 2455
The form hasn't changed in months, I haven't changed any references or
upgraded Office 2000, or done any patches recently, only Windows 2000
security patches which shouldn't have any bearing on this. Microsoft's site
suggests it is a "dirty" property problem, but I don't think it is; it has
worked forever. The help files don't help either.
I totally removed Office 2000 from the PC, then reinstalled it, followed by
SP1 and SR3.
I ran the System File Checker which found no problems.
I then looked at a year old backup of the database to see if my current
references had changed. They hadn't.
I've tried a copy of the dB from another PC, the old version (which had no
problems) and the newest one. But I am still getting the same error for any
copy of the db I have:
You entered an expression that has an invalid reference to the property
Form/Report. 2455
The only thing I did recently was to do some Windows Updates last week just
prior to this happening. I was able to use spuninst to get rid of one but
that didn't fix the problem.
I am hoping I don't have to reinstall Windows. This was a Win98SE PC,
formatted and started over with Win2K Pro 6 months ago. (dB was on a since
retired PC.) I am told you cannot reinstall Windows over itself; and the
one time I tried it I had to borrow ERD Commander to fix the PC because it
became totally fried, not bootable even!
Does Win 2000 Pro have a system restore - I couldn't find it, just the "last
known good configuration" but I've tried a lot of things in the last few
days, hard to tell what this "last known good" one would consist of....
Should I uninstall those Windows Updates done last week - how is this done?
(Also posted to microsoft.public.access.forms but no fix yet)
I don't have the luxury of being able to get another PC - any ideas please?
Thanks,
Mich