Recent content by tsf.admin

  1. T

    why won't a line print under 1st instance of detail record in subreport?

    In a subreport, I have a line that prints under each detail record EXCEPT that it won't print for the very first main record. I have spent all day trying to figure out why the first record is different and the line won't print this. I really shouldn't have spent so much time on this ridiculous...
  2. T

    How to hide a label on 2nd subreport if 1st subreport has no data

    After an unmentionable number of hours, I am very close. I put this code in the ON-FORMAT event in the header section where the label resides: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) Me.NewsLabel.Visible =...
  3. T

    How to hide a label on 2nd subreport if 1st subreport has no data

    where do I find the subReport control name? I don't see a name other than the name of the subreport.
  4. T

    How to hide a label on 2nd subreport if 1st subreport has no data

    Thank you for the additional instructions. Yes, I used the expression builder because I couldn't get the correct syntax on my own. I am too new to all this. Is your link for (Forms: Refer to Form and Subform properties and controls) also apply to reports? I will try again...
  5. T

    How to hide a label on 2nd subreport if 1st subreport has no data

    Hi, I cannot get the label to disappear This is what I currently have. Private Sub Report_Load() [rpt-MidYear-balstmt-subreport].Report![NewsLabel].Visible = [rpt-MidYear-Awardee-List-subreport].Report.HasData End Sub Is there some other property on the label itself that needs to be changed?
  6. T

    How to hide a label on 2nd subreport if 1st subreport has no data

    Hi, Overview: Our non-profit has 2 separate mailings mid-year to almost the same recipients (about 600 recipients). I'd like to merge the 2 reports into 1 to streamline the process and save on postage. Recipients may get 1 report or the other or both or neither. So far I have 3 queries and...
  7. T

    Hello from a newbie

    Hi, I'm Anne and I am new to Access. Used to work with Oracle 20 years ago but things have changed since then ;)
Top Bottom