Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   I want Outlook to talk to MS Access (http://www.outlookbanter.com/outlook-vba/75813-i-want-outlook-talk-ms.html)

Mir[_2_] July 25th 08 10:10 PM

I want Outlook to talk to MS Access
 
Hi all,

I am trying to populate my Access Database table with data from Outlook. I
created this Access database tool that sends Reminders (follow up) in
Outlook. But now I want Outlook to talk to MS Access, so that when someone
clicks "Complete" on a reminder, it would access the Access database table
and flag it as complete.

Please help.

Thank you!
Mir

Norman Yuan July 26th 08 04:34 PM

I want Outlook to talk to MS Access
 
It is fairly easy to write a VBA macro to update the "Complete" field in a
database table, be it Access database or other. You use ADO to open a
connection to the target database, and then execute an SQL statement to
update data in database.

Almost all VB/VBA books have examples of using ADO for database access.

"Mir" Mir @discussions.microsoft.com wrote in message
...
Hi all,

I am trying to populate my Access Database table with data from Outlook. I
created this Access database tool that sends Reminders (follow up) in
Outlook. But now I want Outlook to talk to MS Access, so that when someone
clicks "Complete" on a reminder, it would access the Access database table
and flag it as complete.

Please help.

Thank you!
Mir




All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com