Index

T

tab controls, 193–195, 434

Tab Order screen, 197–198

tab stops, order of, 197

table(s)

adding to the Customer Service application, 466–467

adding to databases, 241–242

combining data from two, 162

creating in a database, 134

creating with ADOX library, 177–178

exporting to XML, 209

inserting results from a Select statement, 165

for Project Tracker, 341–343

retrieving data from more than one, 161

specifying to upsize, 278, 280

table alias, 160

table attributes, specifying to upsize, 278, 280

table names, removing spaces in, 277

table scans, reducing, 325

table view, 140

TableDef object

creating, 229, 230

programmatically linking a list, 229–232

with a SharePoint list as its source, 229

TableName parameter

for the TransferSharePointList method, 226

for the TransferSpreadsheet method, 205

for the TransferText method, 206

Tables category in Access Projects, 264

tabs

controlling the visibility of, 194

for the Project Tracker screen, 336–339

Tag property, 124

tags in an XML file, 209

tasks in SharePoint, 221

tbl (Table) prefix, 56

tblComplaints table, exporting to HTML, 249–251

tblContacts table, mapping to fields on, 341, 343

tblCustomers table, adding to the Customer Service application, 466

tblCustomersPlanHistory table, adding to the Customer Service application, 467

tblPlans table, adding to the Customer Service application, 467

tblPlansStatus table, adding to the Customer Service application, 467

tblProjects table, adding, 341, 343

tblProjectsComments table, adding to Project Tracker, 342, 343

tblProjectsContacts table, adding to Project Tracker, 342, 343

tblProjectsFileAttachments table, 342, 343

TemplateFile parameter for the OutputTo method, 249

templates, prebuilt, 2

Terminate event for a class, 115

TerraService web services, 215–216, 218–220

Test Connection button, 261

TestCaseStatement procedure, 60–61

TestError procedure, 73–74

TestError2 procedure, 76

TestIfStatement procedure, 57–58

testing phase of SDLC, 24–25

TestLibrary procedure, 311–312

TestLoop procedure, 61

TestMethod method, 111

TestPrinter procedure, 99

TestPrinter sub procedure, 99–100

TestTransferDatabase procedure, 202–203

TestWebService procedure, 218, 219

text box controls

displaying a selected date, 307

setting to current values, 146, 153–154

text boxes

adding to a form, 135

code displaying values in, 188

drawing on a form, 29, 30

text box object variable, 53

Text field data type, 51

text files, 205–208

thin client, 16

three-tiered architecture, 15–17

tiers of an application architecture, 12

toggle button, 438–439

togShowAll_Click event, 424, 438–439

ToolBox, 86, 88

tooltip, 220

TOP predicate, 160

transactions, 313–314

transactions form, displaying, 194, 195

TransferCopyData parameter, 204

TransferDatabase method, 200–203

TransferSharePointList method, 225–229

TransferSpreadsheet method, 204–205, 206

TransferSQLDatabase method, 203–204

TransferText method, 205–208

TransferType parameter

for the TransferDatabase method, 201

for the TransferSharePointList method, 226

for the TransferSpreadsheet method, 205

for the TransferText method, 206

Trust Center, accessing, 47

T-SQL, 159

two-tier applications. See client-server applications

typ (User-Defined Type) prefix, 55

Type Mismatch error, 64, 66

typTripInfo user-defined type, 52–53