<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.tntware.com/tntconnect/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect.aspx</link><description /><dc:language>en-US</dc:language><generator>CommunityServer 2008.5 SP2 (Debug Build: 40407.4157)</generator><item><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect.aspx</link><pubDate>Wed, 09 Apr 2025 14:30:30 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:31</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Current revision posted to Frequently Asked Questions by Troy Wolbrink on 4/9/2025 2:30:30 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntConnect?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntConnect doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntConnect.&amp;nbsp; TntConnect has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds read-only links to tables within TntConnect.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx" target="_blank" rel="noopener"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntConnect file (*.mpddb) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntConnect to link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntConnect provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntConnect.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntConnect.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntConnect&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntConnect?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;The linked database is to a read-only copy.&amp;nbsp; If your add-on is going to change data in TntConnect, you&amp;#39;ll have to make changes directly in the TntConnect database.&amp;nbsp;&amp;nbsp;A TntConnect 3.1 or newer&amp;nbsp;database is an Access 2000 database (subject to change).&amp;nbsp;&amp;nbsp;If you do make changes to data in the&amp;nbsp;TntConnect database, it may&amp;nbsp;be&amp;nbsp;required to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntConnect. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntConnect&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntConnect\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntSync&amp;nbsp;is provided as an example of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on),&amp;nbsp; &lt;strong&gt;Parameters&lt;/strong&gt; for additional command line parameters sent to your application.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Parameters&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntConnect&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntConnect includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntConnect, look in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntConnect exits, look for the example in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="https://www.tntware.com/tntconnect/downloads/9/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntConnect.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/10.aspx</link><pubDate>Sat, 24 Jun 2017 16:48:32 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:961</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 10 posted to Frequently Asked Questions by Troy Wolbrink on 6/24/2017 4:48:32 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntConnect?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntConnect doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntConnect.&amp;nbsp; TntConnect has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds &lt;span style="background: SpringGreen;"&gt;read-only&lt;/span&gt; links to tables within TntConnect.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntConnect file (*.mpddb) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntConnect to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntConnect provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntConnect.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntConnect.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntConnect&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntConnect?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;The&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;linked&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;database&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;is&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;a&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;read-only&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;copy&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp; If your add-on &lt;span style="background: SpringGreen;"&gt;is&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;going&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;change&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;data&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;ll&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;have&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;make&lt;/span&gt; changes &lt;span style="background: SpringGreen;"&gt;directly&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;database&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;A&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;3.1&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;or&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;newer&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;database&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;is&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;an&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Access&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;2000&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;database&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;subject&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;change)&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;If&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;do&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;make&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;changes&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; data in &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt;&amp;nbsp;TntConnect &lt;span style="text-decoration: line-through; color: red;"&gt;using&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;your&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;linked&lt;/span&gt; database&lt;span style="text-decoration: line-through; color: red;"&gt;tables&lt;/span&gt;, &lt;span style="background: SpringGreen;"&gt;it&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;may&lt;/span&gt;&amp;nbsp;be&lt;span style="text-decoration: line-through; color: red;"&gt;sure&lt;/span&gt; &amp;nbsp;&lt;span style="background: SpringGreen;"&gt;required&lt;/span&gt; to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntConnect. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntConnect&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntConnect\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntSync&amp;nbsp;is provided as an example of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on),&amp;nbsp; &lt;strong&gt;Parameters&lt;/strong&gt; for additional command line parameters sent to your application.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Parameters&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntConnect&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntConnect includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntConnect, look in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntConnect exits, look for the example in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntConnect.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/9.aspx</link><pubDate>Tue, 17 May 2016 20:27:58 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:745</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 9 posted to Frequently Asked Questions by Troy Wolbrink on 5/17/2016 8:27:58 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntConnect?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntConnect doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntConnect.&amp;nbsp; TntConnect has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntConnect.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntConnect file (*.mpddb) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntConnect to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntConnect provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntConnect.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntConnect.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntConnect&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntConnect?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntConnect using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntConnect. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntConnect&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntConnect\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntSync&amp;nbsp;is provided as an example of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on),&amp;nbsp; &lt;strong&gt;Parameters&lt;/strong&gt; for additional command line parameters sent to your application.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Parameters&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntConnect includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;, look in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; exits, look for the example in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntConnect.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/8.aspx</link><pubDate>Tue, 17 May 2016 20:27:33 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:653</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 8 posted to Frequently Asked Questions by Troy Wolbrink on 5/17/2016 8:27:33 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntConnect?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntConnect doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntConnect.&amp;nbsp; TntConnect has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntConnect.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; file (&lt;span style="text-decoration: line-through; color: red;"&gt;*.mpd)&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;*.mpddb)&lt;/span&gt; and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntConnect provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntConnect.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntConnect.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntConnect&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntConnect?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntConnect using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntConnect. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntConnect&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;/span&gt;&lt;span style="font-size:xx-small;"&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntConnect\ExternalTools\&amp;quot;)&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;TntSync&amp;nbsp;is provided as an example of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on),&amp;nbsp; &lt;strong&gt;Parameters&lt;/strong&gt; for additional command line parameters sent to your application.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Parameters&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntMPD&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntConnect includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntMPD, look in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntMPD exits, look for the example in TntConnect&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntConnect.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntConnect?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/7.aspx</link><pubDate>Tue, 17 May 2016 20:26:55 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:652</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 7 posted to Frequently Asked Questions by Troy Wolbrink on 5/17/2016 8:26:55 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;.&amp;nbsp; &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &amp;nbsp; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;TntMPD.exe&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;TntConnect.exe&lt;/span&gt; /?&amp;quot; from the command line.&amp;nbsp; The location of &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD.exe&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect.exe&lt;/span&gt; can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;&lt;span style="font-size:xx-small;"&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\InstallPath&amp;quot;&lt;/span&gt;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\&amp;quot;&lt;/span&gt;&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntConnect\ExternalTools\&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;TntCrypt&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;and&lt;/span&gt; &lt;br /&gt;&lt;/span&gt;TntSync&lt;span style="text-decoration: line-through; color: red;"&gt;are&lt;/span&gt; &amp;nbsp;&lt;span style="background: SpringGreen;"&gt;is&lt;/span&gt; provided as &lt;span style="text-decoration: line-through; color: red;"&gt;examples&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;an&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;example&lt;/span&gt; of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on),&amp;nbsp; &lt;strong&gt;Parameters&lt;/strong&gt; for additional command line parameters sent to your application.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Parameters&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntMPD&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt; includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntMPD, look in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntMPD exits, look for the example in &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for &lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;TntConnect&lt;/span&gt;.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/6.aspx</link><pubDate>Tue, 12 Apr 2011 18:29:43 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:651</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 6 posted to Frequently Asked Questions by Troy Wolbrink on 4/12/2011 6:29:43 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntMPD?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntMPD&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntMPD?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntMPD using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntMPD&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntCrypt and TntSync are provided as examples of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on)&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt;&amp;nbsp; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Parameters&lt;/span&gt;&lt;/strong&gt; &lt;span style="background: SpringGreen;"&gt;for&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;additional&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;command&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;line&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;parameters&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;sent&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;application&lt;/span&gt;.&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;Target&lt;/span&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Parameters&lt;/span&gt;&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntMPD&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntMPD includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntMPD, look in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/5.aspx</link><pubDate>Thu, 06 Aug 2009 05:34:27 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:225</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 5 posted to Frequently Asked Questions by Troy Wolbrink on 8/6/2009 5:34:27 AM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntMPD?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntMPD&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntMPD?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntMPD using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntMPD&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntCrypt and TntSync are provided as examples of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on).&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Target&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntMPD&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntMPD includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntMPD, look in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/4.aspx</link><pubDate>Thu, 06 Aug 2009 05:30:47 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:135</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 4 posted to Frequently Asked Questions by Troy Wolbrink on 8/6/2009 5:30:47 AM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntMPD?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;Access Database Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom Access solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Windows Application Add-On&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Each add-on&amp;nbsp;can create and maintain its own link to the database without requiring the user to&amp;nbsp;manually establish the link.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;TntMPD&amp;#39;s Database Structure&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Changing Data in TntMPD?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntMPD using your linked database tables, be sure to perform&amp;nbsp;the File|Maintenance&amp;nbsp;task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Adding your Add-On to the &amp;quot;Tools&amp;quot; menu in TntMPD&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Look in the Windows registry (using regedit.exe) at the key:&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\&amp;quot;&lt;/span&gt;&lt;br /&gt;(or if you&amp;#39;re on 64-bit Windows look at: &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;br /&gt;&lt;/span&gt;TntCrypt and TntSync are provided as examples of how you can register your add-on under the &amp;quot;Tools&amp;quot; menu.&amp;nbsp; &lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:xx-small;"&gt;&lt;span style="font-size:x-small;"&gt;Each tool can specify certain values:&amp;nbsp; &lt;strong&gt;Category&lt;/strong&gt; (if you want a sub-menu), &lt;strong&gt;Target&lt;/strong&gt; (what get&amp;#39;s executed when you click the menu ... can be anything that runs under the Windows &amp;quot;Start&amp;quot; menu ... &amp;quot;Run&amp;quot;), &lt;strong&gt;IconTarget&lt;/strong&gt; (where you want the menu extracted from for the tool&amp;#39;s menu item), and &lt;strong&gt;Shortcut&lt;/strong&gt; (if you want a keyboard hotkey such as &amp;quot;Ctrl+F1&amp;quot; for running your add-on).&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;In the &lt;strong&gt;Target&lt;/strong&gt;, you can include &amp;quot;currentgroup.csv&amp;quot; somewhere, and it will be replaced with the name of an actual file which represents an export of the current&amp;nbsp;filtered list&amp;nbsp;of contacts&amp;nbsp;in TntMPD&amp;#39;s contacts view.&amp;nbsp; This allows your add-on to do something with the current group.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Mail Merge Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;TntMPD includes built-in support for merging with Microsoft Word 2000 and newer.&amp;nbsp; You can&amp;nbsp;replace this with&amp;nbsp;your own Mail Merge functionality.&amp;nbsp; For some documentation on how to integrate your add-on with TntMPD, look in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;App Exit&amp;nbsp;Handler&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If you want your add-on program to get called when TntMPD exits, look for the example in TntMPD&amp;#39;s installation folder under &amp;quot;\Developer Notes\External Handlers.zip&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/3.aspx</link><pubDate>Thu, 06 Aug 2009 05:27:22 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:134</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 3 posted to Frequently Asked Questions by Troy Wolbrink on 8/6/2009 5:27:22 AM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntMPD?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: Developer Guides&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;TntMPD&lt;/span&gt; &lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Access&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Database&lt;/span&gt; Add-On&lt;span style="text-decoration: line-through; color: red;"&gt;Developer&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;Page&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom &lt;span style="background: SpringGreen;"&gt;Access&lt;/span&gt; solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Windows&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Application&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Add-On&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; &lt;span style="text-decoration: line-through; color: red;"&gt;Thus&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;,&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;each&lt;/span&gt; &amp;nbsp; &lt;span style="background: SpringGreen;"&gt;Each&lt;/span&gt; add-on&lt;span style="text-decoration: line-through; color: red;"&gt;should&lt;/span&gt; &amp;nbsp;&lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt; create and maintain its own link to the database &lt;span style="text-decoration: line-through; color: red;"&gt;,&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;and&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;without&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;requiring&lt;/span&gt; the user &lt;span style="text-decoration: line-through; color: red;"&gt;shouldn&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;t&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;have&lt;/span&gt; to&lt;span style="text-decoration: line-through; color: red;"&gt;be&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;involved&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;.&lt;/span&gt;&amp;nbsp; &lt;span style="text-decoration: line-through; color: red;"&gt;(&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;Note:&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;The&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;MLC&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;add-on&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;was&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;designed&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;before&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;this&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;feature&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;was&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;available&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;and&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;thus&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;requires&lt;/span&gt; &amp;nbsp;&lt;span style="background: SpringGreen;"&gt;manually&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;establish&lt;/span&gt; the &lt;span style="text-decoration: line-through; color: red;"&gt;user&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;link&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&amp;#39;s &lt;span style="text-decoration: line-through; color: red;"&gt;involvement&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;in&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;setting&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;up&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;the&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;link.&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;)&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Database&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Structure&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Changing&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Data&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;?&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;If your add-on changes data in TntMPD &lt;span style="text-decoration: line-through; color: red;"&gt;tables&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;in&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;Access&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;2000&lt;/span&gt; using your linked database &lt;span style="background: SpringGreen;"&gt;tables&lt;/span&gt;, be sure to perform&lt;span style="text-decoration: line-through; color: red;"&gt;this&lt;/span&gt; &amp;nbsp;&lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;File|Maintenance&lt;/span&gt;&amp;nbsp;task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data.&amp;nbsp; These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Adding&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Add-On&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;Tools&amp;quot;&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;Look&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Windows&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;registry&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;using&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;regedit.exe&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;)&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;at&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;key&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;:&lt;/span&gt;&amp;nbsp; &lt;span style="font-size:xx-small;"&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\ExternalTools\&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;or&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;if&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;re&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;64-bit&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Windows&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;look&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;at&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;:&lt;/span&gt; &lt;span style="font-size:xx-small;"&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\TntWare\TntMPD\ExternalTools\&amp;quot;)&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size:x-small;"&gt;&lt;span style="background: SpringGreen;"&gt;TntCrypt&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;and&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntSync&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;are&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;provided&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;as&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;examples&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;of&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;how&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;register&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;add-on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;under&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;Tools&amp;quot;&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="font-size:xx-small;"&gt;&lt;span style="font-size:x-small;"&gt;&lt;span style="background: SpringGreen;"&gt;Each&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;tool&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;specify&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;certain&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;values&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;:&lt;/span&gt;&amp;nbsp; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Category&lt;/span&gt;&lt;/strong&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;if&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;want&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;a&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;sub-menu)&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Target&lt;/span&gt;&lt;/strong&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;what&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;get&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;s&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;executed&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;when&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;click&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt; .&lt;span style="background: SpringGreen;"&gt;..&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;be&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;anything&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;that&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;runs&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;under&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Windows&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;Start&amp;quot;&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;..&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;Run&amp;quot;),&lt;/span&gt; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;IconTarget&lt;/span&gt;&lt;/strong&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;where&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;want&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;extracted&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;from&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;for&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;tool&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;s&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;menu&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;item)&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;and&lt;/span&gt; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Shortcut&lt;/span&gt;&lt;/strong&gt; &lt;span style="background: SpringGreen;"&gt;(&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;if&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;want&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;a&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;keyboard&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;hotkey&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;such&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;as&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;Ctrl+F1&amp;quot;&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;for&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;running&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;add-on)&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;In&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Target&lt;/span&gt;&lt;/strong&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;include&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;currentgroup.csv&amp;quot;&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;somewhere&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;and&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;it&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;will&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;be&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;replaced&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;with&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;name&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;of&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;an&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;actual&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;file&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;which&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;represents&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;an&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;export&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;of&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;current&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;filtered&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;list&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;of&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;contacts&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;s&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;contacts&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;view&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp; &lt;span style="background: SpringGreen;"&gt;This&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;allows&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;add-on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;do&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;something&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;with&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;current&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;group&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Mail&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Merge&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Handler&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;includes&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;built-in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;support&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;for&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;merging&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;with&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Microsoft&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Word&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;2000&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;and&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;newer&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp; &lt;span style="background: SpringGreen;"&gt;You&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;can&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;replace&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;this&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;with&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;own&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Mail&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Merge&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;functionality&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;.&lt;/span&gt;&amp;nbsp; &lt;span style="background: SpringGreen;"&gt;For&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;some&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;documentation&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;how&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;integrate&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;add-on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;with&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;look&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;s&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;installation&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;folder&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;under&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;\Developer&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Notes\External&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Handlers.zip&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;App&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Exit&lt;/span&gt;&amp;nbsp;&lt;span style="background: SpringGreen;"&gt;Handler&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="background: SpringGreen;"&gt;If&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;you&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;want&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;your&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;add-on&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;program&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;to&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;get&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;called&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;when&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;exits&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;,&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;look&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;for&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;the&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;example&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;in&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;TntMPD&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;#39;&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;s&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;installation&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;folder&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;under&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;&amp;quot;\Developer&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Notes\External&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Handlers.zip&lt;/span&gt;&lt;span style="background: SpringGreen;"&gt;&amp;quot;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;&lt;span style="background: SpringGreen;"&gt;Examples&lt;/span&gt;&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/2.aspx</link><pubDate>Mon, 29 Sep 2008 19:17:49 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:133</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 2 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 7:17:49 PM&lt;br /&gt;
&lt;h2&gt;How can I develop add-ons for TntMPD?&lt;/h2&gt;
&lt;div style="font-size: 90%;"&gt;Filed under: &lt;span style="background: SpringGreen;"&gt;Developer&lt;/span&gt; &lt;span style="background: SpringGreen;"&gt;Guides&lt;/span&gt;&lt;/div&gt;

&lt;p&gt;&lt;strong&gt;TntMPD Add-On Developer Page&lt;/strong&gt;&lt;/p&gt;
&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;lt;!--webbot&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;bot=&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;Navigation&amp;quot;&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;i-checksum=&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;quot;55934&amp;quot;&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;endspan&lt;/span&gt; &lt;span style="text-decoration: line-through; color: red;"&gt;-&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;-&lt;/span&gt;&lt;span style="text-decoration: line-through; color: red;"&gt;&amp;gt;&lt;/span&gt;
&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;/p&gt;
&lt;p&gt;&lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt; &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Thus, each add-on should create and maintain its own link to the database, and the user shouldn&amp;#39;t have to be involved.&amp;nbsp; (Note: The MLC add-on was designed before this feature was available and thus requires the user&amp;#39;s involvement in setting up the link.) &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; If your add-on &lt;b&gt;changes data&lt;/b&gt; in TntMPD tables in Access 2000 using your linked database, be sure to perform this task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data. These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://www.tntware.com/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;</description></item><item><title>How can I develop add-ons for TntMPD?</title><link>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/revision/1.aspx</link><pubDate>Mon, 29 Sep 2008 19:17:14 GMT</pubDate><guid isPermaLink="false">1fa7c37c-d68d-46f5-9639-4669b01a21c5:37</guid><dc:creator>Troy Wolbrink</dc:creator><comments>https://www.tntware.com/tntconnect/faqs/en/how-can-i-develop-add-ons-for-tntconnect/comments.aspx</comments><description>Revision 1 posted to Frequently Asked Questions by Troy Wolbrink on 9/29/2008 7:17:14 PM&lt;br /&gt;
&lt;p&gt;&lt;strong&gt;TntMPD Add-On Developer Page&lt;/strong&gt;&lt;/p&gt;
&amp;lt;!--webbot bot=&amp;quot;Navigation&amp;quot; i-checksum=&amp;quot;55934&amp;quot; endspan --&amp;gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; If TntMPD doesn&amp;#39;t do exactly what you want, and you know how to use Access 2000, you can develop custom solutions to enhance TntMPD.&amp;nbsp; TntMPD has a special feature called &amp;quot;Link to Access Database&amp;quot;.&amp;nbsp; This takes an existing database and adds links to tables within TntMPD.&amp;nbsp; This way you can add your own tables, queries, forms and reports and VBA (Visual Basic for Applications) code modules.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; For a better explanation follow this link: &lt;/p&gt;
&lt;p&gt;&lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx"&gt;http://msdn2.microsoft.com/en-us/library/aa141493(office.10).aspx&lt;/a&gt; &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Keep in mind in this illustration that the &amp;quot;Back End&amp;quot; database is the TntMPD file (*.mpd) and the &amp;quot;Front End&amp;quot; database is the Access 2000 database (*.mdb) that you told TntMPD to link. &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; More advanced developers will appreciate the fact that TntMPD provides programmatic ways to create and update linked Access databases via the command line.&amp;nbsp; For help on this feature, run &amp;quot;TntMPD.exe /?&amp;quot; from the command line.&amp;nbsp; The location of TntMPD.exe can be found in the registry at &lt;span style="font-size:xx-small;"&gt;&amp;quot;HKEY_LOCAL_MACHINE\SOFTWARE\TntWare\TntMPD\InstallPath&amp;quot;&lt;/span&gt;.&amp;nbsp; Thus, each add-on should create and maintain its own link to the database, and the user shouldn&amp;#39;t have to be involved.&amp;nbsp; (Note: The MLC add-on was designed before this feature was available and thus requires the user&amp;#39;s involvement in setting up the link.) &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; As to the layout of the underlying tables. You will find that most tables use the first field as their primary key. For example, the main table is called &amp;quot;Contact&amp;quot;. The primary key is &amp;quot;ContactID&amp;quot;. The gift table has a field called &amp;quot;ContactID&amp;quot; that links back to the person who gave the gift. &lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; If your add-on &lt;b&gt;changes data&lt;/b&gt; in TntMPD tables in Access 2000 using your linked database, be sure to perform this task when you are done. Open TntMPD. Click on the &amp;quot;File&amp;quot; menu ... select &amp;quot;Maintenance&amp;quot;. From the maintenance screen, recalculate mailing, money and history data. These steps are recommended for the program to operate correctly.&amp;nbsp; Also, each table has a &amp;quot;LastEdit&amp;quot; field that needs to be updated for TntSync to work correctly.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://www.tntware.com/tntmpd/downloads/g/tntmpd_add-ons/default.aspx"&gt;&lt;strong&gt;There are some add-ons currently available for TntMPD.&lt;/strong&gt;&lt;/a&gt;&lt;/p&gt;</description></item></channel></rss>