I don't mean to SHOUT!!!! BUT!!!!

Don

unread,

Mar 31, 2004, 3:31:23 PM3/31/04

to

Are there any Naturalized US citizens answering on this forum?
On US Shores thats NOT been Outsourced!
I have listed this question for last 2 hours and no response....SQUEEK,
SQUEEK!!!!!

I can't seem to get this macro to work.
I am trying to display this total in a text box on my form.

Macro Name: CELLTOTL
Condition: TRUE
Action Name: SetValue
Arguments: [CELLTOTL], 57.46

Here is the expression in Macro:(All fields are currency)
=[BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+[OTHERCHARGES]+[NONCOM
MRELATED]+[TAXES]

I have even tried:
=Ccur([BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+[OTHERCHARGES]+[N
ONCOMMRELATED]+[TAXES])

I still get the same error on each field data entered although the data
posts to the form ok.
Any help I can get is appreacated

TIA
Donny

Elwin

unread,

Mar 31, 2004, 4:04:17 PM3/31/04

to

You wantee anseree?? OKee Dokee Joe!

Set the 'ControlSource' property of your text box control
to your expression prefaced with an equal sign.

=[BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+
[OTHERCHARGES]+[NONCOMMRELATED]+[TAXES]

Set the Format property of the control to 'Currency'.
Good luck.

>.
>

Cheryl Fischer

unread,

Mar 31, 2004, 4:06:25 PM3/31/04

to

Don,

Your comments are offensive.

I was attempting to reproduce your problem as outlined in your earlier post
and believe I may have an answer for you, but, out of respect for the many
international MVPs and other frequent responders, I am not going to post it.

U.S.born - U.S. raised
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

"Don" <dw_...@yahoo.com> wrote in message
news:vUFac.34719$Td3....@nwrddc02.gnilink.net...

Kevin Sprinkel

unread,

Mar 31, 2004, 4:07:43 PM3/31/04

to

Donny,

This forum is run on a volunteer-only basis for
*professionals* of all origins, races, and skill level.
Noone OWES you a response to any question EVER.

I suggest you make your requests clear and succinct, your
thanks genuine, and your attitude appreciative.

Kevin Sprinkel

Rick

unread,

Mar 31, 2004, 5:00:13 PM3/31/04

to

Why are you dealing with a macro?

Just enter the formula in the text box.

=[BALANCEADJ]+[MOSERVICE]+[HOMECHARGES]+[ROAMCHARGES]+[OTHERCHARGES]+[NONCOM
MRELATED]+[TAXES]

Rick

"Don" <dw_...@yahoo.com> wrote in message
news:vUFac.34719$Td3....@nwrddc02.gnilink.net...

fredg

unread,

Mar 31, 2004, 6:26:18 PM3/31/04

to

Donny,
I saw your question about a half-hour ago, and I decided I would not
respond, as you didn't clearly state what kind of error you were
having.

After reading your introduction to this message, I'm glad I did not.
You seem to think that anyone monitoring this, or any other, newsgroup
owes you an immediate reply. Your message that readers from outside
the United States are incompetent is insulting. Shame on you!! The
incompetency is not theirs, it's yours. You didn't clearly state what
your problem was. Perhaps other readers, like I, didn't want to waste
their newsgroup time by asking for a clarification.

You would be well served to re-think your attitude.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

JunkMan

unread,

Mar 31, 2004, 7:09:44 PM3/31/04

to

Fred
Thanks for your response..But I'm actually angry at You Bleeding Hearts that
think We as Americans owe other nation memebers some sort of apolagy. Wel
GUESS WHAT ..WAKE UP! All the American Jobs are being given to the people
your trying to defend. There is coming a day that your ass may be asking
them for a handout if things keep going as is.
You people MAKE ME SICK with all your sympothy thats misdirected.
So PLEASE .. You Keep your answer Fred I'd rather do without it!

Thanks for nothing
"fredg" <fgut...@example.invalid> wrote in message
news:ls8arhy3jnr4.1s1lbvi4ucz25$.dlg@40tude.net...

Steve Schapel

unread,

Mar 31, 2004, 8:17:57 PM3/31/04

to

Donny,

SHOUT all you want. And spew drivel all you want. And ask questions
that don't make sense all you want. But *DON'T MULTI-POST!!*

--
Steve Schapel, Microsoft Access MVP

TC

unread,

Mar 31, 2004, 11:28:40 PM3/31/04

to

Too houwrs? Me thinkee you to impashent budddeee!!

TC

"Don" <dw_...@yahoo.com> wrote in message
news:vUFac.34719$Td3....@nwrddc02.gnilink.net...

TC

unread,

Mar 31, 2004, 11:29:08 PM3/31/04

to

Nicely put!

TC

"Steve Schapel" <sch...@mvps.org.ns> wrote in message
news:OpVTsc4F...@TK2MSFTNGP11.phx.gbl...

Niklas Östergren

unread,

Apr 1, 2004, 12:15:20 AM4/1/04

to

Make it easy for you Don!

Post an apology to the people who voluntarily spend there presius time
trying to help us with things that would have taken us MUCH longer time to
solve without this great help, if ever!

You owe them that! And it just might help you out a bit geting help here in
the future!

// Niklas

"Don" <dw_...@yahoo.com> skrev i meddelandet
news:vUFac.34719$Td3....@nwrddc02.gnilink.net...

John Viescas

unread,

Apr 1, 2004, 9:08:39 AM4/1/04

to

Instead of posting angry vitriol, you need to go educate yourself. Go read
this:

http://www.salon.com/tech/feature/2004/04/01/collabnet/index.html

For many companies, "outsourcing" is the only way to keep the company alive
in a global economy - and avoid shutting down U.S. operations altogether,
which would result in even more job losses.

--
John Viescas

"JunkMan" <dwe...@nospamyahoo.com> wrote in message
news:c5Jac.10654$BE3....@nwrddc03.gnilink.net...