TECH NEWS

FM::Nexus InspectorLite for FileMaker Pro Solutions

Use this free tool to get an in-depth look at your solutions.

For all readers

TECH NEWS

FileMaker Office Optimizer Kit

Discover tools to help you integrate FileMaker Pro with Microsoft Office applications.

For all readers

TECH NEWS

FileMaker Web Viewer Charting Example Database

Add charts to your FileMaker Pro 8.5 solutions quickly and easily.

For all readers

APPLICATION INTEGRATION

Troubleshoot the IBM Lotus Connector for SAP Solutions

Find out how to leverage Domino and SAP skill sets to best handle integration issues with the two products in your enterprise.

By Scott Morris, IBM Lotus Enterprise Integration manager

For subscribers of IBM Lotus Advisor

ADMINISTRATION

Monitor GroupWise in a Minute

Learn how to use GroupWise Monitor to get timely and accurate monitoring and alerting.

By Eric Raff

For subscribers of Novell GroupWise Advisor

WEBSPHERE SOLUTIONS

IBM Support Assistant: Self-Help Tool that Accelerates Problem Resolution and Support Activities, Part 8

Learn how to work with the Service component.

By Rama Turaga, Owen Cline, and Peter Van Sickel

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

USER INTERFACE

Customize the SharePoint UI via JavaScript and Cascading Stylesheets

Avoid the complications of working with .aspx pages. Using JavaScript and Cascading Stylesheets to customize SharePoint sites is much easier -- and and improves site manageability.

By Mark Gerow

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

DEPLOYMENT

Use Inno Setup in Real-World Microsoft Visual FoxPro Application Installations

Get step-by-step instructions to configure Inno Setup for quick and easy application deployment.

By Doug Hennig

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR ANSWERS

Deploy Web Part Pages to a SharePoint Site

Learn how to work with Features.

By Todd Baginski

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

DATABASE DEVELOPMENT

Ensure Cross-Platform FileMaker Pro Development Success

The majority of your development effort will be cross-platform, but a small percent of items can really make your solution look bad. Learn how to proof your solutions before they hit the big time.

By Elizabeth Kinsella, Soliant Consulting technical lead and authorized trainer

For subscribers of FileMaker Advisor

APPLICATION DESIGN

Control the Flow of Message Box Text in Microsoft Access

Use print and display constants to force the flow of text to suit the message's intent and purpose.

By Susan Sales Harkins

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR ANSWERS

Fix JavaScript Error When Opening IBM Workplace Collaboration Services Calendar

Find out why you'd receive a JavaScript error saying Object doesn't support this property or method when you open a calendar in IBM Workplace Collaboration Services.

Compiled by Karen Gallo-Messore, IBM

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

REPORTING

Generate and Report on Scheduled Activities in Microsoft Access

Here's a tried and true way to get it done.

By Doug Steele

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

APPLICATION DESIGN

List and Change Display Modes in Microsoft Access

If a user doesn't have the screen set up correctly, you have two choices: Let your application look bad or change the screen's display mode. The ScreenInfo class will let you control your user's display.

By Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR ANSWERS

Rename an XML Element in Visual Basic 2005

Say you're working with XML using the XmlDocument class in Visual Basic 2005, and need to rename an existing XML element. Here's how to do it.

By Ken Getz, technical editor

For subscribers of Microsoft Pro Development Advisor or Microsoft Visual Basic .NET Advisor or Microsoft Visual Studio Advisor

TECH NEWS

IBM Lotus Sametime 7.5.1 Brings Video to IM

Point-to-point video, tabbed chat, and integration with Microsoft applications extends instant messaging into unified communications.

For all readers

TECH NEWS

IBM WebSphere Portal Express 6 for SMBs

Collaborative portal gives small and medium-sized businesses templates, tools to create portals quickly.

For all readers

PROCESS MANAGEMENT

Prevent Producing and Requesting Too Much

Here's how court decisions are answering the question: How much production is too much?

By Bethany Gabbert, Esq.

For all readers

FEDERAL RULES

Establish Safe Harbor Protection

Document all auditing, enforcement, and search and collection efforts for an effective chain of custody to establish safe harbor protection.

By John Patzakis, Guidance Software vice chairman and chief legal officer

For all readers

ADVISOR NEWS

Quickr: The Evolution of IBM Lotus QuickPlace

Support of open standards and Web 2.0 technologies expected to speed team collaboration.

For all readers

TECH NEWS

Lotus Connections: Social Software for Business from IBM

Integrated Web 2.0 tagging, blogging, and professional networking tools for the enterprise.

For all readers

TECH NEWS

IBM Lotus Notes and Domino 8 Brings Collaboration to the In Box

Public beta to include advanced usability features and new interface to manage information overload.

For all readers

WEBSPHERE SOLUTIONS

IBM Support Assistant: Self-Help Tool that Accelerates Problem Resolution and Support Activities, Part 7

Learn how to work with ThreadAnalyzer.

By Rama Turaga, Owen Cline, and Peter Van Sickel

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Back Up Your GroupWise System

Find the BEST way to back up your GroupWise system.

By Frank Gioffre

For subscribers of Novell GroupWise Advisor

ADVISOR TIPS

Ghosted and Unghosted Become Customized and Uncustomized in New SharePoint Versions

Find out how edited pages change in Windows SharePoint Services 3.0 and Microsoft Office SharePoint System 2007.

Compiled by Darrin Bishop, technical editor

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

ADVISOR ANSWERS

Take Advantage of the SharePoint ExecuteURL Element

Get to know this flexible feature.

By Todd Baginski

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

WEB DEVELOPMENT

Plot FileMaker Pro Locations on a Google Map

Learn how to build a dynamic Web page to generate and display a map with multiple locations.

By Brian Dunning, FileMaker Advisor technical editor

For subscribers of DataBased Advisor or FileMaker Advisor

ADVISOR TIPS

Send E-Mail from Instant Web Publishing in FileMaker Pro

Find out how to add e-mail capability to FileMaker Pro solutions you've Web-enabled with Instant Web Publishing.

By Scott Love, Soliant Consulting vice president and manager

For subscribers of DataBased Advisor or FileMaker Advisor

ADVISOR ANSWERS

Hide a Text Box in Microsoft Access

Here's a solution to a nagging problem in Access.

By Richard Campbell and Mike Groh, technical editors

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

DATABASE INTEGRATION

Use the LC LSX to Refresh a Table with IBM Lotus Notes Data

Learn how to completely repopulate a table in a relational database to reflect data in a Notes database.

By Michael Sobczak, Comerica Bank senior application developer

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Search XML Content with Namespaces

Working with namespaces can be tricky. Here's what you need to know.

By Ken Getz, technical editor

For subscribers of Microsoft Pro Development Advisor or Microsoft Visual Basic .NET Advisor or Microsoft Visual Studio Advisor

ADVISOR ANSWERS

Change a Default Printer Selection in Microsoft Access

Here's a quick and easy way to do it.

By Richard Campbell and Mike Groh, technical editors

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR ANSWERS

Restore Special Character in LDAP Directory Administrator Password with IBM Lotus Sametime

Find out how to retain special characters such as the @ symbol in the LDAP Directory Administrator password using the Sametime Web Administration interface.

Compiled by Karen Gallo-Messore, IBM

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Troubleshoot IBM Lotus Domino Directory Cataloger Task Issue

Find out why the Directory Cataloger task (Dircat) may fail to load certain .NSF files you've specified.

Compiled by Karen Gallo-Messore, IBM

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

LEGAL TECHNOLOGY

How IT Pros Can Help Lawyers with E-Discovery

Beyond adjustments lawyers must make to deal with the new rules, how do the amendments to the Federal Rules of Civil Procedure affect IT professionals?

By Kenneth A. Mendelson, Esq., Stroz Friedberg, LLC managing director and deputy general counsel

For all readers

ADVISOR NEWS

Can Mental Exercise Positively Affect Seniors' Thinking Skills?

A study shows that some benefits endured for up to five years.

For all readers

RESOURCE MANAGEMENT

The Emerging Role of Technology Counsel

The new federal rules are driving an uncharted level of cooperation between technical and legal forces.

By Daniel L. Pelc, Esq., Fios assistant technology counsel

For all readers

EVIDENCE MANAGEMENT

Use E-Mail Intelligence to Simplify Complex Investigations

Here's how one company successfully automated e-mail analysis for law firms and corporate counsel.

By Kamal Shah, Clearwell Systems, Inc., marketing vice president

For all readers

PERFORMANCE SOLUTIONS

Use Clustering to Maximize WAS-CE Uptime: Part 4

Learn how to lock down your WAS-CE cluster.

By Terrance A. Crow

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

AUTOMATION

Automate Microsoft Visual FoxPro

Build a VFP EXE without using the IDE.

By Rick Borup

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Automatically Back Up Your GroupWise Domain Database Daily

Get a copy of the wpdomain.db file immediately from up to seven days ago.

By Eric Raff, contributing editor

For subscribers of Novell GroupWise Advisor

FUNDAMENTALS

Inside the Microsoft SharePoint Administrator Utility

Make your SharePoint administration responsibilities easier by using the SharePoint administrator command-line utility.

By Asif Rehmani

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

ADVISOR TIPS

Disable List Items in Microsoft Visual FoxPro

Know your backslash!

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Print Files from Microsoft Visual FoxPro

Send ASCII files to the printer programmatically.

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

A Question of NULL Values in Microsoft Visual FoxPro

Solve a foreign key constraints problem.

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Set the Browser Title On a SharePoint Web Part Page

Unlike most pages in WSS or SPS, the new Web Part page does not display the page title in the browser title. Here's a workaround.

Compiled by Darrin Bishop, technical editor

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

ADVISOR TIPS

Hopping on the FileMaker Pro/PHP Bandwagon

PHP is easier to learn than XSLT, and is an open source way to get your FileMaker Pro data to a Web browser. Learn about the resources available to you for learning this popular language.

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

For subscribers of DataBased Advisor or FileMaker Advisor

ADMINISTRATION

Fine-Tune Debugging with Specialized IBM Lotus Domino Logging

Learn how to adjust your logs to collect the right information you need for your current troubleshooting task.

By Leslie Forbes, IBM staff software engineer

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Use the .NET Framework to Convert Relative Paths to Absolute Paths

There's a simple method that retrieves this information for you.

By Ken Getz, technical editor

For subscribers of Microsoft Pro Development Advisor or Microsoft Visual Basic .NET Advisor or Microsoft Visual Studio Advisor

ADVISOR ANSWERS

Learn What To Do When @@Identity Returns NULL in Microsoft SQL Server

Find out a solution to this mystifying problem.

By Richard Campbell and Mike Groh, technical editors

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Pro Development Advisor

ADVISOR TIPS

Execute a Microsoft Access Application from Visual Basic .NET

Here's a solution to a thorny problem in Access.

Compiled by Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR TIPS

Get the Most from Custom Collections in Microsoft Access

A reader points out a possible workaround to a problem when using custom collections in Access.

Compiled by Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR TIPS

Boost IBM Lotus Sametime 7.5 Productivity

Discover what you can do with the example plug-ins IBM provides in the Sametime SDK.

By Rob Novak, SNAPPs president and Lotus Advisor technical editor

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Understand the IBM Lotus Notes Move to Folder Action

Find out what might be happening if using the Move to Folder action doesn't remove documents from folders other than the Inbox.

Compiled by Karen Gallo-Messore, IBM

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Dynamically Cluster FileMaker Pro Records for Subsummarized Reporting

Find out how to solve this tricky reporting problem.

For subscribers of DataBased Advisor or FileMaker Advisor

PROGRAMMING

Beyond Comments: Writing Readable IBM Lotus Domino Code

Properly crafted code may take a little longer to write, but it results in applications that are easier to maintain and update. Find out how to get started.

By Rocky Oliver, IBM Lotus senior software engineer

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

FILEMAKER DEVELOPMENT

Duplicate a FileMaker Pro Record with Child Records

Learn how to take a Quote with line items and make it an Order with line items.

By Chad Adams, Digicutsystems senior developer

For subscribers of DataBased Advisor or FileMaker Advisor

WEBSPHERE SOLUTIONS

IBM Support Assistant: Self-Help Tool that Accelerates Problem Resolution and Support Activities, Part 6

Learn how to work with the IBM Guided Activity Assistant (IGAA) tool.

By Rama Turaga, Owen Cline, and Peter Van Sickel

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Use GroupWise to Access POP Accounts

Learn how to access the mailboxes of another client with GroupWise.

By Frank Gioffre

For subscribers of Novell GroupWise Advisor

ADVISOR ANSWERS

Microsoft Visual FoxPro Sedna, VFPX and VFPy

Find out about new and better VFP tools.

By Tamar Granor, Technical Editor

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Rushmore Optimization and Macro-Expansion in Microsoft Visual FoxPro

Here's how to take advantage of Rushmore Optimization in situations where you might not think it possible: using macro-expanded elements in the FOR clause.

By David Hodgson

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

STORAGE

Microsoft SQL Server and SharePoint Management Best Practices

Carefully managing your content databases is everything when it comes to sustaining the availability and growth of your SharePoint implementation. Here's where to start.

By Chris Fields

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

ADVISOR TIPS

And Buffering in Microsoft Visual FoxPro Doesn't Upset My Stomach...

Understand the hows and whens of buffering.

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Don't Try This At Home in Microsoft Visual FoxPro: O-O No-No!

Here's code you have to see to believe!

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Hide SharePoint Documents After Seven Days

Here are two tricks for when you need to display documents for only a certain number of days.

Compiled by Darrin Bishop, technical editor

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

ADVISOR ANSWERS

Remove IBM Lotus Domino Archive Transaction Logs

Occasionally (typically after a server crash or backup application problem), Domino doesn't delete or reuse archive-style transaction logs (.txn files). Find out how you can clean up these files.

Compiled by Karen Gallo-Messore, IBM

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ACCESS DEVELOPMENT

Determine the User's Screen Characteristics in Microsoft Access

The first step in managing the user's display is finding out what settings are in effect. Here's a class to get that information for you, along with the underlying Windows' API calls if you want to do it yourself.

By Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

REPORTING

Use the Report Manager to Handle All Your Microsoft Access Reports

If you find yourself extending applications with new reports, Report Manager will make your life easier. With Report Manager, you can add a new report without writing a line of code.

By Peter Vogel, technical managing editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

REPORTING

Change Report Grouping and Sorting Dynamically in Microsoft Access

You can build a single report that supports multiple users just by letting your users change the report's sorting and grouping levels dynamically from code.

By Alex Dybenko and Doug Steele

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

APPLICATION DESIGN

Create Multi-Select Checklist Forms for Better Processing in Microsoft Access

Sometimes, letting your use select just one choice isn't enough. Here's how to create a checklist form with all the features of a multi-select list box to let your users choose multiple records for processing

By Christopher Weber

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

APPLICATION DESIGN

Let Users Know What's Going On with the Status Control in Microsoft Access

You just can't provide your users with enough feedback. Using the ActiveX StatusBar control lets you display more information more effectively than the default Access function.

By Doug Steele

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

MACINTOSH

Get to Know the IBM Lotus Notes 7.02 for Mac OS X

Discover the features -- and limitations -- of the newest Notes client for the Macintosh platform.

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

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Calculate Days until Next Birthdate in the .NET Framework

This task isn't hard to figure out in VB6, but what if you need code for use in both Visual Basic 2005 and in C#?

By Ken Getz, technical editor

For subscribers of Microsoft Pro Development Advisor or Microsoft Visual Basic .NET Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Microsoft Visual FoxPro O-O No-No! Revisited

Here is an amendment to my tip on using objects in PRGs.

By Ceil Silver

For all readers

ADVISOR TIPS

Set a Microsoft SharePoint Alert for New Sites

Here's how to subscribe to Site Directory alerts.

Compiled by Darrin Bishop, technical editor

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

MESSAGING

E-Mail Management Best Practices

Set up your GroupWise system and backups so you can more easily find specific messages.

For subscribers of Novell GroupWise Advisor

INNOVATIVE SOLUTIONS

Integrate IBM Rational Application Developer 6 With a Windows Installation Bundle Generation: Part 3

Create a Window.exe file for a Java program using free software.

By Andrejus Chaliapinas

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ACCESS DEVELOPMENT

Understand Multivalued Fields in Microsoft Access 2007

Take advantage of this new feature in Access 2007 to create validated combo boxes and list boxes where you can choose from more than one value.

By Joe Stockman

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

FILEMAKER DEVELOPMENT

Supercharge Your FileMaker Pro Tooltips

Use these techniques and ideas to reveal additional information conditionally, based on user preference, privilege level, or other database settings.

By Lee Lukehart, Soliant Consulting director of training

For subscribers of DataBased Advisor or FileMaker Advisor

DEPLOYMENT

Deploy Microsoft Visual FoxPro Applications Smoothly With Inno Setup

Learn how to use a free installation tool that provides fast deployment, easy uninstalls, and a better user experience with your applications.

By Doug Hennig

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

View Unsaved Changes in Microsoft Visual FoxPro

Use a SQL Select statement that reflects data as it currently appears in the buffers.

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Fix Truncated Report Items in Microsoft Visual FoxPro

Cure punctuation vexation.

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

ADVISOR TIPS

Debug in Microsoft Visual FoxPro with _ClipText

Get debugging help!

Compiled by Ceil Silver

For subscribers of DataBased Advisor or Microsoft Pro Development Advisor or Microsoft Visual FoxPro Advisor or Microsoft Visual Studio Advisor

WEB DEVELOPMENT

Create Branching Microsoft SharePoint Surveys

Here's how to create sophisticated surveys that take users to different questions, depending on their answers.

By S.S. Ahmed

For subscribers of Microsoft Office Advisor or Microsoft Pro Development Advisor or Microsoft SharePoint Advisor

WEB DEVELOPMENT

Use AJAX to Build DHTML Web Views in IBM Lotus Domino

Find out how to use Asynchronous JavaScript And XML (AJAX) to build faster dynamic Web views in Domino.

By Scott Good, Teamwork Solutions president and co-founder and Lotus Advisor technical editor

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Edit Fields in a Controlled Access Section in an IBM Lotus Domino Form

If you're unable to edit fields in the controlled access section of a Domino form, even though your user name is assigned to that role, this tip will help.

By Karen Gallo-Messore

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR ANSWERS

Differentiate IBM Lotus Notes Hotspots and Doclinks

Find out what to do if you want to check documents for link hotspots, but not doclinks.

By Karen Gallo-Messore

For subscribers of IBM Lotus Advisor or IBM WebSphere Advisor

ADVISOR TIPS

Get a Handle on Data Scrambling in Microsoft SQL Server 7.0

Here's something to watch out for when working with Access 2000 and SQL Server 7.0

Compiled by Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR INTERVIEW

IBM's Mike Rhodin on The Future of Lotus

ADVISOR talked with Lotus General Manager Mike Rhodin about what's coming soon from IBM, and how he sees Lotus software evolving and improving. Here's what he had to say.

Interviewed by Liz Novak, Lotus Advisor managing editor

For all readers

ACCESS DEVELOPMENT

Handle Complex Formatting and Sorting in Microsoft Access with Query Expressions

Access doesn't offer a built-in solution for every sorting and formatting requirement. To get the fastest performance to a variety of common problems, use an expression in your underlying query.

By Susan Sales Harkins

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

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

For subscribers of Microsoft Pro Development Advisor or Microsoft Visual Basic .NET Advisor or Microsoft Visual Studio Advisor

BOOK CHAPTER

IBM Lotus Notes Developer's Toolbox: Reference Library Applications

In this book chapter, you will learn about Reference Library applications and walk through two example applications.

By Mark Elliott

For all readers

ADVISOR TIPS

Track Procedure Names in Error Handlers in Microsoft Access

Here's a quick trick to solve a nagging problem.

Compiled by Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

ADVISOR TIPS

Work Around the Outlook Security Patch in Microsoft Access

Here's a solution to a nagging problem when using Outlook to send e-mail automatically.

Compiled by Ken Getz, technical editor

For subscribers of DataBased Advisor or Microsoft Access Advisor or Microsoft Office Advisor or Microsoft Pro Development Advisor

DATABASE

Format FileMaker Fields Like a Pro

Ensure everyone enters data consistently, and provide some versatile ways to work with FileMaker Pro.

By Mary Conohan, School Base senior developer

For subscribers of DataBased Advisor or FileMaker Pro Advisor Basics

DATABASE DEVELOPMENT

Create Smarter FileMaker Pro Databases with Relationships

Find out how to use relationships to make your database more flexible.

By Geoff Coffey

For subscribers of DataBased Advisor or FileMaker Pro Advisor Basics

SCRIPTING

S.C.R.I.P.T: Simplify Complex or Repetitive labor-Intensive Processes and Tasks in FileMaker Pro

Learn how to use scripts to simplify complex tasks with one click.

By Paul T. Mitchell, Soliant Consulting technical manager

For subscribers of DataBased Advisor or FileMaker Pro Advisor Basics

ADVISOR TIPS

Get to Know Layout Mode in FileMaker Pro

Compiled by Stuart Gripman, Crooked Arm Consulting

For subscribers of DataBased Advisor or FileMaker Pro Advisor Basics

REPORTING

Create Great FileMaker Pro Summary Reports

Discover the secrets behind summarizing database information.

By Maria Langer, technical editor

For subscribers of DataBased Advisor or FileMaker Pro Advisor Basics

TECH NEWS

IBM Lotus Notes 7.0.2 for Mac OS X

Upgrade for Mac users integrates Lotus Sametime Instant Messaging features and Web 2.0 technology.

For all readers