Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Vaughan last won the day on April 22

Vaughan had the most liked content!

About Vaughan

  • Birthday 03/30/1962

Profile Information

  • Slogan
    Mostly Harmless
  • Gender
  • Location
    Sydney, Australia

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Sierra, Win 10

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Vaughan's Achievements

Grand Master

Grand Master (14/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post
  • Collaborator

Recent Badges




Community Answers

  1. First get a backup copy of the database to play with, the optimum strategy will take some time to work out. Decide how you'd like to clean the data. For instance, should double-dots be replaced with a single dot or removed completely? Replacing double-dots to single would be Substitute( self ; ".." ; "." ) As for cleaning up the rest of the data, the easiest method is to replace the field contents with GetAsNumber( self ) which will take the data, interpret it as a number, and put that number back into the field. This will strip all non-numeric characters and spaces etc. You'll need to test it and see how it looks. "$4.60" will be replaced with "4.6" for instance.
  2. I have had a couple of small to medium clients become aware of their lack of security only when a staff member leaves and takes a copy of the clients (or even the whole database) with them.
  3. Do you have window zoom set to something other than 100%?
  4. What Matthew said: globals calculate differently when hosted. You need a preferences table to store the file path, not a global field.
  5. The scrolling issue sounds like software problems rather than file corruption. What version FMP are you using? If is anything less than FMP 10 then it's probably not compatible with your OS.
  6. Budget for a license of FileMaker Server and a dedicated box to use as the FMS host.
  7. I say it too. My reasoning is this: if the server goes down *unexpectedly* the files need to be checked. If you come in on Monday morning and the files are not available then you know the server went down some time over the weekend. If the server automatically opened them there is no clue that something has gone wrong. I do not want the server opening the (possibly damaged) files up and users going back in a doing work with them. If they went down then they stay down until somebody checks them, possibly restores the previous backups and opens them back up. Also of the server opens the files again then the backup schedules will run. This could possible delete the previous backups that you need to restore from.
  8. When weird things like this happen to me (typically users report that new records seem to be displaying old data in portals) it's because I've done an import or something and not updated the next serial numbers in primary key fields. Eg: in main table, next serial number is 101. Import 100 records process the data, create new primary keys, etc which now go up to 200. Forget to update the next serial number. User creates new record (pk=101) and it matches old data. So I'd start by checking all serial number key fields and making sure that they are not creating duplicate ehtries, or doing anything else unexpected.
  9. You cannot convert files from Bento to FMP, or FMP to Bento. Data entered into Bento can be imported into a FMP database, but that's not the same as "converting" the file: only re-using the data.
  10. The Get( WindowDesktopHeight ) and Get( WindowDesktopWidth ) functions will return something close to what you ask for, but what will you do with the information: have several different sets of layouts and switch between them based on whether the user has the dock on the bottom or top? You could I suppose, but it's be a HUGE amount of work to create and even MORE to maintain, and it still won't really solve the problem that there is an infinite variety of screen sizes and OS interface user preferences that the solution could run on, and for which you have no control. Any solution that uses applescript will not be cross-platform. The majority of FMP licenses are for Windows. Ultimately, the size and position of a solution's windows are under the control of the user, not the developer.
  11. Ultimately all you can do is design for the default sizes and positions of windows and OS widgets, or if you're keen, take into account the window size when the dock/taskbar is on the side rather than the bottom. If I want to make my task bar half the height of the window, there is nothing you (as developer) can do about it. Decide what the *smallest* screen your solution will support. For me it's Apple Macbook Pro 13 inch 1280 by 800. Make a test file with a layout and size this so the window just fits without the scroll bars appearing. Now move the dock to the side and resize the width of the window so it still fits. Load this same file onto a machine running Windows 7 (and/or 8) and resize the layout so it fits. Only make a dimension smaller, not larger. The resulting layout is now cross-platform.
  12. Preview mode only relates to FileMaker Pro. When accessing a database in IWP you're using a web browser.
  13. Create a calculation text field that is = the other field, and put this cal field on the layout. Allow entry into the field and users can scroll, select and copy the text but cannot edit it (because it's a calc field).
  14. Page scaling and the generic "any printer" option (and print to pdf) is standard on Mac OS X but not WindOS. The page scaling option is usually available in WindOS if the driver is Postscript, but PS drives are not always available and if they are they are usually not installed by default so it cannot be relied upon even for PS printers. To make the printing more portable, consider using only the intersection of A4 and US Letter as your design template, then use the auto-sizing feature to allow the objects to expand if there is more room (or let them centre themselves on the page). A4 = 210 x 297 mm US Letter = 216 x 279 mm US Legal = 216 x 355 mm A design template for a "safe" print layout should be 210x279 mm.
  15. That calculation looks good, and the error message also looks correct if the data being entered does not validate. So the question is, what data were you entering into the serial number field? The field should be of type number, not text. Finally, make sure that your FMP software is updated to the final patch version. That was 5.5v2 for Mac and 5.5v4 for Windows. To be honest I'm surprised that FMP 5.5 is working on 10.6 at all. Do not discount incompatibilities as the cause.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.