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