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. What is the key commands to pause or interupt a startup script /opener script? Or should you just delete the file and start again and insert a pause statement? Thank you.

  2. FileMaker Legacy fp3 and fp5 · Started by jimi,

    What is the advantsges/disadvantages when FMP is compared with VFP? -jimi

    • 0 replies
    • 834 views
  3. FileMaker Legacy fp3 and fp5 · Started by George,

    I have a flat application file that is related to itself based on a field (link) whose value is always "1". On the form layout view I have a portal with 20 rows on the left side and the individual record on the right half of the screen. I am trying to scroll through the list in the portal and click on a row and want the record on the right to go to that record. What is happening when I assign the portal field as a button with the goto related record script attached, the record on the right performs correctley but the portal jumps back to the first record and I want it to stay on the "selected/clicked on" record. Thanks

    • 4 replies
    • 666 views
  4. Is there a neat, free and simple conversion-program available (Somewhere ? Somehow ?) to convert my .xls-files (Office 97) to a FM Pro format for Mac :

    • 3 replies
    • 1.5k views
  5. FileMaker Legacy fp3 and fp5 · Started by jimi,

    IMHO, seperating database and program in different files causes less risk of data lost.. Would someone pls tell me what is the advantage of saving them in the same file as in FMP? -jimi

  6. FileMaker Legacy fp3 and fp5 · Started by danjacoby,

    So these folks say they need information in "CSV format, pipe delimited". What the heck do these terms mean? And can FMP accommodate them?

    • 7 replies
    • 1.1k views
  7. FileMaker Legacy fp3 and fp5 · Started by J.P.,

    I know that you can't modify calculation field. But, is there any other way of going around and modify the calculation fields?

    • 2 replies
    • 781 views
  8. I can't believe this is so difficult to find, so I hope I am just missing something obvious, though I've been searching web sites and news groups for hours. I have a simple "Price Book" database in FileMaker Pro 5 for Mac. One of the fields is a Text field with a "filename to a JPEG image". I simply want the browse screen to display the picture when a record appears (just like a web page would with <img src="mypic.jpg"> ). I can't seem to find anything to do this, INSERT PICTURE doesn't appear to let you specify a variable for the Filename. The ScriptMaker in FMP5 seems to be highly crippled, I can't manually edit any of the code to forc…

    • 6 replies
    • 1.1k views
  9. I'm having an awful time relating, and correlating the way that FileMaker Pro5.0, functions and it's terms compared to Access which is the Program I used for a database! Is it me or is it really minus some of the abilities of Access. I keep trying but, I am having an awful time understanding FileMaker Pros functions, and how they will work for me! If anybody knows both programs well, I could use help in a big way!

  10. I am trying to Match 2 fields from one database to a portal in another. I can do one or the other with relationships, but can't get it so that both fields in the new database have to match in order for the portal to show the data. Example on my job ticket database I have one field that asks for client, in another field I have a request for Job #. I want the other database to display all the jobs for that client and that job number in a portal. Seems simple but I have not figured it out yet.

  11. Hey people, need a little help if you have the time. I have to replace Microshaft Access here at my work. Does FileMaker 5 read these files?: If not what can? Can anyone answer this questions? Cheers from the Doc

    • 2 replies
    • 883 views
  12. You could just add 91 days. It won't be quite correct but maybe good enough. The next_rev field is a calculation field where the calculation is: last_rev + 91 result is a date.

    • 2 replies
    • 785 views
  13. I have a Master menu FM file with buttons to link to other fm files. The script opens the 2nd fm file and closes the menu and has the same procedure to go back to the menu file. However the script doesnt always work and open the other file. What is the best way of linking a menu fm file to a number of different files and back. Cheers

    • 4 replies
    • 671 views
  14. Do you know what the estimated limit should be on the amount of fields in one database? Is 130 too many?

    • 2 replies
    • 656 views
  15. I would like to create a database that will allow me to see the records running from left to right and the fields within each record listed below it. Example: (printed) If you were to look at a sheet of legal paper you would see four records going across the paper from left to right. Below each of the four records you would see seven fields (days of week) listed below it. I would like to have two weeks worth of information on one sheet of paper and it's easier to run the information vertical and not horizontal. Can anyone help? -Thanks

    • 1 reply
    • 617 views
  16. Hopefully someone can help me. I'm trying to breakdown film scripts by the Actors and their Chrono days in the script. I have set up each scene # as an individual record with Scene #, Location, Chrono, Roles, as fields, but when I try to place more than one actor in the roles field via a portal FM creates another record of the scene with just one actor. What can I do? I also want another lay out for each actor displaying only the scenes he or she is in and then be able to makes notes about that scene. Of course I would like all of this to take place in one main form and then filter out automatically. I'm new to FM so please be patient and fairly basic. Thanks for t…

    • 1 reply
    • 737 views
  17. FileMaker Legacy fp3 and fp5 · Started by danjacoby,

    The problem with posting on other bulletin boards within the FM Forums is that so few people check them. A client has FMPv4 on a PC running Win95. They need to upgrade their system software in order to use a new CD-R they've bought. Can they upgrade to WinMe and still run FMPv4, or do they need to upgrade to FMPv5?

  18. I have reciently installed a peer to peer network on two Windows 2000 systems. Now I am sharing my solution on this little network. I have gone through all the steps to share my files correctly (open file, hosts, etc...). Every thing is going great... accept when I proform a script (by hiting a button) that takes me to my Job Schedule which shows me all my jobs for today and the future. The script step is simply a Perform Find. Before writing this script I did the find that I wanted done in this script, which was >=// in the Job Date field. This has been working perfectly for about 7 years now. It still works perfectly on the host machien. The problem is that w…

    • 0 replies
    • 676 views
  19. I have an invoicing database with a parts file,invoice file etc. I have kept the rates by which items in the invoice are calculated in another Admin file with the rates as global number fields. Admin is related to Invoice by the business name and all has been well until I realized that when rates need to be changed they should be of a lookup type so that only subsequent invoices are affected by the changes. I've added new _rate fields in the invoice file that are set to lookup the global in Admin. All are of type Number and I've read all I can find in my docs, but no values appear in the new _rate fields. Are globals not allowed to play that game? Thanks Bill Jayne…

    • 4 replies
    • 539 views
  20. I am trying to find a range of dates automatically in a script. When I execute the script I get a question mark in the date, and a statement that no records match the request. The script reads: . . Enter Find Mode [] Set field ["date","Date(Month(Today),Day(Today-5),Year(Today))..Date(Month(Today),Day(Today),Year(Today))"] Perform Find [] How do I go about scripting this to find the last five days?

    • 2 replies
    • 1.1k views
  21. I have a list of 1000 potential jurors. I need to be able to select, say 100, random jurors and put them into a separate database. Eventually, the unused jurors will return to the 1000 potential jurors. I have tried using RANDOM but the Random field must be able to be recalculated at will and also I can't get it to create unique integers. (Geaorge, I sorry. Ididn't explain myself very well.)

    • 4 replies
    • 760 views
  22. I have spent most of today on this scripting problem and have not found the answer either in my mind or in this forum. I need to identify records in an inventory database. I have a field for 'date last sold' and 'date last received.' I need to find stuff where both of these field are more than a certain number of days. Like for instance, stuff we haven't received or sold for 90 days. I want to make this a variable report, so the report generator can put in the number of days and the date they want to count from. So far, no problem, just use a couple of global variables and an entry screen. Here, however IS the problem: I want an expression in Find mode like: date receiv…

    • 3 replies
    • 842 views
  23. FileMaker Legacy fp3 and fp5 · Started by RTH,

    Hi. I'm building a solution for my clients and I was thinking how could I make some kind of master file that's store the company's name, logo, home address, telephone number etc. that is used then in related files, printouts etc. Is it possible to use global field? Thanks, ------------------ Reynir

  24. In my bound solution I've included both an "About" script and a "Help" script. The "About" script works beautifully. The "Help" script works -- once. Then, when I close the Help file, the "Help" menu choice disappears. Even when I'm working from the main file, which is always open. How can I keep the "Help" menu option available after closing the Help file? As I said, the main solution file is always open, so that's not the problem.

    • 0 replies
    • 646 views
  25. FileMaker Legacy fp3 and fp5 · Started by MEG,

    I have come across a problem in my database that I did not foresee. Each product has a set of "testing areas" that we need to watch for. For example "Product A" has 4 testing areas that may fail. So when you are entering information for "Product A" and "Test 1"fails you need to enter the number of product A's that failed in the "Test 1" area. Down the road as a "Product A" changes it's "Testing areas" will change. What is the best way to set this up so that when "Product A's " testing areas change, I can make the changes to the "Testing areas" and the old records will stay the same?, and the old reports will stay the same? Basically, I need to be making changes to …

    • 3 replies
    • 634 views
  26. How do I get the data that's in a portal to display in another field as a drop-down menu value list? Thanks!

    • 3 replies
    • 1.2k views
  27. FileMaker Legacy fp3 and fp5 · Started by ttinsman,

    NEVERMIND WE SEEM TO HAVE TO MANY MACINTRASH USERS HERE. Besides i figured out my problem. [This message has been edited by ttinsman (edited March 07, 2001).]

    • 0 replies
    • 563 views
  28. FileMaker Legacy fp3 and fp5 · Started by MEG,

    THANK YOU VERY MUCH FOR THE INFORMATION YOU HAVE GIVEN ME. I HAVE RUN INTO A NEW PROBLEM. I CREATED MY RELATIONSHIPS AND LOOKUPS AND I NEEDED TO CREATE SOME FORMULAS IN MY REPORT TO GRAB THE APPROPRIATE INFORMATION. I AM NOTICING THAT WHEN IT GRABS THE APPROPRIATE INFORMATION FOR THE REPORT IT WILL SAY 4 RECORDS FOUND AND YOU PAGE THROUGH THEM AND IT IS THE SAME RECORD AS THE FIRST. EXAMPLE - I SEARCH FOR PRODUCT "Z" THAT WAS COMPLETED IN MARCH. THE TOTALS GO INTO THE APPROPRIATE AREAS FOR MARCH BUT YOU HAVE 4 RECORDS FOUND, ALL THE INFORMATION STAYS ON THE FIRST RECORD. WHICH IS OKAY UNLESS PRODUCT "Z"'S "TESTING AREA" CHANGES IN THE MIDDLE OF THE MONTH. ON THE R…

    • 3 replies
    • 757 views
  29. I have two databases. Each record has a number in both databases I want to write a script that will take a number from the fist data base and preform a find in the second data base.

  30. I am currenting using email to transfer files to outlying associates. I am doing this interactively. I want to automate the process. The problem I am having is in creating, automatically, a file id. My thought is some sort of concatenation of my id, month and day, and associates id. For instance, HMH0413XXX would be the id for a letter from me on the 13th of April to XXX. Can anyone tell me how to do this through scripting.

    • 3 replies
    • 759 views
  31. I am using a calculated field to build a filename. I now want to use that file name in an export specification. I want a script to copy the filename from the calcuated field (have been able to do that) and then paste the name into the export file. Then the script should be able to cause the export scripting step to complete itself without operator intervention. I have been able to copy the name into the clipboard, but I have had to use the CTRL-V keystroke to insert the name at the export filename spec, and then press the enter key until the export is completed. It is really not too complicated, but I am trying to get it to complete itself so that other operators wi…

  32. When trying to insert picture into a container field, I received an "error -43 occurred during initialization of Claris XTND System" msg. I've checked the technical q/a at filemaker.com but couldn't find any reference to this. Anyone have any suggestions for a possible solution? Thank you.

  33. FileMaker Legacy fp3 and fp5 · Started by jacger,

    Fairly new user of filemaker. Transitioned from old Q&A (dos) and currently Access 2000. Would like a suggestion for reference which goes into detail with scripting. Thanks. HHill

    • 4 replies
    • 713 views
  34. Patience please ladies and gents. 1. When I import a jpeg image into a container field (as a reference only) there appears to be a limit on the image size apr 2megs; much larger and jpeg error #53 is returned. Is this correct? If so how do you reference and therefore display larger images? 2. Anybody fancy giving me a laymans/idiots guide as to how I would open the images, as per 1 above, in photoshop or similiar. I am using macs. When I say idiots guide I really do mean idiot. Thanks in advance for your help Regards Lawrence/Anne

  35. Who can help me by telling me the possibility about communication between FM Pro and an LDAP server? It's realy very important and urgent. Thanks in advance Eve SilverTop.fp7.zip

    • 1 reply
    • 1.5k views
  36. Here is the situation (please help!): I am running a mac using system 9.1 (with 256mb of RAM), fmp 5.0 with latest updates, and AOL 5.0. About 75% of the time when I am in AOL mail and I return a fmp database, fmp crashes with type 2 or type 3 error. I thought this was possibly a memory starvation problem so I set fmp's memory in Mac os to 30mb then 45mb then 60mb. Situation the same. I then reinstalled both AOL and FMP (first AOL, then FMP and then vice versa). I ripped out preferences, fonts. etc. No change. If I change the memory allocated, it sometimes works for an afternoon and then back to the same situation. Any advice. This only happened since I change to versio…

  37. We have a client who have a performance problem with there new computer Dell Optiplex pentium III 800. They installed FMServer 5 and FMP 5 on the same computer (using WinNT workstation). When they access to the server via the LAN their is no speed performance problem but when they access via the FMP installed on the same computer it is VERY, VERY, VERY SLOW.... Any idea of what is the problem : By the way, the FMServer console open but is not working, any idea :

  38. how do I make that performs an external script? (like run a script in another file)

  39. FileMaker Legacy fp3 and fp5 · Started by juanito28,

    I'm just starting with FileMaker (5.0) and cannot find in the help how to size new layouts. The samples files provided are nicely built layouts with that standalone look. But when you start a new layout and add fields to it, the page is like a humongous spreadsheet (in layout mode) - you can scroll right and down almost indefinately. And there are no right or bottom borders you can grab and drag to size the layout. So how do I do it?

  40. I have 4.0 & 5.0 question... I am using the program to invoice customers...My invoice records have customer i.d., date, labor, materials... labor and materials are repeating fields... I am interested in creating a layout so that I can look up all materials for one client in one form... all i can do now is create a layout showing materials but it is separated so that each record for a particular client has repeating fields... I was to create a layout so that I will be able to show all materials on one form for one year for one client (though the client may have 14 records with 10-15 materials on each record) Also...when I try to export the repeated fields (mater…

  41. I want to create a field that would always add the number preceding it, the field would be cumulative. Is this possible and if so , how do I proceed. This field would be part of a timesheet and it would add time spent on projects by different employees thanks Gary

    • 2 replies
    • 646 views
  42. FileMaker Legacy fp3 and fp5 · Started by Rhagerma,

    I am trying to get a script to work. I have several databases tied together (relational) and I want a button from one layout in a specific database to bring another layout on a different database. I keep trying with no success. Can anyone help?

  43. I'm looking for the FMP3 buttons... the ones that came with the program. i have them on a CD, but since i have FMP5 on my computer, it won't read the CD (at least, i think that's why). All i want are the buttons file for a database i'm currently building. does anyone have this file they can email me?

  44. FileMaker Legacy fp3 and fp5 · Started by Carlosmc,

    I'm not sure if I neeed a script to do what i want to do.. Basically i have 2 feilds a (Date feild) and a (week no feild. Is there a way I can make the Week feild know what week it is in the year by looking at the dat. is there a script of some sort to do this. Cheers Carlos

  45. Apologies if this has been around before, but I can

    • 10 replies
    • 776 views
  46. I have recently been asked about using FMPro in an enterprised environment (Oracle etc) Lots of Acronymns where thrown around like COM+ and EJB,R3 etc which mean little to me at this stage. What I would like to know is does anyone know where i Can go to see how FMPro can be used with these larger systems and what the pitfalls might be. Cheers in advance

  47. FileMaker Legacy fp3 and fp5 · Started by jimi,

    5500*0.0157 should be exactly 86.35 right? but in FMP it gives me 86.349999999999999 where truncate(num, 2) will be 86.34, I have tried to round it to 3 dp b4 truncate, even tried to change the round result to text and then back to number for truncating, it still gives me 86.34 how can I fix this error? -jimi

    • 5 replies
    • 814 views
  48. FileMaker Legacy fp3 and fp5 · Started by jimi,

    Are there any script to close the whole File Maker Pro application but not only the files? -jimi

    • 2 replies
    • 733 views
  49. FileMaker Legacy fp3 and fp5 · Started by Savako,

    I want to disable keyboard shortcuts within a particular layout for security purposes. In particular Find, Print, Delete. I'm currently using fp3. Any suggestions would be appreciated. Thanks

    • 2 replies
    • 733 views
  50. I've read on line at Filmaker.com that those who have FMpro v2.1 can get an up grade to FMpro v3 which is y2k ok. But when I called their 800# all the gal could tell me was I couldn't get the full version of FMpro v3,only some upgrades. She didn't know what upgrades ment, v2.1 to v3 or for v3 only? I don't want to shell out the bucks for FMpro v5 until I play around with what I already have. FMpro v2 works and I don't see any y2k problems ahead unless I'm wrong. Anyway how long will FMpro v5 be good before. I'm upgrade poor as it is. Thanks for any help. Ed...

    • 3 replies
    • 625 views
  51. How can I move or copy the first 100 records to a new database file?

    • 3 replies
    • 674 views
  52. I'm working on a database file where each layout window size needs to vary. Can windows in each layout be sized so when navigating using buttons, each layout displayed will have it's own size? Thanks.

  53. So this Windows95-based client has to upgrade their OS in order to hook up a CD-R. The question is, can they upgrade to WindowsMe and continue using FMPv4, or do they need to stop with Windows98? And is Win2K even an option here?

  54. I have a field that is called zip code which some records have zip only and others have a space then zip + four. I can perform a find on the records to just locate the zip+four records, now I want to move only the last four numbers to a new field and leave the five zipcode values in the field. How can this be done? Thanks

    • 2 replies
    • 591 views
  55. -I want to design a layout to display a 3x3 grid of cells, each cell representing a position in a storage box for sewing buttons. -Each record will contain 9 fields, one for each cell of the storage box plus a field indicating box number. -Assume I have the contents of 10 button boxes entered into 10 records. -How do I search for all "blue" buttons and display for each hit, the corresponding cell contents, grid position, and box number in a spreadsheet-style layout? Alteratively, how could I do the same thing using a unique record for each cell and still easily display the box view showing its contents and easily print a catalog of the 10 box views? Thanks for any…

    • 5 replies
    • 2.3k views
  56. I have a file "invoice" which store the main info of invoices(such as customer name) and another file "invoice txn" which save the content of each invoice (such as item purchased). In an invoice, for each item in Invoice Txn, I have to run some script and decide whether I need to keep it in another file "invoice item" If all above processes are run thr' a LAN, would it be greatly slowered because of the repetitive process? (for me it's more than 10 times slower than run in server) thx for any suggestion

  57. FileMaker Legacy fp3 and fp5 · Started by steVen,

    I have two Macs networked. How can I prevent people from closing windows on the host machine. I try to have them always hide but they close out of habit. I also need a script that will open all the files I need then hide them all. I created a script that open, hide, open, hide but it doesn't work. It only opens all the files. And lastly. . . How can I have the guest machine automatically open a file from the host? ...steven

    • 4 replies
    • 806 views
  58. FileMaker Legacy fp3 and fp5 · Started by yafreax,

    quick question hope someone can answer: anyone have any experience integrating quark xpress tags (a semi-scriptable page layout program) into filemaker? tia jeremy ------------------ Life's great when you're a millionaire. . . well, ya know, i'm assuming.

    • 5 replies
    • 800 views
  59. I am attempting to route output from scripts to various printers. Can I accomplish with Filemaker or will I require a plug-in to do this?? Thanks.

  60. Can I write a script which opens another database and then searchs through this database for a record

  61. Hello, I'm trying to figure out how to determine how many of a unique item occur per category, using the following sample database: Bank Park Chase Everglades Mellon Yellowstone Mellon Everglades Citi Central Chase Everglades Mellon Central My goal is to set it up so that I get the following info: Bank Mellon 3 Chase 2 Citi 1 Park Everglades 3 Central 2 Yellowstone 1 I'm using FM 4.0 and tried doing this with subsummaries, but things never work out correctly. I've been using FM for awhile, but only sporadically and still consider myself to be a newbie. For the past two days, I've been struggling with this problem (and the manual)…

  62. I need to export records from one file to another. Unfortunately, the records are being exported out of an FM 5.0 file and they need to be imported into an FM 4.1 file. When I try to do this I get a message that reads the files cannot be read. Is there any hope? Thanks

  63. Hi, the connection between the FileMaker Pro and ASP was solved. But I encountered another problem. I can only display text data in the web browser but display "rubbish" for the image, e.g "???A[]AA". The data is retrieved from FileMaker Pro database and I use dreamweaver ultra dev to display the data in the asp form.

    • 0 replies
    • 631 views
  64. My script is complicated because this test doesn't seem to work: IsEmpty( Status(CurrentFieldName) ) Am I asking too much?!

    • 4 replies
    • 829 views
  65. I'm having some terrible problems with filemaker pro 4.1's internally stored record numbers. My understanding of this special record number field is that Filemaker is supposed to generate a new unique value for it for every record that gets created in the database. I also expect it to increment serially through the entire life of the database. But instead what I see is that when a new record gets created, sometimes the record number for other records in the database get "pushed up" by +1 and the new record is assigned a previously used record number. Example: John Smith=1 Bob Jones=2 Lisa Clay=3 Tim Riley=4 Create a new record: Sharon Taylor You get: John S…

    • 3 replies
    • 802 views
  66. I have created a page that will reside on our www site. This page will be used to input customer info. i will then want it to be downloaded to my fmpro file that resides on my network here. Can someone give me some help doing this or can you point me in a direction that will help me out. Thank you very much. ------------------

  67. I have a button in dbs #1 that opens dbs #2. Is it possible to have it also make dbs #2 the active window? TIA, Bill

    • 2 replies
    • 694 views
  68. RE: My earlier 4.0 vs 5.0 question. I have several users who need to buy 4.0 and can't find it anywhere. If we can't find it, looks like we will be forced to upgrade everybody to 5.0. In my user group that'll be about 20 clients plus the server creating a budget crunch. Anybody know where I may buy 4.0? Thanks

  69. Hi, may I how to open a FileMaker database connection in ASP? Another question I would like to ask is that, how does the ODBC FileMaker Pro driver know which FileMaker database to connect to when only the datasource name and description is specify? Is it that the datasource name must be similar to the database name? Thanks.

    • 0 replies
    • 679 views
  70. Hey, All-- I'm sorting a portal row by the Creation date descending. The relationship is set to allow creation of related records. This brings the latest dates up first, however, the blank record is still at the bottom, and is frequently hidden below the scroll. Is there any way to have the blank record appear first, st the top of the portal? Thanks Jeffrey Ellis

    • 2 replies
    • 764 views
  71. I have a database which stores the paths to high quality images. The number and size of the picyures makes storing them directly impractical. Is there any way to show the path to the picture without having to manually input it. Obviously FMP knows where an image is. How does one display that information? TIA, Bill

    • 0 replies
    • 642 views
  72. Am attempting to build an automatic online email database where web viewers enter their email to receive monthly newsletters via email. Which Filemaker product should I look into? Too many options for this newbie and I don't know where to begin or what the correct term I should be using when I speak about this email database. Any advice or resources would be greatly appreciated.

  73. I am using FM5.0 and would like to be able to publish my database to my website's server that is not located at my ISP's server. Specifically, I want to be able to send it to tripod.com or zkey.com. Is this possible? If so, how? THANKS anaserene

  74. I'm new to FileMaker so I may be way off track, but here's my question: How does FileMaker know which file to open if multiple machines are hosting files with the same name? We have FileMaker Server 5 and it is hosting a file named "Y2K". As a test, I created another multiuser file named "Y2K" on my client PC (with totally different fields). I tested a script which uses the "OPEN" statement and it appears to open the first file named "Y2K" (which happens to be on my PC, not on the server). What this means is that now that we've had to put a fully-capable client on each user's machine, any user could potentially screw up existing scripts, etc. by simply creating and hos…

  75. FileMaker Legacy fp3 and fp5 · Started by barcab,

    Does anyone know of a database or template that tracks vacation. We have 350 employees and are currently using FM5.0 to keep track of other employee information.

  76. I have managed to connect to an FMP db from a VB 5.0 program using ODBC. I can create a recordset and read the data. The question now is how do I write to it. I have the options set in the program to open the recordset to allow read/write but that apparently doesn't matter since as soon as I issue an Edit command I get an error indicating that the recordset is read only. What am I missing? Is there some setting in FMP that might be wrong? As always all help will be appreciated. Dave [email protected]

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

    I would create a calc field that returns the month and year of the date. Then create a layout with a sub-summary part when sorted by this new calc field. Next, do a sort on that field (and any other fields you want, such as "Product", "Customer", etc.). Then create a script that sorts, goes to the layout with your new sub-summary part. Note: The sub-summary will only show up in Preview mode (or when you print). HTH, Dan

    • 2 replies
    • 832 views
  78. FileMaker Legacy fp3 and fp5 · Started by yalcin,

    Hi folks, We have a File Maker server behind the firewall. I want to host with TCP/IP but I don't know which port(s) should be open for this. Thanks for your help, Yalcin

  79. FileMaker Legacy fp3 and fp5 · Started by Carlosmc,

    I am running a filemaker database from a server and giving access to users to log in via a web browser. All this is working fine, but when they log in the web page has <align> tags all over the page. For some reason if you log into the databse via a web browser on a PC it looks fine, using the same web browser on a Mac and the database is distorted. Does anyone have any ideas. Much appreciated. Carlos

  80. FileMaker Legacy fp3 and fp5 · Started by SNSpix,

    When importing JPEG pictures into a container field in File maker, there is an error saying "JPEG Error #53" Can anyone help with this? The error is shown with larg meg size pic is being imported. However the manual states any size can be imported. Any help would be good.

  81. i was wondering. it says you can build royalty-free runtime solutions. does this mean you can build a program that will run just like filemaker, but for a single database? and can i still use all my scripts? and how many computers can i have this runtime application on? ------------------

  82. Please Help! In my database I have several questions that use radio buttons with value lists. I would like to figure out how to display the total number of specific responses for each value from the list. So if I have a possible response of YES, NO or MAYBE.. I would like to have a results page display how many people chose YES, how many chose NO and so on. ANY HELP WOULD BE GREAT! I cannot seem to find this in the books I have.

  83. Hi- I am having a problem thinking of a way to list all of the managers for a department for each page. (There are hundreds of departments). The current page break is department but each department contains multiple managers. Currenty, Filemaker is only listing the first manager on that page instead of all managers. Is this possible in FileMaker. I can't use a global field because the information will change for each page. Please help. Thanks in advance for any response. Thumperman

  84. FileMaker Legacy fp3 and fp5 · Started by beenet,

    Hi, I'm looking for a method to generate random PIN numbers. These PIN numbers will be used to access a secure site. Question: How do I create a field that generates a random number (lets say with 5 digits?) For example: 47618 Thanks.

  85. In contract db I calculate monthly sales. In find mode I select individual sales rep to calculate monthly sales for the rep. Now I want to run a report for all sales reps showing their individual performance. I would like to save the reps monthly actual in the rep db where there is a record for each rep. Of course there is other stuff like quota and year to date actual versus quota that I think I can handle.

  86. FileMaker Legacy fp3 and fp5 · Started by Yeti,

    On the invoice layout are number fields, for financial stuff. I need to make these number fields accesible for letters (PM: Pro Memory). I know this is not possible. I could change the numbers field to text, but then I'd loose the way numbers are displayed (Fl xxx,xx) I tried placing wo fields on top of eachother, one text and one number field, but how do I make sure the number goes in a numberfield and text in an text field. Or is ther another way to solve this? Hope I made myself clear.... ------------------ Yeti

  87. FileMaker Legacy fp3 and fp5 · Started by Maxwell Morlay,

    Members of my user group are rushing me toward adopting FM 5.0. I was told that we could stay with 4.0 because we have a small network of users, and 5.0 was mainly for internet compatibility. Should we go to 5.0 regardless? Thanks.

  88. I want to know if it is possible to make a data base run indepedently of the File Maker Application. (Like compiling for Computer code)

  89. Hi All! I have a problem converting an FM3 database to version 5. I have a text fields, which contain non-English (French, for example) text. Conversion to FileMaker version 5 destroys almost all accented characters. The only solution I know is to export all data from FM3 and import it into FM5 converted file. Perhaps, there is another (more

  90. Hi, I am in serious need of a FilemakerPro5 database programmer. This is a very good opportunity for the right person. If you want to work on a contract for 6 to 9 months at Apple Computers in Sacramento. Let's talk. This is a full-time position on site. ------------------ Terri Holub Technical Recruiter [email protected]

  91. I can't seem to be able to do this in the layout. Is there anyway to put this on the layout so when I print reports with multiple pages, it will display page 1 of 3, 2 of 3, 3 of 3, etc. Please help. Thanks! Thumperman ------------------

  92. From previous responses, thank you very much, I learned how to take info from one DB which had an active and inactive field to show only active customers in a pop up menu in other DB's. New question: If there a way to show active items from 3 different DB's in the same pop up menu: example I have a JOB db which has job numbers and I have a SERVICE DB which has service numbers. Can I make a pop up menu look for active service #'s and active job #'s and disply them in the same pop up menu? Thanks in advance

  93. I'm creating a Sales/Contact Dbase and want to write my docs in Word (mac). Can I link specific docs to specific records and possibly access the docs through FM. Maybe a script that accesses Apple script and opens the doc? Is there a built-in way? They advertise seamless integration w/ office, but I don't see it.

  94. Any recommendations for easy faxing from Filemaker 4 using Windows 98. I used to do this very easily on the Mac using global village fax software - just hold down the apple key and file print turns into file fax. No such luck on new PC software it doesn't recognise Filemaker 4.0 at all. Any suggestions would be much appreciated

  95. The conversion seem to go smoothly. However, the formulas didn't seem to make it. creating the formulas across are no problem. Can't figure out how to create formulas for columns. any suggestions> ------------------ -------------------------------------------------------------------------- Phillip M. Jones, CET |MEMBER:VPEA (LIFE) ETA-I, NESDA,ISCET, Sterling 616 Liberty Street |Who's Who. PHONE:540-632-5045, FAX:540-632-0868 Martinsville Va 24112-1809|[email protected], ICQ11269732, AIM pjonescet -------------------------------------------------------------------------- If it's "fixed", don't "break it"!

  96. Sorry for the incredibly basic question. I am very new to FM. Bear with me as I get up to speed. What is the proper way to make FM go to the beginning of the first line in a large text field? Is there a sendkeys equivalent in FM?

  97. FileMaker Legacy fp3 and fp5 · Started by dtrots,

    I was wondering if you can do a calculation and after the calculation is performed it stays unique to that DB. Example: I have an employee database which has a "hourly rate" field. I also have a timesheet DB that looks at the employee "hourly rate" and calculates the hours work times the rate. If months later I want to increase the hourly rate I do not want it to affect any previous timesheets, just the new records. Any help is appreciated: Dave

  98. Running FM unlimited 5v3 WebCompanion v6 G4 450 256Mo Web Security 1 open Database I was running Filemaker unlimited for a couple of months without any problem, but since last week, Filmaker quits several times a day, for any reason with error 2, 3, or 10. I've tried to re-install it, scan disk, change computer, rebuild the database (export data, create new bank db and reimport), changing IP ports. It's crazy, the problem remains I wonder if I'm a victim of kind of pings attacks or something. Is there a security problem with this solution ? Thank you for your help.

  99. Using v3.0v6 on NT I'm trying to print a total at the bottom of the last page of a report. I have used the suggestion found in the support database--Adding Continued on Next Page Formatting to Reports--by creating a number field, a calc field comparing the number field to the current page number. Then setting the field in a script. The problem is the report looks fine in preview mode, but when I print it still puts the value on every page. Suggestions?

    • 3 replies
    • 825 views
  100. FileMaker Legacy fp3 and fp5 · Started by lop,

    Is FM3 server compatible with OS 9.x?

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.