Re: Add ONE variable word to report header

If I understand correctly, you are asking whether the report opened
successfully before I added these lines to the open event:

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

And the answer is, yes, it did.



Marshall Barton wrote:
Now is around the time when I start to fear I'm trying my advisor's patience.
I tried to do what you said and the report still won't open, except in design
[quoted text clipped - 5 lines]
End If
End Sub

Does the report open correctly if you remove those three
lines?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200603/1
.

Relevant Pages

  • Re: Temp Form holds previous values
    ... form isn't actually closing. ... > Private Sub Report_Open ... > ' Cancel Report if User Clicked the Cancel Button ... > ' Open event is completed ...
    (microsoft.public.access.formscoding)
  • RE: HELP
    ... then have the form run the report once the values are entered that the report ... Private Sub cmdCancel_Click ... If Not bInReportOpenEvent Then ... ' Open event is completed ...
    (microsoft.public.access.forms)
  • Re: Error: Microsoft jet database engine does not recognize " as a va
    ... If you are attempting to create a crosstab report with dynamic columns, ... > Dim rstReport As DAO.Recordset ... > Dim intX As Integer ... > Private Sub Detail_Format ...
    (microsoft.public.access.reports)
  • Re: Sending report about the current record in mail
    ... > filter so the report opens and is sent with just the record you need. ... In the Open event of the report, apply the filter string, and then ... > Private Sub Report_Open ...
    (microsoft.public.access.forms)
  • Re: Change Query SQL Programatically
    ... you could also set the RecordSource of the report itself in its ... Open event: ... Private Sub Form_Open ...
    (microsoft.public.access.queries)