eliminating the pre programmed "OnNotInList" message Box

[Chris Hayes]

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?

--
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]

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

 

[Chris Hayes]

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"]

 

[Chris Hayes]

Answer:
Response = acDataErrContinue

Thanks to "Access 2003 Inside / Out" by viescas

One of my favorite books on the subject


--
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"]

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"]

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

 

[fredg]

Answer:
Response = acDataErrContinue

Thanks to "Access 2003 Inside / Out" by viescas

One of my favorite books on the subject

Didn't you read my message?

Response = acDataErrContinue ' ** Add this line

 

[missinglinq via AccessMonster.com]

This is kind of the straw that's breaking this camel's back! This is the 5th
time today I've seen this identical behaviour, here and on other forums! The
people that give their time and expertise here to help others out are all
volunteers! They have families and jobs and lives of their own that they
could be pursuing, if they weren't here trying to help out. For the original
poster to ignore help that was offered, by fredg in this case, and simply
post a comment such as "Anyone else?" is inexcusably rude! For him to do so
when the response by fredg was correct is the height of stupidity, and for
him to come back, over 48 hours later, and crow about having found the answer
himself is beyond comprehension!

If you post a question, try out the solutions that are offered. They won't
always work, for a variety of reasons, frequently because the original poster
has omitted crucial facts or hasn't explained his problem clearly. But try
the solution out, and come back and explain why it didn't work, if that is
the case. This will give others helpful info in trying to help you. If the
solution offered does work, come back and let us know that too! That way
everyone knows that there's no need to keep offering suggestions, and people
searching the forum with similar prolems will know what works and what
doesn't.

 

[Chris Hayes]

FYI I HELP PEOPLE HERE (look at my profile)

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.

I didn't see his answer, all I was was a comment sharp shooting my code. I
put the focus on the form to ensure that that form gets the "new" record.

Thanks for your input? Yeah, thanks.
--
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"]

 

[Chris Hayes]

I'm sorry fredg, I missed it. All I saw was the sharp shooting on my line
for focusing the form. I owe you an apology. Please forgive me.

--
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]

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.

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"]

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

 

[Chris Hayes]

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"]

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.

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"]

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

 

['69 Camaro]

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/micr...daef7?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.

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"]

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.

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"]


:

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

 

[Chris Hayes]

I'm frankly flattered by all the attention you are giving little ole me.

I can't say I'd write this long of a thread about your inadequacies...

Look Camaro... you're right, I was rude, I didn't really stop to read
fredg's response, I jumped the gun, jumped to conclusions that he was
sharpshooting my code with no regard to my question.

I'm assuming you have NEVER done this yourself and that you have an entirely
impecable record.

--
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"]

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/micr...daef7?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.

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"]

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.


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"]


:

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

 

[Chris Hayes]

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"]

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/micr...daef7?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.

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"]

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.


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"]


:

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

 

['69 Camaro]

Hi, Chris.

I'm assuming you have NEVER done this yourself

Have I asked a question, received an answer I didn't like, brusquely brushed
the answerer aside to get another answer from someone else, and when I
didn't get one, researched elsewhere to find an answer I did like, returned
and tooted my horn that _I_ found the right answer to the person who gave me
the original answer -- and then spoke rudely to those who admonished me for
being way out of line and advised me how I should have acted instead? No.
I haven't. Not even when I was a kid, because we were taught to treat
others with respect.

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.

I'm frankly flattered by all the attention you are giving little ole me.

I can't say I'd write this long of a thread about your inadequacies...

Look Camaro... you're right, I was rude, I didn't really stop to read
fredg's response, I jumped the gun, jumped to conclusions that he was
sharpshooting my code with no regard to my question.

I'm assuming you have NEVER done this yourself and that you have an
entirely
impecable record.

--
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"]

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/micr...daef7?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.

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"]


:

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.


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"]


:

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

 

['69 Camaro]

Hi, Chris.

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;

If you interpret any of my statements as rude, threatening, abusive,
insulting, or humiliating, then no one is going to lift a finger to try to
convince you otherwise. To be fair to you, I thought you should have a
heads up as to why your questions may not be answered as quickly in the
future when some experts aren't promptly coming to your aid when you post
questions, since they don't want to be treated with the rudeness you've
exhibited in this thread. If you consider my telling you how you are going
to be treated according to your disposition in this thread as threatening to
your well-being, then people aren't going to tell you the truth in the
future, and you'll just have to guess what's going on. If you consider my
telling you that any future rudeness by you is going to be shot down again
with posts from us admonishing you -- and reminding you that it's never okay
to be disrespectful -- as threatening to your well-being, insulting or
humiliating you, or rude or abusive to you in any way, then don't be rude.

Perhaps you were having a bad day. I don't know. My advice is to try to
avoid repeating it. Treat others the same way you wish to be treated.

I would greatly
apreciate it if you were a little kinder with your statements.

A little kinder? Gunny is short for Gunnery Sergeant, United States Marine
Corps. If you aren't familiar with the characteristics of a Gunny, then
take a look at this guy:

http://www.orizzontikubrickiani.it/images/hartmantojoker.jpg

http://content.answers.com/main/content/wp/en/thumb/9/97/325px-Lee_Ermey_Full_Metal_Jacket.jpg

http://www.rleeermey.com/

Gunnys don't coddle anyone except babies and toddlers. If you're not
wearing diapers, you're not getting coddled, no matter how primo that
parking space is.

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.

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"]

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/micr...daef7?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.

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"]


:

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.


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"]


:

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

 

[Chris Hayes]

This ain't the marine corp

and I'm not a slick sleave

You need to be professional toward civilians

You won't always be in the corp, the world doesn't work like the corp.


--
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"]

Hi, Chris.

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;

If you interpret any of my statements as rude, threatening, abusive,
insulting, or humiliating, then no one is going to lift a finger to try to
convince you otherwise. To be fair to you, I thought you should have a
heads up as to why your questions may not be answered as quickly in the
future when some experts aren't promptly coming to your aid when you post
questions, since they don't want to be treated with the rudeness you've
exhibited in this thread. If you consider my telling you how you are going
to be treated according to your disposition in this thread as threatening to
your well-being, then people aren't going to tell you the truth in the
future, and you'll just have to guess what's going on. If you consider my
telling you that any future rudeness by you is going to be shot down again
with posts from us admonishing you -- and reminding you that it's never okay
to be disrespectful -- as threatening to your well-being, insulting or
humiliating you, or rude or abusive to you in any way, then don't be rude.

Perhaps you were having a bad day. I don't know. My advice is to try to
avoid repeating it. Treat others the same way you wish to be treated.

I would greatly
apreciate it if you were a little kinder with your statements.

A little kinder? Gunny is short for Gunnery Sergeant, United States Marine
Corps. If you aren't familiar with the characteristics of a Gunny, then
take a look at this guy:

http://www.orizzontikubrickiani.it/images/hartmantojoker.jpg

http://content.answers.com/main/content/wp/en/thumb/9/97/325px-Lee_Ermey_Full_Metal_Jacket.jpg

http://www.rleeermey.com/

Gunnys don't coddle anyone except babies and toddlers. If you're not
wearing diapers, you're not getting coddled, no matter how primo that
parking space is.

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.

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"]

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/micr...daef7?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.


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"]


:

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.


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"]


:

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

 

['69 Camaro]

Hi, Chris.

You need to be professional toward civilians

I am being professional, although you'll disagree because you feel insulted
and humiliated at being criticized for your behavior. I'll be honest with
you, too. You had more than half a dozen flaws in the nine lines of code
you posted, but given your displeasure of any sort of criticism, it's
doubtful anyone will quickly jump on the opportunity to provide further
assistance with the other half dozen flaws. It's also doubtful that you'll
recognize what those flaws are or how to fix them without that assistance.
And it's highly probably that the rest of your procedures are built from the
same mold as this procedure, so I would advise you to swallow your pride and
accept the help you need, even if you don't specifically ask for it.

And for the record, Fred didn't shoot down one of the flaws in your code.
He questioned what you were trying to do with it, so that he could offer the
correct syntax. You appear to be unwilling to accept his assistance as an
offer of help and instead consider it to be a criticism either of your work
or of you. If you maintain that attitude, you will have a tough row to hoe
ahead of you. The volunteers in these newsgroups are here to help you, as
long as you're willing to let them -- and you don't bite them.

Good luck.
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.

This ain't the marine corp

and I'm not a slick sleave

You need to be professional toward civilians

You won't always be in the corp, the world doesn't work like the corp.


--
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"]

Hi, Chris.

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;

If you interpret any of my statements as rude, threatening, abusive,
insulting, or humiliating, then no one is going to lift a finger to try
to
convince you otherwise. To be fair to you, I thought you should have a
heads up as to why your questions may not be answered as quickly in the
future when some experts aren't promptly coming to your aid when you post
questions, since they don't want to be treated with the rudeness you've
exhibited in this thread. If you consider my telling you how you are
going
to be treated according to your disposition in this thread as threatening
to
your well-being, then people aren't going to tell you the truth in the
future, and you'll just have to guess what's going on. If you consider
my
telling you that any future rudeness by you is going to be shot down
again
with posts from us admonishing you -- and reminding you that it's never
okay
to be disrespectful -- as threatening to your well-being, insulting or
humiliating you, or rude or abusive to you in any way, then don't be
rude.

Perhaps you were having a bad day. I don't know. My advice is to try to
avoid repeating it. Treat others the same way you wish to be treated.

I would greatly
apreciate it if you were a little kinder with your statements.

A little kinder? Gunny is short for Gunnery Sergeant, United States
Marine
Corps. If you aren't familiar with the characteristics of a Gunny, then
take a look at this guy:

http://www.orizzontikubrickiani.it/images/hartmantojoker.jpg

http://content.answers.com/main/content/wp/en/thumb/9/97/325px-Lee_Ermey_Full_Metal_Jacket.jpg

http://www.rleeermey.com/

Gunnys don't coddle anyone except babies and toddlers. If you're not
wearing diapers, you're not getting coddled, no matter how primo that
parking space is.

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.

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"]


:

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/micr...daef7?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.


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"]


:

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.


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"]


:

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

 

[John W. Vinson]

I'm sorry fredg, I missed it. All I saw was the sharp shooting on my line
for focusing the form.

You saw "sharpshooting". I saw a question asking for clarification, and an
expression of surprise at a nonstandard operation (setting focus to a form).

Calm down, Chris. Nobody was attacking you... until you started being prickly
and insulting. There is a difference between criticising your code and
personally insulting you as a person - it's quite possible to do the first
without doing the second.

John W. Vinson [MVP]

 

[Marshall Barton]

This ain't the marine corp

and I'm not a slick sleave

You need to be professional toward civilians

You won't always be in the corp, the world doesn't work like the corp.

Lighten up Chris.

Questions (not sharpshooting) about your code are intended
to either clarify why you are doing something or to get your
attention in a constructive criticism way. No one was
attacking you and even your prickly responses only provoked
constructive criticism intended to help you be a more
effective poster.

 

[RD]

You were more than wrong. You were, and are, a complete ass. You can't ask for
help in a public forum, put your foot in your mouth, and then tell people to
"mind their own business".

Welcome to the "Bozo Bin".