March 2010


After spending about a week putting together a significant database I ran into a glitch that astounded me.  I was creating envelope template when the program crashed.  When I restarted the program and went into my database, that I had been working on, the progam now asked for user name and password.  I had NOT set either.  It took quite some time but the trick is this.  Enter “Admin” for the user name and leave the password blank.  Do this now.  Put that user name and password (blank) into your computer Keychain application so you will remember.

Tip: Before you put in hours of time building a database, add one or more full access users to that database and record the logon some place that you will not forget. Filemaker Pro has two default users.  Only one is turned on, that being Admin.  Unless you set a password, you should be able to get in without using any logon.  But when Filemaker Pro crashes it might start asking for a logon.  It will NOT give you the words “Admin”.  It will probably default to your user name, you use to log into your computer.  You must remember that Admin is the default. I recommend that you put that logon into the Keychain if you have a Mac computer.    If you have a Windows machine, you might consider looking for some software that will guard important pin numbers, log on, account info, etc..  I like SplashID but there are a lot of similar products, some free.

Tip 2:  If you are going to start to tie down the database by requiring security log on, think about adding TWO ways into that database.  A lot of IT people have learned, the hard way, to always provide a back door to the house.

Another option: Activate Guest by checking the box in front of that account.  Then make sure you give “Full Access” to that account.  I would do this only for listing really unimportant data because anyone that gets to use your computer can view the data.

I use SplashID to keep all my secret information.  That program costs money.  If you have a Mac computer, try using Keychaina as it comes free with the Mac operating system.  You can find this application in Applications>Utilities>Keychain Access.app.

Program: Microsoft Excel 2008 for Mac.
Version: 12.2.3

Problem:  After entering in a formula the cell that contains the formula will still show the formula and NOT the result.  There are a number of causes for this problem.  One can be that you asked Excel to display an incompatible cell format.  Go to the cell or better yet the column you want your formula results to reside and click on the capital letter at the top of the column so as to select the WHOLE COLUMN (or single cell if that rocks your socks).  With the whole column selected (changes color) or single cell (changes color) you will then remove ALL formatting.  Next, go to Format at the top of the Excel screen and then choose “Cell…”.  Choose “General” as your cell format option.  Once you see the formula results begin to work, you can come back to this option and change it.

Now here is the trick or option that will stop you in your appreciation of Excel.  Hidden in the Excel main preferences is a toggle (turn on or off) to show formulas.  If you have show formulas checked (turned ON), you will ONLY see formulas and NOT the results.

Go to the top menu where it shows Excel.  Click on that word, top left corner.  A pop down menu offering will be displayed.  Choose “Preferences …”.  When you click on Preferences a large box will appear and give you mind numbing choices.  Don’t mess with anything but “View”.  Open View up and look to the top right column.  You should se the words (option) to “Show formulas” on (when check box has an X) or off when the box is not checked.  Make sure the box is UNCHECKED!

A really good time for you to turn “Show formulas” on is when you know you are seeing bad results  in one or more cells on the spread sheet and you suspect you screwed up one or more formulas.

Show Formulas

Show Formulas