470,591 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

#Error on form when no data present: Access 2003...

Dököll
2,364 Expert 2GB
Hey Fans!

Perhaps you can help me...

I am using MS Access 2003. I have tried a number of things to get rid of the text #Error from appearing on form fields when no data present.

Tried the NZ function, also tried the IIF function, told it to give me zero if no data found, so far it seems to lead to nowhere land. What are your thoughts? Hopefully it's not very simple and I missed the boat, hee hee...

Thanks for your help!

Dököll
Mar 7 '08 #1
5 2231
sounds like there is a problem with your form fields. Fields should appear empty if there is no data in the underlying table/query/expression.

#error/#name etc. in the field would suggest there is a problem in retreiving the value, not that the value is null
Mar 7 '08 #2
missinglinq
3,532 Expert 2GB
While that's true of #Name, it's on ly sometimes true of #Error! With #Error it can also mean that the expression used as ControlSource cannaot be evaluated. What's the expression you have in the ControlSource for this field?

Linq ;0)>
Mar 7 '08 #3
While that's true of #Name, it's on ly sometimes true of #Error! With #Error it can also mean that the expression used as ControlSource cannaot be evaluated. What's the expression you have in the ControlSource for this field?

Linq ;0)>
thanks missinglinq you are right it is most likely a prob with the fields controlsource expression, nice call:)
Mar 7 '08 #4
NeoPa
32,298 Expert Mod 16PB
Tell us what you are populating the fields with in your form.
Include the details for a control where this happens as well as the RecordSource of the form itself if you can.
Mar 10 '08 #5
Dököll
2,364 Expert 2GB
Hey Gang!

Thanks for replying and please excuse the late reply. The form is being populated by a subform which is being populated by a query, will post some of the work to get an idea:

This is one of the fields that have the #Error instance

Expand|Select|Wrap|Line Numbers
  1.  
  2. =[InfoOnlyDataPRE].Form!InfoInfo
  3.  
  4.  
This is the subform portion, an attempt to calculate all items within that column/field abd feed it to the form using =[InfoOnlyDataPRE].Form!InfoInfo

Expand|Select|Wrap|Line Numbers
  1.  
  2. =Sum(NZ([Informational]))
  3.  
  4.  
This is our query portion, an attempt to feed items to subform column/field

Expand|Select|Wrap|Line Numbers
  1.  
  2. Informational: IIf(NZ([DataCentralReport!Category]="PreErrors" And [DataCentralReport!Informational])=True,1,0)
  3.  
  4.  
It looks like it should work, I should get zero, don't you think? When data are available as mentioned, all is well. Something is there, and I just can't quite put my finger on it.

Let me kow what you see. And thanks for your assistance, very cool.

Dököll
Mar 27 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by James Walker | last post: by
reply views Thread by M. Farrenkopf | last post: by
6 posts views Thread by Peter Frost | last post: by
7 posts views Thread by p | last post: by
reply views Thread by Yelena Varshal via AccessMonster.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.