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 General Discussions

Older discussion forums for previous versions of FileMaker

  1. Is there a way to open a database file automatically as in set it as default database when you launch FMP? Thanks

    • 4 replies
    • 1.7k views
  2. FileMaker Pro v7 – v11 · Started by mf,

    I came across this article in the KB: 7071 Miscellaneous Behavior Changes in FileMaker Pro 10 It has some interesting content: in particular I was interested in the Get( LastODBCError ) In FM9 and before, when the import was all good, the error returned was "00000", but it seems now with FM10 that the result is "empty". Anyone else has noticed this? or is it documented somewhere?

    • 0 replies
    • 1.4k views
  3. This forum is just as much over my head as filemaker is! Please bear with me as I am very new to FMP. We have 3 iMacs in our office and one host the filemaker database. As of right now it is setup to connect to remote with the internal ip of the iMac on the network. One problem I have is filemaker has to open and running all the time on the main host machine. If not the others can not open it. Is there a way to host the database independent of filemaker? I hate to bring this up but when we used MS Access it was a database file that sat on a hard drive of one of the pc's and all could access it via a shortcut. This was VERY convenient! Made backing up a lot easier also. …

    • 10 replies
    • 2.2k views
  4. I am trying to highlight the active field using the new GetFieldName() function: Get (ActiveFieldTableName) & "::" & Get (ActiveFieldName) = GetFieldName ( Self ) I have the same formula attached to a tooltip. When the field is active, the tooltip returns true - but conditional formatting is not applied. Is this a bug or am I overlooking something? GetFieldNameBug.fp7.zip

    • 8 replies
    • 2.6k views
  5. FMSA10 / Mac OSX10.5 running IWP. I have replaced the IWP Homepage with my own very simple HTML page with hard links to my IWP Databases. All works fine but... The placed graphics in my HTML page do not display! I built the page with Dreamweaver and it displays fine when opened directly in a browser. The page even displays properly when I double click the actual HTML file inside the Library/Filemaker Server/Web Publishing/IWP folder - but when I open the served file (via the /fmi/iwp address) the graphics link is broken. The graphics are in the same folder / level as the HTML file. I have restarted the whole machine to try and flush the webserver c…

    • 2 replies
    • 2.6k views
  6. Hi, I hope this topic is not duplicated but am I to understand that I cannot attach my custom scripts to the New Record, Show All, Sort, etc. button icons in the toolbar? In other words I want my new record script to go to the assigned field or object in every table layout. Am I also to understand that I cannot decide which icons shall be available in every table layout, or in other words if I choose New Record in table A, I cannot choose to delete New Record icon in Table B? If that is the case I don't know what the advanced improvement is. The whole point to my purchase was to save time by dragging pre-made icons to a slick looking toolbar, and then as…

    • 6 replies
    • 3.8k views
  7. I am trying to get filemaker to load databases from an external volume. I have an alternate location setup for the filemaker databases, but, when I boot the machine, Filemaker loads the databases in the default location, but not in the alternative location. However if I stop the database server and the start it, everything loads. I suspect filemaker may be launching before the external driver gets mounted at boot. I would like to delay the launch of filemaker on boot. I called tech support and they did not have any ideas on how to do this. Filemaker tech support did give me the command line start/stop. But I don't want to have the server boot, start filemaker,…

  8. I'm having troubles with the Open Remote function in Filmaker 9 Advanced on Leopard. When I choose this command, nothing happens. One would expect a window with access to FM servers and remote files, but nada... It works fine on 3 other (Tiger) machines that access the same server. I've chekced my firewall settings, checked if something is blocking port 5003. I've reinstalled FM again from the cd. The first time I hit the Open remote command, Leopard asked me if FM remote connections should be allowed. I did allow this. I've even turned off the firewall. Still no luck. This is driving me mad! Any suggestions?

  9. FileMaker Pro v7 – v11 · Started by james74,

    I have FMP 10 and I want to run a report or script to view the database (all properties etc). I know there is an option in FMP 10 Advanced, but is there a similar way to do that in regular FMP 10? Thanks

  10. Installed Filemaker Pro 10 Trial. During the extraction of files I noticed the grayed-out path pointed to C:Program FilesIBMLotusNotesData. Installation added a folder called FMICD at that location that now contains the install files for FMP 10. No User or System variables point to that location. Made a bug report at Filemaker.com Has anyone else seen this kind of behaviour

  11. It appears there is a change with 10 that I discovered when running a script. In a list view layout with header / body / grand summary / footer, the grand summary will stretch to fill the gap between the header and footer depending on how many body rows there are. If you omit all records from the found set all you will see is the header / grand summary / footer. In this space I have used either a field or web viewer - calculated to show record count or "End of List" or "No Records Found" occasionally add a button. As i don't mind the user landing on a list with zero found. However in 10 it appears that the sort operation is evaluated even when the found…

  12. In version 9, the Text Formatting toolbar had buttons for Increase/Decrease Font Size, Single/Double Space, and - most importantly - Custom Space which provided quick access to the Paragraph setup window. All these are missing from the new formatting bar in v.10.

    • 7 replies
    • 2.4k views
  13. I just got Filemaker 10. I have a Contact database I made in FM9. I would like to update the look of my contact Database to match the look of the new Contact database this is a template in FM10. How do I update my database to the "New Look?" Kevin

  14. Oh. I'm dumbfounded. Surely this is a mistake. To get the little magnifying glass to appear in a field for find mode, we have to turn SHOW FIELD FRAMES back on or it won't work!! Hey FileMaker, did you have a ... We spent YEARS asking for a way to turn field frames off and now we must have it back on to take advantage ...

  15. FileMaker Pro v7 – v11 · Started by Flashylightsmeow,

    Hi, I'm very new to filemaker pro and am having some problem with relationships. I'm trying to make a database based on an elderly care facility, one table has the names of the residents ("Resident Info" Table, their address and the date they came into the care home, and the other is a table with details of people who pay for those individual residents("payee" table). What I want to create is a field in the Resident Info table called payee, where i can select from a drop down list the name of the payee who pays for that resident. so i create a field in both tables called payee and link them. But when I add data to the Payee table and then go back to the resident info …

  16. I have been playing around with FM 10 Advanced on a Mac G4 and I have FM Server 9 on a G5 with 2.5 GB (1.6 GHz running OS 10.4.x). It appears that the FM client is running slower and I am interested if anyone has any data on whether the FM Server 10 produces any speed bump. I'll probably install it anyway but I would like to know if anyone has noticed faster or slower speeds.

  17. I've just upgraded to FMP 10 and built my first set of runtime files. They're over 5 megabytes larger than the same application under 8.5. A quick check of the runtime directory revealed that the following subdirectories have been added: Microsoft.VC80.CRT Microsoft.VC80.MFC Microsoft.VC80.MCFLOC SASL2 XTPTrans Can someone tell me what these are for? ... IWP? ... SQL Access? I'd like to jetison them like I have the unnecessary dictionaries. But, of course, I don't want latent problems showing up. Thanks for any help.

    • 0 replies
    • 1.5k views
  18. Has anyone else noticed that under Vista the background color for tooltips has changed from yellow to a light blue gradient? And worse, that it renders as a banded effect, not a true gradient? Was this an advertised "improvement"? Is there a way to change it back? I've checked my desktop settings under Properties and they're the same as they've always been. FMP is somehow overriding them. For most folks, I suppose this isn't a problem (other than the banding effect). But I have some companion help panels that are color-coordinated to match the previous tooltip backgrounds. Any help will be appreciated.

    • 0 replies
    • 1.4k views
  19. FileMaker Pro v7 – v11 · Started by GHT,

    Our company is trying to decide on Filemaker Pro or Maximizer. We need a very comprehensive CRM plus many custom features for various areas of the business. We are not a big business. Does anyone have any feedback on the pros and cons of either? Any feedback is greatly appreciated.

  20. Hello, does anyone know if it´s possible to run FM10 Clients with FMS 9 Server? We have no need for the FM 10 Server functions, but like to use FM 10 Clients because of the Skript Trigger functions. I think I recall that one could use a FM 8 Server along with FM9 Clients, but I might be wrong... -)

  21. I took a look at the new FM Pro 10, and have to say that it looks pretty nifty. I like the looks of the new features and ever simplifying the interface, but I do have an issue.... I just purchased FM Pro 9 for my company as a means of keeping track of all our sales info. It was delivered Nov. 24th. FM refuses to let me upgrade to 10 without cost because I did not buy it after Dec. 6th. Anyone else think this is a crock? I saw no indications that a brand new version was about to be released, otherwise I could have waited the additional couple weeks. I guess I just need to gripe about it, as it seems like pretty poor customer service to me. You spend a bunch o…

  22. FileMaker Pro v7 – v11 · Started by RPCia,

    Am I missing something or is there no way to change the order of the layouts on a file hosted by FileMaker Server 10.

  23. Hello, Anybody know where I can find the up to date list of Error Codes for FileMaker Pro 10? Specifically I would like to catch the errors that might be generated by the Send Mail (using SMTP server) script step. Thanks...

  24. Text: 80 Character string 01234567890123456789012345678901234567890123456789012345678901234567890123456789 Calculation: Code = Code (Text) results: 5000049000480001300057000560005500054000530005200051000500004900048000130005700056000550005400053000520005100050000490004800013000570005600055000540005300052000510005000049000480001300057000560005500054000530005200051000500004900048000130005700056000550005400053000520005100050000490004800013000570005600055000540005300052000510005000049000480001300057000560005500054000530005200051000500004900048 Code () only evaluates to 80 characters anything longer you get a question mark. Another set of fields A…

    • 6 replies
    • 6.4k views
  25. FileMaker 10 has a bunch of new features and has received a much needed facelift. Throw all your favorite new features into this forum so we can figure them out.

    • 55 replies
    • 9.3k views
  26. FileMaker Pro v7 – v11 · Started by Raybaudi,

    Finally !!! _10_MaxLength.zip

    • 10 replies
    • 2.7k views
  27. I have 2 separate databases that is hosted on FMServerAdv 9 and IWP is enabled on both the database. Prior to upgrading, my filtered portals are working fine. The field that I used to filter the portal is in db1 and the portal is linked to db2. But after upgrading to server advanced 10, the portals doesn't show anything, the fields are blank, but it only happens on IWP. If I use the client FMProA10 everything is ok. At first, I thought the new version does not open the DB2 automatically when you log in. But when I checked the server, the user is logged in to both db. Help?

    • 0 replies
    • 1.5k views
  28. ... so now it's possible to enter 010101 ( or even only 1 ) into a time field. With an auto-enter calc like this: Time ( Middle ( Self ; 1 ; 2 ); Middle ( Self ; 3 ; 2 ) ; Middle ( Self ; 5 ; 2 ) ) you'll obtain a real time field.

  29. FileMaker Pro v7 – v11 · Started by Reed,

    Anyone find it strange that FMP10 for windows requires XP SP3, while FMPA10 only requires SP2?

  30. Take a look here for more information. Steven

  31. Does anyone know if Instant Web Publishing has been upgraded or enhanced in FileMaker 10?

    • 7 replies
    • 2.3k views
  32. Hello, I started using FM about 2 years ago with my new job. I still feel like I don't know too much about it. We currently run FM 8.5 Advanced. I have a free upgrade to Pro 10 but not Advanced. Are there going to be some major things missing from my app if I upgrade from 8.5 Advanced to 10 Pro? Thanks for your help!

    • 2 replies
    • 1.9k views
  33. GUI LIMITATIONS in my opinion: • possibility to change de icons of "Status Toolbar" to my icons wihout any kind of cracks (In my view, the status toolbar icons are ugly) • possibility to translate de icon name to other language… (like custom menus,…) • "Layout Bar" is included in "Status Toolbar", why not in separate, to activate it or not with a script,… Show/Hide Status Bar and Show/Hide Layout Bar… • "Modify Table View", call it through Script, not possible, correct? • No Improvements to Radio Buttons, CheckBox, etc • No Improvements to the Relationship Graph (zoom in and out, left, right, top, bottom, becomes boring…) • possibility t…

  34. I upgraded a person's machine from 8 to version 9 standard. Now when she prints just about any layout in that file it's cutoff. If she goes and changes the graphic scaling in the printer like we've done for many years, it really doesn't seem to matter what we set it to, it cuts off in the same place. (Shows in preview this way). I brought the file to my machine runnnig 9 Advanced and same issue. Doesn't matter if I change printers, Adobe, etc., same issue. Not sure where to start? Suggestions?

  35. FileMaker Pro v7 – v11 · Started by mleiser,

    I noticed in the documentation that server 10 works on windows server or vista. I have server 9 running on xp. Will server 10 continue to work on xp?

  36. I tried to install FMPA 10 in XP SP2 under Parallels but it won't install. The FM website states XP SP3 is required, but the documents accompanying the software say XP SP2. Bug or typo?

  37. I know I should probably contact my sales rep about this, but their phone is probably ringing off the hook today: How soon do VLA customers with a maintenance contract typically get their download links and serial numbers for the new software? The same day it ships? Within the next week? Later? And does it come automatically or should I specifically request it? I am in the first year of the VLA program so this will be my first "free" upgrade.

  38. Here are a few text expander shortcuts for the new Code ( ) function so you know exactly what the number is when evaluating a calculation. Useful for script triggers knowing what key was pressed. hence the 'kp' or key press TextExpander_FM10_Code.textexpander.zip

  39. Hi, I just did one test but repeatedly a very complex export involving many nested unrelated fileds and relationship fileds towards a XML file. FMP 10 trial vs FMP 9 Advanced 269s vs 299 s = 238 records and 242s vs 270 s = 514 records (less complex because some empty) Test was done locally (no server involved) Filemaker Advance 9.03 vs FM Trial client 10. File in the exact same state (copied from a backup each time) so there's no caching difference Maybe client is faster than advanced but I don't think so. On a side note, I felt the interface was slower in 10 but that's perhaps me. Did someone else see the same thing.…

  40. Puppy Dogs and Wagging Tails... Up to now we have been able to target a single field with dynamic conditional data. (the wagging tail) Now we have the ability to targeting a field programatically and the data results as well. ( two wagging tails ) Since double clicking on the Set Field or Set Field By Name script step defaults to opening the first target field "specify" when we always wish for the second specify to be the default dialog. To put all the logic in the first "Target Field" Specify calc dialog using Let. Let ( [ $field = > $result = > ; ]; $field ) Then in the second calculation (non defau…

  41. FileMaker Pro v7 – v11 · Started by mcyrulik,

    Hey all, I did some searching, but couldn't find a definitive answer. Can someone point me towards a compatibility guide for FM 10? Meaning, is Filemaker Pro 10 client able to connect to a Filemaker 9 server, can Filemaker Pro 9 clients connect to a Filemaker 10 server, etc. Obviously, a complete upgrade to 10 would be the best path, but with our remote users, a sweeping rollout is not an option. Thanks for any help.

    • 1 reply
    • 1.6k views
  42. Here is a great article http://sixfriedrice.com/wp/introducing-filemaker-10/

    • 2 replies
    • 1.8k views
  43. New FileMaker Pro 10 Ships With Sleek New Interface and Breakthrough Reporting and Automating Features Most dramatic interface improvements in over a decade put commonly used features at users’ fingertips SAN FRANCISCO and LAS VEGAS (Macworld Expo and CES) – January 5, 2009 – FileMaker, Inc. today announced it is shipping the new FileMaker Pro 10 ( http://www.filemaker.com/fm10_launch_pr ), a breakthrough version of the award-winning database software, which features a sleek new interface and intuitive new design. With a fresh new interface, FileMaker Pro 10 delivers the most dramatic design changes in over a decade. The redesigned and customizable Status…

    • 0 replies
    • 12.4k views
  44. The release today of FileMaker® Pro 10, FileMaker® Pro 10 Advanced, FileMaker® Server 10, and FileMaker® Server 10 Advanced marks an important new milestone on FileMaker, Inc.’s product roadmap. Congratulations to FileMaker, Inc. and especially to the Product Management and Engineering teams. With the introduction of thirteen new, long-awaited, and much-sought event triggers and Set Field by dynamic calculation, the new FileMaker Pro 10 is the most significant change since the introduction of FileMaker® Pro 7 in early March of 2004. The User Interface has undergone a significant alteration as well to produce a more contemporary look familiar to users of productivit…

  45. FileMaker Pro v7 – v11 · Started by zinneken,

    Can filemaker look (with the purpose of looking and editing) into the Apple's Address book as if it was an outside table/DB? If so, how would it be done?

  46. FileMaker Pro v7 – v11 · Started by aholtzapfel,

    : does anyone have a list of known bugs in filemaker 9? I know there are some. (I'm sure filemaker is aware of most of them but, from experience they do not let the public know what they are until there is a fix. Good for sales, bad for everything else.) If there is a list, I'd love to see it. If there is not, I invite all to post any bugs they have found here. (I once spent three months tring to figure out what was wrong with my solution only to find out that Filemaker knew of an indexing issue and did not publish any info on it until there was a revision that fixed it. I for one would like to avoid anything like that in the future.)

    • 63 replies
    • 12.2k views
  47. Slow Screen Redraw Windows machines -Help! We have a database thats been used for almost 2 years. It's in Filemaker 9 and it had been working fine. It's running on Windows XP machines (the file server using filemaker server advanced). I connect remotely through VPN to make changes occassionally to layouts etc.. My home computer is a macbook pro. Every since last week all of a sudden all the windows machines are extremely sloooooooooooooooow,whether they connect off site or on site, the screen redraws constantly. When I connect with my mac it's fine. I can't figure out what's wrong. It's all the pcs that it's slow one. Making it practically unusable. As I said every…

    • 4 replies
    • 2.9k views
  48. Anyone know how I can download a trial copy of 9 Advanced? I want to put a copy on a client's computer (and activate it) for short term development, but I don't have the app itself. In the past, I've downloaded the trial of 9A and used my license key with no problem. But I can't find a link to that download anymore.

  49. Have been running FMP 6 through all the permutations of OSX, and we continue to do so on all our Macs in the office. But I had occasion to turn my iMac off and when I turned it back on FMP 6 would not run. Everything else does. FMP 6's screen appears, then goes away, and in a moment or two the notice of a crash appears. Have trashed preferences, verified disk, and repaired permissions to no avail. It continues to work on our other machines. In fact we put mine on a flash drive, plugged it in to a macbook and another iMac and the program worked well. Apple says it's FMP. FileMaker says they don't support 7 or before and that 6 isn't certified for Leopard, but "th…

  50. FileMaker Legacy fp3 and fp5 · Started by MacNut,

    Any one know of hardware/software solution for having FileMaker be an auto dialer? I know we can use a modem, but most folk, have PBX phone systems instead of analog.

  51. Hi there, I forgot a password to a small .fp7 file I haven't worked on in over a year. Can someone help me retrieve or reset it ?

  52. FileMaker Legacy fp3 and fp5 · Started by Tim Goss,

    Hi: I'm running FileMaker 6.0 Unlimited. I have a pulldown menu when searching for user names in the database. When I search on the name "Noteboom S" it finds all the records for that user. When I search on "Noteboom N" it finds all the records for both "Noteboom S" and "Noteboom N". And now here's where it gets weird. I have two other users with the same last name ("Smith R" and "Smith T") and different first intitials, but their searchs work perfectly. And even weirder: If I change "Noteboom N" to "Noteboom L", it works. "Noteboom Na" works. . . just not "Noteboom N". Any suggestions? Thanks in advance. Tim

  53. I have a database in fp7 that I need to give to an fp5 user. There seems to be no way to export or save as a different version. How can I do this?

  54. FileMaker Pro v7 – v11 · Started by kmcb,

    Hello, I apologize in advance if this has been posted, but the forum search function is currently down. I'm new to filemaker and we have recently converted our database from FM 5 to FM 9. The DB consists of 50 plus files and we are starting to discuss moving forward with an effort to combine all files into 4. Our company current uses Server for people to access the files via intranet and may start allowing access over the internet both using FM9 local copies. My question, we are looking for the advantages and disadvantages to doing this. In terms of speed, reliability, ease of use, new features that will be available, etc. Any thoughts would be appr…

    • 2 replies
    • 2.1k views
  55. Not sure where to post this, sorry if it’s in the wrong place. I’m trying to understand the difference between a VLA and an SLA. I’m looking for a 50 seat license. On the VLA a 50 seat license costs $241, while on an SLA a 50 seat license costs $159. Obviously there must be a major difference between the two to account for the price discrepancy.. what am I missing ?

    • 2 replies
    • 3.7k views
  56. Hi: I have FileMaker 6 Unlimited running with Outlook Express and serving Web pages using CDML. FileMaker runs a script that sends email. Recently, and now about every 2 days, I get a dialog box from FileMaker asking me if I want to compact Outlook Express to save space on the hard drive. This hangs up FileMaker and keeps my clients from accessing their data (unless I'm sitting there watching the server). Even if I say "Yes" to compacting or "Cancel" the box keeps popping up. Any solutions you could offer would really help as I have several hundred clients hitting this server during the day. Thanks, Tim

  57. This is driving me nuts, DDR report (XML/HTML) crashes when scripts are included in the report. No problems running DDR on other files. Tried file recovery, optimize/compact/file, I even tried deleting all scripts in the file but whenever I run DDR with scripts selected on this particular file FM crashes. I tried it on a different machine and same thing. Are there any logs I can look into? Our main file has some 1500 scripts so migration to a fresh empty file is not an option. I tried running DDR on the same file with FM 8.5 Advanced and it worked fine. Running FM 9 Advanced 9.0v3 / WinXP Any ideas?

  58. I'm migrating from an Excel-based list to a simple FM Pro (8.5) database. One of my fields is a set of radio buttons. What I need to do is take my list of 1,000+ entries in Excel, and set one of the radio buttons for each of those entries. The key field here is a unique registration number, which exists in both the FM Pro database and my Excel sheet. My question is ... what's the easiest FM Pro way to do this: "For each registration ID in this list, if you find it in the FM Pro database (which it will, as they're all there), then set the radio button field to Option #2. I know I can do this with a massive multiple-find and then 'replace in found set,' but w…

  59. OK, I am probably going to regret posting this, but it's the end of the day and I'm fried and I figure one of you guys or girls will be able to answer this before I can figure it out tonight...... Let's say I have a field(Field 1) with a list of items: 1 2 3 4 Now let's say I have another field(Field 2) with values in it: 1 3 Now let's say I want to return all the values in Field 1 that don't appear in Field 2. How would I go about doing that? FilterValues(Field1; Field2) will return those values in Field 2 that DO appear in Field1. I'm looking for just the opposite.

  60. Hello, I work in a studio and we have about 30 Macs (all OS X, vary between 10.4 and 10.5). All computers have the latest OS installed (of either 10.4 or 10.5) and all machines are running FileMaker Pro 8.5 (latest update/version). The FileMaker Server is running FileMaker Server 8 (latest updates). We haven't changed anything in quite some time and everything is running as it should for the most part. Well, except for one, new client I just installed. It's an older G4, but it's running the latest 10.4 OS and the latest 8.5 FM software (exact same setup as all other machines). The odd thing with this machine is, when I try and open remote files via the server, I…

    • 5 replies
    • 8.2k views
  61. Hello, i have an interesting issue here that would like to share with you guys and hopefully solve it since its very important for a process which i am working in my company. The process is based on a scan of products in a global fields formatted as text. The scan may contain numbers from 2 digits until 6 for example: 12 123 1234 12345 123456 After the scan is done i do a process which looks for the related parts in our inventory which thats already working good, after that it goes to the first part and checks on the global scanned how many times that part has been scanned, this is where the problem comes. Lets say i scanned 35 parts with the part…

    • 8 replies
    • 4.8k views
  62. Sorry if this isn't the right spot for this question. I just stumbled on here today while searching online for some sort of idea of what is going on. The basic setup in my office is my computer running filemaker and hosting the various files I use and one other computer running it's own version of filemaker connecting remotely to mine to access the files. It has been working fine for years! But today, I tried to open a file remotely and it crashed Filemaker. I rebooted, it crashed again. I'm running Mac OSX on both computers. When I went back to the host computer, the file was no longer functioning. I closed it and tried to reopen it, but no dice. The file was…

  63. Hi All, We're about to upgrade from FM 7 to FM 9. Is it possible to purchase a handful of Pro Advanced copies for development, and get copies of Pro for the rest of the users? Or would the functions developed in Advanced not work for Pro users?

    • 2 replies
    • 1.6k views
  64. I've very new to filemaker so sorry for the basic question here. I am using filemaker pro 9, as a simple one PC database. I often export columns from the database for use in excel. I have a column where the majority of data is numerical, but some data isn't - for example, some entries are S24, instead of just 24. When I export this column, and open the text file in excel, it removes the letter. What can I do to fix this?

  65. I'm brand new to Filemaker & I've just installed the trial version of Filemaker 9. I setup a database using a sample template, but have a question on field entries. My field contains an alpha-numeric "ID" for each record. In this case - 1A1,1A2, 1A3,...1A9,1A0,2A1,2A2,2A3, etc. Is there a way to prevent someone from creating a new record with an already existing "ID"? Info in fields following the ID should be changable. I did search on the forum, but didn't really see what I was looking for. Thanks for any help.

    • 2 replies
    • 2.3k views
  66. Hey all, I am trying to VPN connect to my Filemaker 8.5 Pro however it refuses to make a connection. I can however connect to my Filemaker 5.5 Anyone know of this issue? Thanks, brad

  67. I'm just starting to use FM and, although my Hebrew fonts appear on my other applications, they do not appear on my FM font menu. What do I have to do to make them accessible?

    • 0 replies
    • 1.6k views
  68. I am using 10.5.3, Filemaker 9.0v3, on a MacBook Pro core duo. Has anyone else experienced Filemaker just freezing on you (forever spinning beach ball) and then Filemaker crashes with the typical mac message that Filemaker just crashed, no other program was effected? I am not experiencing the problem when my computer goes to sleep or waking up from sleep. The problem seems to happen randomly, and sometimes when I change from Layout mode to Browse mode. I never had these issues in 10.4. I may switch back to Tiger.

    • 8 replies
    • 2.8k views
  69. I get the following error message in the bottom box of the error reprt contents: C:DOCUME~1ADMINI~1LOCALS~1Temp1dcd_appcompat.txt I am unable to copy the entire upper box, but long and short of it, I am unable to install fmp8.5 on my tablet pc w/xp. really frustrated. installed/removed several times, lost and dont know what to do. plz help!

  70. I have just purchased FileMaker 9 Pro. I am not clear about whether I am able to activate this on both my desktop and laptop machine (I want to be able to work on databases while commuting and also run those databases via web publishing on my home machine). I found this article: http://www.applelinks.com/index.php/more/filemaker_pro_9_review/ that suggests that I can have it activated on both desktop and laptop computers. This is the significant wording: "If you are unfamiliar with Activation, what it means is that you have a serial number that is good for two machines. You can install the software on any number of machines, but it can only be active on two…

  71. FileMaker Pro v7 – v11 · Started by overrider,

    Hello all, i made a Solution for my Employer containing about 50 Files in FM6. Everything from Employees, Salarys, Items, Bom, Multi Currency, Warehousing, Drawings Database etc. Now i want to do the whole thing over in Filemaker 7. Now my Question is, how to organize my Files? Is this the better way?; The File Contacts will contain Employees, Vendors, Customers The File Item will contain Item and Bill of Material etc. Or can i basically put the whole Solution into one File and seperate by tables? How does Filemaker Server treat the Tables within one File? Should i understand the File as a Package, containing many Tables (former Files)? In my Bom F…

    • 10 replies
    • 4.3k views
  72. Hello, I have a system running FM Pro 7 with a Mail-it plug-in for sorting email into a FM database running on a FM 9 Adv server. Every morning I get a FM crash around 3 to 5am PST. Each time it says the same thing... any ideas? -------------------------------------- Date/Time: 2008-09-16 04:30:06.492 -0700 OS Version: 10.4.11 (Build 8S165) Report Version: 4 Command: FileMaker Path: /Applications/FileMaker Pro 7/FileMaker Pro.app/Contents/MacOS/FileMaker Parent: WindowServer [57] Version: FileMaker Pro version 7.0v3 (7.0.3) PID: 23582 Thread: 0 Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_PROTECTION_FAILU…

  73. FileMaker Pro v7 – v11 · Started by mtpaper,

    Hi folks - I am in the process of switching from pc to mac And from Approach to FM I played with the trial of FM on my daughter's laptop, converted and set-up a good portion of my work, loved FM, bought it, and installed it on my desktop imac. I opened the file - no problem. However, when I try to use Layout, I'm locked out - not allowed to make any changes. I get the error message, 'this action cannot be performed because this file is not modifiable." Well, I can't find any place that will give me more rights than I already have! I've gone to File->Manage->Accounts and Privileges Accounts Guest is not active Admin has full access…

  74. We bought the tool from New Millennium 5 yrs ago. I used it once or twice, but can't recall where to begin! I have the plugin file in the system directory. Hoe the heck do I use it? : Does anyone out there remember how to use it (i.e. what to launch?!)? TIA! FMP6 developer files

    • 3 replies
    • 2.3k views
  75. My profile is incorrect because the options aren't there -- I'm using FMpro 3.0 clients on Win2k/XP machines, hosted by Filemaker Server 3.0 running on Windows NT Server 4.0! I need to upgrade to a new machine, but my installation CD is nowhere to be found! It should be in the box... I've got the manual and the box in mint condition, no CD!! Does anyone out there have any idea how I can get a replacement CD? Quickly?? I'm willing to pay... but I DON'T WANT TO UPGRADE! I've got no time and my current installation works just fine. thanks in advance, Pete

  76. I am trying to use an installation of Filemaker Pro 3.0v2 on my Windows XP box and am trying to update it to the highest version of FM3.0 available. I think the highest released version was 3.0v5. However, the update file is no where to be found. I contacted Claris and they said that they don't have it any longer and referred me to this forum. Would anyone be able to tell me how to obtain it or have it available? Thanks.

  77. FileMaker Legacy fp3 and fp5 · Started by hos,

    do anyone have this calender snap with unlocked version p/s send to me a copy

  78. FileMaker Pro v7 – v11 · Started by Steven Cappiello,

    Hi there, I work at a company that has just rolled out version 9 across a few thousand workstations. I pressed for upgrade to 9.0v3 but have been told they're busy and it's scheduled for Oct/Nov. Are 9.0v2 and v3 important ? and if so, any suggestions for how I might respond to the deployment officers given we have many folks using our FileMaker databases?

  79. I'm thinking of upgrading to FM pro and server v9.0 and accessing the database remotely from another country. What is a good minimum speed requirement for the internet connection for the client side to have? The blank FM database is around 30MB in size without data and there will be around 3-4 simultaneous users accessing it remotely.

    • 2 replies
    • 2.4k views
  80. I have been unable to find my FM Server 5 installer CD for Windows but I have the serial # for it. I tried calling FileMaker, but they told me that they don't have the media any more. Anyone out there have a Server 5 for Windows CD (really just the installer) that they could send me via email (or I could set up an ftp account). Thanks!

    • 0 replies
    • 1.6k views
  81. FileMaker Pro v7 – v11 · Started by GRMike,

    On one of our XP Pro installations of FM9 Pro, the program can take up to 40 minutes to open after a reboot. There are not any scripts running at startup, no db's are being opened at startup -- only FM9. After the program successfully loads it can be closed and restarted within an expected time span (< 5 sec.). The glacial opening only occurs after the system has been restarted. Task Manager reports @ 35 k (@ 50%) of the program loads within seconds then halts and the remainder loads 10-40 minutes later. I have tried uninstall-reinstall with no changes. System specs: WinXP Pro sp2 AMD Athlon 2800 2GHz 1 GB RAM FM9.0v3 Thanks in advance, Mi…

    • 3 replies
    • 3.2k views
  82. All- Does anyone know with any certainty if FM Pro 9 will work with Vista 64-bit op sys on a stand- alone pc (not Mac)? I am a fairly new FM (Pro 9) user and was just getting started building a database when a crash forced me to 'upgrade' to Vista [64-bit] from an old XP system. The folks at FileMaker are pretty vague about whether or not my FM Pro 9 software will work with the 64-bit op sys (Vista 32-bit is apparently OK). The previous postings seem to be focused on servers not stand-alone pc's (not sure if it is a separate issue). Before I start down the road of re-building everything I was hoping to find out if I am wasting my time. Any help/advice greatly a…

    • 0 replies
    • 1.5k views
  83. FileMaker Pro v7 – v11 · Started by DR,

    I've set up an SQL request to import training-related data from an external (Oracle) database. The request works fine except that 5 records out of the 54 imported, display the wrong completion dates. In each case the month is correct, but the day and year are not. I've also tried returning the dates as text with the same result. The same query entered through SQL_Plus returns all 54 records correctly. Crazy.

    • 0 replies
    • 1.2k views
  84. Hi, I recently opened the database I am working with and all my data has disappeared. The records are still there, but they are empty and devoid of data. I had a back-up copy, so it is not the end of the world, but I would like to know how to avoid this problem in the future. Does anyone know why this might have occurred and how I could avoid it? Thanks, J

    • 1 reply
    • 2.4k views
  85. Has anyone found a way to print text in black ink only when printing to a digital press? FM changes 100% Black to 74 Cyan, 71 Magenta, 64% Yellow, 87% Black. I'm guessing that FM is using a color profile to convert the values. Maybe someone had found a way to actually print black as black. Should not be a hard thing to do. I have removed all color profiles from the system. To the point where FM crashed when I go to edit a color. I had to replace at lease the generic CMYK for the sliders to work. But even then it seems like a generice RGB profile exists. I have also turned off color matching in the print setting in my scripts. This is not an issue in FM 6 ru…

  86. Filemaker 9.0v3 2.8 GHz intel core 2 duo, running 10.5.4 1.83 GHz intel core duo, running 10.5.4 1.8 GHz Power PC G5, running 10.4.10 I am having an issue with using the Code 3 of 9 barcode font with Filemaker 9. It is working on the same computers with Filemaker 6, but will not even display in Filemaker 9 (I get a default readable font.) Any ideas?

  87. FileMaker Pro v7 – v11 · Started by Arny,

    I have been using FileMaker for a long time from version 3 up to my current version 9 advanced. As I've progressed, I've kept each version [version 5, 6, 8.5adv & 9.0adv] on my system. The reasoning is that several clients that use my solutions are still using one of the specific versions mentioned. I've recently begun to have 'sharing' problems with my latest versions. I decided to verify the version number on each of my different solutions, only to find that ALL of them display a version number of "5.1". Is there any way to reset the version number or at least get it to operate with the version number of the specific version in use? Perhaps the regis…

    • 0 replies
    • 1.6k views
  88. FileMaker Pro v7 – v11 · Started by DanTMan,

    Hi I have 2 x 5 user licences of Filemaker 7 which we run accross our office. I have replaced a number of machines and would like to find out which licence key I have used, so that I dont duplicate them, using 7 of one and 3 of another etc. In about filemaker it simply says volume licence, is there a way of finding out which key i have used? Thanks Dan

    • 2 replies
    • 3.9k views
  89. Hi, I need some help please... recently I bought Filemaker Pro 9. I started doing my database in Windows XP. The problem is that know I have to move to Mac and when I open the database in Mac, I don't know why, but I can't have access to the files I've put there! I'm only able to see the records...the files appears only the icon, but if you try to click on them or save it to the disk the option doesn't work..appears like if you can't perform that option.. I don't know if the problem is because I used a different operator system to make the database, but that shouldn't be the problem cause i'm using the same program! Can anyone help me??

  90. FileMaker Pro v7 – v11 · Started by chrisho30,

    Is there any tools can do Stress Test on FMP database?

    • 15 replies
    • 2.4k views
  91. FileMaker Pro v7 – v11 · Started by Heathbo,

    This is probably a stupid question. I know a cache is temporary storage for commonly used information. My question is, what is it used for in FileMaker? Is setting it higher better? I assume yes, but I'm just checking. Does setting it higher improve performance? Especially if there are a lot of relationships? Thanks.

    • 1 reply
    • 1.6k views
  92. I recently needed to update a FM3 database to FM9. In addition, the database was migrated from a PC to a Mac. While the conversion of the database went without issue, I was experiencing significant performance issues when using the database. Mainly, I would get the beach ball as I moved from record to record. With only 5800 records in the database, I knew something else was causing the problem. After multiple Google searches, and having limited luck in finding similar experiences, I applied the "check for invalid file references" recommendation to a broader set of functions within my DB and was finally able to resolve the issue. In short, if you see performance…

    • 1 reply
    • 1.4k views
  93. I loaded FM 9 adv on my Win Vista based HP laptop and the short cut keys ctl-alt-arrow for aligning objects stopped working. I have to use the menu to align objects. I don't have this problem with FM9 adv on my Win Vista desktop computer. Can this be a keyboard issue? Is there a setting somewhere in FM?

    • 1 reply
    • 2.4k views
  94. hi, Is it possible to merge two filemaker files into one, with all of the field definitions? I have moved from FM4.1 to FM9 advanced. In 4.1, relational tables were different files. FM9 can have multiple tables in a single file and it would be better to do it this way rather than maintaining several files. I can't see anything in the user's guide or help files. Exporting field definitions would also work but I can't see how to do this either. I'd be grateful for suggestions, many thanks, George

    • 2 replies
    • 1.6k views
  95. I have a related DB with 8 files. Works fine in versions 7 & in 8. But when I open the DB in V9, I get the message that one of the files is damaged & needs to be recovered. So I use the recover function, but when I open the file I have lost about 150 records. Done this a number of times with the same result. Never happens in versions 7 or 8, only in 9. Any ideas?

    • 2 replies
    • 1.9k views
  96. I've seen this a couple of times in different DB's where a record in a database display question marks (?) in all the fields. When I perform a file recovery, no errors are reported, but the record in question disappears. What is odd is the record can be found based on data that was on the record, say, by Student ID number. As far as I can tell the record is completely corrupted so I import a good copy of the record from a backup. Any ideas on why this is happening?

    • 4 replies
    • 7.3k views
  97. Argh, this is driving me nuts. I contracted a few people to put in data on to a spreadsheet in Excel, and now I'm trying to import this data in to the "LawCases" database, and for some reason, I'm able to import them fine straight from the excel file, but when I try to import them from another .fp7 file that I have imported the excel data in to (in order to mess around with the serial numbers easily), the damned thing keeps giving me this message! I'm able to do it from the "Clients" layout, and the BoxesMatters layout, for some reason, but not any of the others.. Please help, this could take days if I'm not able to mess around with serial numbers on a seperate fil…

    • 6 replies
    • 7k views
  98. If I have Filemaker 8.5 Advanced, am I eligible to purchase an upgrade to the regular version of FM 9 (not Advanced)?

    • 0 replies
    • 1.7k views
  99. I installed FileMaker Pro on a client machine and was able to connect to the databases on the FileMaker server database host. Everything was golden. Then, the machine needed to be reloaded (and we completely blew away and reinstalled everything). After I reinstalled FileMaker Pro, I could no longer connect to and see the databases on the FileMaker Server. For the life of me, I cannot figure out what has changed from the last load to this load. FileMaker Pro worked and still works on every machine we installed it on, but now, it doesn't work on any machine we re-load. The Firewall is off. OS is XP, both before and after re-load. We tried completely opening u…

    • 4 replies
    • 1.5k views
  100. Every time I quit my solution I several hundred of the following message when opening Console. iMac C2D, 2.16ghz, 3MB Ram, Leopard 10.5.3, FMP9 v.03. Also, the opening splash screen says FMP9 Trial. Yet Trial is not on my system and my copy of FMP9 is paid for and legit. Any help with either issue would be greatly appreciated. FMP9_Close_Error.pdf

    • 0 replies
    • 1.3k 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.