[mso] Re: Formulas in Word
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 23 Aug 2002 05:35:09 -0400
Thanks Dian - I knew there was a good reason I avoided this kind of thing in
Word! I'll have a play with VBA; but I was hoping to avoid this as because
it's not my form it needs to be kept simple...
I'll also take a butchers at the ebook.
Dave.
-----Original Message-----
From: Dian Chapman [mailto:dian@xxxxxxxxxxxxx]
Sent: 23 August 2002 07:36
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Formulas in Word
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
*************************************************************
*************************************************************
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:
