Re: Add ONE variable word to report header

Comments inline below.
--
Marsh
MVP [MS Access]


Ann Scharpf via AccessMonster.com wrote:
Actually, I didn't go back into my database but cut & pasted those lines out
of Klatuu's earlier post. The lines that ARE in my open event are:

Private Sub Report_Open(Cancel As Integer)
If MgbBox("Is This A Revision", vbQuestion + vbYesNo) = vbYes Then
Me.Label4.Caption = Me.Label4.Caption & " Revision"
End If
End Sub

This is the ONLY change that I have made to my report, so if I remove them, I
am just back to the original version which, as I said, did open just fine.

The reason I want you to actually remove that code is to
double check that something else isn't getting in the way of
chasing down this problem. Logic may say it can't happen,
but I really want to make sure that the above perfectly
sensible code is somehow blowing up the whole report.


I did use your "quick and dirty" method of adding a text box with a control
source to prompt the user to add the word REVISION. This worked on three of
my four reports. The last report is significantly more complicated than the
others. (It's a composite of four unbound reports.) When I try to add the
field with control source to this report, Access doesn't print the word
REVISION in the header but the word ?NAME.

If you got that to work anywhere, you must have fixed my
missing quote mistake. I don't see any reason for it to
work one place and not work in another. The only way I can
think of getting ?Name is if the quotes were wrong, so maybe
you didn't fix my mistake in the one that doesn't work.


So, I am trying to find a way to make this last report print the word
REVISION at the top of the first page.

Another difference between the reports is that the three that work have a
report header and the one that doesn't is lacking the report header. So I
made a copy of the report and switched the page header info to the report
header. Didn't have any effect.

I don't think that makes a difference, but if it did, you
would need to use Klatuu's idea, which, except for your lack
of VBA skills, is better all the way around.

.

Relevant Pages

  • Re: Reset Page of Pages in Multipage reports
    ... which is the Report Number in the header - reports ... Dim GrpNameCurrent As Variant, GrpNamePrevious As Variant ... Dim GrpPage As Integer, GrpPages As Integer ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... If you don't want to show the header on the first group, ... Open the report in design view. ... I have a header of shutdown in front of the whole list but the two lists ... The Subreport will only show as many rows as will fit in the area I delegated ...
    (microsoft.public.access.reports)
  • Re: Report with Sub-Report with NO-DATA on Sub-Report
    ... held in the header/footer of the report. ... primary header ... detail section followed by the subreport. ...
    (microsoft.public.access.reports)
  • RE: Split worksheet into multiple worksheets
    ... Dim lngRow As Long, lngLastRow As Long, varTemp As Variant ... The report I tested it on consisted of 3 cost centres. ... split the first 2 perfectly and it pulled the header of the 3rd into a new ...
    (microsoft.public.excel.programming)
  • Re: subreport displays only once
    ... The Page Header is a page-oriented section, ... > You will basically re-create the orders form as a report... ... You will see that the subform only shows up once. ... >> LinkMasterFields/LinkChildFields is being applied correctly, ...
    (microsoft.public.access.reports)