Using Microsoft FoxPro with ACT!

FoxPro is the best tool for working with ACT! because it is


ACTFox is a FoxPro program which displays all the ACT! tables, and their relationships in windows to browse and edit

See all the tables at a glance

Learn about how ACT! works and the relationships between its tables

Make editing changes and correct problems (be careful)

Using Methods, Properties, and Functions from within FoxPro to control ACT!

Import data from other contact managers into ACT!

Click to enlarge

 Contact - names, addresses, phone numbers, user defined fields
 Sales - sales and opportunities
 Rel_Grp - relation file into Groups
 Group - categories of contacts
 Email - Internet addresses for contacts
 History - Cleared activities, Attachments and Notes
 Rel_ACT - relation file into Activity table
 Activity - Calls, meetings, and ToDo's

ACTFox.prg with Microsoft FoxPro, preferably Visual FoxPro.  

1. Get to the Command Window

2. CD or SET DEFAULT TO you ACT Database folder


Using Microsoft FoxPro with ACT!

Microsoft FoxPro is an important tool for any ACT! Certified Consultant or database administrator.  It allows him to make changes directly and quickly to the database in ways that ACT! cannot.  It should be used with care, experience, and training.   The following articles are examples of how FoxPro can be used.

  • Using FoxPro's Proper function to clean up ACT! popups

  • Using FoxPro to Replace User field in ACT!

  • Using FoxPro to control ACT! using the SDK Functions

  • ActDefine - List to use to populate variables for progdrams

  • Associate New Sale With Contact - sample program

  • List Sales For Contact- sample program

  • The  SDK (9 megabytes) which comes with ACT! includes sample code from Visual Basic (VB) and C++ (VC++).  The syntax is basically similar, but different in the details.  Rick Shaddock has provided the code that would be used with Visual FoxPro (VFP).
    Seminar featuring instruction on using Microsoft FoxPro with ACT!

    Rick Shaddock
    C I Corporation
    Washington, DC
    202-829-4444  202-449-9500 Fax
    800-319-3190  877-727-9070 Fax

    Return to C I Corporation Home page


    Order Form

    ACT! is a trademark of Interact Commerce Corporation
    FoxPro is a trademark of Microsoft Corporation