access 2002 vs 2003

[hatemma]

I need help please. Some features of my database work fine in work computers
that run access 2002 but not 2003.
eg
=IIf([Forms]![frm_tabs]![CXR date]>([Forms]![frm_tabs]![Fm_MDT]![date of
meeting]),"",[Forms]![frm_tabs]![CXR details])
also if I try to open report based on date on the form, I get an empty
report with no data.
It seems that the functions that dont work all linked to on control in a
subform [date of meeting].
Please help

 

[boblarson]

Sounds like you might be dealing with a references issue.

See here:
http://allenbrowne.com/ser-38.html

or here:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[John W. Vinson]

I need help please. Some features of my database work fine in work computers
that run access 2002 but not 2003.
eg
=IIf([Forms]![frm_tabs]![CXR date]>([Forms]![frm_tabs]![Fm_MDT]![date of
meeting]),"",[Forms]![frm_tabs]![CXR details])
also if I try to open report based on date on the form, I get an empty
report with no data.
It seems that the functions that dont work all linked to on control in a
subform [date of meeting].
Please help

Try using the full, unambiguous subform reference:

[Forms]![frm_tabs]![Fm_MDT].Form![date of meeting]

If either of the form references might be NULL you may need to use NZ() to
replace the null value with a meaningful date.

John W. Vinson [MVP]

 

[hatemma]

Thanks John, I have changed the reference to the subform as adviced and it
has worked.
Many thanks again

I need help please. Some features of my database work fine in work computers
that run access 2002 but not 2003.
eg
=IIf([Forms]![frm_tabs]![CXR date]>([Forms]![frm_tabs]![Fm_MDT]![date of
meeting]),"",[Forms]![frm_tabs]![CXR details])
also if I try to open report based on date on the form, I get an empty
report with no data.
It seems that the functions that dont work all linked to on control in a
subform [date of meeting].
Please help

Try using the full, unambiguous subform reference:

[Forms]![frm_tabs]![Fm_MDT].Form![date of meeting]

If either of the form references might be NULL you may need to use NZ() to
replace the null value with a meaningful date.

John W. Vinson [MVP]