question

AhmadAriefMohdNor-2381 avatar image
0 Votes"
AhmadAriefMohdNor-2381 asked thedbguy commented

How do I Fix or Remove #Error on Access textbox?

Here are what I write in the textbox control source box under property sheet.

=DSum("[CountReminder]","[QRunningReminder]")

My question is, how do I Remove the #Error on the textbox when there's no value/item in query for it to calculate? I would like or it to simply say "0" or "None". Or at least leave it blank.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Hi. Probably not the best way, but you could try something like:

=IIf(DCount("*","QRunningReminder")=0,"None",DSum("CountReminder","QRunningReminder"))

Hope that helps...

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AhmadAriefMohdNor-2381 avatar image
0 Votes"
AhmadAriefMohdNor-2381 answered thedbguy commented

Sorry, my bad. I wrote the wrong Query name. Access automatically leave it blank if there's no data to show.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Excellent! Glad to hear you got it sorted out. Good luck with your project.

0 Votes 0 ·