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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: AJ Raiber (anonymous_at_discussions.microsoft.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 15:48:44 -0800

Don,

   If all you are doing is trying to enter a total, why
are you using a macro? Is this a total you need to store
for some reason? If not, just enter the formula in an
unbound box. If you do need to store the total for some
unknown reason then post again and we'll see what we can
come up with.

   By the way, I only answer cause I am a really nice
person. I can understand your other response. If at
first you don't get a response in the future, try another
post to clarify the question. The help I have gotten here
has been from all over the world. rarely have I gotten
any responses from the US.

HTH

AJ
>-----Original Message-----
>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
>
>
>
>
>.
>

Relevant Pages

  • Re: I dont mean to SHOUT!!! BUT!!!
    ... If you do need to store the total for some ... > unknown reason then post again and we'll see what we can ... I can understand your other response. ... >>I can't seem to get this macro to work. ...
    (microsoft.public.access.macros)
  • Re: identifying most recently used symbol (via VBA) in MSO2003, as sho
    ... dialog and store them separately. ... ' where they can be read by another macro that needs to know ... >Sub InsertSymbol() ...
    (microsoft.public.word.vba.general)
  • Re: Filling in the Blanks - Using the Mouse
    ... response to my posted question. ... populate a particular blank field. ... having to set the macro security level to Medium and clicking the Enable ... Now go into the Properties dialog of each form field and set the Entry ...
    (microsoft.public.word.docmanagement)
  • Re: identifying most recently used symbol (via VBA) in MSO2003, as
    ... > document is always a left parenthesis regardless of what character you ... > dialog and store them separately. ... > Sub InsertSymbol() ... > ' where they can be read by another macro that needs to know ...
    (microsoft.public.word.vba.general)
  • Re: Drag and Drop Rows (not just cells)
    ... Others have responded in my defense and have interpreted my response in the vein ... You stated "aside from creating a macro, which I am unable to do?" ... Gord Dibben MS Excel MVP ... button although when selecting the menu options you can use either button. ...
    (microsoft.public.excel.newusers)