Additional References

The following books and Web sites provide additional information about developing applications and solutions.

Access Virus Information

Access Virus Information Web site
(http://officeupdate.microsoft.com/Articles/antivirus.htm)

ActiveX Data Objects (ADO)

Microsoft Universal Data Access Web site
(http://www.microsoft.com/data/)

Microsoft ActiveX Data Objects Web site
(http://www.microsoft.com/data/ado/)

Microsoft Office Developer Center
(http://msdn.microsoft.com/office/)

Vaughn, William R. Hitchhiker's Guide to Visual Basic and SQL Server, Sixth Edition. Redmond, WA: Microsoft Press, 1998.

Administrator Control over Passwords

Microsoft Office Resource Kit Web site
(http://www.microsoft.com/office/ork/)

Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.

Administrator Control over Internet Explorer

Internet Explorer Administration Kit Web site
(http://ieak.microsoft.com/)

Answer Wizard SDK

Microsoft Office Resource Kit Web site
(http://www.microsoft.com/office/ork/)

Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.

Calling the Windows API from VBA

Appleman, Dan. Dan Appleman's Visual Basic 5.0 Programmer's Guide to the Win32 API. Indianapolis, IN: Macmillan Computer Publishing, 1998.

Bockmann, Christopher J., Lars Klander, and Lingyan Tang. Visual Basic Programmer's Library. Las Vegas, NV: Jamsa Press, 1998.

Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.

O'Brien, Timothy, Steven Pogge, and Geoffrey White. Microsoft Access 97 Developer's Handbook. Redmond, WA: Microsoft Press, 1997.

Creating Add-ins and DLLs in Microsoft® Visual Basic®

Microsoft Developer Network Web site
(http://msdn.microsoft.com/default.asp)

Microsoft Visual Basic 6.0 Programmer's Guide. Redmond, WA: Microsoft Press, 1998.

Cornell, Gary, and Dave Jezak. Core Visual Basic 6. Upper Saddle River, NJ: Prentice Hall PTR, 1998.

McKinney, Bruce. Hardcore Visual Basic, Second Edition. Redmond, WA: Microsoft Press, 1997.

Creating and Using DHTML Scriptlets

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

Creating Application-Specific Templates and Add-ins

Boctor, David. Microsoft Office 2000/Visual Basic Fundamentals. Redmond, WA: Microsoft Press, 1999.

Getz, Ken, Paul Litwin, and Mike Gilbert. Access 2000 Developer's Handbook, Volume 1: Desktop Edition. Alameda, CA: Sybex, 1999.

Creating COM Add-ins with Visual C++ and Visual J++

Microsoft Developer Network Web site
(http://msdn.microsoft.com/default.asp)

Creating Object Models in VBA

Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.

Stearns, Dave. "The Basics of Programming Model Design." MSDN Online Web site at http://msdn.microsoft.com/library/techart/msdn_basicpmd.htm.

Creating PivotTable Reports

Microsoft Office Developer Center
(http://msdn.microsoft.com/office/)

Wells, Eric, and Steve Harshberger. Microsoft Excel 97 Developer's Handbook. Redmond, WA: Microsoft Press, 1997.

Data Access Objects (DAO)

Microsoft Office Developer Center
(http://msdn.microsoft.com/office/)

Microsoft Jet Database Engine Programmer's Guide, Second Edition. Redmond, WA: Microsoft Press, 1997

Database Design

Hernandez, Michael J. Database Design for Mere Mortals. Reading, MA: Addison-Wesley Developers Press, 1997.

Roman, Steven. Access Database Design and Programming. Sebastopol, CA: O'Reilly & Associates, 1997.

Debugging VBA Code

Maguire, Steve. Writing Solid Code. Redmond, WA: Microsoft Press, 1993.

McConnell, Steve. Code Complete. Redmond, WA: Microsoft Press, 1993.

Debugging and Error Handling in Script

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

DHTML

Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.

Simpson, Alan. Official Microsoft Internet Explorer 4 Site Builder Toolkit. Redmond, WA: Microsoft Press, 1998.

Disabling User Passwords

Microsoft Office 2000 Resource Kit. Redmond, WA: Microsoft Press, 1999.

General Security Issues

Microsoft Security Advisor Web site
(http://www.microsoft.com/security/)

HTML Help

Steve Wexler. Official Microsoft HTML Help Authoring Kit. Redmond, WA: Microsoft Press, 1998.

Internet Information Server Authentication and Encryption Configuration

Microsoft Internet Information Server 4.0 Online documentation
http://www.microsoft.com/ntserver/web/exec/feature/Datasheet.asp)

Macro Viruses

Microsoft Office Anti-Virus Center Web site
(http://officeupdate.microsoft.com/Articles/antivirus.htm)

International Computer Security Association (ICSA) Web site
http://www.icsa.net )

Microsoft Jet Replication

Microsoft Jet Database Engine Programmer's Guide, Second Edition. Redmond, WA: Microsoft Press, 1997.

Dove, Debra. "Database Replication in Microsoft Jet." (RepJet.doc)

Microsoft Outlook

Byrne, Randy. Building Applications with Microsoft Outlook 2000. Redmond, WA: Microsoft Press, 1999.

Microsoft SQL Server

Microsoft SQL Server Web site
(http://www.microsoft.com/sql)

Naming Conventions

Microsoft Knowledge Base article: "Built-in Constants in Visual Basic for Applications," Q112671 (http://support.microsoft.com/support)

OLAP, OLE DB for OLAP, and OLAP Queries

Universal Data Access Web site
http://www.microsoft.com/data

Microsoft SQL Server OLAP Services
(http://www.microsoft.com/sql/techinfo/olap.htm)

OLE DB

Microsoft OLE DB Web site
(http://www.microsoft.com/data/oledb)

Optimizing VBA Code

Balena, Francesco. "88 Optimization Tips." Visual Basic Programmer's Journal 7, no. 14 (December 1997): 28–41.

Signcode.exe Utility for Signing COM Add-ins

Microsoft Internet Client SDK Web site
(http://msdn.microsoft.com/workshop/essentials/inetsdk/inetsdk_map.asp)

SQL Server Replication

SQL Server Books Online, Replication.

Subclassing Windows Messages

Bockmann, Christopher J., Lars Klander, and Lingyan Tang. Visual Basic Programmer's Library. Las Vegas, NV: Jamsa Press, 1998.

Training Resources for Office XP

http://www.microsoft.com/office/training/training.asp

Universal Data Access Strategy

Microsoft Universal Data Access Web site
(http://www.microsoft.com/data)

Useful Tips and Sample Code

Microsoft Office Developer Center
(http://msdn.microsoft.com/office/)

The Microsoft Knowledge Base
http://support.microsoft.com/support

Useful VBA Sample Code

For samples and how-to articles that may provide interesting code, search the Visual Basic for Applications section of the Microsoft Knowledge Base for "VBA." The Knowledge Base is available at http://support.microsoft.com/support.

Using ActiveX Data Objects with MDB Files and the Microsoft Jet Database Engine

Microsoft ActiveX Data Objects Web site at http://www.microsoft.com/data/ado.

Using ActiveX Data Objects with SQL Server

Vaughn, William R. Hitchhiker's Guide to Visual Basic and SQL Server, Sixth Edition. Redmond, WA: Microsoft Press, 1998.

SQL Server Books Online, Building SQL Server Applications.

Using Scriptlets

Scriptlet Technology Web site
(http://msdn.microsoft.com/developer/sdk/inetsdk/help/scriptlets/scrlt.htm)

Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.

Scriptlet Wizard on Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting)

Using Scriptlets in HTML Files

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

Isaacs, Scott. Inside Dynamic HTML. Redmond, WA: Microsoft Press, 1997.

Windows File System Security

Microsoft Windows 95 Resource Kit. Redmond, WA: Microsoft Press, 1995.

Microsoft Windows 98 Resource Kit. Redmond, WA: Microsoft Press, 1998.

Microsoft Windows NT Workstation Resource Kit. Redmond, WA: Microsoft Press, 1996.

Microsoft Windows NT Server Resource Kit. Redmond, WA: Microsoft Press, 1996.

WinHelp 4.0

Microsoft Help Workshop (download from the Microsoft Technical Support Web site at http://www.microsoft.com/downloads/release.asp?ReleaseID=23216)

Microsoft Windows 95 Help Authoring Kit. Redmond, WA: Microsoft Press, 1995.

Working with JScript

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

Working with VBA

Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.

Working with VBScript

Microsoft Scripting Technologies Web site
(http://msdn.microsoft.com/scripting/default.htm)

Working with the Visual Basic for Applications Extensibility Library

Getz, Ken, and Mike Gilbert. Visual Basic Language Developer's Handbook. Alameda, CA: Sybex, 1999.

Wrapping API Functions

Microsoft Developer Network Web site
(http://msdn.microsoft.com/default.asp)

Appleman, Dan. Dan Appleman's Visual Basic 5.0 Programmer's Guide to the Win32 API. Indianapolis, IN: Macmillan Computer Publishing, 1998.

Writing Reusable Code

McConnell, Steve. Code Complete. Redmond, WA: Microsoft Press, 1993.

XML

XML Developer Center
(http://msdn.microsoft.com/xml/default.asp)