TABLE OF CONTENTS

License and Warranty Addendum... iv

The software you are acquiring has been specially configured to run on a network, and consequently Interact Commerce Corporation grants to you the right to use the enclosed Software on a computer network provided that for each and every concurrent user on the network, you have acquired and dedicated one licensed copy of the software. iv

What’s Included. 5

“How-Do-I” support 7

Consulting Services. 7

Programming Services. 8

Conventions used in this section. 17

Syntax conventions. 17

Terminology. 18

Parameter types. 18

Special data types. 19

Date and time formats. 19

Phone formats. 20

Overview of the ACT! OLE Database Object 21

How can developers use an ACT! OLE Database Object?. 21

How does the OLE Database Object affect the ACT! user interface?. 21

Is the OLE Database Object a database tool for developing applications that can access ACT! data?  21

Features and limitations of the ACT! OLE Database Object 22

System requirements. 22

Development languages. 22

Using the Database Object with Visual C++. 22

Example VISUAL C++ code. 23

Using properties in Visual C++. 24

Understanding key files. 24

Using the type library. 25

ACT! Database Unique ID field considerations. 25

ACT! OLE Database Object definitions. 26

ACT! OLE object model 27

What’s new   28

Changes for ACT! 3.0.6. 28

Changes for ACT! 3.0.7. 29

Changes for ACT! 4.0. 29

Changes for ACT! 4.0.2. 30

Changes for ACT! 2000. 30

Common properties and methods. 34

Add Method. 38

Close Method. 39

Data Property. 39

Delete Method. 40

Edit Method. 41

Error Property. 41

Execute Method. 42

FieldCount Property. 42

Fields Property. 43

FindDuplicates Method (requires ACT! 2000 or later) 43

GetDataEx Method (requires ACT! 4.0.2 or later) 44

GetDuplicateCriteria Method (requires ACT! 2000 or later) 46

GetSort Method (requires ACT! 4.0 or later) 47

GoTo Method. 48

IsBOF Property. 48

IsEOF Property. 49

IsLocked Property. 49

IsOpen Property. 49

Jump Method. 50

LastError Property. 50

LockLevel Property. 51

Lookup Method. 51

LookupKeyword Method. 52

MoveFirst Method. 53

MoveLast Method. 53

MoveNext Method. 53

MovePrevious Method. 54

Name Property. 54

Position Property. 54

Query Property. 55

Rebuild Method. 55

RecordCount Property. 55

SetDataEx Method (requires ACT! 4.0.2 or later) 56

SetDuplicateCriteria Method (requires ACT! 2000 or later) 57

Sort Method. 58

Update Method. 59

Activity object properties and methods. 60

Clear Method. 62

ClearClearedFilter Method. 62

ClearContactScope Method. 62

ClearDateScope Method. 63

ClearGroupScope Method. 63

ClearPriorityFilter Method. 63

ClearRecurring Method. 64

ClearTimedFilter Method. 64

ClearTimelessFilter Method. 64

ClearTypeFilter Method. 65

ClearUnclearedFilter Method. 65

ExceptionInfo Property. 65

FirstScheduledWith Property. 66

GetDaysOfMonthBits Method. 67

GetDaysOfWeekBits Method. 68

GetRecurringFrequency Method. 69

GetRecurringUntilDate Method. 70

GetWeeksOfMonthBits Method. 71

HasAlarm Method. 72

HasDetails Method (requires ACT! 2000 or later) 72

IsClear Method. 73

IsOutlookActivity Method (requires ACT! 2000 or later) 73

IsRecurring Method. 74

IsTimeless Method. 74

NextScheduledWith Property (requires ACT! 4.0 or later) 75

RecurringChangeMode Property. 76

recurringType Property. 76

SetClearedFilter Method. 77

SetContactScope Method. 77

SetDateScope Method. 78

SetGroupScope Method. 79

SetPriorityFilter Method. 79

SetRecurringDays Method. 80

SetRecurringDaysAndWeeksofMonth Method. 80

SetRecurringWeekDays Method. 82

SetTimedFilter Method. 83

SetTimeless Method. 83

SetTimelessFilter Method. 83

SetTypeFilter Method. 84

SetUnclearedFilter Method. 84

Unclear Method. 85

Contact object methods. 86

LoadLookUpQuery Method (requires ACT! 3.0.6 or later) 86

LookupMyRecord Method (requires ACT! 2000 or later) 86

SetAsMyRecord Method (requires ACT! 4.0 or later) 87

Database object properties and methods. 89

ActiveUserCount Property. 91

Activity Property. 91

ActVersion Method (requires ACT! 3.0.6 or later) 92

BeginBatchInsert Method (requires ACT! 4.0.2 or later) 92

BeginBatchUpdate Method (requires ACT! 4.0.2 or later) 93

Close Method. 95

Contact Property. 95

CurrentUser Property. 95

DatabaseVersion Method (requires ACT! 4.0 or later) 96

Email Property. 96

EndBatchInsert Method (requires ACT! 4.0.2 or later) 97

EndBatchUpdate Method (requires ACT! 4.0.2 or later) 97

GetDatabasePath Method (requires ACT! 4.0 or later) 97

GetTableId Method (requires ACT! 3.0.6 or later) 98

GetTableNameFromId Method (requires ACT! 3.0.6 or later) 99

GetTableNameFromIndex Method (requires ACT! 3.0.6 or later) 99

GetUniqueId Method. 100

Group Property. 100

IsInBatchMode Property (requires ACT! 4.0.2 or later) 100

IsLocked Property (requires ACT! 4.0.2 or later) 101

IsMultiUser Property. 101

IsOpen Property. 101

IsOpening Property. 102

Lock Method (requires ACT! 4.0.2 or later) 102

LogTransactions Property. 103

MajorVersion Property. 103

MinorVersion Property. 104

Name Property. 104

NoteHistory Property. 104

Open Method. 105

OpenEx Method (requires ACT! 4.0 or later) 105

PhoneFormatting Property. 106

Relations Property (requires ACT! 3.0.6 or later) 106

TableCount Method (requires ACT! 3.0.6 or later) 107

Unlock Method (requires ACT! 4.0.2 or later) 107

Users Property. 107

ValidateUser Method. 108

Version Property (requires ACT! 3.0.6 or later) 109

Email object methods. 110

ClearContactScope Method (requires ACT! 3.0.7 or later) 110

SetContactScope Method (requires ACT! 3.0.7 or later) 110

ExceptionInfo object properties and methods. 112

Add Method. 112

Clear Method. 113

Count Property. 113

Remove Method. 113

Seek Method. 114

Value Method. 114

Fields object properties and methods. 115

AutoPopulate Property (requires ACT! 2000 or later) 116

BeginBatch Method (requires ACT! 4.0.2 or later) 117

Count Property. 118

DecimalPlaces Property. 119

EndBatch Method (requires ACT! 4.0.2 or later) 119

EntryRule Property (requires ACT! 4.0.2 or later) 119

EntryTrigger Property. 120

Exists Property. 121

ExitTrigger Property. 121

FieldId Property (requires ACT! 3.0.7 or later) 122

FieldIdAt Property (requires ACT! 3.0.6 or later) 122

Flags Property. 123

GetLinkToList Method (requires ACT! 2000 or later) 123

HasPopupList Property. 124

Id Property. 125

InitialValue Property. 125

IsBlockSync Property. 125

IsCutHistory Property. 126

IsIndexed Property. 126

IsPrimary Property. 127

IsSortable Property. 127

Label Property. 128

Length Property. 128

Modifiable Property. 129

POPUPINFO Property. 129

SetLinkToList Method (requires ACT! 2000 or later) 130

Type Property. 131

UnLinkLists Method (requires ACT! 2000 or later) 132

Group object properties and methods. 134

AddContact Method. 135

AddSubGroup Method (requires ACT! 2000 or later) 135

AssignParent Method (requires ACT! 2000 or later) 136

ChangeToParentGroup Method (requires ACT! 2000 or later) 137

ChangeToSubGroup Method (requires ACT! 2000 or later) 137

ClearContactScope Method (requires ACT! 3.0.7 or later) 138

ContactCount Property. 138

GetParent Method (requires ACT! 2000 or later) 139

GetSubGroup Method (requires ACT! 2000 or later) 139

GetSubGroupCount Method (requires ACT! 2000 or later) 140

GetSubGroupList Method (requires ACT! 2000 or later) 141

GroupType Method (requires ACT! 2000 or later) 142

Members Property. 143

RemoveContact Method. 143

SetContactScope Method (requires ACT! 3.0.7 or later) 143

ListTable object methods. 145

ClearScope Method (requires ACT! 2000 or later) 145

GetScope Method (requires ACT! 2000 or later) 146

SetScope Method (requires ACT! 2000 or later) 146

Members object properties. 148

Name Property. 149

UniqueId Property. 149

NoteHistory object methods. 150

History types. 150

ClearAttachmentFilter Method. 152

ClearContactScope Method. 152

ClearGroupScope Method. 152

ClearHistoryFilter Method. 153

ClearNoteFilter Method. 153

SetAttachmentFilter Method. 153

SetContactScope Method. 154

SetGroupScope Method. 154

SetHistoryFilter Method. 155

SetNoteFilter Method. 155

PopupInfo object properties and methods. 156

Add Method. 156

Clear Method. 157

PopupCount Property. 157

Remark Method. 158

Remove Method. 158

Value Method. 158

Relations object properties and methods. 160

Count Property (requires ACT! 3.0.6 or later) 161

GetColumn1ID Method (requires ACT! 3.0.6 or later) 162

GetColumn2ID Method (requires ACT! 3.0.6 or later) 162

GetRelationType Method. 162

GetTable1ID Method (requires ACT! 3.0.6 or later) 163

GetTable2ID Method (requires ACT! 3.0.6 or later) 163

UsesRelationTable Method (requires ACT! 3.0.6 or later) 163

Sales object methods. 165

AssociateWithContact Method (requires ACT! 2000 or later) 165

AssociateWithGroup Method (requires ACT! 2000 or later) 166

CompleteSale Method (requires ACT! 2000 or later) 167

ReopenSale Method (requires ACT! 2000 or later) 168

Users object properties and methods. 170

Access Property. 171

AddUser Method (requires ACT! 4.0 or later) 171

CheckIsPhonebook Method (requires ACT! 4.0 or later) 173

Count Property. 174

CurrentUserAccess Method (requires ACT! 3.0.6 or later) 174

CurrentUserId Method (requires ACT! 3.0.6 or later) 174

CurrentUserName Method (requires ACT! 3.0.6 or later) 175

CurrentUserSecurity Method (requires ACT! 3.0.6 or later) 175

Exists Property. 176

GetPassword Method (requires ACT! 4.0 or later) 176

IsValidPassword Method. 177

Name Property. 177

Security Property. 178

SetAsPhonebook Method (requires ACT! 4.0 or later) 178

SetPassword Method. 179

UniqueId Property. 179

Conventions used in this section. 196

Syntax conventions. 196

Terminology. 196

Parameter types. 197

Special considerations. 197

Using properties in Visual C++. 198

Changing the focus. 198

System requirements. 198

Development languages. 198

Using the Application Object with Visual C++. 198

Example C++ code. 199

Understanding key files. 200

ACT! OLE Application Object model 201

What’s new   202

Changes for ACT! 4.0. 202

Changes for ACT! 2000. 204

Changes for ACT! 2000 version 5.0.2. 205

Common properties and methods. 208

Activate Method. 209

Active Property. 210

Application Method. 210

Caption Property. 210

ClearError Method (requires ACT! 4.0 or later) 211

Close Method. 211

CurrentFieldId Method (requires ACT! 2000 or later) 212

CurrentRecord Method (requires ACT! 2000 or later) 212

Displayed Property. 213

GetLastError Method. 213

GetMode Method (requires ACT! 2000 or later) 214

HasRecordChanged Method (requires ACT! 2000 or later) 215

LookupKeyword Method (requires ACT! 2000 or later) 215

Maximize Method. 216

Minimize Method. 216

Name Property. 217

Parent Method. 217

ReSize Method. 217

Show Method. 218

Type Property. 219

Update Method. 219

ViewState Property (requires ACT! 2000 or later) 220

Application object properties and methods. 221

ActVersion Property (requires ACT! 2000 or later) 223

AddUser Method. 224

BackupDB Method (requires ACT! 4.0 or later) 225

Caption Property. 225

ChangePassword Method. 226

ClearError Method (requires ACT! 4.0 or later) 227

CloseDB Method. 227

Command Method. 227

CompressDB Method. 228

GetActiveDB Method (not currently implemented) 228

GetAppName Method. 229

GetAppPath Method. 229

GetCurrentUserName Method (requires ACT! 4.0 or later) 230

GetLastError Method. 230

GetOpenDBName Method. 230

GetPosition Method. 231

GetSize Method. 232

GetUserId Method. 232

GetUserPrivilege Method. 233

GetVersion Method (requires ACT! 4.0 or later) 233

Help Method. 234

IsDBOpen Method. 234

IsVisible Method. 234

LastContactListModTime Property. 235

Maximize Method. 235

Minimize Method. 235

OpenDB Method. 236

OpenFile Method. 236

Preferences Method. 237

ProcessFile Method. 237

PurgeHistories Method. 238

PurgeNotes Method. 238

PurgeTransactions Method. 239

ReIndexDB Method. 240

RemoveOutlookActivities Method (requires ACT! 2000 or later) 241

ReSize Method. 241

RestoreDB Method (requires ACT! 4.0 or later) 242

RunMacro Method. 242

SaveCurrentLookup Method. 243

SendKey Method. 243

Show Method. 244

Update Method. 245

UpdateOutlookActivities Method (requires ACT! 2000 or later) 245

Views Method. 246

CalendarView object methods. 247

GetActiveMonth Method. 248

GetCalendarMode Method. 248

SetActiveMonth Method. 249

SetCalendarMode Method. 249

ContactListView object methods. 250

AddNewContact Method (obsolete) 250

AddNewContactEx Method (requires ACT! 4.0 or later) 250

GetGrid Method. 251

ContactView object methods. 253

Activities Method. 255

AddContactToGroup Method. 255

AddNewActivity Method (obsolete) 256

AddNewActivityEx Method (requires ACT! 4.0 or later) 257

AddNewContact Method. 258

AddNoteHistory Method (obsolete) 259

AddNoteHistoryEx Method (requires ACT! 4.0 or later) 259

AttachFile Method (requires ACT! 4.0 or later) 261

BOL Method. 261

CompleteSale Method (requires ACT! 2000 or later) 262

CreateLookup Method (requires ACT! 2000 or later) 263

CreateSalesForecast Method (requires ACT! 2000 or later) 263

Delete Method. 264

DeleteContactFast Method (requires ACT! 2000 or later) 265

EOL Method. 265

GetActiveGroup Method. 266

GetActiveGroupName Method. 267

GetActiveTab Method. 268

GetCount Method. 269

GetCurrentID Method. 269

GetField Method. 270

GetTabCount Method (requires ACT! 4.0 or later) 270

GetTabName Method (requires ACT! 4.0 or later) 271

Goto Method. 272

GroupMembership Method. 272

LookupAll Method. 273

LookupField Method (obsolete) 273

LookupFieldEx Method (requires ACT! 4.0 or later) 273

LookupMyRecord Method. 275

LookupPrevious Method. 275

MoveFirst Method. 275

MoveLast Method. 276

MoveNext Method. 276

Moveprevious Method. 276

NewContactDialog Method (requires ACT! 4.0 or later) 277

NotesHistory Method. 277

RunQuery Method. 277

Sales Method (requires ACT! 2000 or later) 278

SaveQuery Method. 279

SelectContactDlg Method (requires ACT! 4.0 or later) 279

SetActiveGroup Method. 280

SetActiveGroupName Method (requires ACT! 4.0 or later) 281

SetActiveTab Method. 281

SetField Method. 281

TriggerActivitySeries Method (requires ACT! 2000 or later) 282

EmailView object methods. 284

GetActiveInbox Method. 284

GetInboxCount Method. 285

GetInboxName Method. 285

GetOpenFolderMessageCount Method (requires ACT! 2000 or later) 286

MsgComposeView Method. 286

OpenInbox Method. 287

SetActiveInbox Method. 287

Sort Method (requires ACT! 2000 or later) 288

ExplorerView object methods. 289

GetStartupURL Method. 290

GetURL Method. 290

GoBack Method. 290

GoForward Method. 291

Refresh Method. 291

SetURL Method. 291

Stop Method. 292

Grid object methods. 293

BOL Method. 294

DeleteRow Method. 295

EOL Method. 295

GetColumnCount Method. 296

GetColumnID Method. 297

GetColumnName Method. 298

GetCurrentRow Method. 299

GetField Method. 299

GetFilter Method (requires ACT! 4.0 or later) 300

GetLastError Method. 302

GetRowCount Method. 302

GetRowNumber Method. 303

GetUniqueID Method. 303

Goto Method. 303

MoveFirst Method. 304

MoveLast Method. 304

MoveNext Method. 305

Moveprevious Method. 305

RefreshGrid Method. 305

SelectRow Method. 306

SetField Method. 306

SetFilter Method (requires ACT! 4.0 or later) 307

Sort Method. 308

GroupView object methods. 309

Activities Method. 310

AddMemberToGroup Method. 311

AddNew Method. 312

AddNewSubGroup Method (requires ACT! 2000 or later) 313

AddNote Method (obsolete)