Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old June 27th, 2008, 08:22 PM
Coll
Guest
 
Posts: n/a
Default 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
  #2  
Old June 27th, 2008, 08:22 PM
Tom van Stiphout
Guest
 
Posts: n/a
Default Re: MS Access & Lotus Notes

On Sat, 19 Apr 2008 17:58:19 -0700 (PDT), Coll
<col_mcmanus@hotmail.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.

Quote:
>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
 

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles