Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Philland

  1. Philland

    Can't Open A Database;Error Message I've never seen

    Sorry I'm so late in responding. If you still need info, I believe the "privileges" issue is OS X based. You should try two things. Run Disk Utility / Repair Privileges on you OS X box (Applications/Utilies/Disk Utility). Take the file to a machine running OS 9 and FMP 6 and try to recover...
  2. Philland

    Effects of Memory Expansion of FM 6

    I don't think that memory expansion is gooing to give you much of a noticeable diiference, though it certainly won't hurt. You would probably be better off upgrading the hard drive to the fastest drive available if you haven't done that already and maybe cache memory. Phil Welsher
  3. Philland

    Password Protecting

    Okay then the short answer is yes, you can put a password on a button by using the Custom Dialog script step in the script for the button. You then have to create the validation for the password by adding an if/then statement after the dialog to compare the password used to a field containing...
  4. Philland

    Password Protecting

    Just one thing to add to Marty's explanation. If you have multiple users that will access each area, you can assign passwords to groups and then create your validation using If (Status(currentgroup) = "sales", . . . This way you can assign individual passwords, but maintain the...
  5. Philland

    How to use FileMaker Server 5.5 on a home network

    If you're using FileMaker Server, your databases don't need to be set for multi-user. The server software can be set for "enable sharing of single user files". Doing it this way prevents yo from accidentally sharing files if you open them outside the server environment. Your...
  6. Philland

    File Maker and Applescript

    on a Mac, Apple Script will capture keystrokes in the operating systems and you can execute an Apple Script from within Filemaker, but you need to use the FileMaker scripting for actions inside Filemaker. You can build a Filemaker script that performs functions in filemaker such as exporting...
  7. Philland

    best way to hide a field

    You should to create two groups (admin and production) and at minimum two passwords (admin and production). You will assign you production people to the production group with a password or individual passwords for each person and you will assign admin people to the admin group the same way...
  8. Philland

    Printing serial numbers on multipart forms

    I assume that you are talking about printing pre-collated, NCR type paper. Try making your page layout 22 inches deep instead of 11 and exactly duplicating all text and fields from the first 11 inches to the second 11 inches. Use your T-squares and graphic rulers to match the placement. This...
  9. Philland

    Advice needed...

    I certainly see no reason why you would not be able to do this with Filemaker Pro. Filemaker is more user friendly than Access. it seems like you should be able to do what you want using the predefinited calculation options with little trouble. I can't say what the best structure for doing...
  10. Philland

    How to alternate colors in list view?

    Okay, here it is; Create these three fields, 1) a global field of the type container <g_Stripe> 2) a calculation field set to &quot;Calculation result is Container&quot; <ContainerCalc> the calculation will be: If (Mod(Status(CurrentRecordNumber), 2) = 0, g_Stripe,&quot;&quot;) This...
  11. Philland

    How to alternate colors in list view?

    I will write you the basic fields and calcs you need for this over the weekend. I've just been a bit busy. Hope you can wait. Phil
  12. Philland

    Change the value for a Global field

    Changing a global field shouldn't be any different than changing any other field. I would double check your field definitions and confirm that this is properly inidicated as a global. If you have a copy of Filemaker Developer, check to see if this field is used in any scripts. Try this; In...
  13. Philland

    Opening Mac PC &quot;FMP&quot; file

    Paul, I believe he's trying to go Mac to Windows not Windows to Mac. Filemaker Pro 6 should give you an alert if the file is pre-FMP5 and ask if you want to convert to current, saving a new copy in a FMP 5 - 6 compatible format. I the correct extension for windows for a Filemaker Pro 5 or 6...
  14. Philland

    Change the value for a Global field

    I have multiple databases running on Filemaker Server and pretty much all of them use global fields to move data or maintain relationships between bases. The use of a global field with Filemaker Server should not, in and of itself, be a problem. Are there other users that may be setting the...
  15. Philland

    Finding Telephone Numbers

    Maybe I'm missing something here, but wouldn't the best long term solution be to create three separate telephone number fields so that the phone numbers can be segmented like your example 1 in all cases. This way your input is standardized so your searches become simpler. The fields would set...

Part and Inventory Search

Back
Top