Hide error in textbox

[ikzouhetnietweten]

Guys

Im Having an error code in my textbox of my form Unit2. Its supposed to be error cus when u dont fill in a projectnr, it obviously cant find it. I just want it to hide it. I tried this but to no avail:

=IIf(Nz(DLookUp("KH";"Project";"Projectnr=" & [Projectnr]);"");"")

Or

=IIf(DLookUp("KH";"Project";"Projectnr=" & [Projectnr]);"");DLookUp("KH";"Project";"Projectnr=" & [Projectnr])

Or

=IIf(DLookUp("KH";"Project";"Projectnr=" & [Projectnr])=[DbNullValue];"";DLookUp("KH";"Project";"Projectnr=" & [Projectnr]))

 

[CJ_London]

duplicate post http://www.accessforums.net/programming/hide-error-textbox-56012.html

suggest you read this link http://www.excelguru.ca/content.php?184

 

[ikzouhetnietweten]

Your (external) link with guidelines is your view = personal. The more answers the better = my view.

 

[bob fitz]

Your (external) link with guidelines is your view = personal. The more answers the better = my view.

Lack of respect for the people willing to help you = fewer answers

Good luck with your project.

 

[ikzouhetnietweten]

Don't see why I should have respect for someone who is not willing to help. Then also have respect for someone who isn't putting all his eggs in one basket.

 

[CJ_London]

Your (external) link with guidelines is your view = personal. The more answers the better = my view.

you are missing the point - by double posting you are likely not to get any answers

 

[spikepl]

Your (external) link with guidelines is your view = personal.

No. It's the view of essentially all who volunteer their knowledge here. SInce you did not understand what it is about I'll try to make that clear: "WE DO NOT LIKE TO SEE OUR EFFORT WASTED". So as CJ_London said: double post and wave goodbye to any help.

 

[ikzouhetnietweten]

No. It's the view of essentially all who volunteer their knowledge here. SInce you did not understand what it is about I'll try to make that clear: "WE DO NOT LIKE TO SEE OUR EFFORT WASTED". So as CJ_London said: double post and wave goodbye to any help.

How is your effort wasted by posting on another website. When receiving an answer I'd post it. Can't say that about you. Learning from eachother? Effort? Didn't see any proper answer in this thread other than whining about double posting.

 

[Cronk]

Goodbye!!!!

 

[Uncle Gizmo]

How is your effort wasted by posting on another website. When receiving an answer I'd post it. Can't say that about you. Learning from eachother? Effort? Didn't see any proper answer in this thread other than whining about double posting.

Please read the thread on double posting. Once you have read it and understood it, then we can move on and help you with your problem.

 

[ikzouhetnietweten]

Dear 'Super Moderator',
Could you post me a link of the Thread about double posting? Thank you so much!
Regards, an innocent Access learner.

 

[bob fitz]

Dear 'Super Moderator',
Could you post me a link of the Thread about double posting? Thank you so much!
Regards, an innocent Access learner.

CJ_LONDON gave the link in post #2 http://www.excelguru.ca/content.php?184

 

[ikzouhetnietweten]

I'm not following.
1. Those are not guidelines?
2. That's an entire different website?
I can also make a website: Excelisawesome.com, post an article named 'Double posting isn't a sin' and paste it in Access threads like here. Then you should also folllow those rules, correct?

 

[speakers_86]

Yep, you're going to get a ton of help.

 

[arnelgp]

if not in this forum, how can it be double posting?

 

[bob fitz]

if not in this forum, how can it be double posting?

This is Cross-Posting which is generally not appreciated.
If you don't understand why, perhaps you would care to look at the link given earlier.

 

[ikzouhetnietweten]

As stated earlier, it's all about a personal view to the double posting. Technically I didn't do anything wrong. I can't help it that your personal career, wanting to be appreciated and a high self esteem is more important than actually helping people. (Concluded by this unsolved thread)
No, I won't look at your website. Don't see why. I also won't tell you to read my personal views on a website as it's got nothing to do with Access.

 

[speakers_86]

I'm pretty sure they mostly just wanted you to disclose that you cross posted this. That issue aside, if you are expecting free help on a technical issue, you should treat these volunteers with a bit more respect.

 

[Uncle Gizmo]

Not another Colin... I'll resign!

 

[JHB]

As stated earlier, it's all about a personal view to the double posting. Technically I didn't do anything wrong. I can't help it that your personal career, wanting to be appreciated and a high self esteem is more important than actually helping people. (Concluded by this unsolved thread)
No, I won't look at your website. Don't see why. I also won't tell you to read my personal views on a website as it's got nothing to do with Access.

What has your attitude given you of solutions until now - on both WEB-sites, none as far as I can see, even if the solution is obvious by logical thinking!
If something can be Null/Empty - then make a test for it first.