Search results

I tried it, it doesn't make a difference, the page header is always hidden.

Private Sub Section_PageHeader_Format(Cancel As Integer, FormatCount As Integer) If Me.txtRunSum = 1 Then Me.Section_PageHeader.Visible = False ElseIf Me.txtRunSum > 1 Then Me.Section_PageHeader.Visible = True End If End Sub

oops, I spoke too soon... The page header now is always hidden.

Thanks. It works as expected.

Hide Page header on first page of every group Hello all experts, I have a report which is grouped by a field called name. I want to hide the PAGE header on the first page of each group. I tried a method that I found at...

Hello to All, I'm trying to find a setting for emailing in cdo that will display custom text in the recievers inbox "From" column. So far everything I tried didn't help, in the From column the receiver sees my gmail address minus @gmail.com. This is the code I'm using: Private Const...

I should have trusted you. After developing automation for two different virtual printers, I discovered that the formatting I wanted was only applied if the report was open (like you said) in AcViewPreview, now that I think about it, it makes lots of sense. So it turns out that the automation...

I guess that's what I'll have to do too. I was thinking of automating PDFCreator, what do you use?

I tried that and unfortunately it doesn't make a difference, it still ignores the vba.

In the PageHeader_Format. Here it is: Private Sub Section_PageHeader_Format(Cancel As Integer, FormatCount As Integer) 'Display the page header on all pages but the first of each group 'idea from...

Hello all Experts, I'm trying to use DoCmd.OutputTo to save a report as a PDF file. The trouble I'm having is that it seems to ignore the formatting set in VBA. In this case if a certain condition is true the PageHeader is hidden, the problem is that DoCmd.OutputTo prints that header even if...

Is there a way to print the page header on every page but the first page of each group (there I want the group header)?

@jdraw I can't find anything relevant.

I'm considering looping until Err.Number <> 4198. Any comments?

As I mentioned in my question the answer is yes. It fails with error 4198.

I tried a quick search but didn't find anything, can you point me to some relevant posts?

Dim oWord As Object Set oWord = CreateObject("Word.Application")

I'm trying to create a new document based on a template which is stored on a network drive, to merge data to. It will not load the first time, since there seems to be a Word 2010 bug, that Word is still initializing. It succeeds after several tries. How can I create a loop that will try to...

No, what I have laid out is the set up of the property information, there are no groups. Maybe I'll give your idea a try.

I would like to have it self contained in Access (I already prepared the layout).