DescriptionWhat is this book about?
Access 2000 is an important part of the Office 2000 program suite, and is available on both the Premium and Professional editions of Office 2000. Access has traditionally been the Office suite database program par excellence. It still remains that way, but with Office 2000 the face of Access is changing. This book will look at the traditional role of Access and its future uses in the Office suite.
Using VBA (Visual Basic for Applications), the user can program his or her own programs in what is essentially a subset of the Visual Basic programming languages. This is tremendously powerful, as it allows you to create great User Interfaces (forms etc), as a front end to actual database storage and manipulation. This continues to be one of the great strengths of programming Access VBA.
This book updates, expands and improves Beginning Access 97 VBA Programming, in an Office 2000 setting. All the great tutorial content, teaching people how to program with VBA in Access is there, but now majorly rewritten to take account of Office 2000.
- Updated to take account of the Office 2000 facilities
- Constructs a substantial example application with VBA
- Database theory taught in the Wrox Beginning style
What does this book cover?
In this book, you will learn how to
- Construct a substantial example application with VBA
- Master the foundations of Visual Basic for Applications
- Understand the concepts behind classes and objects
- Understand how Automation can be used to link Office applications
- Create custom objects using the Class Module feature
- Debug your programs and implement robust error handling
- Add support for multiple users
- Publish your Access database on the Internet
- Optimize and add polish to your finished database application
Who is this book for?
This book is for users who already have a basic knowledge of databases and the basic Access objects, such as tables, queries, forms and reports. You now want to expand on your existing knowledge of Access and wish to learn how to program in VBA. You don't need any prior programming experience, although a basic knowledge of Access macros would be helpful.
Chapter 1. Access 2000 – A Long Journey.
Chapter 2. Designing Applications.
Chapter 3. Introduction to Event Driven Programming.
Chapter 4. Creating Code.
Chapter 5. Controlling the Program.
Chapter 6. Using Access Objects.
Chapter 7. Using DAO.
Chapter 8. Data Management Techniques.
Chapter 9. External Data.
Chapter 10. Reports.
Chapter 11. Advanced Programming Techniques.
Chapter 12. Error Handling and Debugging.
Chapter 13. Using Classes.
Chapter 14. Libraries and Add-Ins.
Chapter 15. Automation.
Chapter 16. Multi-User.
Chapter 17. The Internet.
Chapter 18. Optimizing Your Application.
Appendix A. Choosing Between MSDE and Jet.
Appendix B. Choosing Between DAO and ADO.
Appendix C. ADO 2.1 Object Model.
Appendix D. Access Object Model.
Appendix E. Microsoft DAO 3.6 Object Library Reference.
Appendix F. Access Events.
Appendix G. ANSI Character Set.
Appendix H. ODBC and PWS.
|WileyError in loading dll for main project |
In the database icecream.mdb in the root directory of the installation for
|79||Page 79 Typing error |
The second exercise should include the phrase 'event handlers' rather than 'even handlers'. The whole paragraph should read:
Take some time to read through the list of events and their uses. You will find that some events are more useful than others - in other words, you will find yourself writing custom event handlers for some events more often than for other events. Look at the list and try to think about which events you would most commonly handle with custom event handlers.
Thanks to Heather Wainwright
|90||Page 90 IsMissing function |
The code at the bottom of the page has two unnecessary Else statements. It should simply read as follows:
|102||Page 102 Table at bottom of page |
In the table at the foot of this page the third value given in the left-hand column should read '22.345' rather than '12.345 + 10 ' as stated.
Thanks to Terry Franklin
|106||Page 106 Code Error |
The code in bullet 2 should read:
|116||Page 116 Error in Code |
n step 3 the line
|116||Step 1 Code Highlight |
Step 1 should have the following lines highlighted:
|187||Code Error |
19-Jul-02We have just found an error in the code supplied in the Solutions.mdb database pertaining to the exercise in Chapter 6, pg 187. Thanks to Roger Pellatt
|198||Page 198 typo |
The last line of code at the bottom of the page should read as:
|205||Page 205 Table-type Recordset Objects |
The following statement is incorrect:
|228||Page 228 Error in Code |
Code should read as:
|271||Page 271 code error|
In bullet point 4 at the bottom of the page the Function declaration should read as:
|307||Page 307 Error in text ||22-Feb-01||1|
|336||Page 336 Code Error |
n section 13 at the bottom of the page the code should read as follows:
|374||Page 374 Missing code |
The code in point 3 at the top of the page should read as follows:
On the botton of page 444 says
|471||Page 471 The MeanDelay property |
n point 5 the first line should read:
|540||Order.dot missing from CD |
It appears the Order.dot template you need to run the Creating a Word Document Try It Out in Chapter 15 was omitted from the CD. We have added it to the code download section for the book on this site. Apologies if this caused any inconvenience.
At the bottom of page 540, two variables are declared as follows:
|552||Page 552 Code error |
THe SELECT statement in the code snippet on this page should read as:
|557||Page 557 Code snippet |
The SELECT statement towards the bottom of the page should read as follows:
|594||Page 594 Coding error |
The portion of code that verifies the new password does not exit the
|687||Error in code|
Dave Sussman comments....
|700||Page 700 Error in code |
The code should read as follows:
|709||Page 709 Error in code|
The code on p709 should read as follows: