Cargando…
Microsoft Access 2010 : VBA programming inside out /
You're beyond the basics, so dive right in and customize, automate, and extend Access--using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Disco...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
Published with the authorization of Microsoft Corp. by O'Reilly Media,
©2011.
|
| Colección: | Inside out (Redmond, Wash.)
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | OR_ocn768081753 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 111212s2011 cau o 001 0 eng d | ||
| 010 | |a 2011275936 | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d UMI |d COO |d N$T |d YDXCP |d OCLCQ |d TEFOD |d OCLCQ |d DEBSZ |d OCLCQ |d OCLCF |d OCLCQ |d OCLCA |d FHM |d NLE |d VT2 |d UA@ |d CNSPO |d OCLCQ |d OCLCA |d WYU |d OCLCQ |d UKAHL |d OCLCO |d YDX |d OCLCQ | ||
| 019 | |a 741517521 |a 803521242 |a 859879497 |a 1062884275 |a 1103282936 |a 1129361655 |a 1152978184 |a 1192337533 |a 1240517871 | ||
| 020 | |a 9780735665033 |q (electronic bk.) | ||
| 020 | |a 0735665036 |q (electronic bk.) | ||
| 020 | |a 9780735664906 |q (electronic bk.) | ||
| 020 | |a 0735664900 |q (electronic bk.) | ||
| 020 | |a 9780735661639 | ||
| 020 | |a 0735661634 | ||
| 020 | |z 9780735659872 | ||
| 020 | |z 0735659877 | ||
| 029 | 1 | |a AU@ |b 000050492785 | |
| 029 | 1 | |a DEBSZ |b 368471136 | |
| 029 | 1 | |a DEBSZ |b 397136668 | |
| 035 | |a (OCoLC)768081753 |z (OCoLC)741517521 |z (OCoLC)803521242 |z (OCoLC)859879497 |z (OCoLC)1062884275 |z (OCoLC)1103282936 |z (OCoLC)1129361655 |z (OCoLC)1152978184 |z (OCoLC)1192337533 |z (OCoLC)1240517871 | ||
| 037 | |a CL05000000100 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b C68 2011 | |
| 050 | 4 | |a QA76.9.D3 W454 1997 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.7565 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Couch, Andrew. | |
| 245 | 1 | 0 | |a Microsoft Access 2010 : |b VBA programming inside out / |c Andrew Couch. |
| 246 | 3 | |a Access 2010 VBA programming inside out | |
| 260 | |a Sebastopol, Calif. : |b Published with the authorization of Microsoft Corp. by O'Reilly Media, |c ©2011. | ||
| 300 | |a 1 online resource (xxvii, 700 pages). | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Inside out | |
| 505 | 0 | |a Copyright; Dedication; Contents at a Glance; Table of Contents; Introduction; Features and Conventions Used in This Book; About the Companion Content; Acknowledgments; Support and Feedback; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Part 1. VBA Environment and Language; Chapter 1. Using the VBA Editor and Debugging Code; Debugging Code on a Form; Entering the VBA Editor; The Application and VBA Code Windows; Creating Modules and Procedures; Creating a Module; Creating a Procedure; Executing a Subroutine; Executing a Function. | |
| 505 | 8 | |a Viewing and Searching CodeSplit Window; Searching Code; Debugging Code in a Module; Debug Commands; Breakpointing Code; Set Next Command; Breakpoint Step and Run Commands; Displaying Variables in the Locals Window; Tracing Procedures with the Call Stack; Watching Variables and Expressions; Adding Conditional Watch Expressions; Working with the Immediate Window; Changing Code On-the-Fly; Using the Object Browser and Help System; Configuring the Help System; Working with the Object Browser; Summary; Chapter 2. Understanding the VBA Language Structure; VBA Language Settings; Comments. | |
| 505 | 8 | |a Setting Option ExplicitSelecting Option Compare; Compiling Code; Conditional Compilation; References; Working with Constants and Variables; Improving Code Quality with Constants; The Enum Keyword; Variables and Database Field Types; Handling NULL Values, IsNull and Nz; Using Static Variables; Using Global Variables; Variable Scope and Lifetime; Working with Arrays; Type Structures; Functions and Procedures; Managing Code with Subroutines; Defining ByRef and ByValue Parameters; Private and Public Procedures; Optional and Named Parameters; The ParamArray Qualifier. | |
| 505 | 8 | |a Organizing Code in Modules and Class ModulesControl Statements and Program Flow; IF ... Then ... Else ... Statements; IIF Statements; Choose Statements; Select Case Statements; TypeOf Statements; For and For Each Loops; Do While and Do Until Loops; Exit Statements; The With Statement; GoTo and GoSub; Line Continuation; Splitting SQL Over Multiple Lines; Summary; Chapter 3. Understanding the VBA Language Features; Using Built-In Functions; Date and Time Functions; String Functions; Domain Functions; Constructing Where Clauses; SQL and Embedded Quotes; Using VBA Functions in Queries; The Eval Function. | |
| 505 | 8 | |a Shell and SendkeysThe DoEvents Command; Objects and Collections; Object Variables; Is Nothing, IsEmpty, IsObject; Creating Maintainable Code; Naming Access Document Objects; Naming Database Fields; Naming Unbound Controls; Naming Variables in Code; Indenting Code; Other Variable Naming Conventions; VBA and Macros; Access Basic; Converting Macros to VBA; Error Handling; On Error Resume Next; Err Object; On Error GoTo; Developing a General Purpose Error Handler; OpenArgs and Dialog Forms; Err. Raise; Summary; Part 2. Access Object Model and Data Access Objects (DAO). | |
| 520 | |a You're beyond the basics, so dive right in and customize, automate, and extend Access--using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access--and challenge yourself to new levels of mastery!Enhance your application with VBA built-in functions and SQL codeUse the Access Object Model to work with data in forms and reportsManipulate data using SQL, queries, and recordsets with Data Access Objec. | ||
| 588 | 0 | |a Print version record. | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Visual Basic for applications. |
| 630 | 0 | 0 | |a Microsoft Access. |
| 630 | 0 | 7 | |a Microsoft Visual Basic for applications. |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Access. |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Access. |2 fast |0 (OCoLC)fst01371910 |
| 630 | 0 | 7 | |a Microsoft Visual Basic for applications. |2 fast |0 (OCoLC)fst01382545 |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 776 | 0 | 8 | |i Print version: |a Couch, Andrew. |t Microsoft® Access® 2010 VBA Programming Inside Out. |d Sebastopol : Microsoft Press, ©2011 |z 9780735659872 |
| 830 | 0 | |a Inside out (Redmond, Wash.) | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780735661639/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a YBP Library Services |b YANK |n 18067798 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26378544 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL771448 | ||
| 938 | |a EBSCOhost |b EBSC |n 431800 | ||
| 938 | |a YBP Library Services |b YANK |n 7279934 | ||
| 994 | |a 92 |b IZTAP | ||