View Single Post
  #2   Report Post  
Greg Maxey
 
Posts: n/a
Default

You should get a good start here and the linked articles by Dian Chapman:

http://word.mvps.org/faqs/customizat...nTheBlanks.htm

The forms decribed in the article above are oddly called online forms.
Using on line forms, you don't need a macro. You can use Textfields to hold
your QTY, Unit Price, Decription, and a Calculation field for the total.

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Mike Shimizu wrote:
Office XP

I believe it was office 97 that had a purchase order templat you could
download that had formulas to extend unit price and subtotal the
exteded prices for all line items and total at the bottom.

All the templates I have seen do not have this anymore, they appear
to be just empty table fields you type in. The specific template I
downloaded was PO w/ unit price.

How do I create the formulas to have my PO template, calcualate
automatically?

I have tried on line one of the PO where you input qty , unit,
description, unit price. In the total field, I tried Table-Formula.
Tried =product(A1,A4) , tried =product(A1:A4), tried =(a1*a4) none of
these worked.

Then I tried designating the qty field with a text form field and
formatting to numeric. Did this for all releveant fields with
bookmark names a1, a2, a3 , a4. Then tried all the variants of the
formula I mentioned above. Still nothing works.

I recall there was a macro that was needed for this to work back in
the Office 97 days. Which of course I do not have this macro or any
idea how to make it. Is this why it's not working for me now?

I do not see where my e-mail goes in this form so here it is:
mike.shimizu(remove