Archive | FileMaker RSS feed for this section

Compress FileMaker Databases for Zip

4. December 2007

0 Comments

To give some zip to your lethargic FileMaker databases, routinely compress them. According to Claris, compressing should be performed every few weeks to increase speed and save in file size. One of my databases slimmed down from 488k to 323k with compression.

Continue reading...

Backup Databases

4. December 2007

0 Comments

For a backup of a large database, “Unsort” and then “Save”. It takes less disk space. Do not depend on this savings for your main or current file which you use. FileMaker constantly saves records PLUS where to find the records (or in what order). If you sort the file, it will grow in size [...]

Continue reading...

How Do I

4. December 2007

0 Comments

How do I

Continue reading...

FileMaker Pro Searches for Oddball Characters

4. December 2007

0 Comments

The new and improved FileMaker Pro 2.0 will finally search for oddball characters such as the commas, and Finds can include single- or multi-character wildcards. To search for a comma, conduct a Literal search. Choose Literal from the Symbols list and enter the text exactly — with any and all spaces. (To find a comma, the [...]

Continue reading...

Virtual Sock Drawer

4. December 2007

0 Comments

Publishing a FileMaker Pro 4.0 database to the Web? If you select a layout with related fields in it (via the Web Companion View Setup dialog), those related fields will appear when a Web looker peeks into your file. They can snoop into these related fields even if the related databases are protected with FileMaker’s access [...]

Continue reading...

Non-Printing FileMaker Fields

4. December 2007

0 Comments

To make a field non-printing, where do you think you’d look? Field format? No! The control is in Arrange… Slide Order…. Check the box at the bottom for “Do not print the selected objects.”

Continue reading...

Changing Databases

4. December 2007

0 Comments

Remember that whenever you work with any database program (such as FileMaker), changes are saved as you move from record to record. This is handy because you can’t lose too many changes, but it can also cause problems. Before you make any changes to a database, it is a good idea to save a backup version [...]

Continue reading...

Claris Font Problems

4. December 2007

0 Comments

Occasional problems crop up with fonts when you move a FileMaker Pro from one Mac to another. Try removing the Claris Fonts file and the Claris Temp file from the Claris Folder — that is inside your System Folder.

Continue reading...

Add/Duplicate FileMaker Fields

4. December 2007

0 Comments

When you’re working in layout mode in FileMaker Pro, you can add/duplicate fields by simply holding down the Option key and dragging an existing field. When you let go, it will bring up the Field List to choose from.

Continue reading...

Convert a Microsoft Excel Worksheet to a FileMaker Pro Database

1. April 2006

0 Comments

Do you have information stored in Microsoft Excel that you’d like to store in FileMaker Pro instead? As you get used to FileMaker Pro and see how useful it can be, there will be times when you realize you have information stored in other applications that you’d like to store in FileMaker Pro instead. A common [...]

Continue reading...