Access 2007 VBA programming for dummies:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Hoboken, NJ
Wiley
©2007
|
| Schriftenreihe: | --For dummies
|
| Schlagworte: | |
| Online-Zugang: | FAW01 FAW02 Volltext |
| Beschreibung: | Includes index Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers.; Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming.; Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately.; Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office a Cover -- TOC36;Table of Contents -- Introduction -- Part I Introducing VBA Programming -- CH36;Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- CH36;Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- CH36;Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- CH36;Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- - CH36;Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA44; Recordsets44; and SQL -- CH36;Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL63; -- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- CH36;Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- CH36;Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right45;Click -- - CH36;Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- CH36;Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- CH36;Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- CH36;Chapter 13 Using VBA with Multiple Databases -- Client45;Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing44; Exporting44; or Linking to Anything -- CH36;Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- - Sending E45;Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- CH36;Chapter 15 Ten Commandments of Writing VBA -- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- II46; Thou Shalt Not Use VBA Statements in Vain -- III46; Remember to Keep Holy the VBA Syntax -- IV. |
| Beschreibung: | 1 Online-Ressource (1 volume) |
| ISBN: | 0470148047 1280741910 9780470148044 9781280741913 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043110630 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151126s2007 |||| o||u| ||||||eng d | ||
| 020 | |a 0470148047 |c electronic bk. |9 0-470-14804-7 | ||
| 020 | |a 1280741910 |9 1-280-74191-0 | ||
| 020 | |a 9780470148044 |c electronic bk. |9 978-0-470-14804-4 | ||
| 020 | |a 9781280741913 |9 978-1-280-74191-3 | ||
| 035 | |a (OCoLC)85854706 | ||
| 035 | |a (DE-599)BVBBV043110630 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1046 |a DE-1047 | ||
| 082 | 0 | |a 005.75/65 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Stockman, Joseph C. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Access 2007 VBA programming for dummies |c by Joseph C. Stockman and Alan Simpson |
| 264 | 1 | |a Hoboken, NJ |b Wiley |c ©2007 | |
| 300 | |a 1 Online-Ressource (1 volume) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a --For dummies | |
| 500 | |a Includes index | ||
| 500 | |a Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers.; Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming.; Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately.; Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office a | ||
| 500 | |a Cover -- TOC36;Table of Contents -- Introduction -- Part I Introducing VBA Programming -- CH36;Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- CH36;Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- CH36;Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- CH36;Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- | ||
| 500 | |a - CH36;Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA44; Recordsets44; and SQL -- CH36;Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL63; -- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- CH36;Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- CH36;Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right45;Click -- | ||
| 500 | |a - CH36;Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- CH36;Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- CH36;Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- CH36;Chapter 13 Using VBA with Multiple Databases -- Client45;Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing44; Exporting44; or Linking to Anything -- CH36;Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- | ||
| 500 | |a - Sending E45;Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- CH36;Chapter 15 Ten Commandments of Writing VBA -- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- II46; Thou Shalt Not Use VBA Statements in Vain -- III46; Remember to Keep Holy the VBA Syntax -- IV. | ||
| 630 | 0 | 4 | |a Microsoft Access |
| 630 | 0 | 4 | |a Microsoft Visual Basic for applications |
| 650 | 7 | |a COMPUTERS / Programming Languages / SQL. |2 bisacsh | |
| 650 | 7 | |a Microsoft Access |2 fast | |
| 650 | 7 | |a Microsoft Visual Basic for applications |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 4 | |a Database management | |
| 700 | 1 | |a Simpson, Alan |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Paperback |z 0-470-04653-8 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Paperback |z 978-0-470-04653-1 |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028534821 | ||
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562 |l FAW01 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562 |l FAW02 |p ZDB-4-EBA |q FAW_PDA_EBA |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1804175529981509632 |
|---|---|
| any_adam_object | |
| author | Stockman, Joseph C. |
| author_facet | Stockman, Joseph C. |
| author_role | aut |
| author_sort | Stockman, Joseph C. |
| author_variant | j c s jc jcs |
| building | Verbundindex |
| bvnumber | BV043110630 |
| classification_rvk | ST 271 |
| collection | ZDB-4-EBA |
| ctrlnum | (OCoLC)85854706 (DE-599)BVBBV043110630 |
| dewey-full | 005.75/65 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/65 |
| dewey-search | 005.75/65 |
| dewey-sort | 15.75 265 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06071nmm a2200565zc 4500</leader><controlfield tag="001">BV043110630</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151126s2007 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0470148047</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">0-470-14804-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1280741910</subfield><subfield code="9">1-280-74191-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470148044</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-0-470-14804-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781280741913</subfield><subfield code="9">978-1-280-74191-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)85854706</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043110630</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/65</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Stockman, Joseph C.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Access 2007 VBA programming for dummies</subfield><subfield code="c">by Joseph C. Stockman and Alan Simpson</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ</subfield><subfield code="b">Wiley</subfield><subfield code="c">©2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1 volume)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">--For dummies</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers.; Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming.; Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately.; Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office a</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Cover -- TOC36;Table of Contents -- Introduction -- Part I Introducing VBA Programming -- CH36;Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- CH36;Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- CH36;Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- CH36;Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - CH36;Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA44; Recordsets44; and SQL -- CH36;Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL63; -- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- CH36;Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- CH36;Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right45;Click -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - CH36;Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- CH36;Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- CH36;Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- CH36;Chapter 13 Using VBA with Multiple Databases -- Client45;Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing44; Exporting44; or Linking to Anything -- CH36;Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- </subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a"> - Sending E45;Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- CH36;Chapter 15 Ten Commandments of Writing VBA -- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- II46; Thou Shalt Not Use VBA Statements in Vain -- III46; Remember to Keep Holy the VBA Syntax -- IV.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Access</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Visual Basic for applications</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Access</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Visual Basic for applications</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Simpson, Alan</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Paperback</subfield><subfield code="z">0-470-04653-8</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Paperback</subfield><subfield code="z">978-0-470-04653-1</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028534821</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562</subfield><subfield code="l">FAW01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562</subfield><subfield code="l">FAW02</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FAW_PDA_EBA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043110630 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:17:45Z |
| institution | BVB |
| isbn | 0470148047 1280741910 9780470148044 9781280741913 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028534821 |
| oclc_num | 85854706 |
| open_access_boolean | |
| owner | DE-1046 DE-1047 |
| owner_facet | DE-1046 DE-1047 |
| physical | 1 Online-Ressource (1 volume) |
| psigel | ZDB-4-EBA ZDB-4-EBA FAW_PDA_EBA |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Wiley |
| record_format | marc |
| series2 | --For dummies |
| spelling | Stockman, Joseph C. Verfasser aut Access 2007 VBA programming for dummies by Joseph C. Stockman and Alan Simpson Hoboken, NJ Wiley ©2007 1 Online-Ressource (1 volume) txt rdacontent c rdamedia cr rdacarrier --For dummies Includes index Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers.; Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming.; Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately.; Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office a Cover -- TOC36;Table of Contents -- Introduction -- Part I Introducing VBA Programming -- CH36;Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- CH36;Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- CH36;Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- CH36;Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- - CH36;Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA44; Recordsets44; and SQL -- CH36;Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL63; -- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- CH36;Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- CH36;Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right45;Click -- - CH36;Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- CH36;Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- CH36;Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- CH36;Chapter 13 Using VBA with Multiple Databases -- Client45;Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing44; Exporting44; or Linking to Anything -- CH36;Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- - Sending E45;Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- CH36;Chapter 15 Ten Commandments of Writing VBA -- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- II46; Thou Shalt Not Use VBA Statements in Vain -- III46; Remember to Keep Holy the VBA Syntax -- IV. Microsoft Access Microsoft Visual Basic for applications COMPUTERS / Programming Languages / SQL. bisacsh Microsoft Access fast Microsoft Visual Basic for applications fast Database management fast Database management Simpson, Alan Sonstige oth Erscheint auch als Druck-Ausgabe, Paperback 0-470-04653-8 Erscheint auch als Druck-Ausgabe, Paperback 978-0-470-04653-1 http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562 Aggregator Volltext |
| spellingShingle | Stockman, Joseph C. Access 2007 VBA programming for dummies Microsoft Access Microsoft Visual Basic for applications COMPUTERS / Programming Languages / SQL. bisacsh Microsoft Access fast Microsoft Visual Basic for applications fast Database management fast Database management |
| title | Access 2007 VBA programming for dummies |
| title_auth | Access 2007 VBA programming for dummies |
| title_exact_search | Access 2007 VBA programming for dummies |
| title_full | Access 2007 VBA programming for dummies by Joseph C. Stockman and Alan Simpson |
| title_fullStr | Access 2007 VBA programming for dummies by Joseph C. Stockman and Alan Simpson |
| title_full_unstemmed | Access 2007 VBA programming for dummies by Joseph C. Stockman and Alan Simpson |
| title_short | Access 2007 VBA programming for dummies |
| title_sort | access 2007 vba programming for dummies |
| topic | Microsoft Access Microsoft Visual Basic for applications COMPUTERS / Programming Languages / SQL. bisacsh Microsoft Access fast Microsoft Visual Basic for applications fast Database management fast Database management |
| topic_facet | Microsoft Access Microsoft Visual Basic for applications COMPUTERS / Programming Languages / SQL. Database management |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562 |
| work_keys_str_mv | AT stockmanjosephc access2007vbaprogrammingfordummies AT simpsonalan access2007vbaprogrammingfordummies |