Markpelleymounter

Members
  • Content count

    9
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Markpelleymounter

  • Rank
    member

Profile Information

  • Gender
    Not Telling

FIleMaker Profile

  • FM Application
    12 Advanced
  • Platform
    Windows 7
  • Skill Level
    Expert
  • Certification
    12
  • Membership
    TechNet
  1. Comment is correct in that a calc field using a case statement is the most effective and easiest way. Attached is a very small sample using the case statements to replace a dollar amount, and and summaried (as average) dollar amount as you wanted. Have a look at the field definitions via Manage Also, not fogetting that the calc needs to be set to unstorred in storage options. hth test dollar range.fmp12
  2. One posted to Brian Dunning's excellent repository of custom functions today: http://www.briandunning.com/cf/1757. You can then use the above custom function as a base for a calc field
  3. mac

    Is this an issue with the "/" and "" differences of files struture between Windows OS and Mac OS?? On a purely windows environment I do a very similair things with : Open URL {No dialog; "file:///W:/VendorDocs/"& VendorsID&".pdf"] where W is a shared drive. However, if trying to perform the same script on a Mac, I have to have the "/"'s replaced with ""'s
  4. pc

    Well, unfortunately, this problem has reared it's head again!. Suddenly gone back to being a blank list in Open Remote. This server is not listed and therefore non of the databases on teh server are showing. Open recent opens the files perfectly, and if I 'Add Favourite' and manualy type in the server address, the files are listed fine, but the Open Remote remains blank. The only thing that has been dones is that four pc's were moved to new ports on one of the switches, but there is no IP conflicts caused by these new pc's. Any other suggestions guys?
  5. pc

    As an update, the issue has now been resolved, admittedly through trial and error. I opened FileMaker Server Admin, and unticked then re-ticked 'List all databases' from within Config>Database Server>Security and saved the setting. Perhaps the shutdown and restart process did not properly re-load all the server settings.?
  6. pc

    Thanks for the suggestions. I have uninstalled and reinstalled Bonjour on both the server and clients pc's and the situation is still the same. Would Java versions possibly cause an issue? As for Firewall, all settings, switches etc are the same as they were before the physical moving of the sever.
  7. pc

    Good morning all, We are currently running FMS12 hosted on a Windows Server 2003. All clients are also windows users and are running FM12. Everything has been fine, then yesterday, due to an internal office move, we had to move the server to a new room. Everything was closed down properly and restarted correctly. However, the server is no longer showing in the Open Remote dialogue. Opening the file via 'Open Recent' works fine and the files open fine. I initally did a re-boot of the server and this corrected the issues and the Open Remote wokred last night, but this morning it is back to having an empty 'Open Remote' list. The server IP address and name has remained constant. Any suggestions?
  8. My 'guess' at the promblem is that you are saying (as per the table view screenshot), is that each timestamp is identical. It looks to me that these were set as an auto entered timestamp upon record creation. These are always going to be identical as they are just that.... a timesamp on record creation. Your different note fields are all on one single record. The way I would have done it would to have had each note as a seperate record, and have a field within the"Notes Table" called Notes Table::NoteType attached to the button that creates each note type would be set field step which would set the type to be 'Photo Note'. 'Initial Note' etc. Then you would filter each portal on the layout by this note type.
  9. Certainly finger print scanners can be tied into a FileMaker solution. Within FileMaker's Comunity website - 'Made for FileMaker' they feature a plug-in from Productive Computing : http://solutions.filemaker.com/made-for-filemaker/detail.jsp?id=solution.10000003579