Microsoft Access 2010 Bible

473 CHAPTER Accessing Data with VBA Code IN THIS CHAPTER Examining SQL statements Working with Access data Examining the ADO obj ...

Part II: Programming Microsoft Access 474 comply with ANSI SQL-92 (the generally accepted specification for SQL language impleme ...

Chapter 13: Accessing Data with VBA Code ............................................................................... 475 As ...

Part II: Programming Microsoft Access 476 Using these four basic keywords, you can build very powerful SQL statements to use in ...

Chapter 13: Accessing Data with VBA Code 477 When you build a query using the Query Designer, Access automatically includes the ...

Part II: Programming Microsoft Access 478 When you create a SQL SELECT statement, several predicates are available for the SELEC ...

Chapter 13: Accessing Data with VBA Code 479 FIGURE 13.3 Setting the Unique Values property Unique Values property Top Values pr ...

Part II: Programming Microsoft Access 480 The DISTINCTROW predicate is added to a query’s SQL statement by setting the query’s U ...

Chapter 13: Accessing Data with VBA Code 481 When you’re working with more than one table, you can supply a table expression to ...

Part II: Programming Microsoft Access 482 In the case of an inner join, it really makes no difference which table is specified f ...

Chapter 13: Accessing Data with VBA Code 483 FIGURE 13.5 A query using a LEFT JOIN clause Notice that InvoiceNumber is not inclu ...

Part II: Programming Microsoft Access 484 The query in Figure 13.6 is an excellent example of a typical business requirement. In ...

Chapter 13: Accessing Data with VBA Code 485 The fields specified in the ORDER BY clause do not have to be the same fields speci ...

Part II: Programming Microsoft Access 486 Entire books — big books — have been written on the topics covered in the remainder of ...

Chapter 13: Accessing Data with VBA Code 487 An object’s Properties collection is made up of a number of Property objects. Each ...

Part II: Programming Microsoft Access 488 The Object Browser is easy to use. Select a library (ADODB, for example) from the drop ...

Chapter 13: Accessing Data with VBA Code 489 FIGURE 13.9 Referencing the ADO library In the following code examples, notice that ...

Part II: Programming Microsoft Access 490 The Connection must be opened before it can be used. The following statement is the ea ...

Chapter 13: Accessing Data with VBA Code 491 Debug.Print cnn.Provider cnn.Close Set cnn = Nothing End Sub When working with ADO, ...

Part II: Programming Microsoft Access 492 Finally, open the .udl file in Notepad and copy the connection string from the file’s ...