Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 31st, 2005, 07:49 AM
Registered User
 
Join Date: Jan 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Automatically update all fields [Word 2003]

Within a word template I want a "Page { PAGE }" in the header starting from page number 2. I accomplished this by marking the 'set first page differently' within the header/footer setup dialog box.

Unfortunetaly the page number in the header is not updated. I do have to enter the header manually and force an update with F9.

What I want to know is the following: Is there a way to force this update with every new page that is created? I already know you can create a macro, but I want a function which is triggered without interference/ action of the user. Is there an event which is triggered in conjunction with the creation of a new page? All suggestion on automation of this are welcome.

Many thanks in advance for your kind support.

Kind regards.
 
Old February 2nd, 2005, 07:57 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 168
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

Tools-Options-Print tab

Check Update Fields and everytime Print or Print Preview happens, all fields are updated

-vemaju

 
Old February 2nd, 2005, 08:46 AM
Registered User
 
Join Date: Jan 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I already tried that option, but it doesn't seem to work.

I have defined a header with the option 'First page differently' (no content in header) and the section as 'continuous'. The second page should print 'Page 2', but it prints 'Page 1'. I have to get into the header and manually update the field (F9).

Anybody can help me with the option of using VBA (WithEvents, Fields.Update) to solve this problem?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically update in form Detail section mohiddin52 Access VBA 0 April 18th, 2008 10:36 AM
Enable / Disable Form Fields Automatically jackyam Javascript How-To 10 March 17th, 2008 04:46 AM
automatically update the version of AssemblyInfo piyushnu C# 0 April 14th, 2006 06:17 AM
automatically update or insert record Jittermg Dreamweaver (all versions) 0 July 7th, 2005 03:55 PM
Invoking Word 2003 document from InfoPath 2003 debsoft General .NET 0 April 28th, 2004 08:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.