Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FileMaker Pro v7 – v11

These are discussions for the legacy version of filemaker 7 - 11 with the extension of .fp7
 

  1. Started by malagasy,

    When I run my script to save as a PDF, I am able to click on the button 2 or 3 times before Filemaker crashes and close. I have ran the Debug script and it seems like it comes from the Save as a PDF. The message I get when the application close is related to a dli_dll.dll file problem. Has this problem happened to anyone else? What can I do to solve the issue ? It really slow down my work and need to find a solution.

    • 2 replies
    • 1.2k views
  2. Started by Genx,

    Is Windows XP Home SP2 no longer supported?

  3. Started by tesfa,

    Hello Fellow Filemaker developers. Tesfa Clacken here from Putumayo World Music and I have been updating all our databases from 5.0 to 8.5. And I have an issue and would be greatful for an answer. We have a database thats not letting us enter new records, when I press 'cntrl + n' or even when I select it from the menu it brings up a blank page and after I complete entering the new info and go to add another record it gives me this warning message, well actually its blank but has two options "Revert Record" or "Cancel" Whats causing this? I've checked my scripts, tried it on various computers, turned sharing on, turned sharing off. Nothing Works and i…

    • 4 replies
    • 1.2k views
  4. Started by Kent Searight,

    Can anyone suggest a book on FileMaker 7, 8, or 8.5 that's in Japanese? Thanks in advance!

  5. Started by greger,

    Hi, I need to buy full versions of FileMaker 8.5 Any ideas where I can get a good deal? I have been looking at the current Workgroup Bundle from FileMaker store at $2930. The only problem is that you need to live in the US to get this price. In Europe the price is 50% higher.

    • 1 reply
    • 1.1k views
  6. Hi Folks, Two related questions... I'm new to Filemaker and am creating an events/contact management database. For peoples' contact information I'd like to use value list for state, city, and country. Question 1: Does anyone have predefined value list of the above they are willing to share? I know this is all online but it's very time consuming to copy and paste hundreds of entries into FM. Question 2: How do you make these value list conditional so when, say, NY is selected the correct cities display? Thanks.

    • 1 reply
    • 2.7k views
  7. Started by gorkface,

    This may not be the right forum for this question. I keep records of bills for my business in FM7 on a Mac using OS 10.4 For some reason about 170 of my records in a file of about 500 records are missing. I'm sure I didn't inadvertantly delete them, nor are they omitted. Is there any way to fix a file like this or do I have to restore everything from paper backups?

  8. Hi, I'm finally going to version 8.5. I bought advanced this time ( I did not have developer in the past). While reading about conversions, on the filemaker site it is written that "files should be recovered and then compressed before conversion to version 7 and higher". That is big news to me as I was always told that recovers are to be avoided but in dire circonstances. My question is the following: should I then recover and compress with my 8.5 advanced in the old format ( i.e. .fp5 format) and then convert so as to have the advantage of having the developer report of the old version handy? Thanks and Merry Christmas to all! -) Luc ps as I …

    • 2 replies
    • 1.2k views
  9. Started by bdonelson,

    Is anyone else having a problem with multiple screen redraws. After searching on this topic, I found that it is related to having overlapping and/or grouped objects. But, it only started after upgrading to 8.5.

    • 4 replies
    • 1.5k views
  10. Started by Database Designs,

    What do I need to run FileMaker 8.5 on a Linux machine?

  11. Started by Eliz309,

    I am currently running a FM6Pro database with 8 users sharing the files over the network. We have recently upgraded our network and I will now need to add 3 remote users who will connect using the terminal server. I don't know anything about this stuff and my knowledge of filemaker is limited. My questions are: 1. Where is the optimal place for the files to reside (server, terminal server, should it be on its own machine) 2. Should the answer to #1 also be the host? 3. What versions of Filemaker do we need to upgrade to in order to have 8 local users and 3 remote users? Any help is greatly appreciated.

    • 0 replies
    • 1.1k views
  12. Started by montlewis,

    Hi, I have a 8.5v1 database that has this weird issue that I've never seen before. In one of the tables, when I do a search on a particular ID, I always get a blank record as one of the records in the search results. If I delete that record, do the search again, it reappears. If I view all records in the table, there are no blank records. It's messing up my scripting and I'm at a loss to figure out how to handle it. Has anyone seen this type of behavior before? Thank for your help, Monty Lewis

    • 4 replies
    • 2.6k views
  13. Started by Kent Searight,

    Hi all, Does anyone know of a way to create page breaks in reports dynamically? Specifically, I'm trying to generate a multi-page report that's made of one, multi-page-spanning field, whose contents vary greatly in length. After calculating the page count, I'd like my script to set more data at the end of the text field and have it start at the top of what would be the next page. I'll have to repeat this for a third section. To help understand my goal, the text field is for compiling legal agreements by combining canned text with variable data that's entered via the GUI in another layout. Many of these agreements require schedules and exhibits accompanying them.…

    • 1 reply
    • 1.1k views
  14. Started by Hugh2,

    I have recently upgraded to v8.5 Advanced and am experiencing some weird behavior on my layouts. When I add a field I cannot see it (although it is there, I can see the field label). When I set borders I cannot see them. I cannot see the handles when the field is selected. In Browse Mode I cannot see the cursor when I enter the field and I cannot see text as I type. But when I click out of the field the text appears. I have been using FileMaker since v2 and have never experienced this sort of behavior. Any thoughts?

  15. Started by kevs,

    I have one field for client name where every key I enter, types in a weird symbol. same thing, can I do anything? thanks.

    • 5 replies
    • 1.4k views
  16. Started by omegagoh,

    Dear All, I used to have a set of FileMaker buttons possibly downloaded from Blue World (now call omnipilot). Unfortunately, my hard disk crashed and I lost it. This set of buttons is for FileMaker 4.x but it was so well done that I still see it in a number of FM6 solutions. Just wander if anyone have a copy to share? I would also welcome other good theme buttons and layout designs if any. Thanks

  17. Started by savager1,

    Hello, Sorry if this is the wrong place to post, but I thought this would be an ok place to post. OK, so a couple of years ago (say 6plus) I used Filemaker in my then new job. I was blown away then by the things that were possible in FM. Anyway, I have recently decided to start trying to develop some databases (have had a bad motorcycle accident) so whilst not working full time on my real job, I thought I would try to learn FM more and see if I could eventually become a freelance developer or even just develop in my spare time. So, my question is what's the best way to get experience. It's hard coming up with solutions without a real need. So, for example…

    • 1 reply
    • 1.1k views
  18. Started by Printery,

    I gave a friend a program for his music (FM 8 Advance). After 200 entries or so the program crash or won't accept anymore data. Is not the first time I have this complaint. He had plenty of RAM and H.D. space to work it. This never happens while using FM 6. What can I do to prevent this?

    • 3 replies
    • 1.2k views
  19. Started by Daryl,

    Is there anyway to lock a record? I would like to be able to make a specific record uneditable given a setting in a field. For example: I have a checkbox field called "lock record" set to a boolean value and if it is set to yes, I don't want the rest of the fields on the specific record to be edited. Is this possible? Thanks, Daryl

  20. Started by Anders Stockholm,

    Goodevening from Sweden. 7.45 PM Tips, www-links about FileMaker applications which are integrated with geographic information systems like ESRI ArcView or ArcInfo, MapInfo, Intergraph GeoMedia. Thanks and Regards from Anders Söderman

  21. Started by SueH,

    I am new to this board and hope I am posting properly. Does anyone know if it is possible to load 2 versions of FM on the same computer? I maintain an older version for a client, and now have another client who wants me to do the same - but with a current version. Many thanks

    • 13 replies
    • 6.4k views
  22. Started by kevs,

    I'm using a FM form provide by a photo group, so I don't have lot of control, but check this out: http://img201.imageshack.us/img201/641/picture1hj4.png the text , it prints ok, but looks like hell on my screen. Can I do anything? also: I have one field for client name where every key I enter, types in a weird symbol. same thing, can I do anything? thanks.

    • 10 replies
    • 1.9k views
  23. Started by jasonwood,

    I'm in search of a complete list of features (script steps, functions, etc.) added since version 7. Is there such a thing? Bonus if it shows in what version it was introduced. Two separate lists for 8 and 8.5 would be fine too.

  24. Started by Drew Sanderson,

    Where on my hard drive would I find the filemaker help files? Mac 10.4 Thanks

    • 5 replies
    • 1.2k views
  25. Started by Printery,

    I have no problem with FM8 in my PC. Although my files are small. Another friend send me the following error: Microsoft inform that there is a problem with the program. Microsoft? Then is goes the Error Signature: AppName: Filemakerpro.exe Appver: 8.0.1.295 Modname:Unknown Modver: 0.0.0.0 Offset: 000o01/9 This is the second friend that report the same problems. Did I get a bad, or fake copy? Version 8, WindowsXP

    • 8 replies
    • 1.4k views
  26. Started by Rich in SLC,

    Is there a way, perhaps with a utility, that I can export records WITH container fields (in this case pictures) to an HTML table. FMP export to an HTML table does not allow for container fields.

  27. Started by Raybaudi,

    Hi all Does someone know about this argument ? The lonely thing that I know is that IT exists !

  28. Started by robyt,

    hello, I need to use native windows font in a layout of fm 8.0 for automate a faxing procedure. I know fm use only true type font, so I'm looking for a plug-in or a way to by-pass the problem bye roby

    • 0 replies
    • 756 views
  29. Started by scchang,

    I'm looking for a way to calculate the elapsed time in minutes when a start time and end time are entered. For instance, entering 11:15 start and 12:17 end returns 62 (minutes). Any help appreciated in solving this. Thanks

  30. Started by Zero Tolerence,

    One of the most recent Windows XP security updates has broken FM 8-FM 8.5 runtimes. (It might affect more those are just the only ones I have to try). The application will launch once, and then quit running the next time they try and launch it. As of right now I have only found one way to fix this issue: 1) Moved all the runtime dll's to the system32 folder. 2) deleted msvcp71.dll and msvcr71.dll from the runtime because there is one in the system32 folder 3) Changed the program compatablities to run as a Windows 98 and input settings box checked. 4) Turn off advanced attributes for "file is ready for archiving" and "for fast searching" This seems to…

  31. :P I need to have FMP automatically delete duplicate records down to a specific field when generating a report! My database has field like division, department, goal, objective, tasks... When I generate a report that tells a division each objective it has, there are many duplications because there is a record for each task (which may be 4 to 6 under each objective) I can clean these manually but there must be a way to auto delete duplications at the objective field level for this report!?

  32. Hi, I've a fille names AAAA.fp7 which my development file For upgarding the solution I need to import it's previous version also named AAAA.fp7 (that's the source fie) but which is located in another folder. If I open the dev file, The window name is AAAA, and if I open simultaneously the source file, it's window is named AAAA -2 I want to get the next serial value of the source file to put in my dev file. My script is in my dev file. How can I get the source file next serial value, because the GetNextSerialValue requires a filename, which is the same for both files here. GetNextSerialValue(fileName;fieldName)

  33. Started by life036,

    Hey Everyone, I've got an issue trying to upgrade my FileMaker Pro 8.5v1 installation to 8.5v2. Everytime I try to run the installer, it tells me "The updater cannot find a qualifying product on the system." The funny thing is, I get the same problem on my work computer, and my home computer (PCs). To make that even funnier (although, strangely enough, I'm not laughing), I get the same problems on my FileMaker Server 7, and Server 8 computers (WinServer 2003). I even used to get an upgrade error on my FM Server 5.5 on Macintosh, although I fixed that one already. Anybody know what the heck is going on, and why I seem to be the only guy that has this prob…

  34. Started by Sykes,

    Has anyone ever come across any virii that effects Filemaker? Say one that "eats" layouts? Recently a layout developed a weird graphical glitch in which a small amount of pixelization began just over a button, it looked kind of like static building up until it had "eaten away" the button leaving a blue square. It spread and eventually ate the entire layout, I quickly duplicated the layout and the duplicate is fine but the origional is just a blank page now. This was extremly weird and I had never seen anything like it. I am on WinXP so it could have been a virus, but my anit-virus displays nothing and nothing else seems to have been effected. Has anyone ev…

  35. Started by Zero Tolerence,

    I've came across a problem. Every computer in our company that Runs IE7 cannot keep filemaker open. It opens once, and runs fine, but if the minimize it, or shut if off, it will never open again. (Until you reboot, then the same thing happens.) This seems to have happened as soon as we upgraded to IE7. Anyone else have this issue? Anyone else willing to give it a try so we can make absolutley positive thats the issue? It only happens with a runtime.

  36. Started by stuj1026,

    We have run into this problem since version 7 of FM. We are running windows XP machines and when we close FM and then come back later and try to start it again , most of the time we need to go into the task manager and stop the filemaker which is still running as a process., This is happenning on about 10 machines. Anyone have a solution or has anyone experianced this problem? Thanks Stu

  37. Started by dvalley,

    I have had this annoyance since we first started using FM7. Our company lists chemical names in many of our databases. These are not covered by the spell check dictionaries and show up as underlined. I have tried to turn off the spell check feature in the file options tab, but it always turns itself back on the next time I launch the application. Is there a way to turn it off once and for all?

    • 2 replies
    • 1.7k views
  38. Started by djlane,

    Is there an FM8 function which will allow me to move back to the previous window? ie. to be able to go to the last / previous active window, without having to specify that previous window by name. Something like the "Back" button in Internet Explorer. I can do it by having a separate table called "last window name" to hold the name of the current window before navigating to the second window, thus allowing me to go back to window I last came from. But this is tedious. Is there a simpler way? thanks

  39. Started by jone123,

    I have experienced problems printing large found sets in 8V5. When printing from a complex layout, ie Body,summary, sub-summary, trailing grand summary, etc, and the found set is greater than 300 (we sometimes have found sets on the order of 1200) FM 8v5 will get through printing some of the records and then the layout goes squirrely and garbled and the pages start printing blank. I have updated the drivers, tried 3 different printers, HP9000;HP8100;HP4050 and all do the same thing. This used to work fine on FM6.0. We stepped back through the versions of 8 and have found that the problem does not occur on 8v1 so we currently do our printing from a PC with 8v1 installe…

    • 3 replies
    • 1.5k views
  40. Started by Exceptions,

    Hi all. Just got the disc, and have a big problem. The installer app shows up as a document, and no amount of digging into the file settings or the package contents have helped. Granted it's a Carbon app and I can't remember what's what with the file bits, but I've tried quite a bit of futzing with Xray. I tried making a new admin account (advice of the FM phone tech) - no luck. Full perms fixup - no luck. Fixup of the Installer Vise app inside the package - no luck. Like I said, I'm a little lost with a Carbon app, but frankly the Info bits seem munged up to me. Any help appreciated!!

  41. Started by nosteele,

    I have used FM for some years but by no means can claim to be anything but a novice user, I just open the program and use the existing databases so I hope I can make my problem clear. A couple of times this week when I have opened two different FM databases I have received a screen prompting me to define the database. I have never had to do this before so I responded by "cancel" to find to no data in the DB. Fortunately our data is backed up nightly so I am able to recover the missing data. My questions are: what would cause FM to prompt me to define an existing 8 year old database that has worked with no problems? Do I really need to define the data…

    • 2 replies
    • 1.3k views
  42. Hi all, Is it possible to have the login dialog open with the Guest radio button selected? Thanks in advance!

  43. Started by johnrh,

    is it possible to automatically resize the actual filemaker window from inside filemaker. I am working on a runtime solution and really need the program window to be maximised but out to the size of the filemaker window which I need set to be set to 900 x 680

    • 2 replies
    • 2.2k views
  44. Started by tm1274,

    Is it possible to completely remove access to the layout browser completely. I know I can close the status area before I create a standalone database but the user would still have access to the different layouts through the menu at the lower left hand side where the zoom menu is located. Can anyone tell me if that area can be removed or stop access to the layouts through it?

  45. Started by mcyrulik,

    We had a problem with a user being disconnected from the FM server randomly(or so we thought). We tested just about everyting, network cables, switches, gave her a new Mac... still got disconnected. She is on the latest client (8.5), and our server is updated (8.0v4) and still we couldn't figure it out. Then we noticed that the time on her computer was way off (for invoicing she changes the date on her computer so that the invoices end up in the correct month for accounting), and that she only gets disconnected during the times she sets her clock back. So, is there some sort of check that the FM server or client does to make sure that the times are within a certain…

    • 2 replies
    • 950 views
  46. Started by EZ,

    Hi Folks, I am considering the use of Filemaker for an internal database for an organization of about 5 people. One of their concerns is the interoperability of filemaker with open source document formats such as Open Office. I think their main concern is that filemaker will work with other systems they have in place, open source or commercial. Too boot, they wanted to know if there is any other open source database software comparable to filemaker. I'm familiar with filemaker but on these two issues a bit lost. Can anyone shed some light on this or at least point me in the right direction to ask. Filemaker wasn't able to answer these questions. Thanks!

    • 2 replies
    • 947 views
  47. Hi everyone, I'm working with a database solution here at work where we track a lot of client data. We have a request file that gives us a list of clients who have requested our product. This table, with data entered by import, now contains nearly .5 Million records. Then, we have another table in the same file, that contains records showing how we processed those requests. This table also contains nearly .5 Million records and should, in theory, have the same number of records as in the request file. There are also other tables that contain smaller numbers of records used to help wrangle the data between these two primary tables. All totalled, we have somewhere slig…

    • 5 replies
    • 1.2k views
  48. Started by RMCMA,

    Hello, I'm new here. I did do a search but couldn't seem to find what I'm looking for. We just bought the upgrade (6 to 8.5) but can't seem to find the cdkey for our old version. Someone took it off the old packaging. Is there a way to divine it from the install on my computer?

    • 3 replies
    • 990 views
  49. Started by El_Pablo,

    Hi, I noticed that FMP 8.0 use a lot of CPU. When it is idle with no files opened, FM takes around 30%+ and when a file is open the percentage jumps to 70%. Is that normal? Even an image processing software on idle does not take 20%.

    • 0 replies
    • 796 views
  50. Started by cmack,

    I have a file that I converted a while ago and I have been using it without a problem. All of a sudden I can't import or get to Define-->database without FM hanging and causing a force quit. I also converted the original file again and it does the same thing. The original was in FM6. I can open the file but that is all I can do. Does anyone have any suggestions at all?

    • 1 reply
    • 981 views
  51. My extended characters display as the black ? box on the mac, and the box on the windows machine. Is there anyway I can get these to show how they are supposed to? I'm talking about upside-down ?'s and !'s, and like 1/2 symbols, stuff like that Anyone got any idea's for me?

  52. I have my FM fields all set to the default font Helvetica, 10 pt. Whenever I copy a new email address from my mail program and paste it into the appropriate FM field, it keeps the mail program's font characteristics (Verdana, 12 pt.) rather than changing to the default characteristics of the FM field. Is there a way to make FM change the pasted text to the default font?

    • 3 replies
    • 1.1k views
  53. Hi, Obviously, variables should be faster than globals, but in fact that's wrong. Globals are much faster than variables ! I've made a counting loop with FM 8's script variables and the same script with old school golbals fields. Guess what ? Globals are much faster, either on a standolne solution or through networking with FM 8.0v4 networking. counting to 500 000 with globals }:| 55s, with $avariable : 79s ! That's for local. For WAN performanace with 8.04 server that's 11s vs 16s for counting to 100 000, and 56 vs 86 for 500 000. (at least local and WAN performance is almost the same, which is perferctly normal since everything is processed …

  54. Started by jhomer,

    using FM-8 built in PDF engine i am getting GINORMOUS pdf file sizes... my biggest so far is 50megs for a 15 pg textual report. Any one else having this problem???

    • 16 replies
    • 3.6k views
  55. Started by bdonelson,

    I just started using fm advanced, and I am attempting use the database design report. I trying to figure out what the color coding for the labels is. Other then that, it does produce quite a bit of useful information. Bill

    • 0 replies
    • 1.2k views
  56. Started by bdonelson,

    I have used fm 5.5, 7, & now 8. I also have some programming experience. After reviewing the filemaker website descriptions of the Advanced version, it looks like it has some tools that could make a significant difference for me. Any thoughts from current users of the Advanced version? How useful have the additional features been? Bill

    • 9 replies
    • 1.5k views
  57. Started by Kent Searight,

    Can someone tell me what's the keyboard shortcut for Data Viewer? I've hit it by accident, so I know it exists. I just can't find any documentation on it. Thanks!

  58. I would like to be able to store quicktime movies in my database and then deleted them from my computer. I can do this with pictures but cannot seem to do it with movies. Help, please. Thanks.

  59. Started by xochi,

    FYI, 4D (another database system) has found a serious bug caused by upgrading to OS X 10.4.8. This bug causes calculations to be incorrect. I'm wondering if there is any chance of this occurring in FileMaker, if the bug is in fact in a OS X library? http://4dtoday.com/news?c=detail&id=4690 -------------------------------------------------------------------- Urgent: 4D 2004 and Mac OS X 10.4.8 on the Mac Intel Platform -------------------------------------------------------------------- We have verified a serious issue with the latest revision of Mac OS X 10.4.8 on Intel-based machines. Apple has confirmed a bug that causes rounding and…

    • 1 reply
    • 1.7k views
  60. Started by siringo,

    I have no experience with File Maker Server or File Maker Pro so I am hoping someone can help me here? All our File Maker work is done by a 3rd party interstate all I do is follow there instructions for installing their FM apps. Anyway, here's the problem. We have replaced our Windows 2000 Terminal Server with a new 2003 Terminal Server. Users can connect to the FM app running on/under File Maker Server (on a different server to the Terinal Server, called Appsserver) but the resources used on the 2003 server is 3 times that used on the 2000 server. All Filemaker components, File Maker Pro, Server, the RDP client software etc are the same versions on both se…

    • 3 replies
    • 1.3k views
  61. Started by RPCia,

    Is there a place I can find any known bugs/issues releated to 8.5 client/server, if any exist? Via a thread, whitepaper, or tech brief. Thank you

    • 2 replies
    • 1.1k views
  62. Started by Rod B,

    We upgraded to 8.5 and are experiencing very slow response time in the editing function. Clients noticed it on the server 8, and I am able to reproduce on my desktop w/o files being shared on my local drive. Running XPSP2 :

    • 4 replies
    • 1.1k views
  63. I'm a psychologist and have used FMP to do my billing (on HCFA 1500 paper) for years. I had my database customized recently so I can bill electronically. The script works fine in FMP 6 but I want to upgrade to FMP 8. The script doesn't work in FMP 8. I get a dialogue box that says "Billing_Output.txt could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk." I have looked at both scripts using Scriptmaker and don't see any obvious discrepancies. Any ideas? Thanks!

    • 9 replies
    • 1.7k views
  64. Started by IT_boy,

    I"ve been trying to update my filemaker 6.0 to Filemaker 8.5. I have my old instal code for Filemaker 6 and new one Filemaker 8.5, but it doesn't seem to recognize my old install code. Has anyone else had this problem?

    • 2 replies
    • 1.1k views
  65. Started by merrickmgt,

    Hello, Will FM 7 be ok on an intel Mac? I know it will certainly not be ideal, at the very least. Have any of you intel Mac users upgraded to Pro 8.5?

    • 2 replies
    • 1.4k views
  66. Started by serzone,

    I hope it's the right place to ask this. I'm having a little bit of a problem with a database: users get "cannot modify this record, it's already in use by..." when they try to create a new record in a portal. Well it's a bit more complicated: - I have a layout showing the one and only record from a table called ProjectCenter (almost all the fields are Global in this table an thus they can be modified by anyone at any time). - On this layout, except for one field from that ProjectCenter table, the other fields are from a related table and they show project details. - On this same layout there's a portal showing records related to the project. - When s…

    • 1 reply
    • 1.1k views
  67. Started by PHP2005,

    Hi All, I am new into calculation, I am wonder if someone can give me an idea how should I write this calculation If country equal USA Perform the following calculation If the price is between 1 to 50 it cost 6.50 If the price is between 51 to 150 it cost 10.00 If the price is more than 151 it cost 15.00 Otherwise if country equal other Perform the following calculation If the price is between 1 to 50 it cost 15.00 If the price is between 51 to 150 it cost 20.00 If the price is more than 151 it cost 25.00 Thank you, any help will be appreciated.

    • 5 replies
    • 1.2k views
  68. Started by ari,

    I have used Access a little but am on a Mac now. I imported my data from excel, saved thfile and want to perform some simple consolidation of data (i.e. i have line item by day but i want to sum it by month and add a column for the # of occurrences). I tried to do the query but it said i need to select the ODBC database. I don't get it. Also, if this is not simple to do than please let me know so i can find someone to do it for me. thanks ari

  69. Started by Jeff Bills,

    Has anyone had this problem? Sometimes when I quit Filemaker it takes a couple of minutes for it to completely quit, even when all files are closed.

  70. Started by ino,

    :mrbug: I use Value list for find some data and use two fields in specification of Value list. When I selected filed as [color:blue]drop down value I got result which I want: Choose Country e.g.: [color:red]United States of America and in field I got short from second value list specification: [color:red]USA, bat if I like to use field whit [color:blue]Pop_Up List result isn’t as I wish Value list don’t change from one to another. Is it fp8.5v1 bag : :qwery:

    • 0 replies
    • 924 views
  71. Started by Spiceman,

    I'm - once again - thinking of moving to a current version of FMP, now using 6. Not that it would not do what I need it to do, but I may want to have a searchable database on the Internet and have no wish to learn MySQL, PHP and stuff like that. Downloaded the free trial. Tried to convert a single file. Could not access it "with this account & password" (or whatever it said). Removed groups, gave full access to my good friend Ms No Password and voilà! Tried to use Instant Web Publishing. Nothing happens. "No databases found." With FMP 6 Web Companion I have had the file published occasionally for a co-worker to edit from home - slow, ugly, but works. …

    • 16 replies
    • 1.8k views
  72. Started by cohip,

    Hi, I'm brand new to the board. What i'm wondering is if it's possible to take a filemaker file (w/ complex layouts, tables, scripts and relationships) and import it into an existing filemaker file (w/ other complex layouts, tables, scripts and relationships). Any information would be greatly appreciated - Thanks!!

    • 1 reply
    • 1.4k views
  73. Hi, I've many field by records, but only 3-4 of them are real data inputed by the user, the other field are here for GUI display etc. Those non user filed must be updated with replace steps cripts, imports etc. I've set a modifcation date auto enter filed, but unfortunately it gets updated during maintenance script execution, thus erasing the real user modification date. I need to track user modification of those few user field only, and the creation of the record by user. How should I track the modifiaction date (and creation date) of the records by the user only, and NOT resulting from script execution. The best way would be to prevent scri…

  74. Started by craig_s,

    Hi For sometime now, and only in Filemaker, my printer is unable to print the numbers 2, 3, 4 and sometimes 5. Instead I just get a square. This only happens intermittently. For instance it might print the number 22 and only the second 2 comes out as a square. Has anyone heard of anything like this? I print using an Epson Acu Laser C1100n This problem does not happen with any other application and I have tried several different Fonts in Filemaker. Very annoying. Thanks for any help Sincerely Craig Stewart PS, this has been happening using FM pro advanced (8.5) and before that in a runtime program that was developed in version 8

  75. Started by ken_s2007,

    I'm building a template file with things I want for all or many new files, like scripts, a few layouts, etc. It will undergo periodic modification over time. While this file goes through many revisions, it has very little data in it. Aside from the usual conventions for reducing the chance of corruption of a file, I'm looking for any recommendations for helping to reduce the chances of such a starter template file getting corrupted and the corruption being carried forward to solutions based on it. Should a new file be periodically built and the parts of the existing template be imported or recreated? Or is it mainly indexes and data that are of concern? Thanks. Ken

  76. Started by eljefejb,

    Hi - I guess this would be the correct forum for my question, but sorry if it isn't... it sounded the closest. I recently upgraded to 8.5 at work, and now I'm seeing some strange behavior. I have a "Notes" field in my file that works just fine for some records, but for others it will not let me type anything in. When I click into the field and try to type, I get the pop-up error dialog that says, "Before typing, press Tab or click in a field, or choose the New Record menu command." Well, New Record doesn't apply... I want to add a note to the existing record. I have tried clicking in the field, and I don't get a text cursor. I've even tried playing with the…

  77. Started by Steven Cappiello,

    I have a file that is *not* shared nor served..it has only been run locally. I can not open it nor can I Recover it.. When I try, I am told that the file is in use... but it's not. ANY ideas would be greatly appreciated. The file is NOT locked and the permissions are read/write.

  78. Started by S.A. Moor,

    t seems that I've posted my question to the wrong forum, sorry I'm new in here, so I hope that this time it's OK -) --------------------------------------- I've imported an application from FM version 6 to version 8.04 advanced. Before importing I've remamed all the Scrips so that I can find them once all the databases imported to a main base as tables. Is there a way (using the DDR?) to find out all the non used scripts in the final application so that I can delete them? Thank S.A.

    • 4 replies
    • 1.6k views
  79. I have just downloaded 8.5 to play with web views ... plugged my laptop into my new 20 inch cinema display .... tried dragging a fresh new template from my laptop to my cinema display to find that it bounced right back to the laptop.... All previous versions allows this. So must be a bug. This is a nightmare for my clients who work on laptops and cinema as well as me as i bought the thing recently to have more desktop space to develop my FileMaker Solutions... Anyone else had this!!! Stuart

  80. Started by PF,

    My company is working to improve the support of Central European languages as well as Middle East ones (Arabic/Hebrew). For this purpose, we are looking for people familiar with FileMaker products as well as linguistic issues for those countries. The goal would be to provide us with some help and/or Beta test. If you are interested, feel free to contact me ([email protected]).

    • 1 reply
    • 1.2k views
  81. Started by rosey,

    Hello all, When I go to insurors off the main menu it gives me the screen that you see in the insurorsfm.jpeg attached. I know the data is there because it shows up for other peoples computers. Also if I go to Leases and look under Insurance info it gives me that drop down list and all the insurance companies are there. As you can see in insurorsfm.jpeg the other tabs are blank. But they actually do go where they are supposed to. As you can see in bankfm.jpeg everything fills in when I click on the banks tab. Its pretty weird stuff. Anyone seen this before? I really hope so. Thanks for any help, Cody

  82. Started by weseverett,

    I have a database with about 400,000 records in it. I recently went to change a particular field in the database affecting about 120,000 records by using the "replace" function. Basically, changing the name in a field from "Jason" to "Matt". It processed all but about 400 records and generated an error message indicating such. I then performed a find function for "Jason" records which found the 400 records that appeared to be completely empty. These records were, however, uneditable. Moreover, when I tried to "delete found records" it appeared to delete them (although upon closer examination the number of records was not decreasing) and when I then performed the fin…

  83. Started by Kent Searight,

    Hi all, Does anyone know how to get FM 8 or 8.5 on a Mac to dial out via a VOIP service? Is there a plug-in? I searched the web but came up with nothing helpful. Thanks in advance!

  84. Started by T,

    Hi there I'm having trouble after migrating to FM8 from FM5 where i can't seem to be able to tell it to close certain files that are open in the background once they were opened once. Example is when I go to a particular layout in database X that calls on another database to open say database Y, and even if i go out of that layout in db X to another one that doesn't require db Y, I still can't get FM to close db Y. There are no other files open that I can see that require db Y but I can't get it to close it!! what can i do? am i missing something??

    • 2 replies
    • 1k views
  85. Started by BigZilla,

    I have a products file that was built in FMP 6.0 and I could really use your help and recommendations before adding it to a new solution Iâ��m building in FMP 8. My question is, is their any reason to build the solution differently from 6 into 8. A picture tells a 1000 words so Iâ��ve attached a picture of what the layout looks like. Our products can have up to 6 price points based on tonnage plus prices for "FOB" and "X-Warehouse" as shown. There is no set structure pertaining to pricing. Some vendors have one price, some have six and others can have anything in between. You can also see the â��Special Promotion Dataâ�� that pertain to some products. …

    • 2 replies
    • 1k views
  86. Started by clashman,

    I work in the convention industry and handle a great deal of speakers, depending on the show, and use a Filemaker template I made up to handle the check in process. I was wondering if the new version of FM could create a folder with the speaker's vitals ( Name, date of talk, room number )when they were processed in my check in procedure? Ex. J Smith is checked in and automatically a folder is created that has Time, Name, Day and Room of his talk. Secondly, can filemaker's web features allow me to create a web based log in page at a pc so when the speker puts in, say, his email, they are automatically linked to a their folder so they can click on it and download the pres…

    • 0 replies
    • 869 views
  87. Started by Zero Tolerence,

    I've never actually used the Calculation part of field validation, but here's what I'm wanting to do. I have a tasks table, inside that table I have a Date Field, a Start Time Field, and an End Time Field. No records start time and end time can overlap another records. And I need a way to check for that. Sure, I could use a script to do this, searching by date and then checking the times recrod by record. But then I got to thinking about List and GetNthRecord functions and wondered if this might be possible in a calculation. Just wondering what a few of the more experienced users think here.

    • 6 replies
    • 1.5k views
  88. Started by FM-Brian,

    I am having a very strange problem with one computer and was hoping to get some ideas or advice before I resort to reformatting the hard drive. I am running Windows XP, and Filemaker 8.5 Advanced. When I start Filemaker, it takes 4-7 minutes before I see the splash screen and the File Open dialog. If I immediately quit Filemaker, it will restart in about 3 seconds. I have listed below things that I have checked and done to resolve this issue but in the end, I cannot get the first startup to occur in less than 4 minutes. Any ideas? Here is what I have tried, and what I know: 1. It started happening with FMP 7, and has stayed as I upgraded to 8 and 8.5 …

    • 3 replies
    • 1.1k views
  89. Started by Saubs,

    Hello, all-- I'm about to rebuild our relational databases in FMP 8.5, finally upgrading from FMP6 (and FM Server 5.5). For those of you who have done this already, can I expect to see an improvement in performance over the WAN? Even over T1, my remote users in Chicago are telling me how extremely S - L - O - W our FMP6 databases are to work with. Slow to launch, slow to search (especially data in portals), slow to scroll/redraw, etc. I'm also wondering if performance might improve if I move FM Server out from behind NAT and put it in the DMZ instead. Any comments/suggestions greatly appreciated. Thanks much.

    • 8 replies
    • 2.3k views
  90. Started by bdam,

    Just wondering what those with larger customer base (100+) do in regards to VLA Maintenance? Here's my thinking based on a recent renewal quote: The pricing works like this: pay 50% for renewal every year or 100% each time we decide to upgrade. So yearly maintenenace renewal is only cheaper when you plan on upgrading every year. If you upgrade every other year it’s a break even situation but you have the benefit of spreading the payments. Anything over 3 years then is a waste of money. It took my company 5 years to move from 5.5 to 8.5 although I was only hired in the last year and a half. But what about these great new features that are bound to come …

    • 0 replies
    • 1.5k views
  91. Scenario: FMPA8.5, started in 8 Files UI, DataA, DataB UI display a record from a table in DataA with tabs. DataA has the usual plethora of tables for a project tracking system. DataB, with two tables, each with a handful of fields, is only for container attachments to two tables in DataA. In the UI file, on a button on a tab from a record in DataA, I just made a script to attach a file by going to the Files tab where a portal to DataB lies, with add record via portal ON. Seemed happy when I shut down yesterday. Today I decided to log in as sub accounts to do some testing, and found that the portal row would NOT add to Data B. Using a re-login scrip…

  92. We are talking to a potential client atm whom is looking at Microsoft Dynamics (Formally Navision). As usual the MS site is about as much to the point about what exactly its product is/does as George Bush is about Miltary Actions (sorry bad comparision). Anyhow can anyone tell me what exactly this product is/does and what its bad points (apart from being Microsoft). Also what are its plus points over FileMaker. Thanks

  93. Started by Zero Tolerence,

    I'm having a problem here. When I use this script I get nothing, even when I put it on a button. So my button looks like this: Show Custom Dialog[Get(ActiveLayoutObjectName)] Filemaker says it should return the name of my button, anyone know whats up with this?

    • 1 reply
    • 998 views
  94. I love FMP, as much as I hate it. And since I love it a lot, God knows I hate it ! -) My hater, my huge time wasting, is mainly due to ergonomic stuff that should have been from day 1, but that we still suffer 15 years after. Interestingly, that's stuff that could be fixed in one hour of coding from 1 dev of Filemaker. So without futher ado 1. Sortable Script editor ! I want to be able to sort my script If I want to, like I can for fields (customor order, creation order, and of course name). 2. Sortable display everywhere for fields. Why on earth should I sort them before in the define filed, to be able to have them sorted in the calcultion dialo…

  95. I have noticed that, when cutting and pasting into a field, that the formatting information is copied from the source of the cut instead of from the definition of the field. I find this quite annoying as it makes my database look more and more irregular over time. I have two questions: 1) Is there a way to force the use of the field definition when cutting and pasting into a field? 2) How can I reset the formatting information to that of the field definition after it has been changed by cutting and pasting? Oviously I want to do this with a script, but I can't find any script commands that affect the format of a field. Surely there must be such commands. Jo…

    • 10 replies
    • 1.9k views
  96. Started by xochi,

    I think this is probably a stupid question... does there exist a universal binary version of FM 8.0v4 (client, not server)? If not, is 8.5 the only universal binary FM client planned? I realize there is a UB of FMS 8.0v4 -- already using it.

    • 5 replies
    • 1k views
  97. Started by booboo57,

    Good evening , i would like to know if filemaker 8 runtime files will run on machines that do not have win xp sp 2 installed .. many thanks Tim

  98. Started by cormullion,

    Hi there, folks. I'd appreciate your advice. I'm looking for a solution for the following simple task, and can't decide whether FM is suitable. I'd like to build a simple flat-file database of about 200 records (flat-file), each record containing about 25 fields and a couple of photographs. Then I'd like to build web pages from this data. There will be very few updates once the site is built. FM is obviously not going to be too stressed by the database side of things, but I've been unable to find (on the trial version) an easy way of generating web pages. I'm thinking of a first page containing a list or list of groups, and then a number of subsidiary pages containing…

    • 2 replies
    • 1.3k views
  99. Hello I am new, I have installed updated my QuickTIme When I go to the 'Learning Ctr' ie, about IWP internet web pub.. and click on the video option for training... it loads fine, I get audio but no picture... says something about "QT ..says missing system file to perform, unfortunately it is not available on the QuickTime server?"" Any idea's?

    • 0 replies
    • 775 views
  100. Started by sm,

    I installed FM 8.5 and FM 8.5 advance on some of our systems. Some major features are missing. I can't convert a FM 6 DB. After borrowing someone's system and got the DB converted, I'm able to do the basic fuctions with the DB, but not able to do "save copy as..". The error msg says: This command cannot be used by this installation of FileMaker. It seems like the SW I got only allow to do simple browse/edit features. I called the sales dept of FileMaker, I was told the SW I purchased should be allowed for full feature. I don't even have an access code for one technical support. Can anyone share your thoughts on what my problem coul…

    • 2 replies
    • 878 views

Recently Browsing 0

  • No registered users viewing this page.

Who's Online (See full list)

  • There are no registered users currently online

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.