Hide error in textbox

ikzouhetnietweten · Oct 25, 2015

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:

Code:

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

Or

Code:

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

Or

Code:

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

CJ_London · Oct 25, 2015

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 · Oct 26, 2015

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

bob fitz · Oct 26, 2015

ikzouhetnietweten said:
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 · Oct 26, 2015

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 · Oct 26, 2015

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 · Oct 26, 2015

ikzouhetnietweten said:
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 · Oct 27, 2015

spikepl said:
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 · Oct 27, 2015

Goodbye!!!!

Uncle Gizmo · Oct 28, 2015

ikzouhetnietweten said:
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 · Oct 28, 2015

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 · Oct 28, 2015

ikzouhetnietweten said:
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 · Oct 28, 2015

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 · Oct 28, 2015

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

arnelgp · Oct 28, 2015

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

bob fitz · Oct 28, 2015

arnelgp said:
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 · Oct 28, 2015

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 · Oct 28, 2015

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 · Oct 28, 2015

Not another Colin... I'll resign!

JHB · Oct 29, 2015

ikzouhetnietweten said:
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.

Hide error in textbox

Registered User.

Super Moderator

Registered User.

AWF VIP

Registered User.

Super Moderator

Eledittingent Beliped

Registered User.

Registered User.

Nifty Access Guy

Registered User.

AWF VIP

Registered User.

Registered User.

..forever waiting... waiting for jellybean!

AWF VIP

Registered User.

Registered User.

Nifty Access Guy

Have been here a while

Similar threads

Users who are viewing this thread