Access 2010 Programmer's ReferenceA comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes:
|
From inside the book
Results 1-5 of 83
Page 56
... Here's an example of what you might see: -3831: The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions. For those rare situations in which users still ...
... Here's an example of what you might see: -3831: The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions. For those rare situations in which users still ...
Page 58
... API function, SHELLEXECUTEINFO. Here's. Porting. an. Access. Application. to. a. 64-bit. Platform. Access 2010. Thus, the modified ShellExecuteEx function sample discussed previously. 58. x. CHAPTER3 UPGRADING AND CONVERTING TO ACCESS 2010.
... API function, SHELLEXECUTEINFO. Here's. Porting. an. Access. Application. to. a. 64-bit. Platform. Access 2010. Thus, the modified ShellExecuteEx function sample discussed previously. 58. x. CHAPTER3 UPGRADING AND CONVERTING TO ACCESS 2010.
Page 59
... Here's the declaration as you would have done in past: Public Type SHELLEXECUTEINFO cbSize As fMask As Hwnd As lpVerb As lpFile As lpParameters As lpDirectory As nShow As hInstApp As lpIDList As lpClass As hkeyClass As dwHotKey As hIcon ...
... Here's the declaration as you would have done in past: Public Type SHELLEXECUTEINFO cbSize As fMask As Hwnd As lpVerb As lpFile As lpParameters As lpDirectory As nShow As hInstApp As lpIDList As lpClass As hkeyClass As dwHotKey As hIcon ...
Page 93
... here. First, the expression must be written using the brackets as shown: [IsClient]. If you begin to type “IsClient” in the Macro Designer, autocomplete for expressions in Access 2010 will add a parenthesis following the name of the ...
... here. First, the expression must be written using the brackets as shown: [IsClient]. If you begin to type “IsClient” in the Macro Designer, autocomplete for expressions in Access 2010 will add a parenthesis following the name of the ...
Page 106
... here. Next, you need to retrieve the value of the SortOrder field for the selected item using the Lookup-Record block, as shown here: /* Get the sort order for the selected item */ Look Up A Record In: tblCustomSortOrder Where Condition ...
... here. Next, you need to retrieve the value of the SortOrder field for the selected item using the Lookup-Record block, as shown here: /* Get the sort order for the selected item */ Look Up A Record In: tblCustomSortOrder Where Condition ...
Contents
1 | |
13 | |
33 | |
63 | |
Chapter 5 Using the VBA Editor | 119 |
Chapter 6 VBA Basics | 141 |
Chapter 7 Using VBA in Access | 173 |
Chapter 8 Creating Classes in VBA | 227 |
Chapter 19 Working with SharePoint | 707 |
Chapter 20 Working with NET | 757 |
Chapter 21 Building ClientServer Applications with Access | 799 |
Chapter 22 The Access 2010 Templates | 841 |
Chapter 23 Access Runtime Deployment | 861 |
Chapter 24 Database Security | 875 |
Chapter 25 Access 2010 Security Features | 919 |
Appendix A The Access Object Model | 945 |
Chapter 9 Extending VBA with APIs | 283 |
Chapter 10 Working with the Windows Registry | 319 |
Chapter 11 Using DAO to Access Data | 355 |
Chapter 12 Using ADO to Access Data | 419 |
Chapter 13 Using SQL with VBA | 459 |
Chapter 14 Using VBA to Enhance Forms | 489 |
Chapter 15 Enhancing Reports with VBA | 549 |
Chapter 16 Customizing the Ribbon | 581 |
Chapter 17 Customizing the Office Backstage | 631 |
Chapter 18 Working with Office 2010 | 671 |
Appendix B DAO Object Method and Property Descriptions | 999 |
Appendix C ADO Object Model Reference | 1035 |
Appendix D 64Bit Access | 1095 |
Appendix E References for Projects | 1103 |
Appendix F Words and Special Characters | 1113 |
Appendix G Naming Conventions | 1127 |
Appendix H Access Source Code Control | 1137 |
Appendix I Tips and Tricks | 1145 |
INDEX | 1191 |
Other editions - View all
Access 2010 Programmer's Reference Teresa Hennig,Rob Cooper,Geoffrey L. Griffith,Jerry Dennison Limited preview - 2010 |
Access 2010 Programmer's Reference Teresa Hennig,Rob Cooper,Geoffrey L. Griffith,Jerry Dennison No preview available - 2010 |
Common terms and phrases
_ ByVal ACCDE Access application Access database Add-in Backstage Boolean button callback called chapter client-server collection class combo box connection contains create custom data macro data source data type database application database file database objects Declare default delete dialog box display End Function End If End End Sub code error handling event example execute field file format folder following code installed Integer IntelliSense interface keyword linked tables MDB file menu method Microsoft Microsoft Access Microsoft Office MsgBox ODBC option pane parameter password primary key Private Sub procedure provides Public Sub query record Recordset object reference Registry Ribbon Runtime SharePoint list specified SQL Server SQL statement stored String Sub code snippet subform template update VBA code versions of Access Visual Basic Visual Studio Web Application Windows Wizard