Capricorn1's hunt for the points

When a questioner finds a solution by him self a request for closure can be made and an expert can complain.
That's exactly what capricorn1 did in this case:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24511901.html

The questioner did post his solution and questioners final comment was:
"My appologies. It is that your suggestion is exactly how my code already reads and has nothing to do with the solution."

But capricorn1 did get the "Answer" assigned, although it was solved by the questioner...

Another sample of the "quality answers" you need to pay for to get.

Ab-normalization at Experts Exchange - part 14

Question today: How would you run an update query in Access

A questioner want to update in a field the value -1 to 215 and 0 to Null

The proposed queries by a real expert:
UPDATE tblethnicitycopy SETintFatherNEuropean = Null WHERE intFatherNEuropean= 0
UPDATE tblethnicitycopy SETintFatherNEuropean = 250 WHERE intFatherNEuropean= -1

doesn't work as there's no space after the SET command :-(

But crappy has a working copy/paste solution:
UPDATE tblethnicitycopy
SET intFatherNEuropean = iif([intFatherNEuropean]=-1,250, Null)

He just forgot that all other values (not being -1) will turn into Null too .
That's what I call a beginners mistake, but did I even thought he was an expert?

The questioner added a question:
Now I see why you have > 1,000,000 points. Another great solution to a difficult issue.
Could you tell me why the standard approach I tried ~ to the shambalad solution does not work and
your solution does work?

Like my previous blog article did point out, there's no additional comment from crappy, as he's got his points

Thanks to crappycorn1 I had my daily laugh, so please keep on commenting crappy

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24413706.html)

Ab-normalization at Experts Exchange - part 13

Question today: Is it possible to implement a triple click in MS Access 2007 Form

The correct answer is "No" and that's what crappycorn does know and it does get him another 2,000 expert points.
He even took the effort to ask "can you explain what you want to do?"

The questioner described the goal:
"We are building a touch screen application using MS Access 2007. For text fields on the form, our users
want to have a "Simple" keyboard(A pop up form).
For example, a button with Caption ABC - Single click is A, double click is B, triple click is C."
and accepted the "No" comment as the solution.....

There's an "easy" solution to code a button with an "rotating" caption.

But there's no more commenting from crappycorn, now the question remains, is this because of the "I have my expert points" attitude from crappy or isn't he able to think of such a solution....

It's my guess that option 2 is the correct answer to this, but feel free to think that it's his attitude...

Thanks to crappycorn1 I had my daily laugh, so please keep on commenting crappy

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24322006.html)

Ab-normalization at Experts Exchange - part 12

Question today: Simple Query Criteria pulling data from a form.

Obviously "Simple" was the tempting word here for the EE "expert", so the proposed solution was "Simple" too, a "RTFM" link pointing to "How to use the Query by Form (QBF) technique in Access 2000"

The fact that the questioner posted a query using formfields, does make this solution look a bit odd. The "general" solution is to use "LIKE" or to code some VBA code to construct the WHERE clause.

Remains the question why this "solution" was accepted by the questioner....

So I had my laugh today again, or is it something to cry....

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_24347199.html)

Ab-normalization at Experts Exchange - Part 1

I'm always disappointed when beginners are pointed the wrong way.

The first glance at a table design like:

Table A - ID, LAstname, First Name, Year
Table B - ID, LAst Name, First Name, Year, accepted status

Triggers for me the question "Why two tables with almost identical fields?"

But as the beginner asks for how to delete rows in both tables when the [accepted status] holds a certain value, he's helped by an "expert" without even asking for the reason of this "design". Even the possibility of a Cascade Delete isn't mentioned...

It's obvious that this beginner should start with redesigning his database structure and should be pointed to an article about database normalization. Having this "process driven table design" will cause a lot of additional questions and coding, thus generating more "expert points" for this "would be expert". So it's obvious that it's not in the interest of this "expert" to point this beginner in the right direction and this (paying) experts exchange member is fooled by this "expert" as he thinks his problem is solved, while it just has started.

This bad service to a paying experts exchange "premium" member is even more embarrassing when you know that this "would be expert" even proudly states in his profile that he's an MVP....

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23762363.html and for those without member access a copy can be found at: http://www.altict.nl/Q_23762363.html )

Ab-normalization at Experts Exchange - Part 2

When I see a question with a statement like:
"if someone chooses Mike Smith from the drop-down field, then Mike Smith will also automatically be entered in the other field?"

Then my first question would be why a firstname and lastname are stored in one field.
The next question would be where this drop-down field is getting it's information from.
And also a question why having this mechanism in place, while the proper sequence would be to have the user first determine or a person is already registered, before starting to enter a new one...

None of these questions are stated in the "answer comment", the questioner gets a simple answer with a Move statement, even without referring to a test and/or warning when there's already data in the target field that could be overwritten.

Another fine sample of the way you can be "helped" when paying for an answer.

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23885899.html or at http://www.altict.nl/Q_23885899.html when you have no free access)

Ab-normalization at Experts Exchange - part 3

The question today:
How to trap error when form closes with a null value in an index or primary key field?

Obviously this member tries to close a partially filled for, or a so-called "dirty" form.
The "normalized" way to handle this is to issue a confirmation message that the user wants to abandon the record and when confirmed, issue a "Me.Undo" to restore the record contents and to close the form normally.

The Experts-Exchange #1 Access expert however proposes to code an error handling exit when dataerr=3058 occurs in the form_error event.
This will however work sometimes, but as the error code can differ, depending on the Access and Windows version, it's no 100% solution.
Moreover in general coding rules it's considered bad practice to code error handling afterwards when you can intercept / prevent such an error on forehand.

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Q_23924143.html)