BobWeaver

Moderators
  • Content count

    3,239
  • Joined

  • Last visited

Community Reputation

1 Neutral

About BobWeaver

  • Rank
    Token Fossil

Profile Information

  • Gender
    Male

FIleMaker Profile

  • FM Application
    9 Advanced
  • Platform
    Mac OS X Leopard
  • Skill Level
    Expert

Recent Profile Visitors

2,311 profile views
  1. Did a bit more googling, and found that Developer 7 will build runtimes for Win 2000 but not ME. Just showing my ignorance for Windows operating systems though, I had thought that Win ME was in the same family as Win 2000, but discovered that it was the last gasp in the Win 95/98 line. So, I'm not surprised that Developer 6 would be the last version to support these. So that answers my question. Thanks.
  2. Hmm, IIRC FM 7 came out in 2004? When did WinXP come out? I would have thought FM 7 would still be supporting Win2000 and ME.
  3. Could someone tell me what was the last version of FM Advanced/Developer that would create runtimes for Windows 2000 and Windows ME. Thanx.
  4. I assume that the hardware and system requirements for runtimes would be the same as for the regular Filemaker application. I'm not too conversant with Windows machines, and don't have much hardware to test things out with. However, it looks like there are still a lot of people using Windows 2000. The Filemaker Developer manual only says that the runtimes have been tested out on XP and Vista. Does anyone have any experience using runtimes created in FMA 9 on older systems? Likewise, on the Mac I believe the earliest compatible OS is 10.4.8.
  5. Good point. I think that answers the question.
  6. I guess I've finally found a use for that .005 point font. :laugh:
  7. Bottom of page 6 in the FMPA9_Developement.pdf manual.
  8. After reading that section, I don't see anything in it that waives the requirement for a phone number.
  9. Thanks I'll check that out. (Hmm, I see I need to update my profile.)
  10. I'm curious if anyone here has ever created a freeware runtime. If so, what did you do about the requirements to provide customer support? Obviously, when putting a runtime into the public domain, one shouldn't necessarily be expected to provide telephone support to anyone who wants to use the program the same way one would if it was a commercial application, but you are required by the Filemaker license agreement to do exactly that.
  11. Hi Larry, I tried to have a look, but your files are password protected. Question: I note from your accompanying text files that you have used a custom function. Is there an advantage to using a custom function other than saving time entering the formula in each table that needs to be audited? I've seen a number of audit trail solutions that use custom functions, but so far I haven't been able to determine what advantage they offer.
  12. Try this: Let ( [ trailingLetter = Right ( invoiceNumber ; 1 ) ; trailingLetterAsNumber = Position ( "abcdefghijklmnopqrstuvwxyz" ; trailingLetter ; 1 ; 1 ) ; trailingLetterPlusOne = trailingLetterAsNumber + 1 ; subsequentLetter = Middle ("abcdefghijklmnopqrstuvwxyza"; trailingLetterPlusOne );1 ] ; Left ( invoiceNumber ; 5 ) & subsequentLetter & " is the next invoice in this series." ) You still need to look after the situation where the current number ends in "Z", but this should get you going.
  13. You can either upload it here (using the "Manage Files" link), or if you prefer to keep the information private, check the related private topic that I started.
  14. Hi Karl, I don't think your first file will be much use unless you can figure out what the data means. Maybe some of the UK forum members can shed some light on it. However, the second file should work just fine as is. You just import it into the PostCode table. You won't have the city names; so just leave those fields blank. Also, you need to modify or delete the validation calculation on the targetPostCode field (in the areasearch table). After looking at the architecturalselect link that you posted, we need to clarify what you want to do. Do you want to find your customers that are within a target area, or do you want to find all postcodes that are within the target area? Or, do you want to do both? I have my example file set up to find customers, but an early test version that I made, simply found all postcodes within the area. The result portal was virtually identical to the sample screen in your link. Both functions can be easily implemented. To get it to find all postcodes, you simply use the same 4 parameter relationship that is currently set up between the areasearch table and the customer table. Implement that same relationship between the areasearch table and the postcode table, and that's it. In fact, there is no significant difference between the customer table and the postcode table. They are both lists of postcodes and lat/long coordinates. The only difference is that the customer table has a customer name field added. Assuming that you already have a database set up, and depending on the complexity, it may make more sense to modify your existing file rather than adapt my example file. To do this, I would simply add the postcode table and areasearch table to your existing file; add any missing fields, set up the relationships, and then import the post code data. Your customer table no doubt already has a postcode field, but you will also need the lat/long fields as well. You can populate these by doing a lookup from the postcode table. For new customer records, or when editing them, you can set up an autoenter formula that automatically adds or updates the coordinates whenever the postcode field is modified. My example file does this; you can refer to the field definitions and relationships to see how I did this. If you have more questions, let me know.