VBA word report and header on specific page (1 Viewer)

D

DevAccess

Registered User.

Local time

Today, 06:48

Joined

Jun 27, 2016

Messages

321

• Jul 1, 2016

• #1

Hello,

I am generating report based on access dataset, I would like to have header generated as below starting from page no 2 using vba, can anybody please help me with this.

Test1 test 2 test3

Please advice

 

Cronk

Registered User.

Local time

Today, 23:48

Joined

Jul 4, 2013

Messages

2,772

• Jul 1, 2016

• #2

In the on format event of your report's page header, insert

me.YourControlName.Visible = (Page <> 1)

 

D

DevAccess

Registered User.

Local time

Today, 06:48

Joined

Jun 27, 2016

Messages

321

• Jul 2, 2016

• #3

Thanks, but question is of below code for word report. I dont want to have header on specific page, please see my code below

wddoc.Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = "ORDERS: " & rs.Fields("Order Number").Value & vbTab & "Centre" & vbTab & Format(Date, "DD MMM YY") & vbTab

 

S

sneuberg

AWF VIP

Local time

Today, 06:48

Joined

Oct 17, 2014

Messages

3,506

• Jul 2, 2016

• #4

There are other constants that could be use than wdHeaderFooterPrimary like wdHeaderFooterFirstPage and wdHeaderFooterEvenPages.

I wonder if you set up an additional header with the wdHeaderFooterFirstPage constant and just left it blank if that might do it.

 

Last edited: Jul 2, 2016