By default, you can print reports that contain no records. To solve this problem, you can use either a macro or Microsoft Visual Basic for Applications VBA code to detect the absence of records in a report and then cancel the print operation. The steps in this paper explain how...
Microsoft Excel 2000 provides several new Microsoft Visual Basic for Applications VBA properties, methods, and objects that allow you to take advantage of new data access methods when you automate queries and PivotTable reports in custom solutions. For information about getting Visual Basic Help in Excel, type get VB Help...
By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that functionality manually. If you use Excel 2000, you need to use a few lines of Microsoft Visual Basic...
When you need to give users a list of choices, you typically provide those choices in a combo box control or a list box control. Most Access developers use combo boxes because they're more versatile - they allow users to enter text or select an item from a list. If...
The Chairman, former Chairman, and Ranking Minority Member, Senate Committee on Veterans' Affairs asked GAO to review the Veterans Benefits Administration's VBA efforts to realign its compensation and pension claims processing field structure to improve performance. This report identifies the actions VBA has taken to realign its compensation and pension...
The Chairman, Subcommittee on Disability Assistance and Memorial Affairs, House Committee on Veterans' Affairs, asked GAO to submit a statement for the record highlighting findings from an examination of the Veterans Benefit Administration's VBA fiscal year 2005 budget justification. This paper assesses VBA's determination and justification of claims processing staffing...
With a global emphasis on improved quality, Statistical Process Control SPC is an important process management tool with renewed significance. In order to address this issue, this article discusses an interactive VBA Tool for teaching SPC and process management issues. Students can experiment with the tool to interactively examine the...
Advanced Microsoft Office documents 2007 edition inside out. (CD-ROM included) Krieger, Stephanie. Microsoft Press 2007 671 pages $49.99 Paperback Inside out HF5548 Rather than addressing Microsoft Office 2007 from scratch to experienced...
DUBLIN, Ireland -- Research and Markets (http://www.researchandmarkets.com/reports/c82630) has announced the addition of "RibbonX : Customizing the Office 2007 Ribbon" to their offering. * As the most radical change to the Office interface in its history, the Ribbon replaces the traditional menu bar and toolbars and requires a new...
VBA and macros for Microsoft Office Excel 2007. Jelen, Bill "MrExcel" and Tracy Syrstad. Que Publishing 2008 598 pages $39.99 Paperback HF5548 Intended for advanced Excel users, this guide introduces the macro language Visual...
Microsoft Office Excel 2007 Visual Basic for applications step by step. (CD-ROM included) Jacobson, Reed. Microsoft Press 2007 354 pages $29.99 Paperback HF5548 This guide details how to create macros using Microsoft Excel 2007...
DUBLIN, Ireland -- Research and Markets (http://www.researchandmarkets.com/reports/c71777) has announced the addition of "RibbonX For Dummies" to their offering. RibbonX For Dummies, written in the Dummies friendly, easy-to-understand style, shows programmers how to build applications with the Office Ribbon. This book will show simpler examples in VBA and create...
Alison Balter's mastering Microsoft Office Access 2007 development. Balter, Alison. Sams 2007 1268 pages $59.99 Paperback QA76.9 Balter, a developer consultant/author of several Sams' books on Microsoft Access and SQL Server, introduces the skills...
Have you ever wanted to do something in Excel only to find that it has no function for that task? That shouldn't stop you, because Excel has a built-in ability to help you customize your own functions. The key is Excel's macro tool, which...
RESTON, Va. -- Learning Tree International (NASDAQ NM:LTRE) has added a new title to its Microsoft Office and Access offerings, Building Applications with Microsoft Access 2007: Hands-On. The 4-day course focuses on a single case study and involves attendees in extensive hands-on exercises--led by an expert instructor--for the purpose of...
VBA and C/C++ Support Increases Capabilities of Excel For Faster and Enhanced Decision-Making NEW YORK -- ASPEED Software, the company optimizing application performance in the most advanced HPC environments, today announced the availability of ACCELLERANT 4.1 for Microsoft [R] Excel[R]. Vetted in several customer implementations, the solution cuts...
Tricks of the Microsoft Office gurus. McFedries, Paul. Que Publishing 2005 536 pages $39.99 Paperback Business solutions HF5548 This guide highlights little-used features of Microsoft Office, involving Excel, Word, PowerPoint, Access, and...
A free website from Wise Owl Business Solutions has been launched to provide users with an independent assessment of their knowledge of Microsoft applications. The ms-iq.com website enables users to gain insight into their current abilities and determine if they are a beginner, intermediate or advanced user. The test also...
Automating Microsoft Access with VBA. Harkins, Susan Sales and Mike Gunderloy. Que Publishing 2005 384 pages $34.99 Paperback Business solutions QA76.9 Written for computer-savvy business professionals, this guide uses the Visual Basic...
Excel scientific and engineering cookbook. Bourg, David M. O'Reilly Media, Inc. 2006 424 pages $44.99 Paperback TA345 Traditional scientific and engineering computing tools require specialized access and advanced training. With examples drawn from his...
Articles 2006-06-01
<< Previous
page 1 of 1
Next >>
Premier Vendor Content
Whitepapers, webcasts & resources from our Power Center Sponsors