Learning
Unix.com

Learning
Java.net

Learning
SQLServer
.com

Learning
C.net

Learning
SAP.com

VB White
Papers &
Articles

Tech Stock
Quotes

Database Trends and Applications - Free Monthly Publication

Database Trends and Applications (DBTA) magazine is the leading monthly publication providing corporate information project teams with timely coverage of the technology, intelligence and insight needed to conceptualize, plan, initiate, implement and manage large-scale, integrated, information-rich projects. Building on its long tradition within the multivalue and multi-dimensional database market, Database Trends and Applications now addresses the full range of enterprise information issues, including operational, transactional and analytical systems.

Using Visual Basic for Applications (VBA)

VBA and Macros for Microsoft Office Excel 2007 By: Bill Jelen, Tracy Syrstad You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

Access 2007 VBA Programmer's Reference By: Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein Written by Access MVPs and Microsoft Access testers, this resource will give you the tools to leverage Access 2007's built-in functionality and VBA in order to build more dynamic applications. It explores all aspects of VBA programming for Access and describes the latest innovations. You'll also find several commonly used techniques and sample code to help you get started, as well as expert tips to make your code easier to maintain. The expert author team will show you how to create and name variables, manipulate data using Data Access Object (DAO) and ActiveX® Data Object (ADO), handle errors, and create classes. You'll also learn how to utilize the latest wizards as well as modify and enhance the code that the wizards create. And you'll learn how to take advantage of key new objects, enhanced macros, and the Office Ribbon.

Microsoft Access VBA Programming for the Absolute Beginner, Third Edition By: Michael Vine If you are new to programming with Microsoft Access VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the for the absolute beginner series teach the principles of programming through simple game creation. Covering Access 2007, Microsoft Access VBA Programming for the Absolute Beginner focuses on VBA programming, but also covers beginning database concepts for those who lack that cursory knowledge of relational databases and/or Microsoft Access. Topics range from beginning SQL concepts, user interface upgrades, new data types, essential programming constructs, and much more. The book not only shows you how to apply the concepts learned to real-world Access 2007 scenarios, but by the time you finish the book, you'll be able to apply the basic principles learned to the next programming language you tackle.

Mastering VBA for Microsoft Office 2007 By: Richard Mansfield Get more done in less time by automating Office tasks Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic(r) for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel(r), PowerPoint(r), Outlook(r), and Access(r). You'll find pages of real-world examples as well as easy-to-follow techniques for topics such as accessing one application from another, programming the Ribbon, and much more.

VBA Programming for Microsoft Office Project Versions 98 through 2007 By: Rod Gill The first book devoted to Microsoft Project VBA. Rod Gill helps you get the most from the worlds most popular Project Management tool by showing you ways to automate away the drudgeries of schedule manipulation, how to vastly enhance your reporting capabilities, and how to integrate with other Microsoft Office applications like Access and Excel. VBA Programming for Microsoft Office Project is packed with carefully commented code samples described through a one-step-at-a-time learning approach, each successively building toward more useful and complex application code. With 14 fully functional macros plus many samples of useful code snippets available for download from the official book site, you can start realizing efficiency gains on your very first day using this long-awaited resource. The books editors include Microsoft Project MVPs Gary L. Chefetz and Dale A. Howard, the authoring team who produced the only book on Project Server 2002, and seven titles covering Project and Project Server 2003 including the benchmark standards: Administering an Enterprise PMO using Microsoft Office Project Server 2003 and Managing Enterprise Projects using Microsoft Office Project Server 2003.

VBA for the 2007 Microsoft Office System By: Paul McFedries Shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity.

© 2008, Krislyn Technologies LLC. All rights reserved. All trademarks are owned by the respective company or Krislyn Technologies LLC.