Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About john9210

  • Rank
  • Birthday 04/03/1935

Profile Information

  • Gender
  • Location
    Audubon PA

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

  1. How can I print field boundaries? I want to print boundaries on some fields for emphasis.
  2. Why setup a default printer? It seems that every time you print within a script the default changes to the one in the print step.
  3. FileMaker 17: To update records in table2, I want to import only the new records in table1 into table2. What’s the correct option to use in the Import script step: Add new records, Update existing records or Update matching records?
  4. I'm looking for a field calculation that will break a number into groups of 4 digits, each group separated by a space. The number can have 5 or more digits (say up to 16). For example: XXXXXXXXXXXXXXXX to XXXX XXXX XXXX XXXX
  5. Who wooda thunk! FM is not fully compatible with Windows Home 64 bit! I'll just have to live with it. It's hugh job to upgrade Window. All my program would have to be reloaded and most of my Windows and Program customizations would be lost. I've done this enough times to know not to do it unless absolutely necessary. Thanks for your help. Does FM have a patch?
  6. I like to see the page margins when working in layout mode. However, View page margins is always grayed out. This happens in all my FM 17 solutions, all layouts. How can I view page margins?
  7. I'm using a global script variable to display numbers on my layout. However, I would like it to display a zero when the result is zero. At the present time, it displays as a blank. Is there a way to do this?
  8. Excel and Filemaker calculates the difference between two dates differently. I always thought that when you subtract two date from one another, the result was the number of full days between the dates. For example: Calculate the difference between 1/15/19 – 1/9/19. There are 5 full days between these dates (10th, 11th, 12th, 13th, and 14th). However, FM and Excel calculations do not result in 5, and they don’t even agree with each other! In Excel, Difference = 7 In FM, Difference = 6 It seems that when you subtract two dates in Excel the result includes the starting and ending dates and therefore it is not the number full days between the dates. In FM the result seems to include either the starting or ending date (not both), and therefore it also is not the number of full days between the dates. What gives?
  9. Attached is a picture of the layout. Print margins are fixed: 12 pt (tob, btm; left and right). Print preview shows 2 pages. There are no other objects on the layout. Print Setup is set to landscape.
  10. Can anyone describe how to set up a layout for center fed #10 envelopes?😠 FM help says that after creating the layout you must verify margins and other settings before printing. How do you do that? I've tried everything I can think of, but the script print step prints 2 or 3 envelopes when the print dialog is set to 1 copy. I've tried adjusting the header and body dimensions (by guessing), I've tried deleting the header and keeping the body, I've even tried just keeping the header. Everything looks normal in Preview.
  11. This is a problem I frequently have. I can't custom format a date in the Inspector. I can't make a selection because the drop down menu becomes a long vertical blue stripe and selections are not available. I wonder if this is a FMP problem or a Windows 10 problem. Does any one else have the same problem?
  12. I have a flat file database with only one table. However, I cannot not delete records. I get the error "This operation cannot be performed because one or more required related tables are missing". However, I can create records, just can't delete them. Obviously, I don't have a related table.
  13. I'm looking for a script that will create a record for each Sunday in any given year, but I can't figure it out.
  • Create New...

Important Information

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