Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Generate message (Access 97 Sr2)

    I am just learning MS Access. I have a query report that generates a calendar of appointments by lawyer for the coming two week period (i.e., this report is updated, printed and distributed every Friday. An attorney may have an appointment each day or may have days where no client or court appointments are scheduled. If the query report fails to find any appointments in the two week period, it prints "no records found". I would like to customize this message to say "No appointments scheduled". Everything I've tried so far prints this message for each day no appointment is scheduled. I only want this message printed if there are no appointments scheduled for the entire two week period. Thanks in advance for any advice to rectify my confused state............take care.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Generate message (Access 97 Sr2)

    Any chance that someone can help me out and view post #67355? THANKS.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Generate message (Access 97 Sr2)

    Well, Jim, I'm not clear on this, but I'll try ...

    When you say ..."If the query report fails to find any appointments in the two week period, it prints "no records found". ", do you mean that instead of a calendar report OR somewhere on your calendar report this message is being printed? What is causing this message to be printed?

    It sounds like you are placing your alternate message in the detail section, if it is being printed for each day there are no appointments. It would seem that, in order to address the entire report record source, it would need to be placed in a higher level section.

    If you can post more detail, I can try to be more specific.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •