FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
I need a layout to act as a spread sheet for data that would be imported into a form. if that doesn't make sense let me try to break it down. at my work we have these incident reports we have to fill out when there is an injury to a customer. every week those reports get tabulated and put into a report. what i would like to do is have the incident report in file maker along with a spread sheet that would keep a running total of what injuries are seen. so let's say that we have 3 wrist injuries, 2 upper leg injuries, and a neck injury; each injury would get its own report but then there would be a main page that would tabulate how many injuries we saw that week. i ho…
-
- 2 replies
- 990 views
-
-
We are planning to develop a specialized/expanded version of Biz Tracker for our business. It will run on our all-Mac network. However, our programmer wants to develop on his Windows PC. How would be transfer his work, and ours, back & forth during development? This is not clearly addressed in the FM Docs or Help files, although much is made of the "cross-platform" capabilities. Information on this would be greatly appreciated!
-
- 8 replies
- 2.4k views
-
-
Is it possible from within a script to show a calendar type entry and let the user select the date from it and then use that date variable for a report. And continue the script of course... Merry Xmas
-
- 0 replies
- 877 views
-
-
Hi all, "older version" hold out here. : I have an iMac G5 and installed FM3 on it. I can log onto our server using the "hosts" command, and I thought all was well. We have a button to "print p/u" sheets which changes layouts, updates a last order date etc. When I click this, the printer's icon in the dock opens, but nothing prints and it doesn't show a print job in the printer's status window. If I use the File>print command (changing the layout manually etc), it prints fine. Two different printers same result. Works fine (as always) on our OS 9 machines. Any thoughts?.... other than upgrade to FM8 :
-
- 2 replies
- 1.4k views
-
-
Help my Filemaker 8 files are getting to huge file size wise. Example I have a picture database with images imported as small little 156 kb file images jpg.. But the database file is now at 200 megs with only 78 images in it. Even if I make a copy of the file and delete all records and close the file and check the filer size it still retains the file size with zero records.... Soooo, how can I either clean up the file. Or make a duplicate with no records and data in it just the interface and databases ....
-
- 4 replies
- 1.1k views
-
-
So, what we really have is FileMaker Pro 7.5 not 8. What's your complaint?
-
- 52 replies
- 7.7k views
-
-
I'm trying to store a FM8 file on a Mac OS X disk image (.dmg file). When I open the file from the mounted disk image and try to edit/add data, I get the error: "There is not enough room on the disk to complete this operation. Make more room on the disk, then try again." There's plenty of room (ten megs for a 68K file). It makes no difference whether the disk image is encrypted or not. I get the same message in FileMaker Developer (FM7) and FileMaker Advanced (FM8). Anybody else run into this problem?
-
- 1 reply
- 1.7k views
-
-
I have 5 versions of FMP5 and just received an upgrade for FPMv8. To my horror it is only valid for FMPV6/7 Any recommendations on what to do from here? Obviously I cant by V6...nore can I return V8
-
- 1 reply
- 1k views
-
-
i wana offer fmpro 8 to omebody, he asked me "whats the fmpro8's real database server. what do i answer to him?"
-
- 5 replies
- 985 views
-
-
i have just purchased an MSI M610 laptop and connected that to my desktop (both XP Home) using WLAN 802.11 B/G The network works fine both file sharing and internet access. However I have installed FMP 5 and 6 and they both load up fine but as soon as I try open a new local file or a passworded hosted file the system asks for my password then I get the squiggle cursor then I get an Application Error faulting mode fmcor10.dll - every time. Strangely I can open a non passworded remote hosted file OK
-
- 3 replies
- 1.3k views
-
-
I need help. I have purchased a copy of FMP 6 UL. I want to use the WSC with Webstar 5.4. I have installed WSC following the instructions. My problem is I do not know how to make it connect to Webstar. I do not know where to put the CDML files for them to be handled by Webstar. Cannot find any litterature or instructions on it. Please help. Thanks Aerocan
-
- 3 replies
- 1.9k views
-
-
I am using Office 2004 for Mac. Will the data merge manager in Word recognize a FileMaker Pro 8 database or does the data need to be exported? My Pro 8 database is greyed out when the data source selected is filemaker pro and the choices appear. Thanks, jacob
-
- 3 replies
- 900 views
-
-
I designed a very useful little database that kept track of the Properties, Owners, Tenants. This information was great in the beginning but now we would like to keep track of tenant payments, security deposits and also add a module of Work Orders for the maintenance. I have a tab with the tenant information on it and would like to have on that same tab information about their payments. Just not sure where to start. I have included a sample of the database, so far as I have. Thanks in advance for any advice NEM_Copy.zip
-
- 0 replies
- 4k views
-
-
I'm running FM v 4.1v1 and am having trouble keeping the window of my main file maximized. I have tried putting Toggle Window [Maximize] script steps in the open file script and none others but as soon as another script changing layouts is run the window de-maximises. I have tried putting Toggle Window [Maximize] script steps in the scripts changing layouts but the first time that these scripts are used upon opening the file, for some reason the window still de-maximises. I'm also having an issue during a pause in a script (to choose an option from a pop up menu), once the option is selected (before choosing Continue) the window demaximises! Is there …
-
- 4 replies
- 2.1k views
-
-
When I try to open a file in Filemaker Pro 8 by double-clicking it or dragging it to the Filemaker icon, Filemaker starts, but the file doesn't open. If FM is already open, double-clicking the file works as expected. This is a new install of FMPro 8 on Mac OSX Tiger.
-
- 5 replies
- 921 views
-
-
Hi all, Does anyone know how to make Data Viewer show invisibles (like carriage return symbols) in its Results window? Specifically, what I'm trying to do is see if I have carriage returns where I don't want them in a return delimited list that's created by parsing data from a Value list. I'm currently using a Script Variable to hold the results but I'm still having to set a global field to the variable's result to view unwanted carriage returns in it. This works but it sure would be nice to use the Data Viewer instead of a global field I've dragged onto a layout just for data viewing. Thanks in advance!
-
- 3 replies
- 1k views
-
-
I installed FileMaker Pro 6v4 on a US English Win XP system. In FileMaker, a UKEnglish dictionary is selected. I don't know why it takes UKenglish in the first place. Therefore, I choose in Filemaker as main Dictionary USEnglish. When I exit FileMaker, and start it up again, the UKEnglish dictionary has been selected again. Why doesn't FileMaker remember this? Is this a bug? thanks in advance, dbasine
-
- 1 reply
- 1k views
-
-
Is it true that Filemaker 7 doesn't support the scroll wheel on the mouse? I need a way to scroll through those big data fields that have a scroll bar on the side. I can't even see the contents scroll by when I hold and drag the scroll bar. Has anyone found a way to fix this?
-
- 1 reply
- 1k views
-
-
I'm looking for suggestions on how to trap for a loss of connectivity in FM 6. I have a set of local files and a set of served files. While running a script in the local file, it calls an external sub-script on the served file. I would like to make sure that these changes (from the external sub-script) are being made and that WE KNOW if connectivity is lost either during or after the external sub-script is run. I have the Set Error Capture on currently. What happens if I decide to put If (Status (CurrentError)=100... in the inital local script just after the external sub-script runs? Greg
-
- 0 replies
- 1.1k views
-
-
I recently purchased a copy of FM Pro 6 to update my old version 4 software. I have installed my software into Mac OS X (Panther) and everything is OK, but I want to make sure I have the most recent updates. (Looks to me like the 6v4 file is the most recent - but I could be wrong.) I can't find anything but version 7 updates on Filemaker's website and all other searches have proved fruitless. Does anyone know of a link where I might download the most recent updater for FMPro 6, or could someone be kind enough to email it to me? -TIA
-
- 1 reply
- 1.1k views
-
-
Hi there, I'm trying to allow a user to select multiple entries with one title - ie, selecting Depression would highlight Depression, Mental, and Mental Health in the database. It's in a select statement. I tried Depression but that didn't work. Can you help? Thanks! Sarah
-
- 2 replies
- 901 views
-
-
Hi, I've got data corruption on a large file. I started the file in 1989. When I script a search for a date field, it brings me febuary insteat of november. I recovered the file with the recover tool in FM 6.0 and it brought me the following result :2 field values ignored. I tried my search script after recovery but it still does not bring the correct result? What should I do. Should I keep the pre recovered file instead of the recovered one( back in older versions, I know it was not recommended at all to use recovery except for last resort situations which is not my case right now although I would love this problem to go away). Would a migration to filemaker 8.0 w…
-
- 4 replies
- 1.4k views
-
-
So, this is a seemingly simple problem w/a seemingly simple solution, but... After having not used FMP 7 on my PC for about a week (running XP service pack 2), I tried to open the application yesterday afternoon to create a new database. FMP 7 begins to initialize, but after about 5 seconds the splash screen goes away and it fails to launch and dies on me. The application never actually opens. By the way, I'm running FMP 7 v1a. I don't get an error message to led me to a certain spot, so I've tried to alleviate the problem by rebooting, de-installing the software, rebooting, re-installing the software, running multiple virus scans, running rootkitrevealer, an…
-
- 3 replies
- 945 views
-
-
Greetings all I seem to be encountering a reoccuring problem with indexing. I would like to know if anyone is experianceing similar problems. In general our problem consists of a several oddities all relating to indexed fields. I have an inventory solution in which we capture a large bit of information regarding our material. I see reoccuring problems when personnel search for material based on a Tag #, Location code, modification date and user. all fields are set to index all. (this does not mean a searxch is done on ALL fields at once. it can be a combiniation of these fields or a single one) This has not been a problem in all previous versions of FM we …
-
- 6 replies
- 1.4k views
-
-
When moving some datasets from Filemaker 6 to 7 to 8, I noticed one "feature" that no longer worked well in 8. I have a script makes a DDE call to an outside application-it turns out that it does not matter which application. The script has a loop and depending on the data it has to work on, will make make a DDE call for each record-which could be hundreds if not more calls. After exactly 128 DDE calls, the DDE function stops working. You have to exit FPro 8 in order for it to work again. Flushing the cache, puttting a pause in the script, exiting the script, making a DDE call to a different application has no effect. Only exiting the app does. This was never an is…
-
- 3 replies
- 1k views
-
-
My pc crashes when I delete a single or multiple records in FM 7 and DEV 7. I have tried same on 3 different pc's with same result. Version 7.01a, is this a bug? File has 2 related files and only 80 records. Don
-
- 5 replies
- 1k views
-
-
I posted this earlier but have yet to get a response. I have a text field that stretches 7 pages on a layout. In FM7 I have no problem with this. In FMP8 there is a terrible delay between pressing a key on the keyboard and when the letter actually shows-up on the screen. Anyone else notice this problem? I have reported this to Filemaker but have yet to get a response. I have attached a sample file. KeyDelay.zip
-
- 8 replies
- 1.3k views
-
-
I have 4 databases and if they close i need to come up with a script to open each one and input the pass automatically and open it again. How would i go about doing this? any help would be GREATLY APPRECIATED. Thanks in advance.
-
- 3 replies
- 1.2k views
-
-
Hi... It is possible to open more than two files in File Maker and switch to one and to another by pressing ALT+TAB (like the explorers in Windows)? I want to open two File Maker files, but I don't want to open those windows inside File Maker, I want to open separated, making possible to switch to both by pressing ALT+TAB. Thank you very much.
-
- 0 replies
- 954 views
-
-
Our IT director set up an install script so that all our employees would have to do is double-click on the Pro 8 set-up file and pick English for the language. We are in a testing period with approx 10 individuals and the install when fine for 6 of them. The others receive an error message that basically states "FileMaker can not be installed or uninstalled on this version of Windows". I run XP Professional and can install fine but others running on the same can not. What's going on?
-
- 6 replies
- 923 views
-
-
I have a field that is specified as a button. When I click on the button, a pop-up window appears where I select what data I want to assign to the field that was clicked on for the current record. When no data is assigned to this field, it reads Please Specify Company. I have written a script that duplicates most of the fields in the current record and puts their contents in a new record, the Company field being one of them. Unfortunately, my script is not duplicating the company name from the current record to the new record. I suspect this is because the Company field is a button that the user clicks on in order to get a window where the Company is selected. …
-
- 8 replies
- 1.2k views
-
-
HELP. have a webserver iis and fm6 unlimited on another machine using Web Server Connector. when I added more virtual websites to webserver I cannot longer get web pages containing CDML tags. I do get the html pages from webserver but when calling http:....FMPro?-db=testdb&-lay=web&-format=search.htm&-view. I get "Page not found". I replicated all html pages both on web and fmp unlimited server. Any ideas. Thanks in advance.
-
- 0 replies
- 1.8k views
-
-
Hi every one, I have Find [] script that finds the modified records per Current Date. Also I am produsing a report , new layout, with sub summary and summary based on the user and manager. I am counting the records per user and per manager. I do not have a problem here. The problem is that I need only the Syb Summary per User and SubSummary per manager . I do not need to show the actual record. I do not select the fields for the report layout. When i do that the data from records are not showing but still I have "empty rows" (records) ... Can you help me? How do i correct that? I need to "Now show the records" , only the summary! thanks a million
-
- 4 replies
- 982 views
-
-
Hi All, I recently took the company files from FM6 to FM7/8. There is an opening script and after tracing through it I located the problem to one particular script that opens all these files. I already cleaned up all the duplicate file references. This process of opening all the files took about 7 seconds to complete in FM6 but with both Fm7 and FM8 it now takes 43 seconds. Merging files with tables is not an option right now because of the tight deadline. I will leave that project for another day. Eventually this solution will be hosted remotely, but as of right now it is only local to my PC for development. I also deleted the .tmp files already. …
-
- 7 replies
- 1.2k views
-
-
We have been using FM 3 (and 4) for years on OS 9 and 8 machines, but just recently upgraded to an iMac G5 running Tiger. I have figured out how to connect the computers to each other, but have run into a problem trying to open the FM files on the new machine over the network. Usually, we use the Chooser to log onto the machine which has the FM files. Then when that folder (in this case, called "Database") is mounted, a simple double click and we can open them as long as they are opened on that computer. With this new computer, doing the same thing brings up the warning about "Being a host of a multi user file.....". BUT, if you use the File>open> h…
-
- 7 replies
- 1.6k views
-
-
Hello!, I am a new user of this group and I am italian and I can only speak a little english... sorry. I have a problem: I have a DB of filemaker that access through SQL on a Microsoft Access file. Until version 5 I inserted "Enter" in a field with CTRL+ Enter and this is read correctly from an electrical cad who read the table through ODBC But from version 8 CTRL+Enter inserts a different char code. Two questions: - from what it has been replaced the CTRL+Enter? - like I make to insert a specific ASCII code?
-
- 3 replies
- 1.1k views
-
-
We r done the project in fp7 currently we r using fm8 then how to upgrade that file plz tell me
-
- 2 replies
- 889 views
-
-
Any ideas how I would find the position of the first alphanumeric character in a string? For example, say I have the following 3 strings: .......abc..... ..123.......... 0.............. I need to find the position of a, 1, and 0 in each of the strings with a single calculation. Thanks
-
- 5 replies
- 1.8k views
-
-
Greetings, Sorry if this is in the wrong forum; I didn't quite know where to go with this one... We are looking at rebuilding our solution in FMP 8, and then hope to access/use it from multiple locations (not within the same building). I know basically nothing about doing a multi-location solution, nor anything at all about FMP Server. Some Questions: -Is this something even possible? -What exactly is FMP Server 8 capable of? -Does everyone connect remotely? -Any speed issues? -I have read recently about a viewer model where the users deal only with Global fields (supposedly to help with record lock-up) is this something that I would need to consid…
-
- 3 replies
- 1.1k views
-
-
We have a couple people developing on Macs, and a few on Windows. If we change the layouts on one platform, they end up looking different on the other. (I haven't seen this myself, yet... new to the project) Is this a common problem? I suggested it was maybe a fonts issue, but was told, "its not that things get nudged out of place by a few pixels, but they'll be totally off in a different position." Any help on this issue?
-
- 16 replies
- 2.1k views
-
-
Does anyone know how to export (via Scriptmaker) the layout fields into an existing Excel file. Whenever I export to the filepath of an existing file it overwrites the file. I'd like to have a "Sheet2" which will have preformatted charts so when I import (from FM8-via export to excel) the data I can see the graphs updated. Thank you anyone.....stumped.
-
- 1 reply
- 1.4k views
-
-
I have a database of invoices containing fields showing client name, job title and invoice date. Clients have multiple invoices over the past years. I want to show only the last invoice from each client. How do i do this please? Thanks
-
- 5 replies
- 1.2k views
-
-
Upon upgrade to FMS8, it became apparant that our file is corrupt. FMS8 noted the corruption about 4 hours after regular use and shut the file down. I can recognize the corruption by the inability to import a particular text field (results) in one table (Results), only 10% of the records will come across to the clone of the corrupt file. All will come across if a new database is created and all will come across into a new text field created in the cloned file. As much as Filemaker tech support and I hope this is data corruption, it is more likely file structure corruption. They are currently examining the files. I went to my archives and pulled out a clone of th…
-
- 0 replies
- 816 views
-
-
One of the fields in my table can have forward slashes, pluses and hyphens, but I cannot get a find to match them. I've tried escaping with a and wrapping them in "", but never get a match. How do I enter the search string to find the / character? Thanks Graham
-
- 2 replies
- 878 views
-
-
I am having a major problem with very slow response in FMP8. I am using Dragon Naturally Speaking and when I use it in FM7, text is entered into a text box as I speak at a very quick rate - hardly any delay. Now, in version 8, it is soooooo slooooow. I can type much faster - and I'm a hunt and peck typist! It seriously is about one letter per second. One other major problem I have noticed is this: Create a layout and drag the body down so that it is 7 pages long. Create a single text box (not text field, just a text box) that stretches the entire 7 pages. Then type some text into the text box. The delay is unbearable. Now open this same file in FM7 and type - NO DELAY…
-
- 0 replies
- 743 views
-
-
Hi, I need to build to a customer of mine a simple billing database. He gets max up to 1,000,000 records per month. So lets say we keep records for the last 2-3 years with something like 20,000,000 records. Most of the fields (20) will be non-calc. My question is, can FMP8 handle it? how would be the performance? did anyone try it? Can anyone suggest a good schema? My intentions where for each box (Sending CDRs) create a table. But I don't know if to create them all in the same file or to seperate it... Any comment will be appreciated. P.S I can use MySql/Radius, but I'm an FMP junky...
-
- 2 replies
- 1.3k views
-
-
This was an issue in FM7, but it seems still an issue. The issue is that windows disappear from the "Window" menu if you navigate to different filemaker database windows. Is anyone else seeing this? I reported this under version 7 to filemaker.
-
- 1 reply
- 889 views
-
-
Hello there, We have Pro 7 installed on two Citrix servers (Win2k Server SP4, Metaframe XPa) and are experiencing a few performance problems when running in the users ICA sessions (ICA v9.00), (we also run Filemaker Server 8) Most noticable, when flicking between the records there is a considerible delay, especially when clicking on the Next or Back button more than once. We have tested by loading the Pro7 software directly on the Citrix server (not in the ICA session) and it works fine! Any ideas how to improve the performance on Citrix??
-
- 5 replies
- 1.2k views
-
-
Hi, I'm new to the forums. I would like to use filemaker for our restaurant inventory. Does anyone know of any open solutions that I could use as an example of what is possible? Thanks, Siri
-
- 4 replies
- 1.1k views
-
-
Hi, I have a Mac FM 5.0 server running on a shared T1 line with static IP address and protpcol set to IP only (no appletalk). This has been serving up 4 documents to 5 local computers and 4 remote computers (branch office) for 3 years. Due to demand on our system, we added a DSL line and it was installed today. The server has been left on the T1 with the static IP so the remote machines can log in, but all the computers at the main office have been switched over to the DSL for access. The DSL network does not connect to the T1 network at all. Now remote and local computers are unable to see the server or files by specifying the IP address. We have several Macs running FM6…
-
- 1 reply
- 1.2k views
-
-
The company I work for is all Mac based and is running Filemaker Server 5. I just set up my new PC with filemaker 7. When I try to "Open Remote" to access the server, the "OPEN" button at the bottom is greyed out. I entered the IP address as a favorite, and it will not let me "OPEN" anything, it remains greyed. I know this supremely noob question must have an very simple answer, I have yet to find it. What do I need to do to be able to access the server/files? Thanks in advance.
-
- 2 replies
- 986 views
-
-
Hi. Can we change the language (for french) on install, or even after installing, in FileMaker 6? Thanks Jielle
-
- 0 replies
- 967 views
-
-
Is there anyway to place a tab space into a merge field via a calculation? I've creating a merge field, I'm wanting to have the Item name left aligned, then the cost right aligned on the same line. I can get the name and cost working, but having a consistent space between the Item name and cost is proving beyond my calc. experience?
-
- 9 replies
- 1.6k views
-
-
I am starting work on a major update to a system that I have inherited from previous developers. The current solution uses multiple separate files as it was originally developed in Filemaker 5 and 6. I need to add more tables to the solution - does it cause any issues if the new tables are all added within a single file and relationships set up with the existing files as required? Eventually I anticipate using Filemaker 8 to get all the tables into a single file so this would be a step in that direction if it does not cause any problems to run a mixture of multiple tables in one file alongside the existing separate files.
-
- 3 replies
- 1.4k views
-
-
Could someone recommend possible software, add-ons or enhancements for FMP that would enable a library type circulation system for patrons and checking in/out items? Thank you.
-
- 1 reply
- 1.1k views
-
-
Hello there FMP Users. Has anyone else experienced this? Only after applying the FMP7.0v3 patch (Windows), buttons that perform a script containing a 'Goto related Record' script step do not work. (At least that step does not function - the rest of the script is OK). I have tested and can confirm that: a) These scripts worked fine before the patch was applied. Configuring a button with just the Goto Related Record step (as opposed to perfoming a script to do this) works fine, both before and after patching. c) Installing 7.03a Patch does not resolve this issue. d) I have also tried creating a brand new test DB (in FMPv7.03a in fact), to try this out and…
-
- 17 replies
- 2.2k views
-
-
Hell again, I am sort of new to Filemaker Pro 7, and I was wondering how to attach scripts to your start up or shut down. I used to do this in FM 5. I have searched and cannot find out how. Thank you, Scott
-
- 5 replies
- 1.4k views
-
-
I'm using FileMaker Pro 5.5 and all I want to do is sort my found records. Very simple script but it won't work. Here it is: Show All Records Enter Find Mode [Restore, Pause] Sort[Restore, No dialog] The found records end up unsorted. Any help would be appreciated. Regards, Brooke Kruger
-
- 3 replies
- 2.1k views
-
-
I recently upgraded my report card program from FM5 to FM7 and am getting an error " This record cannot be modified in this window because it is already being modified in a different window. I am trying to change records (language to Arts). FM is opening a window with the records being changed while my main report window is open. Is this because a field in the lookup file is "set" and waiting input? The program worked fine in FM5. Any thoughts
-
- 1 reply
- 1.7k views
-
-
I have completed a major database for my school using FMP7. The school has bought a FMP7 site licence for every computer in the school to run my database. If I convert to 8 - the new tab tool is something that will really save me a lot of time - am I right in assuming that the school will need to update to FM8 as well? I am assuming at this stage (worst case scenario) that my school will need to update ..... Frank
-
- 2 replies
- 805 views
-
-
Here's an insteresting question about script variables - Are Global ($$) variables (with 1 repetition)going to hold the same value for each user in a multi-user situation? I couldn't find any documentation concerning this. When I read "Global", I think like a Global Text Field - each user has their own instance of it. Or in other words - database is being hosted on Server. User A runs Script X that sets variable $$Title to "whatever". User B comes along, and calls another script in the same file that calls $$Title - will that script receive "whatever", or something else? I believe in the long run this won't matter either way, but I can be wrong…
-
- 2 replies
- 847 views
-
-
I have been trying to open a file, but keep getting the error: "Filename" is currently in use and could not be opened. If the file is shared, you can use the Open Remote command to open the file on the network. No one else is using the document, I triple checked. The Open Remote command didn't work. Anyone know how to fix this?
-
- 1 reply
- 4.6k views
-
-
I have a solution that has been used for several years ( I designed it 10 years ago in FMP3.) The problem is that when I want to work on redesigning and adding new modules to the solution fields on related files disappear. They are in the field picker when I start working on calculations, but when I try to link the field to another related field it cannot be found. Right now I am trying to create a database to create advertiser insertion orders for the magazine I work for. contacts has a field ad_code insertion_order is supposed to grab the code from contacts and use it to generate an insertion order number based on the ad code, and the current issue (mon…
-
- 5 replies
- 1.1k views
-
-
Hi all friends so they said that they changed priority in the execution stack of scripts from version 7 and 8. But I can't give a try to this new caracteristic ! Can someone give me an easy example, working in 7 and in 8, that makes me clear the difference !
-
- 0 replies
- 780 views
-
-
Hi, This file is the core of a accounting system I made a few years ago. It was first developed in FM 6 and then translated to FM 7, so far no problem. A few weeks ago I tried to run it over FM 8, everything works fine just for a small detail: I can't perform finds in date fields, when I try it gets a very strange error and then quits FM. It took me some time to "isolate" the problem, because everything else works fine. - First a supposed it was an script error, so I eliminate it (and eventually all of them). - Then all the relationships. - Then all the fields but one, "the" date field. So I ended with a file (36k) containing a single field with no rela…
-
- 5 replies
- 1.2k views
-
-
-
I have a portal that when I enter preview mode to print one row will collapse the row to about half the size, cutting off half the data fields. When I enter another row it's fine. This is not a problem on Windows, works fine, but on the Mac it does it every time with just one row of data. Any ideas? Thanks.
-
- 2 replies
- 957 views
-
-
Is it possible to set up variables in tooltips? If so how do you do that? Could someone post an example script?
-
- 1 reply
- 1.2k views
-
-
I am compiling a survye of the best restaurants in the city, I have a self relational field that tells me how many times each rest. is entered in each category.. how many votes "corky's" has for "best ribs" buckely's for best steak etc... So after i import all off the ballots I get the results then export the reults fields - but I end up with something like this: 06 Cafe 1912 06 Cafe 1912 06 Cafe 1912 06 Cafe 1912 06 Cafe 1912 06 cafe 1912 05 Hueys 05 Hueys 05 Hueys 05 hueys 05 Hueys How can i export JUST one result for each name. there are 241 records, with 47 categories. In the end I would like to have a list of results for each cate…
-
- 1 reply
- 919 views
-
-
Hey, Just received my copy of FM Pro 8 Advanced and tried to install it. I have a G4, 1 ghz, 256 mb ram and OS X 10.3.9. Everything works fine, i can se the installation beginn and the progress bar moving, but after a minute or so it just stops and returns to the previous dialog (the one where you choose custom och ordinary installation). And I try again and the same thing happens yet one more time. Anyone that has any tips or now what the problem is? Thank you!
-
- 6 replies
- 1.1k views
-
-
wht's this problem when i try to remotely open a shared fm7 file with filemaker network and what's it's solution? the host's capacity was exceeded. try again later.
-
- 4 replies
- 1.3k views
-
-
FM PRO 7: Could someone please open up this file and let me know why the button is doing what it does. I have a button that is supposed to open a new window of a certain size, switch its layout, allow the user to select a few options and then you submit it. all the functions work and it opens the new window, but it automatically resizes the main window to the other size window as well. i want the main window to stay the same size. I do not want them all to resizew. please open the file and click the "send media kit" button and see for yourself. thanks fmpro7.zip
-
- 6 replies
- 1.3k views
-
-
I have on layout with a tab (2 tabs). If you put portals on the tabs and run a script from the non dominant tab, after the script is done, it always defaults to the first tab. Even if you put the portals outside of the tab but you are on the second tab, it still defaults to the first tab. This makes a yucky interface. Is there a way to control this?
-
- 5 replies
- 1.3k views
-
-
Hi there, I was setting up a new database, and managed to make a field use a calculation which generates an infinite loop, and now I can't get to the file, it just hangs when I try to open. I can see the file if I set up a relationship from a dummy file, I can import information and scripts, but I can't get the file open. I tried Apple-Period, no help. Anything I can do? Thanks!
-
- 12 replies
- 1.5k views
-
-
I use the Arial MT fonts as a default, since they're installed by the Acrobat Reader installer and we do a LOT of pdf creation for invoicing and such. However, the font does not show up in 8 (on the windows side, our macs are fine). I look into the Configure/more fonts menu item and I see the list of fonts there, but Arial MT is missing. FM 6 lists it. Anyone else seen this behavior? Is it a Postscript issue? I say that as I'm only seeing fonts in the Configure/More menu that have the TT symbol. Though why FM would drop PS support beats the *** outta me. Thanks in advance- Tony
-
- 1 reply
- 842 views
-
-
Apologies if this is covered elsewhere on this forum but don't have the chance to search properly at the moment. Two questions: 1. I have a radio button field with three options. When I create a new record I want the first button to be already selected by default but at the moment all three are just empty. Is this possible? 2. Is there a simple way to force a field to use Title Case. For instance if I'm lazy and type in, say germany (ie. with a lower case 'g') as I click return i want it to change automatically to Germany. I would want it change it for all words in the field - say I typed in south africa it would automatically make it South Africa. I sort …
-
- 2 replies
- 925 views
-
-
Trying to figure out a way to drop the 3 lowest quiz grades from a set of 20 before they are averaged. I know it's an old version and probably a really easy question, but I'd appreciate some help if I can get it. Thanks in advance.
-
- 2 replies
- 1.2k views
-
-
I have a 85+ file, 2 GB db solution, which I want to run "Save Compressed copy" on regularly, or at least some specific files. Does anyone have suggestions to automate this process. FM 5 server on Linux, FM 6.x clients on Win and Mac OSX (10.3 and 10.4). Currently running our reports on a stand-alone OS X system.
-
- 3 replies
- 1.1k views
-
-
Hi I designed an application that has a file over 1.5go. Is it possible (with InstallShield) to split that file on 3 CD? When the user install it, will it be corrupted or it will rebuild the file and work fine??? Thank you!
-
- 1 reply
- 923 views
-
-
I have one database with 120,000 entries and I want to compare the entries received by a field (called account number) for the period 1/7/2004 to 30/9/2004 with the same time period in 2005. So far I have duplicated the base and am doing a manual comparison of one to the other. This is dumb. Can someone please help me compare the 2 bases or preferably compare the data within the one base? Thanks
-
- 1 reply
- 1.7k views
-
-
Can anybody help me by explaining how I can generate a series of invoices in one process? As you might guess, - I'm not very good at writing scripts... I have a database with several tables. I want to generate new invoices in the invoice-table from a selection in the member-table.
-
- 4 replies
- 872 views
-
-
I have a report I generate for my customers, at the end of the report, I want to throw in discriptions on how to fix the issues that the report lists. Is there a way to get something to only show up on/after the LAST page? I'm playing around with it now, and have been for a bit, hoping someone else has hit this problem. For those interested: Title Footers print only on the FIRST page of the document, and Footers Print on every page.
-
- 1 reply
- 806 views
-
-
I'm planning on updating from FMP 5 to 8. What isn't fully clear is the difference between 8 and 8 advanced. I understand the ability to create runtime versions. The rest appears to more around making some things easier, versus adding different capabilities (ie. debugging). My needs are intermittant (hence the long time between upgrades)and not particularly sophisticated. I'll be generally just putting together databases for myself or a small workgroup. But if the Advanced version has better tools, I can probably justify it just based on my time savings. It'd be nice if the Apple stores had them both running, but the local one doesn't even have 8 installed yet. …
-
- 1 reply
- 945 views
-
-
Some background for thosoe who would like to know: In the beginning of September, we switched from Filemaker 5 to 7. The database was too erraticly written for it to properly convert, so it was my job to write a whole new system in 7. I hit a stopping point when the email plugin (pop-it by cnsplug-ins) would lock up. They made a new version, and it fixed that problem. Technical Situation Info: 4 Computers running fm7.0v3 Serving computer is running win2k server, rest are running win2k pro, however, we are not running fmserver. What is happening: (I have been keeping a log, and all errors are the exception, not the rule) When trying to pri…
-
- 3 replies
- 1.2k views
-
-
I just install os 10.1 server and wanted to install the os 10 version of the web server connector that came with my FM version 5 unlimited but I keep getting an error, " missing or old bill of materials" Does anyone have any idea what this means and how I can fix this problem. Thanks
-
- 1 reply
- 1.7k views
-
-
Just planning a rework of an old solution, and trying to fully understand the need for join files for "Many to many" relationships...i seem to be able to get the same result with just the 2 files & no join file...i suspect that this could lead to impending disaster at some future point so am trying to better understand the subject. If there are any good articles or tutorials i would love to know... P.S. is it just me, or is the new FMForums much harder to navigate & search? Many thanks Justin
-
- 5 replies
- 1.8k views
-
-
Please forgive me if I am a bit confusing, I will try to make myself the best understandable as possible. I am starting a new data base set that will do the invoicing for a small company with some 800 different products. So far I have 3 databases: 1) Products DB - (CadastroProdutos.fp5) Here I create one record for each product. I have name of product, ID, weight, price, etc... 2) Records DB - (Registros.fp5) Here I a relationship with Products DB, as I create a new record and type the product ID, the filemaker app imports Name of product, weight, price, etc from Products DB... 3) Invoicing DB - (ControlePedidos.fp5) Here I have a relationship wit…
-
- 1 reply
- 956 views
-
-
We are running Pro7 (v3a) and are experiencing a strange thing with the fonts in some of our databases. When typing in the 150% view (in Arial) the fonts sometimes start showing as obscure fonts i.e. not english!!...when dropping down to 100% the view fine (and if you go back 150% after that it is ok again!!) Any ideas with font problems such as this or similar?? Cheers
-
- 0 replies
- 1.3k views
-
-
Checkout this file. There is a bug in the Summary field "Count of" illustrated in this file. I hope Filemaker fixes this soon!!!! Count_Problems.fp7.zip
-
- 3 replies
- 727 views
-
-
I know I can export sql to a database, but can I import and export sql in real time? My company currently has a web-based database which stores data into a SQL DB. What I want to do is propose a FM DB to the company with more functions and efficiency than what we currently have. On top of that, I would like to keep the current database but make FM able to import/export data to the sql databse that way both the original and the FM database are usable and up to date. Does anyone know if this is possible?
-
- 0 replies
- 717 views
-
-
Hello all, I have been trying to make a small car rental program so that everytime I rent a certain car the mileage will always be correct. The car info is kept in a seperate file and I use the lookup function to pull over the Car Number, Plate, Yr, make etc,, but when I pull the starting mileage over I want it to be the ending mileage of the previous rental. I dont want the starting mileage to change on the rental form when inputting the mileage in. I hope this make sense. Thanks in advance.
-
- 6 replies
- 1.3k views
-
-
I'd like to walk a user through invoicing by asking first for an invoice name (with custom dialog) which works fine and then ask who the buyer is and have the user select from a value list. Is there anyway to have a user do this without going to the field on the layout? Ideally I'd have something like the Custom Dialog box, but with a value list field. Possible? I've looked around this site and I'm beginning to think I'll have to figure out a different way. Your help is MUCH appreciated!
-
- 3 replies
- 1.5k views
-
-
Anyone else seeing this? If you have a layout with a tab panel, and a script which goes to another layout, when the script returns you return to the original layout, often a different tab is selected than the one you started from? Edit -- I know you can manually select the tab by using a Go To Field statement, but this is ugly and requires extra script logic. I'd like to know how FM determines which tab to select...
-
- 2 replies
- 892 views
-
-
I support a medical research group that uses FMP to manage a genetic screening process. The DB's live on a newish xServe, and the clients are all current model MacOS workstations. The users report that during a work day, the system behaves well in the morning, but as the day goes on, everything slows down. Any ideas?
-
- 3 replies
- 1k views
-
-
We have experienced this behaviour a lot of times but still don´t know how to solve it. The thing is that scripts using 'loop' and 'go to next record' to do something to all, or a lot of records in a table, go incredibly faster in the beggining of the table and then it slows down as it goes down the table. ¿Has anyone notice this before? I am talking of tables with more than 200.000 records and scripts that take 10 hours or more to finish running in a FM7pro against FMServer v.3 installed in the same computer.
-
- 2 replies
- 1.2k views
-
-
hi all, we have a number of records, one of the fields is a container field, and sometimes there's a value, and sometime's there's not. in the instances where there is a value, sometimes the value is linked, and sometimes the value is embdedded within the filemaker file. the question is, how can we identify which records have an embedded container value? this is very important, so if you have any ideas that would be great. it is 6.0v4 on a windows platform. svr 5.5v4. thx, jd.
-
- 1 reply
- 914 views
-
-
I just started a new job and this is the first time I have been exposed to Filemaker Pro. The company I work for is quite small and their Filemaker Pro is extremley important. What I would like to ask is if it is possible to port the entire Filemaker installation from the server to my laptop so I can mess around and learn with a local installation of the database without the fear of destroying anything that is live. If you need any more information just ask. Thanks, Louise
-
- 4 replies
- 984 views
-
-
I want to clean up my solution that was migrated from v6 to v8 Advanced. I now have a number of file references like 'Contacts 2', 'Contacts 3', etc. all referring to the same file(s). I tried running the DDR producing HTML (should it be XML?), but FM can't seem to find files that are already open in Filemaker. Then the sucker locked up when I tried to cancel the DDR. Does anybody have any suggestions? Steve
-
- 3 replies
- 858 views
-
-
Hi. Can anybody tell be if Runtime solutions have the same machine requirements as Filemaker 8 itself (that is need: 500Mhz Pentium and 256Mb of RAM)?
-
- 2 replies
- 913 views
-
-
Just a quick question...Does anyone know a way to clear all script variables without closing the file?
-
- 2 replies
- 1.8k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online