Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Word Newsgroups
Word VBA
HOWTO: calculate running total and print at end of page/start of nextpage
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="StefanM, post: 5882181"] Doug, on Word's side, there is no code involved. I'm using SQLWindows (Gupta/ Unify) and the ActiveX-interface to Word to create the invoice. The invoice is based on a DOT-file with all the autotext fields defined and the basic layout and text of the invoice. Up to now I had just single paged invoices. Now I need to generate multi-paged invoices. My (SQLWindows) code loops through all invoice items, and inserts the pre- formatted text for an invoice item before the autotext field "invoice_item". Thus this acts more like a marker than an actual autotext field. I guess using this aproach I have no other choice than to also insert lines for footer page total, page break and page header total. Maybe I should have asked if there is any better aproach, so that the logic for calculating and including those page totals in the layout is done by Word. I know that you can define "fields" (don't know the exact expression as I'm using a german version of Word) and let word calculate values. But this only works with a fixed set of predefined fields. I don't know in advance how many invoice Items an invoice has. Also I can't remember a Word feature to layout those page totals. But with the huge set of finctionality in Word you never know if you didn't overlooked something... One idea would be to define an autotext field "running_total" and calculate the value in SQLWindows and pass it to Word before a new invoice item is sent. Again, the value must be inserted as text before the autotext field (because ONE autotext field can't have different values on different locations in the document). Stefan [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Word Newsgroups
Word VBA
HOWTO: calculate running total and print at end of page/start of nextpage
Top