[mso] Re: Formulas in Word

  • From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Fri, 23 Aug 2002 01:36:06 -0500

The formula fields won't work the way you want because there is a
special way they need to work and to be honest with you...they suck for
formulas! (Pardon moi en francias<g>). Doing those types of field
calculation is a really pain and unstable. You should capture the
quantity and cost in a variable and multiply the variables in VBA code. 

And I really do hate to sound like that damn Video
Professor-Rip-off...but I have to tell you that I have just published my
first eBook from my AutoForm & Beginning VBA classes and this is
LITERALLY what I teach in the AutoForms/VBA class & eBook. Ask some of
the students I have in here who took the class if that's not just what I
showed them how to do in class! 

I teach how to use a Select Case statement so you don't have to use drop
downs for quantity (which takes longer to click and select than just
typing in a number). And then the VBA code shows you how to capture the
quantity and multiply it by the cost...which you can also have
automatically entered...and then the total for the item is entered into
the item total field. Then you can have it all sub totaled, any tax,
shipping or discount added and have the final total calculated. 

The reason I used an invoice in the book IS because an invoice is one of
the most complex things you can do with autoforms and VBA...but
throughout the 250 pages, I explain it all and you learn how to do it.
In my classes, they run 6 weeks, one lesson per week, and at the
end...you know all about forms, VBA for this type of invoice and you end
up with a finished invoice. I created the book for folks who don't have
6 weeks to spend learning and prefer to read the direction and work it
out in a much shorter time. Something that CAN be done with me showing
you how to do it. 

Sorry, but the process isn't something that can be easily
explained...hence the class and book is there...where I show you how to
do what took me a time to learn myself. Here's the link if you're
interested. The class is $20, the book $25. OR...you can pay ME $80 hr
to do it for you! 

Class: Word AutoForms & Beginning VBA
(www.mousetrax.com/techclasses.html)
eBook: Word AutoForms & Beginning VBA eBook
(www.mousetrax.com/books.html)

Dian Chapman
Technical Consultant, Instructor,
Microsoft MVP & TechTrax Editor

Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html
Tutorial web site: http://www.mousetrax.com/techpage.html
TechTrax Ezine: http://www.mousetrax.com/techtrax/

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of David Good - ANSYS Europe
Sent: Thursday, August 22, 2002 11:01 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Formulas in Word



OK, I'm trying to do something which I've avoided for a long time, I'm
looking at it now because it's not my work (although it's fast becoming
it
;) )

Right; onto the problem - I have what equates to an order form done in
Word tables - you know the kind of thing: (DESC, SIZE, COLOUR, PRICE,
QTY, TOTAL). As all of it's relatively fixed I'm doing it with forms -
so I can lock the document. Hence the QTY field is a drop-down with
1,2,3,4,5 etc... I've also put the price in the price column, and
entered (Table>Formula) a [QTY cell]*[PRICE cell] formula.

My problem is now two-fold;
        1. The formulas only seem to update when I highlight the field
and press F9, or "update field"

        2. If I lock the form and use the drop-down then the formula
doesn't seem to work at all

Any way around either problem? - #1's the main one - unless it updates
automatically (pref. without macros) I'll have to find another way.

I'm hoping I've missed something obvious.

Oh, and much as I'd like to embed an excel doc, or use Excel the form
needs to be in Word, and kept simple.

If anyone's kind enough to help, and needs to see the .doc just let me
know,

Cheers,

Dave.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: