MS Access & Lotus Notes

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Coll
    #1

    MS Access & Lotus Notes

    I manage a few databases that have macros that generate email
    reminders to groups of individuals. These macros work correctly on my
    computers as well as one of my coworkers. However, the people who are
    actually supposed to send these reminders are having problems. When
    they run the macro, a new Notes message pops up with all the
    appropriate data (the email messages pull data from fields in Access),
    however, the message is only addressed to one recipient (the first one
    listed in the database for that group). Any ideas? I think we are all
    using the same versions of Access & Notes (Access 2000; Notes Release
    6.5.4). Our IT department has not been able to help (they "don't
    support Access"). I'm not sure if it's an Access issue or a Notes
    issue. Any ideas would greatly be appreciated. Thanks.

    Colleen
    Tags: None
    • Tom van Stiphout
      #2
      Re: MS Access & Lotus Notes

      On Sat, 19 Apr 2008 17:58:19 -0700 (PDT), Coll
      <col_mcmanus@ho tmail.comwrote:

      Could you use one of their computers for a day to debug this further?
      Can you break down the code to its essence and post it here?
      Are you using proper error handling?
      You *think* everyone is on the same version? How about making sure?
      Sometimes the object model has a toplevel object with a Version
      property. In lieu of that, use the About box or the Version
      information of the main EXE file. This goes for Notes as well as
      Access.
      Everyone is running Windows Update, right? (when they say Yes, you may
      want to double-check anyway)

      -Tom.

      >I manage a few databases that have macros that generate email
      >reminders to groups of individuals. These macros work correctly on my
      >computers as well as one of my coworkers. However, the people who are
      >actually supposed to send these reminders are having problems. When
      >they run the macro, a new Notes message pops up with all the
      >appropriate data (the email messages pull data from fields in Access),
      >however, the message is only addressed to one recipient (the first one
      >listed in the database for that group). Any ideas? I think we are all
      >using the same versions of Access & Notes (Access 2000; Notes Release
      >6.5.4). Our IT department has not been able to help (they "don't
      >support Access"). I'm not sure if it's an Access issue or a Notes
      >issue. Any ideas would greatly be appreciated. Thanks.
      >
      >Colleen

        Comment

        Previous template Next
        Working...