You are here: Advisor.com » Advisor Guides » DataBased.Advisor.com » 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 FileMaker Pro, and Law Technology, Compliance and E-Discovery, plus E-Business, Mobile Business, Security, and more. DataBased Advisor -- the business technology authority since 1983.
My.ADVISOR.com Sign-In
EXPERT ADVICE ON BUSINESS DATABASE, DEVELOPMENT & COLLABORATION TECHNOLOGY SINCE 1983
-- SUBSCRIBER NOTICE --
DATABASED.ADVISOR.com provides ALL of our business technology expert advice in one place. Subscribers of ALL ADVISOR, or DATABASED.ADVISOR.com, or any of the publications that were merged in 2007, can sign-in to My.ADVISOR.com to get EVERYTHING in all ADVISOR publications, estimated at more than 10,000 articles, tips and downloads, including all the new articles as they are published, plus everything in the ever-growing reference library. (Note: Our FileMaker-focused publications continue as separate subscriptions, or a subscription to DATABASED.ADVISOR.com includes ALL of our FileMaker content.) - Merger/Upgrade details - Subscriber online access instructions - Subscribe or renew
You can use Access' inline functions to manipulate and extract pieces of data from text fields in order to perform operations (such as sorting) on a part of the data instead of the entire field.
In this tip, and the following series of tips, you'll learn how to create your own application that lets users rotate and flip images. The first step? Creating an application that displays images.
Making changes to the data model of an existing application can be tricky, which is why it's important to think things through before you build your system. But, from time to time, business rules change and so must data models.
Let users save or cancel a record -- without requiring a gloal field for every field the user will enter and a script to set the global field to the regular fields.
Some things are easy to do in reports and impossible to do in queries -- unless you know how to use Access domain functions and SQL subqueries. With those tools you can do the impossible.
Field validation has been available in FileMaker Pro for a long time, but you've had very little control over the message and the buttons in the validation dialog. Script triggers change all that.
Users accostomed to working with spreadsheets often forget to hit the Tab key and instead type the Return key to go to the next field. Here's how to prevent the mess this creates.
The first thing you notice in FileMaker Pro’s new version is the updated and customizable status bar, but there are also a host of new and improved features that benefit users and developers alike.
Companies that take charge by proactively managing enterprise information reduce litigation risk, maintain compliance more efficiently, and save a bundle in the process.
Field validation is simply a way to instruct FileMaker Pro to check the contents of a field and alert the user when the data doesn't conform. Here are the basics.
When you're writing your custom message, be very careful and deliberate with your wording, or you could end up with an incomprehensible message that only confuses users.
You can make your applications more flexible by using reflection to dynamically choose the objects you will use at run time. And, for complete flexibility you can also pick the method to call at run time also.
Find mode was once nearly indistinguishable from Browse mode (where regular data entry is performed). See how FileMaker Pro 10 eliminates this potential confusion.
Values that have carriage returns in them get broken into separate values for the purposes of a value list. Here's a workaround that lets you use text blocks containing carriage returns as values in a value list.
Here's a formula that tests to see if a record belongs to the currently logged-on account, but also allows the full-access password to see all records.
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.
Often, data you want to import into FileMaker Pro comes to you in a format that is not conducive to the proper design of a database. Here's a parsing technique to speed things up.
By John Mark Osborne, Database Pros president and owner, and FileMaker Advisor technical editor
Companies that take charge by proactively managing enterprise information reduce litigation risk, maintain compliance more efficiently, and save a bundle in the process
Find mode was once nearly indistinguishable from Browse mode (where regular data entry is performed). See how FileMaker Pro 10 eliminates this potential confusion.
By Stuart Gripman, technical editor
ADVISORAMA
Lots of times, you have to pretend to join a parade in which you are not really interested in order to get where you are going.