You are here: Advisor.com » Advisor Guides » DataBased Advisor » DataBased Advisor gives you everything: All Advisor's IT, collaboration, development, admin, database and tech know-how in one place, including Microsoft Access, .NET, Office, SharePoint, SQL Server, Visual Basic, Visual FoxPro, and Visual Studio, and IBM Lotus, WebSphere and Workplace, and Novell GroupWise, and Law Technology, Compliance and E-Discovery, plus E-Business, Mobile Business, Security, and more. DataBased Advisor -- the authority since 1983.
My.ADVISOR.com Sign-In
Username
Password
Sign-Up 
Go to Article
Advanced Search 
New Know-How for Subscribers
Top 15 for 2008 Week 20

DATABASE DEVELOPMENT

Know Your FileMaker Pro File Structure Methodologies DOWNLOAD

Which approach is best for a solution: Table-to-table, distribution, separation, or session? Learn about each, and the pros and cons of these approaches.

By Jonn Howell, DataExperience president

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: @Formula Language and LotusScript

In this book excerpt, learn about additions to the @Formula language and LotusScript in Lotus Notes/Domino 8, as well as what's ahead.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

ADVISOR TIPS

Programmatically Control Your Visual FoxPro Project Version

Here's how to make sure the build number is always up to date.

By Rick Schummer

USER INTERFACE

Use Field Description Properties to Make Microsoft Access Information Meaningful

When the field description isn’t adequate, usurp it with a query.

By Susan Sales Harkins

ADVISOR TIPS

Sort Text Data in Microsoft Access

By Ken Getz, technical editor

ADVISOR ANSWERS

Do Complex FileMaker Pro Finds Using Related Data

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: DB2 Integration and View Enhancements

In this book excerpt, learn about more new features in Lotus Notes/Domino 8, including DB2 integration and view enhancements.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

SCRIPTING

Good Catch! Error Capture and Testing in FileMaker Pro Scripts

Learn how and when to use the Set Error Capture script step, and how to script comprehensive error testing and handling.

By David Head, uLearnIT owner and principal trainer

ADVISOR TIPS

Create a Custom Exception .NET Class

Here's how to create a custom exception class that inherits from System.ApplicationException (or System.Exception), and add custom properties as necessary.

ADVISOR ANSWERS

Selecting Files in Access, Revisited

In a previous tip, you got some code to select files. But, what if you're using Access 97 and, therefore, can't take advantage of the Split function. Here's an alternate solution.

ADVISOR TIPS

Give Feedback to Visual FoxPro Users During Drag-and-Drop

How to set the mouse pointer to indicate no-drop zones.

By Mike Lewis, contributing editor

WEB DEVELOPMENT

Create Conditional Value Lists with FileMaker.php and AJAX DOWNLOAD

Make your FileMaker/PHP Web application shine with AJAX.

By Jonathan Stark, Jonathan Stark Consulting

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: Web Services

In this book excerpt, see how to build an example web service.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

USER INTERFACE

Add a Microsoft Help System to Your Access Application DOWNLOAD

Give users the help they need and add that professional touch to your application.

By Tom Anselmo

ADVISOR TIPS

Avoid Unexpected Visual FoxPro Behavior in FOR/EACH Loops

Use FOXOBJECT to avoid problems with collections.

By Mike Lewis, contributing editor

DataBased Advisor articles

ADVISOR ANSWERS

Handling Custom .NET Exceptions

Here's how to bubble up exception information that doesn't correspond to any of the built-in exceptions.

By Ken Getz, technical editor

ADVISOR ANSWERS

Select Multiple Files in Microsoft Access

This flexible code hands back either a single file name or an array of file names.

By Ken Getz, technical editor

APPLICATION INTEGRATION

Connect FileMaker Pro to Corporate Databases with ESS

With FileMaker 9's External SQL Sources feature, you can make the connection to high-end corporate databases with no complicated programming.

By Geoff Coffey, Six Fried Rice partner, and Advisor Basics of FileMaker Pro technical editor

ADVISOR ANSWERS

Uncover Reasons for Strange Layouts After FileMaker Pro Upgrades

Discover the reasons for some odd layouts after an upgrade.

By Lee Lukehart, Soliant Consulting director of training

ADVISOR TIPS

Master FileMaker Pro Keyboard Shortcuts

One of the best ways to be an efficient developer is to master FileMaker Pro's keyboard shortcuts. If you make an effort to learn them, you'll accumulate some truly useful time savers. Here are some favorites.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR TIPS

FileMaker Pro Certification

Why are 173 FileMaker Business Alliance (FBA) members and countless other in-house developers certified for FileMaker Pro 7, 8, and 9? Find out here.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create a Modification Host Timestamp in FileMaker Pro

Learn how to auto-enter the modification timestamp from the host when a user modifies any field on a record.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

COMPLIANCE

Auditing Your Warehouse for Sarbanes-Oxley Compliance

Through a comprehensive auditing subsystem, you can give auditors everything they need to trace data from financial reports back to their sources.

By Tod McKenna

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: Domino Designer Features

In this book excerpt, learn about some of the new features in Domino Designer 8.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

ADVISOR ANSWERS

Selecting Files in Microsoft Access

Here's how to work with an ever-tricky control.

By Ken Getz, technical editor

Display List of Colors on an ASP.NET Page, Revisited

Here's how to display a list of colors on an ASP.NET page, without having to loop through all the members manually.

By Ken Getz, technical editor

ADVISOR ANSWERS

Sorting a List in Multiple Ways in .NET

Here's how to specify several different sort orders

By Ken Getz, technical editor

ADVISOR ANSWERS

Solve a FileMaker Pro Data Importing Conundrum

Find out what to do when text files don't import correctly.

By Lee Lukehart, Soliant Consulting director of training

BENTO

Supercharge Your Address Book with FileMaker Bento

FileMaker, Inc., has given us a brand new way to manage data. Find out what you can (and can't) do with Bento.

By Maria Langer

DATABASE DEVELOPMENT

Stay Sharp! Nourish Your FileMaker Pro Skills with the Right Development Diet

What constitutes good nutrition for creative, professional, responsible FileMaker Pro developers? Find the right blend of programming activities to keep you interested and growing, while providing the greatest value to your company.

By Michael Reddy, Ph.D.

DATA INTEGRATION

Recreate Microsoft Access Tables in SQL Server DOWNLOAD

Here’s a tool that SQL Server has and Access doesn’t: The ability to generate SQL Scripts that can be used to recreate your table design in SQL Server -- or any other database server.

By Roger Carlson

ADVISOR TIPS

Display List of Colors on an ASP.NET Page

Use reflection to display a list of all the named colors in .NET.

By Ken Getz, technical editor

BOOK EXCERPT

What's New in IBM Lotus Notes/Domino 8 Development: Composite Applications

In this book excerpt, learn how Composite Applications change application design and the programming model.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

TECH NEWS

IBM WebSphere Portal 6.1 Features Web 2.0 Support

IBM also releasing three new accelerators for WebSphere Portal, and a lightweight version of Lotus Forms.

ADVISOR TIPS

Track FileMaker Pro Layouts with an Array

Whether you're a newbie or a FileMaker Pro guru, you'll undoubtedly have to provide scripted buttons to navigate through the plethora of layouts in your solution. Find out how.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR TIPS

Create a FileMaker Pro Folder

Learn how to create a directory or folder on the local hard drive from a FileMaker file natively.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

ADVISOR ANSWERS

Deploy Web Part Pages to a Microsoft SharePoint Site

Learn how to work with Features.

By Todd Baginski

AUDITING

Use Internal Auditing to Improve Processes

Make sure your company has the resources, systems, and processes in place for delivering efficient, effective, and secure operations.

By Dan Swanson, President and CEO, Dan Swanson & Associates

ADVISOR ANSWERS

Display a List of Enumerated Values on an ASP.NET Page

Here's how to display the list of enumerated values, let the user choose one, and then apply the value to the corresponding property.

By Ken Getz, technical editor
Welcome, subscribers of Advisor IT publications. You've been upgraded to DataBased Advisor. Sign-in now to get more than 10,000 articles, tips and downloads. If you don't yet have subscriber online access, click for instructions.

USER INTERFACE

Building Microsoft Access Menus Programmatically

Use the Office Commandbar object model to create menus on the fly.

By Ken Getz, technical editor

BOOK EXCERPT

IBM Lotus Notes Domino 8 Upgrader's Guide Chapter 9: What's New in Notes/Domino 8 Development

Learn about Composite Applications in this book excerpt.

By Tim Speed, Dick McCarrick, Barry Rosen, Bennie Gibson, Brad Schauf, David Byrd, and Joseph Anderson

ADVISOR TIPS

Create Multiple-Field Self-Building FileMaker Pro Value Lists

Have you ever found yourself creating essentially the same value list for two or more separate but similar fields? Use this tip to save some time in those cases.

By William Bombardier, Minneapolis, Minnesota

ADVISOR ANSWERS

Embed QuickTime Movies in a FileMaker Pro Database

Learn an alternative to the container field that lets you embed QuickTime movies in a database.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

APPLICATION DEVELOPMENT

Create a Natural Language Query Form in Microsoft Visual FoxPro DOWNLOAD

Integrate Microsoft English Query with your Visual FoxPro applications.

By Mike Lewis

ADVISOR ANSWERS

Building Path Names in .NET

Here's a more modern way to handle the backslashes in path names.

By Ken Getz, technical editor

VERSION CONTROL

Compare Versions of Your Source Code with the Click of a Button

When your program stops working, you need to know what you've changed. Here's a utility that will let you quickly compare the old and new versions of your code—or any text file—to find out what's different.

By Tom Anselmo

ADVISOR NEWS

IBM Lotus Symphony Beta for Linux

Free Linux software delivery service gives one-click download access to IBM Lotus Symphony 4 beta.

REPORTING

Complex FileMaker Pro Reporting? It All Depends! DOWNLOAD

Make reporting easier for users with this application of conditional value lists.

By Michael T. Rocharde

ADVISOR ANSWERS

Hide Items in a ASP.NET RadioButtonList Control

Here's a handy tip to de-clutter your lists.

By Ken Getz, technical editor

ADVISOR TIP

Solve Division Issue in IBM LotusScript

You might be a math whiz, but a LotusScript quirk could have you re-thinking arithmetic division.

By Bob Balaban, Advisor technical editor

MICROSOFT ACCESS DEVELOPMENT

Protect Your Work with Source Control and Access 2007

You've made a change to your application and, after much work, have realized that it's all been a horrible mistake. How do you get back to the working version?

By Peter Vogel, editor

ADVISOR TIPS

Using Activate Event to Requery Microsoft Access Forms

Here's another alternative to looping.

By Ken Getz, technical editor

IBM Lotus Expeditor Mobilizes Web 2.0

Sprint to use IBM Lotus Expeditor software to enhance mobile content for Windows Mobile 6 Smartphones.

VISUAL FOXPRO ADVISOR TIPS

Avoid an Outlook Properties Trap When Working from Visual FoxPro

Here's how to check for the SenderName property.

By Mike Lewis, contributing editor

USER INTERFACE

Get to Know Windows Presentation Foundation

Dive into Windows Presentation Foundation to prepare for the next generation of user interface design.

By Markus Egger

E-DISCOVERY

Beyond Litigation Preparedness:Telling Your System's Story

To have a litigation-ready system and electronically stored information in place is great, but you have to be able to convince the court of this early on in the process.

By John Jablonski, Esq., Goldberg Segalla LLP partner

FILEMAKER.PHP

Display FileMaker Pro Multi-Field Value Lists on the Web DOWNLOAD

Learn how to use the FileMaker API for PHP to build and display complex value lists

By Jonathan Stark, Jonathan Stark Consulting

ADVISOR NEWS

IBM SMash Technology Secures Web Mashups

IBM addressing Web 2.0 security issues, to include technology in Lotus Mashups.

ADVISOR ANSWERS

Use Reflection to Retrieve the Value of Any Control

Here's how to retrieve a specific property name on a control to get the natural value of the control.

By Ken Getz, technical editor

RISK MANAGEMENT

Best Practices for Enterprise Risk Management

A robust data environment is critical for a sustainable enterprise risk management effort.

By Dilip Krishna CFA, FRM, Teradata partner and head of risk management practice

WEB DEVELOPMENT

Understand Cascading Stylesheets in ASP.NET

Get to know this powerful client-side technology that lets you apply a consistent look and feel to an entire Web application.

By Paul D. Sheriff, contributing editor

DATABASE DEVELOPMENT

In-House and Consultant Developers Collaborate to Create Better Solutions

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

FILEMAKER PRO 9

Conditionally Format Layout Objects in FileMaker Pro 9 DOWNLOAD

Create better layouts and help users navigate your solutions by putting the conditional formatting feature to work.

By Paul T. Mitchell, Soliant Consulting technical lead

ADVISOR ANSWERS

Complex Multi-Column Publishing in FileMaker Pro DOWNLOAD

Discover a solution to a complex printing problem.

By Chris Moyer, The Moyer Group CEO and FileMaker Advisor technical editor, and Bob Bowers, Soliant Consulting CEO and FileMaker Advisor technical editor

MICROSOFT VISUAL FOXPRO

Reduce DECLARE-DLL Overhead in Visual FoxPro

Is it poor coding practice to use DECLARE commands to call Windows API functions?

By Mike Lewis, contributing editor

IBM Lotus Notes Mac Client 8.5 Alpha Version Debuts

IBM Lotus said one of the benefits of the new Eclipse UI was that it would offer better cross-platform support. The release of an alpha/preview version of Notes 8.5 for the Mac is IBM's attempt to prove it. Will those of us who have chosen Macs be forever in the feature backwaters of the Notes universe? Let's find out.

By Terrance A. Crow, Corporate One assistant vice president of technology and Advisor technical editor

MICROSOFT ACCESS USER INTERFACE

Let One Microsoft Access Report Do the Job of Many DOWNLOAD

Don’t overload your database with unnecessary reports, when one will do.

By Susan Sales Harkins

WEB DEVELOPMENT

Let Users Build Their Own Custom IBM Lotus Domino Web Menus DOWNLOAD

Learn how to implement a system for users to create and order their own Web menus, so they can navigate your site the best way for them.

By Terrance A. Crow, Corporate One assistant vice president of technology and Advisor technical editor

VISUAL FOXPRO ADVISOR TIPS

Maintain Transparency in GIF Images in Visual FoxPro

VFP has supported transparency in GIFs since version 6 -- but only for the Image control. Here's how to get around that.

By Mike Lewis, contributing editor

DATABASE DEVELOPMENT

In-House and Consultant Developers Collaborate to Create Better Solutions

In-house and consulting developers tend to be experts on different, complementary pieces of the software development picture. Learn how to bring these talents together to build more and better FileMaker Pro solutions.

By Michael Reddy, Ph.D.

APPLICATION INTEGRATION

Manage Your Contacts: Import vCards into FileMaker Pro DOWNLOAD

Are your contacts getting out of control? Find out how to get all the valuable information from your vCards into a FileMaker Pro database.

By Roger Jacques, Soliant Consulting

ADVISOR ANSWERS

Polish FileMaker Pro Solutions with Scripting

Want to spiff up a solution? Scripting is the answer. Find out how scripting can help your solutions look great.

By Lee Lukehart, Soliant Consulting director of training

Speed Up -- and Simplify -- FileMaker Pro Date and Time Searches

Learn some shortcuts that can have you finding just the right data with few keystrokes.

By Jason Mundok, IT Solutions Consulting project manager and FileMaker developer

VISUAL FOXPRO ADVISOR ANSWERS

Quality Complaints

For better or worse, paying attention to the details (or not) sends an important signal to your users.

By Christof Wollenhaupt, contributing editor

ADVISOR TIPS

FileMaker Pro Super Search

The super search is a method for quickly searching several fields without having to enter Find mode. Learn how to use it.

By Stuart Gripman, Crooked Arm Consulting founder and president, and Advisor Basics of FileMaker Pro technical editor

ADVISOR TIPS

Create a FileMaker Pro Folder

Learn how to create a directory or folder on the local hard drive from a FileMaker file natively.

By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Special Offer

Secrets Of The Top Experts -- Now!

See exactly how to do it, step-by-step, in Advisor Academy CDs created by the top experts. Click to see what you can learn right now.

AdvisorAcademy.com

Free E-Newsletters

Keep up! Hot News, How-To, Tips & Tricks, Expert Advice, and more. Click to request your's free.

AdvisorUpdate.info

Need Know-How Now?

What direction are you going with your business? Advisor Guides are packed with the answers you need to work smarter. Can you afford to fall behind?

AdvisorStore.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com

ADVISORAMA
The ego is the ugly little troll that lives underneath the bridge between your mind and your heart.
-- Dennis Miller

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2007 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, DataBased Advisor and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Website powered by LOTUS SOFTWARE
domino-144.advisor.com my.advisor.com 05/14/2008 03:22:28 PM