Re: eliminating the pre programmed "OnNotInList" message Box

and, your posts are boarderline rude and threatening. Do you realize that
your statements can be interpreted as:
Examples of Abusive or Insulting Language?
1. Verbal threats;
2. Humiliating statements;
I don't necessarily think your statements are totally above par and Abusive
and Insulting language is grounds for legal action. I would greatly
apreciate it if you were a little kinder with your statements.
--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name who
wrote that song about "Spam"]


"'69 Camaro" wrote:

Hi, Chris.

1) I formally apologized to fredg. I admitted that I missed it. All I
saw
was his sharpshooting my code. I apologized to fredg.

I'm glad of that. Perhaps you'll offer apologies for your rude and snide
remarks to others as well?

Because you're anonymous you
feel you can just shoot people down

Just as your assertion that you weren't aware of Missinglinq's posting
history has no bearing on whether or not he is allowed to criticize your
behavior, it makes no difference whether or not you personally know the
posters who are pointing out your unacceptable behavior to you. It would
have made no difference if Mike Reynolds and Joe Wilson (or your neighbors
across the street, for that matter) pointed out that your rudeness is not
acceptable here with the exact same words Missinglinq and I used in our
posts yesterday. The messages were clear that you were out of line, it was
noticed, and no one else should follow in your footsteps thinking "it's okay
to be rude in the Access newsgroups." If you consider that being "shot
down," then don't fly in that no-fly zone, or it will happen to you again.

I have never -- and would never -- write something in a post on the Internet
that I wouldn't say to a person's face. So don't think I'm only being brave
telling you that you were rude merely because you aren't within arm's reach.

And both Missinglinq and I are hardly anonymous, except perhaps to you.
We've been posting in the Access newsgroups for quite a while, and have
built reputations with our specific display names. If you need evidence of
that, since I occasionally post to the newsgroups using the same forum as
you do, you can read my profile by clicking on the profile link on the first
message I posted in this thread. I suspect you'd have to go to
AccessMonster.com to check Missinglinq's profile, because he's not a member
of the Microsoft Online Community.

From another post of yours
(http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/f054f91104eeca40/f3e34b667f3daef7?lnk=st&q=&rnum=8&hl=en#f3e34b667f3daef7),
it appears that you have respect for those who include MVP in their
signatures. Perhaps you feel you can be as rude and disrespectful as you
want to be to those who don't include MVP in their signatures. Be aware
that many folks read the posts in these newsgroups, including MVP's, and can
see how you treat others. You can be sure that those readers will treat you
accordingly.

your some god of the internet.

"God of the Internet"? Awesome! Is this a paid position? Do I get a primo
parking spot and business cards, too? I'll have to add this title to my
star on the Hollywood Walk of Fame:

http://urltea.com/l2a?HollywoodStar

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Chris Hayes" <hayes.csmontypython@xxxxxxxxx> wrote in message
news:FF1F775D-4E7E-4CA3-9630-4BA7FE4AFC25@xxxxxxxxxxxxxxxx
1) I formally apologized to fredg. I admitted that I missed it. All I
saw
was his sharpshooting my code. I apologized to fredg.

2) Some of you should mind your own business. Because you're anonymous
you
feel you can just shoot people down like your some god of the internet.
The
original post appeared to me of someone sharpshooting my code outside of
my
request for assistance with no regard to my question. I was wrong and
apologize.
--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name who
wrote that song about "Spam"]


"'69 Camaro" wrote:

Hi, Chris.

Anyone else?

No need. Fred did an excellent job giving you advice. It stands on its
own.

However, your rejection of his answer and his effort to help you with a
rude
"Anyone else?" isn't likely to prompt the generous and helpful experts in
the
Access newsgroups to come to your aid for this question or your future
questions -- even if Fred's answer had been wrong. That's mainly because
people don't want to receive the same disrespect from you if their
answers
displease you in some way. The volunteers in this newsgroup, as in most
newsgroups, work hard to provide correct, timely responses to assist
those
who need it, and we provide it completely free of charge. The volunteers
don't deserve to be treated badly.

Elsethread:

FYI I HELP PEOPLE HERE (look at my profile)

Switching shoes does not give you permission to bite the hand that feeds
you
simply because you have fed others in the past.

I looked at your profile and there's no info so I can't tell if YOU
help or
not. You probably do but I can't tell.

A quick search of the forum or the newsgroups would tell you that he
often
helps posters with their Access problems. But even if he was a
first-time
poster outraged by your rudeness, do you think that invalidates his
pointing
this out to you and allows you to ignore his explanation of how to handle
a
response that's less than you desired? It does not. That he has no
profile
in the forum you use to access the newsgroups matters not. Nor does it
matter that you have no profile in the forum he uses to access the
newsgroups.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Chris Hayes" <hayes.csmontypython@xxxxxxxxx> wrote in message
news:D6E838D3-4DF9-4E18-B7F0-0D42B6CFB898@xxxxxxxxxxxxxxxx
Anyone else?
--
Chris Hayes
Still a beginner (only 12 years)

[fyi, you can email me by getting rid of the British Comedian''s name
who
wrote that song about "Spam"]


"fredg" wrote:

On Wed, 16 May 2007 09:25:01 -0700, Chris Hayes wrote:

Here's my code:

Private Sub Combo1985_NotInList(NewData As String, Response As
Integer)
If MsgBox("Contributor Not Found" & vbCrLf & "Add a new
contributor?",
vbYesNo + vbQuestion, "Contributor Not Found") = vbYes Then
Me.Combo1985 = Null
Me.Form.SetFocus
DoCmd.RunCommand acCmdRecordsGoToNew
Else
Exit Sub
End If

End Sub

This all works but...

How do I get Access not to show the "notinlist" message box?

Private Sub Combo1985_NotInList(NewData As String, Response As
Integer)
Response = acDataErrContinue ' ** Add this line
If MsgBox("Contributor Not Found" & vbCrLf & "Add a new
contributor?", vbYesNo + vbQuestion, "Contributor Not Found") = vbYes
Then
Me.Combo1985 = Null

Me.Form.SetFocus ' *** What is this line supposed to do? Do
you have a form or control named "Form"? I hope not.

DoCmd.RunCommand acCmdRecordsGoToNew
Else
Exit Sub
End If

End Sub



.

Relevant Pages

  • Re: eliminating the pre programmed "OnNotInList" message Box
    ... humiliating you, or rude or abusive to you in any way, then don't be rude. ... We've been posting in the Access newsgroups for quite a while, ... Private Sub Combo1985_NotInList(NewData As String, Response As ...
    (microsoft.public.access.modulesdaovba)
  • Re: eliminating the pre programmed "OnNotInList" message Box
    ... Perhaps you'll offer apologies for your rude and snide ... We've been posting in the Access newsgroups for quite a while, ... Private Sub Combo1985_NotInList(NewData As String, ...
    (microsoft.public.access.modulesdaovba)
  • Re: eliminating the pre programmed "OnNotInList" message Box
    ... fredg's response, I jumped the gun, jumped to conclusions that he was ... Perhaps you'll offer apologies for your rude and snide ... We've been posting in the Access newsgroups for quite a while, ... Private Sub Combo1985_NotInList(NewData As String, ...
    (microsoft.public.access.modulesdaovba)
  • Re: eliminating the pre programmed "OnNotInList" message Box
    ... fredg's response, I jumped the gun, jumped to conclusions that he was ... Perhaps you'll offer apologies for your rude and snide ... We've been posting in the Access newsgroups for quite a while, ... Private Sub Combo1985_NotInList(NewData As String, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sit Down, Theyre Closing the Show
    ... newsgroups for quite a while now.> ... Notice how every one of your posts has at least 4 or 5 one star ... ratings whereas Kukla aka gayport has the opposite. ... I just don't understand why he has to be rude to ...
    (rec.arts.theatre.musicals)
Loading