| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] object libraries object models 2nd 3rd 4th 5th learning names in 2nd referencing object variables 2nd 3rd declaring 2nd objects in For Each loops 2nd setting 2nd objects . [See also ADO (ActiveX Data Objects), DAO] adding to VBA 2nd ADO (ActiveX Data Objects) 2nd versions Connection (ADO) ADO library, referencing 2nd 3rd ConnectionString property 2nd 3rd 4th 5th 6th 7th 8th 9th data sources, specifying 2nd declaring 2nd instantiating 2nd New keyword 2nd opening 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th UDL (universal data link) files 2nd 3rd 4th 5th 6th DAO (Data Access Objects) 2nd versions methods object libraries object models 2nd 3rd 4th 5th learning names in 2nd referencing Parameter properties ODBC Microsoft Access Setup dialog box 2nd OFFSET function 2nd Offset function 2nd OFFSET function BaseCells 2nd example 2nd Height/Width arguments 2nd 3rd multiple cells, returning 2nd 3rd OLAP Cubes On Error GoTo statement one-to-many relationships 2nd one-to-one relationships 2nd Online Analytic Processing (OLAP) Cubes Open event 2nd 3rd 4th 5th 6th 7th 8th Open function Open method arguments 2nd 3rd 4th example 2nd 3rd OpenDatabase method 2nd 3rd opening ADO connections 2nd 3rd 4th GetConnectionStrings function 2nd MakeTheConnection function 2nd Open method with arguments 2nd 3rd 4th Open method with no arguments 2nd 3rd DAO connections 2nd secured Access databases 2nd 3rd 4th OpenRecordset() function 2nd 3rd 4th optimistic locking Optimize Memory option (pivot tables) Option Explicit statement 2nd Options command (Tools menu) Options parameter (OpenDatabase method) Options property (CreateDatabase method) Options property (OpenRecordset() function) orientation changing with Paste Special command 2nd changing with TRANSPOSE function 2nd outer joins 2nd 3rd 4th overworking functions 2nd 3rd 4th 5th 6th Overwrite Existing Cells with New Data, Clear Unused Cells property (data ranges) |