Validation Rule - NO COMMAS - all other characters allowed
Newbie
my export for a bulk load spreadsheet.
Thank you.
--
Newbie
a a r o n . k e m p f @ g m a i l . c o m
Newbie
Validation Rule - NO COMMAS - all other characters allowed
--
Newbie
bob.q...@gmail.com
Ignore a aWr o nG kempf.
use the replace() function to substitute a space (or other symbol) for
the comma.
Q
Ken Sheridan
InStr([YourField],",")=0
or the Like operator:
Not Like "*,*"
In a form you can prevent the user typing a comma by putting the following
lines of code in the control's KeyPress event procedure:
Const COMMAKEY = 44
' set return value of KeyAscii argument
' to zero if comma key pressed
If KeyAscii = COMMAKEY Then
KeyAscii = 0
End If
This does not prevent a comma character being entered by other means of
course, so should be backed up with a validation rule for the column in table
design. Also the user would be given no indication why they cannot enter a
comma, so you might additionally want to call the MsgBox function within the
If….End If statement to inform the user that the character is not allowed.
Ken Sheridan
Stafford, England
![Arvin Meyer [MVP]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjWNeBaELXBA4T-Yh0e0NpfK3HiG4ga607fRgadqcjevhVaQ=s40-c)
Arvin Meyer [MVP]
news:4D5BEE35-337D-4CE8...@microsoft.com...
> Trying to write a Validation Rule that will not allow commas. They mess
> up
> my export for a bulk load spreadsheet.
Setting an input mask to a lower case a, allows entry of only letters or
numbers, so if you have a 20 character text field, use 20 a's:
aaaaaaaaaaaaaaaaaaaa
See the help files for InputMask then look at the syntax and examples
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Newbie
Is Null or Not Like "*,*"
and it seems to work. Gave it a Validation Text of "No Commas Allowed" to
remind.
Thanks.
--
Newbie
a a r o n . k e m p f @ g m a i l . c o m
keep your personal attacks elsewhere.
-Aaron
On May 14, 9:52 am, "rquin...@sympatico.ca" <bob.quin...@gmail.com>
wrote:
Bob Quintal
wrote in
news:18468a3b-0a09-4cd3-a9d3-48027a88ab69
@l17g2000pri.googlegroups.co
m:
> rob;
>
> keep your personal attacks elsewhere.
What I wrote was not an attack against your person, but against the
nonsense you posted.
I would not attack the stupid, and worse the malicious, advice you
spew if you would take yourself elsewhere.
Go away,
At this point I no longer care if you go away angry,
just go away.
--
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **
a a r o n . k e m p f @ g m a i l . c o m
The idiots around here-- that attack me with mob tactics-- _ARE_
stupid and malicious.
-Aaron
On May 14, 3:00 pm, Bob Quintal <rquin...@sPAmpatico.ca> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> ** Posted fromhttp://www.teranews.com**- Hide quoted text -
>
> - Show quoted text -
Arvin Meyer [MVP]
message
news:6a59795f-204d-41d8...@t12g2000prg.googlegroups.com...
> I'm not stupid or malicious.
Really? Then why were you convicted of personally threatening one of the
MVPs here? It seems to me that your conviction rate for stupid criminal
activity is significant.
Considering that you are on probation right now for some of that activity, I
would think that it is quite stupid to risk revocation of that probation.
There will come a point where your daddy can't or won't bail you out any
more. A smart person would be aware of that and act accordingly.
a a r o n . k e m p f @ g m a i l . c o m
revocation? lol.
It's probation, not parole!!!
I'm just not sure you get it.
thanks
-Aaron
On May 15, 12:46 am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote in
> messagenews:6a59795f-204d-41d8...@t12g2000prg.googlegroups.com...
a a r o n . k e m p f @ g m a i l . c o m
I wasn't convicted of anything other than some kid whining to the
right pig.
It's laughable-- to take such so-called threats seriously.
Furthermore-- I'm not positive that I ever agreed that I did
anything. Personally-- I deny all of it.
Thanks
-Aaron
On May 15, 12:46 am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote in
> messagenews:6a59795f-204d-41d8...@t12g2000prg.googlegroups.com...
BruceM
It looks like he "gets it".
"a a r o n . k e m p f @ g m a i l . c o m" <aaron...@gmail.com> wrote in
message
news:cafe59ee-736d-46b3...@q27g2000prf.googlegroups.com...
a a r o n . k e m p f @ g m a i l . c o m
you _CAN_ revoke parole
-Aaron
On May 15, 4:23 am, "BruceM" <bam...@yawhodotcalm.not> wrote:
> With whom are you disagreeing now? Arvin referred to probation, not parole.
> It looks like he "gets it".
>
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote in
> messagenews:cafe59ee-736d-46b3...@q27g2000prf.googlegroups.com...
>
> revocation? lol.
>
> It's probation, not parole!!!
>
> I'm just not sure you get it.
>
> thanks
>
> -Aaron
>
> On May 15, 12:46 am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
>
>
>
> > "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote
> > in
> > messagenews:6a59795f-204d-41d8...@t12g2000prg.googlegroups.com...
>
> > > I'm not stupid or malicious.
>
> > Really? Then why were you convicted of personally threatening one of the
> > MVPs here? It seems to me that your conviction rate for stupid criminal
> > activity is significant.
>
> > Considering that you are on probation right now for some of that activity,
> > I
> > would think that it is quite stupid to risk revocation of that probation.
>
> > There will come a point where your daddy can't or won't bail you out any
> > more. A smart person would be aware of that and act accordingly.
> > --
> > Arvin Meyer, MCP,
> > MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...- Hide quoted text -
BruceM
this matter.
"a a r o n . k e m p f @ g m a i l . c o m" <aaron...@gmail.com> wrote in
message
news:d5cc953b-7e66-4e85...@y18g2000pre.googlegroups.com...
![Tony Toews [MVP]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjVFNFhAO8kxGtutFBSPYzx5Lbrrty7WRKPHNhjuWtTEHvsoQdk=s40-c)
Tony Toews [MVP]
wrote:
>I wasn't convicted of anything other than some kid whining to the
>right pig.
That's what a judge is there for. To keep the police reasonably
honest.
>It's laughable-- to take such so-called threats seriously.
Really? Let's let folks review your history and make up their own
mind. http://www.tonytoews.com/disruptions2007.htm
>Furthermore-- I'm not positive that I ever agreed that I did
>anything. Personally-- I deny all of it.
Interesting.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Arvin Meyer [MVP]
news:ecnhKRqt...@TK2MSFTNGP05.phx.gbl...
> I'm unfamiliar with the terminology, so I will yield to your expertise in
> this matter.
Probation terms violation can cause imprisonment at any time during the
period of his sentence. Just let him violate the terms of his probation and
Big Bubba may be teaching him some new terminology.
Bob Quintal
wrote in
news:6a59795f-204d-41d8-ba56-a53423814bb9
@t12g2000prg.googlegroups.co
m:
> I'm not stupid or malicious.
I didn't say you were stupid or malicious, I said your ADVICE was
stupid or malicious. Your above comment tempts me to say that you
actually are both stupid and malicious, I shall refrain for now.
Don't push your luck, though.
a a r o n . k e m p f @ g m a i l . c o m
Your mob-tactics-- hundreds of people attacking everything that I
say-- _IS_ malicious.
-Aaron
> >> ** Posted fromhttp://www.teranews.com**-Hide quoted text -
a a r o n . k e m p f @ g m a i l . c o m
thanks
-Aaron
On May 15, 11:10 am, "Tony Toews [MVP]" <tto...@telusplanet.net>
wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote:
>
> >I wasn't convicted of anything other than some kid whining to the
> >right pig.
>
> That's what a judge is there for. To keep the police reasonably
> honest.
>
> >It's laughable-- to take such so-called threats seriously.
>
> Really? Let's let folks review your history and make up their own
> mind. http://www.tonytoews.com/disruptions2007.htm
>
> >Furthermore-- I'm not positive that I ever agreed that I did
> >anything. Personally-- I deny all of it.
>
> Interesting.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony Toews [MVP]
wrote:
>every judge I talked to-- agreed that they never had probable cause.
Hahaha. You pleaded guilty.
a a r o n . k e m p f @ g m a i l . c o m
Thanks
-Aaron
On May 15, 8:43 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote:
>
> >every judge I talked to-- agreed that they never had probable cause.
>
> Hahaha. You pleaded guilty.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony Toews [MVP]
wrote:
>uh actually I did _NOT_.
The court record states otherwise.
a a r o n . k e m p f @ g m a i l . c o m
your assumptions might interpret otherwise.
Just another couple of months and it will be 'as if it never
happened'.
Technically; it is already 'as if it never happened'.
But honestly-- I don't think that you're sherlock- you weren't then
and you aren't now.
You stalked me-- and I don't need to hear your crap any longer, kid.
You're just a sad old programmer that is defending a sinking ship.
Sorry-- but you're never right and you never have been once.
You _LIE_ and I will not put up with it.
'oh ADP haven't had a fix in the past 3 versions'.
whatever kid-- it's just sad that you need to lie in order to convince
people to stick with a sinking ship.
-Aaron
On May 15, 9:40 pm, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote:
>
> >uh actually I did _NOT_.
>
> The court record states otherwise.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Arvin Meyer [MVP]
uh actually I did _NOT_.
Thanks
-Aaron
Uh, actually you did.
Court: King Co Superior Ct
Case Number: 07-9-36099-4
We know that you are living in a fantasy world. Your answers here prove
that. Do yourself a favor and find a good therapist.
Tony Toews [MVP]
wrote:
>You stalked me
Please phone your local police department or the RCMP.
Bob Quintal
wrote in
news:ab0d209d-57c2-4451-b49b-de833038bdf3
@l17g2000pri.googlegroups.co
m:
> My advice is neither malicious or stupid.
The court of public opinion disagrees.
>
> Your mob-tactics-- hundreds of people attacking everything that I
> say-- _IS_ malicious.
>
> -Aaron
>
Your paranoia is showing.
Begone!
Arvin Meyer [MVP]
person who caught you. Now that's really sad.
No one's stalking you. No one cares enough about you to waste their time.
You post inaccurate and nonsensical replies and get caught doing it. We
won't let those who come here for real answers walk away without knowing
that you've posted nothing but trash.
I don't know where you got the impression that Microsoft hasn't fixed
problems with ADPs. They have, and will continue to do so. I can't find any
new features in ADPs in the last version, but that doesn't mean that
Microsoft won't fix bugs.
So you think Access is sinking? Would you believe Bill Gates talking about
Access?
http://blogs.msdn.com/danielfe/archive/2008/02/12/the-bill-gates-interview.aspx
Sorry, but you are wrong. You've always been wrong about Access and are
often wrong about SQL-Server as well. I set an ignore flag on you once. I
should again. So should the entire Internet.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"a a r o n . k e m p f @ g m a i l . c o m" <aaron...@gmail.com> wrote in
message
news:06c30463-e09f-41e3...@i36g2000prf.googlegroups.com...
a a r o n . k e m p f @ g m a i l . c o m
I did not 'plead guilty'-- it is a different charge than what they
charged me with.
Furthermore-- yes, I am a victim of a bully crowd and a bully cop.
Thanks
-Aaron
On May 16, 8:44 am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> Interesting! You've been caught red-handed in a lie, and you accuse the
> person who caught you. Now that's really sad.
>
> No one's stalking you. No one cares enough about you to waste their time.
> You post inaccurate and nonsensical replies and get caught doing it. We
> won't let those who come here for real answers walk away without knowing
> that you've posted nothing but trash.
>
> I don't know where you got the impression that Microsoft hasn't fixed
> problems with ADPs. They have, and will continue to do so. I can't find any
> new features in ADPs in the last version, but that doesn't mean that
> Microsoft won't fix bugs.
>
> So you think Access is sinking? Would you believe Bill Gates talking about
> Access?
>
> http://blogs.msdn.com/danielfe/archive/2008/02/12/the-bill-gates-inte...
>
> Sorry, but you are wrong. You've always been wrong about Access and are
> often wrong about SQL-Server as well. I set an ignore flag on you once. I
> should again. So should the entire Internet.
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com> wrote in
> messagenews:06c30463-e09f-41e3...@i36g2000prf.googlegroups.com...
> > Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/- Hide quoted text -
Tony Toews [MVP]
wrote:
>bullshit. I never lied.
>I did not 'plead guilty'-- it is a different charge than what they
>charged me with.
The court record states you pleaded guilty. How you can possibly deny
that is beyond me.
And Daddy paid your fine.
>Furthermore-- yes, I am a victim of a bully crowd and a bully cop.
No, you're no victim. You're the stalker. And you pleaded guilty.
a a r o n . k e m p f @ g m a i l . c o m
I might have 'plead guilty'- but I am not guilty.
Thanks
Nice try.
You're the one that put up websites-- following me around; putting my
personal information on your website.
I did nothing of the sort.
Here is more information about how I can deny it:
--------------------------------------------------------------------------------------------
http://www.pierce.ctc.edu/whamilto/DPIntro.htm - deferred prosecution
Washington State's Deferred Prosecution Intervention Policy
Deferred prosecution is a unique policy. No other states have a
policy (law) like it, and few have anything similar. Deferred
prosecution is a true intervention initiative. It recognizes that
crisis is often the best incentive to motivate changes in behavior or
confront dysfunctional or unhealthy life-styles. It also recognizes
the disease nature of chemical addictions, and the "loss of control"
that accompanies chemical dependency and many mental health diagnoses.
--------------------------------------------------------------------------------------------
http://www.expertlaw.com/forums/showthread.php?t=14868
A reference to a "deferred sentence" is normally to a sentence where,
if the defendant successfully completes a period of probation, the
charge is dismissed without a conviction being entered. The result is
that the person can truthfully deny having been convicted of the
underlying criminal offense.
If the defendant violates the terms of that probation, the conviction
is entered and they are sentenced on the charge.
--------------------------------------------------------------------------------------------
Again-- Althought I might have plead guilty _TO_A_LESSER_CHARGE_ I
still maintain my innocence.
Even-- if I did 'pleady guilty' I don't agree that I said X, Y or Z.
I was just told that it would be _SAFEST_ to plead TO A LESSER CHARGE.
I'm not guilty of anything-- except a bunch of old dudes that will
stop at _NOTHING_ to silence critics.
-Aaron
On May 16, 9:03 am, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote:
> "a a r o n . k e m p f @ g m a i l . c o m" <aaron.ke...@gmail.com>
> wrote:
>
> >bullshit. I never lied.
> >I did not 'plead guilty'-- it is a different charge than what they
> >charged me with.
>
> The court record states you pleaded guilty. How you can possibly deny
> that is beyond me.
>
> And Daddy paid your fine.
>
> >Furthermore-- yes, I am a victim of a bully crowd and a bully cop.
>
> No, you're no victim. You're the stalker. And you pleaded guilty.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony Toews [MVP]
wrote:
>You're the one that put up websites-- following me around; putting my
>personal information on your website.
What personal information did I put on my website? Everything I
stated and linked to is available on many search engines..
>Again-- Althought I might have plead guilty _TO_A_LESSER_CHARGE_ I
>still maintain my innocence.
>Even-- if I did 'pleady guilty' I don't agree that I said X, Y or Z.
>
>I was just told that it would be _SAFEST_ to plead TO A LESSER CHARGE.
I'm sure that's what you were told. Quite obvious actually.
>I'm not guilty of anything--
Rubbish
>except a bunch of old dudes that will
>stop at _NOTHING_ to silence critics.
Again rubbish.