FileMaker Pro v7 – v11
These are discussions for the legacy version of filemaker 7 - 11 with the extension of .fp7
2,988 topics in this forum
-
Hi guys, I need to reopen an old FileMaker Pro 11 project, but I lost the product key that was on the box, which I threw away. Can someone give/sell me one they no longer use (I can pay €10)? Best regards, Marcos
-
- 4 replies
- 202 views
- 3 followers
-
-
I have an active database file on my desktop to which I add records every week. I maintain an identical database on an external hard drive which I maintain as a cumulative backup of all records. I want to periodically move recently added records from my active database to the archived database, which I keep offsite for protection (except when I am transferring records). Is there a way to do this FileMaker-to-Filemaker records transfer?
-
- 1 reply
- 10.7k views
- 2 followers
-
-
With doing LIST function in a portal, the result field shows each portal entry (text word) on a separate line. How to concatenate the resul Example (portal entries): They went to school Need the result to be : They went to school
-
-
- 1 reply
- 2.4k views
- 1 follower
-
-
I have a file with 100 records, each record is a scanned image of one page in a book. So my layout shows single pages. What can I do to show two pages of the book (left and right sides as an open book)? or in another word to be able to create a related table with 50 records in addition to the original one.
-
- 5 replies
- 1.1k views
- 1 follower
-
-
I have a file that contains one word in each record, how can I create a field that shows two consecutive words "records": Record1: They Record2: went Record3: to Record4: school I want a field to show in record1: They went In record2: went to In record3: to school In record4: school Thanks
-
-
- 2 replies
- 1.8k views
- 1 follower
-
-
Hi! First of all, sorry if I can't explain me properly. I am not a user of the filemaker, but my work colleagues are having problems with it. They use the filmmaker 10 (32bits) and Office 365 (64bits) on windows 10 (64bits). The filemaker 10 never had problems opening the "new email" window in Outlook. Some months ago(can't be precise), when it calls for Outlook, it just doesn't do anything, no error, nothing... doesn't matter if Outlook is opened or closed, it doesn't show open the "new email" window. We tried different computers with the same versions and it works, but is happening in 3 computers. They are both HP, I even though the problem was related th…
-
- 1 reply
- 5.4k views
- 1 follower
-
-
In the attached sample, there are two tables: a Project table ("AD") for project name and booked $ amount and a related table ("Rcvbls") which can have multiple invoices per project as shown below: I want a report that shows projects by status and has summary amounts for the Rcvbls data as shown below: As you can see, the BookedAmt (from AD) works fine in each part of the report, but the related records subtotals and grand totals aren't acting correctly. Any ideas what I'm doing wrong? The db is attached. ReportTest.fp7
-
- 2 replies
- 5.4k views
-
-
Being forced to upgrade my Filemaker version. I bought it under the Educational discount just before I retired. I had to replace my computer this month and now I can't use that version of Filemaker (8.5). That's fine. It's an old version and I wanted to upgrade, anyway. The problem is the price of the current Filemaker version. I'm not going to pay a thousand or even hundreds of dollars per year for a license to use FIlemaker at home. When I still worked at the university I used Filemaker extensively, and I was pretty good at it, but I'm using it for a few small databases at home. I'm looking for affordable alternatives. Is there a Filemaker lite? I'd like a one…
-
-
- 8 replies
- 2.6k views
- 1 follower
-
-
I tried to update two databases from version 6 to 9 -- FM 9 read the files and then asked me for a password. I entered the password I had used, and a dialog said "The account and password you entered cannot be used to access this file." I was sure I had used the correct, case-sensitive password. I duplicated the files and opened them in v. 6, and deleted the passwords. Tried to open those in 9 and got the same message. Another post in this forum on the same issue said that since 6 did not require account names, you needed to enter the password in both the account name and password text entry fields. Tried that, nope. I opened all four files in 6 to confirm that the origin…
-
-
- 4 replies
- 1.6k views
- 1 follower
-
-
I just upgraded my Mac OS to Mojave (10.14.4). I am running FMP Advanced 11.0v4, and my databases are in FP7 format (due to a legacy system at work.) I now have a repeatable "glitch" where if I perform a find in a database and there are no records that come up as results (i.e., no records match the find), regardless which choice I make next (Cancel or Modify Find), the app quits and I keep getting the window to send the issue to Apple. I can immediately re-open the database, though usually the last 2-3 changes I made weren't saved. Other than the obvious option of upgrading the app, does anyone know of a workaround for this? Thanks in advanc.
-
-
- 5 replies
- 7.7k views
-
-
Hello, Sorry if I'm in the wrong part of the forum, please let me know if I need to move my post! Recently I have inherited a legacy FileMaker 9 server setup with a handful of users. The admin credentials for the server install have been lost to time, however we would like to change the server that the installation is running on due to the hardware being so old (Windows Server 2003). We also do not have the license key for our installation. Is it possible to recover the admin password or remove the need for admin credentials for the FileMaker admin console? I have full administrative privilege on the machine otherwise, but am unable to access FileMaker. …
-
- 1 reply
- 1.5k views
-
-
Hello I find in an old drives some fmp5 files. To open them in FMP18 I need to convert them first to FMP7. I have an old version of FMP7 however each time I install it the app crashes telling me the installer was modified with another version and crashes. I tried to download from the Filemaker site the trial version but I can't find it ... any help? Thanks
-
- 2 replies
- 2.4k views
-
-
I am using a 2015 MacBook Air running Mojave 10.4.5 and a HP LaserJet 1102w. When I try to print from FileMaker Pro 10 the program will crash after the third print. If I try to save the record as a PDF first it will crash immediately. I have to go into two to five layouts to print an entire service order. The Genius at the Apple Store was unaware that FileMaker is an Apple product, told me to reset the printing system and try again. This made no difference. I went back and they said to call FileMaker but FileMaker no longer supports FileMaker 10. So I bought another printer, a Xerox 3260 laser printer which does exactly the same thing. It will also crash after t…
-
- 2 replies
- 1.9k views
-
-
Basic Question: I am attempting to import 60 records from a CSV file. There are 4 fields per record: First Name, Last Name, Email and Source. When I choose Import Records... > File... from the File menu, everything looks good, 4 data points point to the correct field names: arrow icon "Import this field" but the rest are the double dots icon, "Don't import this field," and when I click on the Import button only the first record is imported. I don't use Filemaker frequently enough to remember everything but when I need it, I really need it. I do not remember having to go thru and changing every icon in the Import dialog to import this field, I thought th…
-
- 4 replies
- 1.9k views
-
-
with filemaker 10 pro advanced I have a calculated multivalued that displays linked images. I checked "keep the proportions" and reduce the image. On screen in preview mode everything is ok ... ... but in print the picture is cropped what can I do?
-
- 0 replies
- 1.7k views
-
-
Filemaker Pro 11 is running on two Windows 10 computers connected as Host and Client over a network. The script to import data from an Excel .csv file utilizes the following script step options: 1. Un-Checked - Specify data source - File 2. Check - Specify import order, Import Action a. Select - Update existing records in found set b. Check - Don't import first record (contains field names) 3. Check - Perform without dialog When the Import script is run from the Host computer, and the desired .csv file is manually selected, the Excel first row field names are not imported and the second row with the data is imported as expec…
-
- 0 replies
- 2.1k views
-
-
After my Windows 10 based Filemaker Pro 11 MarinaPro Solution is launched (Path = C:/MarinaPro/Marina.fp7), I need to create a variable ($$source = filewin:/C:/MarinaPro/ResScheduler/) to a revised default "Open File" path. Because I need to select from several reservation request attachment Excel .csv files, placed in the ResScheduler directory by an Outlook 2010 Macro, my "Import Records" script is set with an "unspecified" data source. When my script is activated with Error Capture "Off", I get the obligatory Filemaker Pro Error message, "The file <unknown> could not be found..." and the "Open File window is still set to "Look in: "MarinaPro" (Default). An…
-
- 8 replies
- 3.8k views
-
-
I've updated my computer from Windows 7 Pro to Windows 10 Pro. My FileMaker Pro Advanced 11 does not launch. I get the message "The application has failed to start because its side-by-side configuration is incorrect." What's the solution for this issue? Update: I clicked on an fp7 file, and then Windows asked me to insert the FileMaker CD, which I did. Some files were quickly copied over, and everything works fine now!
-
- 0 replies
- 2.5k views
-
-
Hi, Good Day! I'm quite new to the world of FileMaker, I have a database file fp7 whilst trying to update its contents i get ODBC error. File is hosted by filemaker 7 server. I was able to get that file unprocted still i cant update contents. ScriptMaker and all other features are greyed-out. At this point i have no clue - could you please help me. Thank you kindly. // KSN
-
- 4 replies
- 3.5k views
-
-
I have several customers that utilize our MarinaPro Marina Dockage Management solution. All are running Windows 10 Pro 64Bit and Filemaker Pro 11.0v2. All the MarinaPro solutions are functioning well with exception to the one marina that is using an HP LaserJet Professional M1217nfw MFP printer. The printer has been named "HP LaserJet". The problem is that scripted reports will not print after an updated/revised solution is installed on the computer. However, a test page can be printed from the Windows default printer. Print scripts are utilized by more than one report and this sample is named - "Master Portrait Printer | Current Record | All | 1 |" and…
-
- 0 replies
- 3.3k views
-
-
In Filemaker Pro Advanced 11 ( and 14 ), is it possible to launch the Windows 10 Mail program (WinMail.exe.mui) using the Filemaker "Send event" or some other approach?
-
- 2 replies
- 3.8k views
-
-
I'm a botanist, and the tables I am working with are for tracking botanical garden collections. The data represents plants in the garden, and the plants are tagged and show up in the database. The tables I am working with were created in FMP 7, and I'd like to open them up in FMP 11 (or later.) The system hasn't been used in years, but still has valuable information. One of the tables is giving me problems using the FMP convert and recover commands. These tables are all inter-related. The main table is the Accessions table, which contains records for all of one kind of plant, from the same source, received on the same date. It is basically a museum standard.…
-
-
- 1 reply
- 4.9k views
-
-
I am working in a biology lab and have developed several basic databases using filemaker 11 to help the lab organise their stocks of chemicals and so on. We have a fairly onerous excel sheet that we have to fill out for registering certain new reagents we make with the regulatory authorities and as these are a pain to use, they are not filled out regularly enough. I would like to simplify this for everyone by making a filemaker form/database that will automatically fill out as much detail as possible. The data in question is that when we clone a piece of DNA we need to insert this into several different DNA vectors that are used for different things. When…
-
- 2 replies
- 2.4k views
-
-
Hi, A client of mine has an Windows 2008 Server which runs an SQL Server. Because he doesn't have another machine and (Due To some reason, my client do not wish to mess with current SQL database structure), so I will like to ins tall FM 11 runtime onto the same machine, The runtime solution is to schedule login to SQL server to perform importing / filtering and exporting data report. My question is :... Has someone ever done this and can it be done? Possible for FM to login onto same machine to access SQL DB ? Thanks!
-
- 2 replies
- 2.3k views
-
-
I and most of my clients are still on Windows 7 and Windows Server 2003. I have several FileMaker executable files (solutions) developed using FileMaker 11 Advanced. Will these run on Windows 10? Will the Windows 10 compatibility mode (i.e., Windows 7) run these files? I don't have a Windows 10 machine to test.
-
- 6 replies
- 11k views
-
-
I'm getting the attached error messages when trying to modify records in a file. It's appears as though there is some protection in place, privilege sets etc, but there isn't and never has been. I've tried recovering the file to no avail, is there anything else I can try? I haven't accessed this file in approx. 6 months, but have never had issues before and I'm the only user of the file.
-
- 7 replies
- 2.9k views
-
-
I'm using filemaker7 on a windows 10 machine. when I'm in layout mode and click on an on a object the screen goes black. I had this problem before using XP and forgot how to solve it. does anyone know what i need to do? thanks for any advice you can give with this problem.
-
- 2 replies
- 2.6k views
-
-
I have a MacMini running macOS Sierra with FM11PA that works; however this FM11PA was installed when there was MacOS X 10.10 on the MacMini. Attempting to install FM11PA on my MB15R fails, well the installer appears to work fine( as pr attached image, ) but launching the app( as pr attached image ) tells me somebody has been fiddling with the installation and that I have to reinstall the application.
-
- 4 replies
- 10k views
-
-
I'm running Mountain Lion on my MacBook Pro just so I can continue to use FileMaker Pro 11. The software is owned by my client, which doesn't want to pay for an upgrade, and is used by two other people, one of whom has a PC. So I'm getting pushback on the idea of upgrading FMP right now. On the other hand, I have to use other apps which require using Yosemite. So, before I install Yosemite anyway and then find out FMP 11 won't run - has anyone had experience with running it on one of the latest Mac OS's? Our application is very simple. We just keep a database, do searches, and run simple reports. Thank you!
-
- 3 replies
- 2.4k views
-
-
I am modifying the Invoice sample that comes with FM to provide some basic Inventory management functions. Works pretty well. However...I really need to be able to order a product in 2 ways : (1) (Kit - ISBN) and have that deplete and ship all of the parts that make the kit. (2) as individual pieces) For example: Kit 1234 (includes) 3 of part 2234 5 of part 9987 1 of part 097 Someone might order Kit 1234 PLUS an extra 9987. Make sense? No clue on how to connect them. Thanks in advance File Maker Jedis.
-
- 4 replies
- 3.6k views
-
-
I hope I am allowed to post here for FM11 Pro Advanced on Win 7. I am struggling with the Code shown below. (mainpath = location statement for $filespec) ROT is the Destination Folder on my Desktop. After Final Testing, the Destination Folder will be elsewhere on my PC. I need to Save Records as pdf to the Location Path on my PC, to "mainpath" Location with the Filename "Service_Web_120716.pdf" I have chosen this method, so that I can easily change the Location Path to that required on other Operators machines. The remainder of Code has tested OK - It is only Destination Path Location that is causing issues. Error produced is::: Service_Web_120716…
-
- 4 replies
- 3.2k views
-
-
Dear All, I know this might a very easy question, but it's really giving me hard time, I'm new to FM, I'm coming from Access / VB background so maybe I'm still trying to do things in FM the Access way. My question is that, I have a table which has members information, there is one field which called "Status", what I want to do is that to have a button on the main screen and when I click on it shows a report which have only members with the "Status" = "Active" only. The report is grouped by Team name, so every team have some members related to it and this work fine. I designed the report and it's working fine, except that it shows all the records not the …
-
-
- 2 replies
- 12.5k views
-
-
Hi all, I'm summarizing line items of sales records. Items are charged in more than one currency, so I'm sorting/breaking the report by currency. I don't use a body part, only summaries, so that, for example, 85 sales of product xyz are shown on a single line per currency. The next line might show 34 sales of the same item in another currency. This works fine so far. In the trailing grand summary, I'd like to show the total like so: Total sales, US$: 2346.50 Total sales, EUR: 3562.52 This doesn't work the way my parts are set up, since I can only have the number field calculated once and FM just adds up all the numbers regardless of the currency. …
-
-
- 6 replies
- 3.1k views
-
-
A button-attached script will perform error checking for field entries and then commit the record. I do NOT want a user to be able to commit a record by clicking outside a field, thereby avoiding using the button. Is it possible to disable this default Filemaker7 feature?
-
- 6 replies
- 5.1k views
-
-
Hi all, I've recently added FM10 to my MacBook Pro that runs on Mavericks. When trying to format a date field, I get the box in the attached screen shot. The date field on the layout looks accordingly, so it's not just a dialog box display problem. Any idea what's going on here? Thanks, Stefan
-
- 2 replies
- 2.4k views
-
-
Apparently, the keyboard shortcut to collapse script folders CMD- no longer works in FMA11. I use this all the time. Help.
-
- 2 replies
- 3.3k views
-
-
Hi all, This is my first post here so Hello! At work we are still stuck on Filemaker 11 systems wise but also have Filemaker 12 on hand. Unfortunately my solutions must be built in Filemaker 11 so please forgive my ignorance if there is an obvious solution in newer versions (I've yet to read about any). Does anyone know of a way to return the Field name where a positive was found via a Quick Find? FM11 has the the ability to search all fields: Quick Find, return the fieldname: Get(FieldName) but I can't find a way of getting them to work together. Many different clients send data to us to be loaded into our own database system. The data we get from clients has to c…
-
- 11 replies
- 3.3k views
-
-
I'm still using FMP 10. Well, I was until a few days ago. I made the mistake of deleting my FMP from WIN7. No worries - just re-install it. It keeps asking me for a 'qualifying product'. Although I have the CDs for a few earlier versions, I cannot find any of the associated paperwork; so, no luck. (We've been moving from house to house for a few years and lots of stuff has gone missing or been buried in unrelated boxes.) Please don't nag me about backup! My backup wants a password; guess where I keep a record of my passwords. Yep, in a FMP file. Does anyone have any idea how to get around the problem of missing 'qualifying product'? I haven't tried contacting …
-
- 2 replies
- 2.5k views
-
-
I have two identical tables only one of them has data inputted into it the other table has no user access. After a user has created a new record in Table A i want all of the data to be duplicated into Table B and just stored there. This is because Table A can later have individual records deleted and we need to keep a backup of all the data entered into Table A I did write and export script which exported the record from Table A to excel and then imported the excel file into Table B but this does not work very well over our network. Any suggestions would be appreciated.
-
- 1 reply
- 2.1k views
-
-
i want to import into filemaker from a text file which is a result of a http request. (in filemaker 11!) actually, what i get back from the http-request in a browser is a simple OK 1204888105 now, if i do this via filemakers script step “Import Records” and XML Data to be able to write a http request, i get the obvious error: XML parsing error: invalid document structure Line Number: 1 Column Number: 1 so i was wondering, if there is a possibility to write a XSL style sheet, that can help me grabbing this text into a record. a style sheet, that presents this short text to filemaker as XML data ? thanks for any thoughts ! klaus
-
- 2 replies
- 2.3k views
-
-
Hi All, I am using IIS 7 ,Filemaker 11 and PHP 5.2.17. I have installed IIS and Filemaker 11 server correctly and also for the default site added in the handler mapping section the correct path for the FM webpublishing PHP which is C:\Program Files (x86)\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\php5isapi.dll. But when I run the php code then I get an error as : PHP Notice: Only variable references should be returned by reference in C:\Program Files (x86)\FileMaker\FileMaker Server\Web Publishing\publishing-engine\php\FileMaker\Command.php on line 126. Can any1 please help? Thank you in advance.
-
-
- 3 replies
- 3.7k views
-
-
Hi everybody: I have a product drop down list that shows all products for a certain supplier when making a new order. The list changes according to the supplier of the products. This is easily done by indicating who the supplier is in the products Table and making the appropriate relationship. Now, I want to shorten the list by eliminating obsolete products (I need to keep history, so I can't simply delete the obsoletes from the products table) The products table has a field which I can click when a product becomes obsolete. My solution (it works, but I don't like it) is adding a field called obsolete in the purchase orders table, which is automatically set…
-
-
- 6 replies
- 5.4k views
-
-
Can Filemaker 7 Server run solution created with FileMaker 13 to support IOS devices such as Ipad and Iphone?
-
- 1 reply
- 2.3k views
-
-
Hi all, Here is my requirement. I need to integrate FileMaker (Mac) with QuickBook for Mac. 123 Sync is a product used to integrate FM (Windows) with QuickBook (Windows). 123sync is compatible with Windows QB versions only. Mac users can run QB on Parallels, VMware or Boot Camp (This is an additional expense). I am looking for an integration product which supports FM and Quickbook integration without any other supporting software expenses. FYI Please refer the following link... http://secure.solutionmakers.com/store/index.lasso?page=detail&category_id=&keyword=&skip=3 Regards Pushkraj
-
- 10 replies
- 12.4k views
-
-
Hi: By mistake I installed FM11Pro using the same licence key on 2 machines Windows 7 and Windows XP (yes, I still use it and love it) I thought: no problem, I'll uninstall and reinstall on one of the machines. Surprise, it does not appear in Add/remove programs XP; Programs and features W7, so I have no clue on how to properly remove it. Right now I have 2 users who cannot use FM concurrently. A possible solution is to upgrade one machine with an extra licence of FMPA 11 that I have, but I find it strange to be unable to remove it. Any ideas? Thanks Carlos
-
- 4 replies
- 5.3k views
-
-
In my office we are currently using FM Pro 8. I want to upgrade to FM Pro 13. Is my version too old for an upgrade? Do I need to buy the full version and just convert my existing databases to the new format? Thanks!
-
- 8 replies
- 5.5k views
-
-
I have a friend who has just switched from a PC to a new MacBook. We are having trouble transferring files between us. When ever I send her an updated FileMaker Pro file, or whenever she returns it to me, the name changes, and it requires several steps to get it to open - like this: 1. We have an FMP file called PZF 6/28/14 2. One of us makes additions or corrections, and Emails it to the other 3. When downloaded, the file shows as a generic (blank page) documant, and is titled PZF 6_28_14 4. While downloading the receiving Mac asks if it should open the file with Text Edit or Font Book - naturally, the answer is "No" 5. To open the f…
-
- 3 replies
- 2.6k views
-
-
Could use some help hunting this down. I have a relational database with one table containing 3 primary data fields to find records including a status which is Pending, Active or Complete. The other selection fields are Activity, Project type, Program type. When the found set selection is status is Pending and Program type is Emergency Repair, a phantom record is created which I can delete. If I add the Project type to the find, no phantom. If I add the Activity to the search, a phantom is created. When I search for Pending on all other Program types in the database, there are no phantoms created. It is only for this one program type, Emergency Repair. Once pa…
-
- 3 replies
- 3.7k views
-
-
I know FIlemaker says it does not support FM10 on a new Windows 8.1 computer, but I wonder if anyone has had success doing that? I will have to dump my WinXP computer soon and hope I will not have to buy all new software for it.
-
- 1 reply
- 6.2k views
-
-
Hello, I manage a warehouse and created a database that maps all the pallet locations in the storage racks (about 400 uniquely named locations). I created a field for each location and each field has the same name as the location (ie: PR.001.A.01). The 400 unique fields are in 1 table named(Specific_Rack_Locations) and reside in 50 different layouts. There is only 1 record for this table. When something is received into the warehouse I create a record in a different table named (Receiving Data). It has many fields, 2 fields named (Control_Number) and (Location_Assignment) are the focus of my question. (Control_Number) is a serialized auto enter number field. (Locatio…
-
- 3 replies
- 3.3k views
-
-
I'm running FM Pro 11 and recently installed it on a new Windows 7 laptop. Now a script that executes wget no longer works. See attached file for the error. I have installed wget in the Windows/System32 directory and that directory is in the PATH. I can sucessfully execute the batch file that contains the wget outside of FM Pro; it fails however when it is executed in a script (send event) Any ideas? Thanks.
-
- 2 replies
- 3k views
-
-
I have found a Starter Solution template that I want to use. But to authorize secure accounts I need to know what the original password for the file is. I am in FM 11 Advanced. Any help? Thanks!
-
-
- 2 replies
- 3k views
-
-
I am working with a FileMaker application that was built and maintained in FMP4, and am trying to migrate into FMP11. The files were converted first to .fp5, then imported into FMP11 and coverted to .fp7. Overall the fields, layouts, scripts and security accounts survived the process with only some adjustments. However, there is a problem with deleting records through a portal. Our main DB layout contains a portal to another table in another .fp7 file. The Relationships chart shows the relationship, and has the "Allow creation of records in this table via this relationship" and "Delete related records in this table when a record is deleted in the other table" chec…
-
- 1 reply
- 4.7k views
-
-
hi,  on Windows 8.1, Filemaker 11.0.1 installed successfully, but when trying to update it to .2 or .3, I get a window that seem to be a manual to a command line (see attached)  I've tried compatibility mode, troubleshooter... no luck  any suggestions?  thanks alex
-
- 4 replies
- 3k views
-
-
I have a vertical solution that is designed to fit on screens that are 1024 pixels in height or higher. I have a client with several computers that have resolutions of 1080 pixels in height, but our solution does not fit correctly. The FileMaker window is maximized and if I run the function Get ( WindowDesktopHeight ) it returns 641. Has anyone ever seen this before? Is there a fix for this problem? OS: Windows 7
-
- 0 replies
- 3.1k views
-
-
I am using FM Adv 11 on OSX I have a pretty simple situation. There are a couple of navigation buttons (right and left arrows) that, when clicked goto next or goto previous record. The 'mystery' comes into play when I navigate through my database, I get a beep on 'some' records'. It frequently is NOT reproduceable on the same record. It also occurs when I open a new window with a new layout in that window. Silence would be golden if I could figure this out. Your help is appreciated. Thanks Ron
-
- 6 replies
- 4.2k views
-
-
I have 6 golfers per team and I want the 4 lowest scores from each team to be a total team score, but I don't want to click any buttons, just enter each players hole scores and once the total 9 hole score is calculated for all six golfers it ranks them. I understand that there may be scores with the same value (40,36,40,42,52,43) end result (36,40,40,42= 158).
-
- 44 replies
- 10.3k views
-
-
I know there was a problem in the layout mode that was updated but yesterday we ran the new update 10.7.4 and now the files blur when scrolling until it goes dark. Only inside the database. The FM program frame with headers is unaffected. You can go out of one report to another and it corrects itself when going back to the prior layout, but only until you do another query. Help.....
-
- 16 replies
- 5.7k views
-
-
Hi, I am trying to figure out a way I can have the user insert text based on choosing an option from a drop down list. I have a bunch of different "template" texts, to be used based on a situation... i can't figure out how to script it. vandy
-
- 4 replies
- 4.4k views
-
-
I'm using Filemaker 8.5. Trying to add a command to a script to open a window to an SFTP (Secure FTP) site. The URL format is like this: sftp://[email protected] I'm using the Open URL command. I can get it to work with "regular" ftp URLs, but it doesn't seem to work with SFTP URLs. Any ideas? thanks!
-
- 2 replies
- 2.7k views
-
-
Hi, question about my first foray into JDBC: Background: FM Pro Advanced 11, intermediate user, not a Java programmer, Mac OS 10.7, latest Java update installed, downloaded FM JDBC driver (fmjdbc.jar) from FM website, copied to /Library/Java/Extensions as instructed. Tried to copy and compile the short Java program in the FM ODBC/JDBC manual to confirm connectivity, (BTW, why would that manual have a sample program with the message "Note This example is not meant to be compiled."--not nice!), and got an error. Source code: import java.sql.*; class FMPJDBCTest { public static void main(String[ ] args) { // register the JDBC client driver t…
-
- 0 replies
- 2.7k views
-
-
I am sending emails to people in my database telling them the mailing address we have is incorrect. I want to include the "fields" that refer to that address in the email so they will see what address, city, state we were using. I cannot figure out how to insert these fields with the correct operators around them so i can have each email customized for that person in the database. Here is a sample of the email i am sending. DNNUserExport Converted::firstname& ":¶" & "x organization is verifying snail mail addresses. We sent mail to this address and it was returned to us." ¶¶ DNNUserExport Converted::address1 DNNUserExport Converted::city DNNUse…
-
-
- 15 replies
- 8.2k views
-
-
Do Filemaker Pro 8 and Filemaker Poro Advanced work in OS 10.7?
-
-
- 4 replies
- 4.6k views
-
-
Hi everyone and excuse me please if I seem ignorant of the inner workings of Filemaker. I stuck together my database a couple of years ago when my brain was younger, fresher and it took me the best part of 2 months !! We use it for writing invoices and creating quotations for my wife's business. It has worked absolutely brilliantly and I think FM is a wonderful bit of software. However I have just upgraded my wife's computer to Mac operating system OS10.7 (Lion) and suddenly a strange thing seems to be happening. This only happens on her computer and not on mine running OS10.6.8. When she uses one of the little drop down calendars to insert a date it …
-
- 10 replies
- 7.4k views
-
-
Hi, I have bought a FMPro 8 advanced CD second hand, but got a Volume License Agreement license for FMPro 8 (not advanced) from the seller. Seller most probably bought a boxed product and did not register it. FM Support can not help me. Does anybody want to get rid of their FMPro 8 advance Licence (key) kind regards, Iwan
-
- 1 reply
- 2.9k views
-
-
I have heard from several sources that the FileMaker Pro cache should be set to 256 MB. I would like to heard recommendations on cache size for FM Pro 9 and the following memory sizes: 1 GB 2 GB 4 GB Any help would be appreciated.
-
- 0 replies
- 3.2k views
-
-
I have used the Developer Utilities in FM11 Pro Adv before, but now every time I try to create a runtime solution, the Create button is grayed out. Yes, I have selected the correct options, etc. I tried on files that worked just last week, but no go today. So I created a junk .fp7 file with only one table and one field. Still, the Create button is grayed out when trying to process this minimal file. Anyone have an idea of why the Create button is grayed out?
-
- 1 reply
- 3.3k views
-
-
I need to be able to find the version of Internet Explorer that is installed from a FileMaker script, so that I can prompt my users to install the latest version of IE. I have done a lot of research and have found a way to do it on WinXP and Server 2003, but that method does not work on Vista, 7, and Server 2008. Any help would be appreciated.
-
- 1 reply
- 2.6k views
-
-
Hi, I am having a problem with FileMaker Pro 9 in MacBook Pro (Lion). I got an error message "FileMaker cannot share files because another user is already sharing files" when I started my databases. I have tried all the solutions I could find on the internet, but the problem still not resolved. Any help from you will be very much appreciated. Below are what I have tried. 1. Uninstall and reinstall. (no luck) 2. Set IPv6 in Network advance setting to "Linked-local onlly". (no luck, it is not possible to turn it off). 3. No other copy of FM Pro is running 4. No FM Pro server is running in the network 5. unplug network cable from the computer (still get…
-
- 3 replies
- 5.7k views
-
-
Hi I have just gotten delivery of a new laptop. How do I deactivate my licence on the old machine and set it up on the new one?
-
- 4 replies
- 5.2k views
-
-
My mouse wheel scrolling does not work correctly. I can scroll, but only when I spin it very fast, not slowly one record at a time. I'm trying to scroll through the records while I'm in "view as form" in "browse mode." Has anyone had this issue and found a fix? Is it a FileMaker setting or a mouse setting? I just upgraded my computer from Win XP to Win 7. I had FileMaker Pro 11.0 v3 on my old machine and again on my new machine. I'm using the same mouse that worked on my old machine but now does not work on my new machine. Other folks in my office have Win 7, but they are not having this issue. Any help would be appreciated.
-
- 2 replies
- 3.5k views
-
-
Hi All, FMP 8 on a G4 mac running OS 10.3.9 (soon to be 10.4.11, but here we are). FMP Server 8.5 on... something else, but also mac OS. also old. I don't think it's a server issue. Running FMP8 on client works fine. However, when using "connect to remote" to connect to the server, I get a license conflict. With myself! -number of users connected to server doesn't affect it. -number of users on network doesn't affect it. -restart does not fix -deleting preferences does not fix -Reinstall did not fix -License key is a real key, on the jacket of the disk. this license was previously installed on this machine, but it's been through a fo…
-
- 2 replies
- 3.6k views
-
-
I'm very newb when it comes to filemaker pro 7 but it is a beast i have inhereted. Here is all i want to do, i want to rename the usernames i have in pro 7 to a different name structure (currently it's lastname first initial and i want to change it to first initial lastname). As soon as i do that i no longer see the info for that user? Any help is greatly appreciaited. Koury
-
- 10 replies
- 5.5k views
-
-
Hi. I'm new to the forum, and could really do with some help. I've made a Job Book FMP file. And got it all completed and ready to roll. Put a user and pass on it so it's secure. And completely forgotten the login details. Before I get flamed for being stupid, or accused of stealing the file, please save your breath! My name is Aran Jackson, I work for Gavin Willis Art Direction LTD. Northampton UK. The file doesn't contain anything apart from a few test fields. Happy to supply the file if anyone can help with this... please do! (File attached) (My boss is going to kill me if I don't sort it today) Thanks in advance Job Book.fp7.zip
-
- 1 reply
- 4.5k views
-
-
I am running FM 11 v3 in OSX. My application was running great until I installed Lion. Now my date fields are in Japanese. There does not seem to be any way to get them back to 'normal'. Or, am I missing something? Thanks
-
- 3 replies
- 2.4k views
-
-
I recently bought FMPA 11v3, but there appears to be an issue with Entourage and this version - I am supposed to downgrade to 11v2 to make it work. Where do I find an installer? Obviously, my purchase can't be downgraded thanks for any help, Don
-
- 0 replies
- 1.5k views
-
-
I have an early version of FM pro but with the new system for Mac (Lion) I find I have to replace it as it wont work on the new system. I have downloaded a test copy from the internet which works OK on the old system and was offered a new copy for $299 US. I contacted a local dealer and was advised that an Australian copy would cost me $499. The price difference seems unreal and I would like to know can I use the US system in Australia and what is the difference between the two versions. I assume that version 11 works OK with Lion is this correct? Ianbag
-
- 1 reply
- 1.7k views
-
-
Has anybody experienced a failure within a new calculation of the "Evaluate this calculation from the context of.... " list to update with all appropriate relationships in the relationship graph. My file which started life in FM5 lost its reference to the main table recently, necessitating all new calculations to be copied from a previous calculation, which still had the full list, and then amended. I have partially overcome this problem by deleting the two relationships that remained in the list. Somehow this forced the main table to reappear in any new calculations and a couple of others popped up as well. However, I am still missing about 20 that have been created o…
-
- 0 replies
- 2.7k views
-
-
This is the behavior I've seen reported to expect when updating files created in pre-10 versions that have Custom Menus which are missing new features, like Saved Finds. "1.2. To add new custom menu items such as Saved Finds to menu sets created in versions prior to FileMaker Pro 10 Advanced, create a new custom menu and add the new menu item from the list ofstandard FileMaker menus in the Create Custom Menu dialog box." However, what I'm experiencing is that even if I create a blank, new menu item, [saved Finds] is not available for selection as a Sub Menu item. [saved Finds] isn't in the list of menu items, period. If I create a new file in 10, of course…
-
- 8 replies
- 8.6k views
-
-
Is there any problem running a FM9 application in Windows 7?
-
- 1 reply
- 3.7k views
-
-
Is there anyway that I can freeze a column like in Excel in a filemaker database? I have a DB with names that are the first Field column and I want to freeze the pane so when I scroll waaaay over to the right they'll travel with me
-
- 5 replies
- 6.6k views
-
-
When I open a series of files I find that the majority are neither listed in the Window - Open Files listing nor the Window / Show Window (hidden files) listing. The only practical way to navigate between files is to minimise the one in view, select the other file I need and maximise it. Surely there must be an easier way than that? I wonder whether this is an error on my system or a shortcoming of Filemaker 9 Advanced?
-
- 1 reply
- 3.8k views
-
-
Hello, I am a FM novice. I work with Filemaker Pro 10 and here is my problem: I have a field where one can choose the value from the value list. Values are "YES" and "NO". My goal is to create the script which will navigate the person to the other specific field if he/she chooses "YES". As far as I understand this, I need to tell the FM that my "YES" in value list is certain number and then tell FM in script that if the Field matches this number then go to the field... But how to tell the FM the first text value in the valuelist is some value (number etc.)... Of course, any other suggestion/solution is welcomed. Thanks!
-
- 0 replies
- 2.8k views
-
-
I have (maybe foolishly) just deleted a copy of 8.0v2 as it seemed to be opening my 8.5 files. However, I now get the above alert on opening my 8.5 files and am wondering if I can re-install the dictionary (not sure if it exists even) from maybe my install disc - is there a custom install for this or should I be more concerned...i.e. have I got a major problem here. Thanks in advance.
-
- 2 replies
- 7.5k views
-
-
Good Morning, I am trying to get some items in the header to only print on page 1 when there are multiple pages. Thanks
-
- 2 replies
- 2.4k views
-
-
Warning. If you are developing a solution to be used by both FM10 and FM11 users, you will now have to take care to watch the GET functions. The following get functions are have changed their names! Open a file in FMP11, create a new script that uses these one of the new functions, then open it in FMP10. The 'new' functions are not recognized. (not forward compatible) Even worse, open FMP11 now modify your new script to use either the old name or the new name. You can't use the old name in FMP11 since it is not a recognized function. (not backward compatible) This is going to be a nightmare for those people who are using both 10 and 11. I …
-
- 20 replies
- 8.6k views
-
-
I think FM 11 portal filtering will have a lot of great uses. It also presents some problems that will need to be solved. For instance, you can set up a filter that might show invoices by date or customer or something. Handy. But - how do you get the total for this filtered subset? The existing sum() function won't work, because it only operates on the basic relationship and is not affected by the filter. Of course, you could create a let function in the filter calc that creates a global variable. Hm.
-
- 25 replies
- 9.3k views
-
-
I have a data base that I am keeping track of speeches each event creates a new record and I have it tied to a contact ID I just want a summary field listing all the talks this person gave with a comma between them......... I do not want to do a report layout just a calculation field listing the talks a person would be giving. Thanks in advance..
-
- 2 replies
- 3.9k views
-
-
I've recently updated to FileMaker 11 and often find when I try to paste an image that some sort of macro recording window comes up instead. It displays a number of buttons including play pause and fast forward. What is this and where is it coming from?
-
- 3 replies
- 2.1k views
-
-
I run a solution on FM 9 Adv. for one project that is data entry and printing of form letters and envelopes.There are some simple printing scripts as part of it. A second person helps out and enters data through IWP sometimes. Now that business has increased and we need her to print too. The data is kept locally on my MacBook Pro and it can remain there. The second person is normally only there when I am and there is no particular need to store the data on a server. Given that, what version of FM do I need so she can enter data and print just as I do running the original data and solution located on my computer? Do I need server or can I just get for her FM9?
-
- 3 replies
- 3.6k views
-
-
I'm trying to create a button that lists all client records where their birthday is due within x days. I.E. Press the button and there appears a list of clients who's birthdays fall within the next 30 days. I'm sure it's been done a hundred times, but the method has changed in FM7 and I'm stuck. I would appreciate any help from you gurus out there!
-
-
- 10 replies
- 5.9k views
-
-
Hello, I wanted to know what is the simplest way (if a way even exists) to send a filemaker page to someone through email and have them fill out missing forms remotely. After a cursory search, I see that there are several email pluggins for Filemaker, but I have little knowledge of the program, let alone with it's pluggins, and I don't know which ones (if any) could help me accomplish this. As a backup, is there a plugin that will let me send out a filemaker page to someone through email, have them fill it out, and send it back to me through email so that I can manually update fields? The important part is that I can send someone a page with some empty forms, …
-
- 3 replies
- 5.4k views
-
-
An update for Version 11 was released yesterday. http://www.filemaker.com/support/downloads/ Lee
-
- 0 replies
- 2.2k views
-
-
I created a full name field by calculating First & " " & Last. All are text. It works on the layouts. It works when printing to PDf and preview. I actually see the full name. I then export the fields to a basic file. This gives me plain text, with each field surrounded by quotes. The fields all are what they should be, except for the full name field. It is "0" in every single instance. Why does it not produce text instead of 0? Is there any other way to output the fields as plain text. I don't really need the quotes, but I do need text in a file (not pdf)
-
- 2 replies
- 3.5k views
-
-
Hello, I am new to this forum and File Maker too. I am creating a database of my family tree. I don't have the expertise to do a proper family tree so I am doing a simple tree. However I need a little help. Here are the details I have created a database where every record is an address book card of an individual. So far we have traced out 350 people in the family tree. So in the database we have 350 individual address cards. We have fields for spouse, children, and siblings (does not include cousins) The problem is when I enter something in those fields can it be somehow linked to an existing record? For example If I list my children as John and Lisa I s…
-
- 1 reply
- 7.7k views
-
-
Hello fmforums community! I have filemaker advanced 10 for windows and I need to create a solution for. My work and I would like to be able to allow powerusersz to be avble to add new users frfom a runjtime db because they don't have fm on any computer at work... if you could advise me on how to accomplish this then I. Would greately. Be appreciste it
-
- 3 replies
- 2.7k views
-
-
I have a client who reported an error message saying 'Unknown error 18'. When he tried to find another record the list kept coming up with the same 3 records he had before he went into the find. The error message actually appeared twice every time he tried to do anything. It works on other machines. He re-started and the error kept coming up, but when he re-started a second time the error had vanished. Does anyone know what this error is and/or has anyone encountered it before?
-
- 4 replies
- 4k views
-
-
Hi I Installed FM pro 11 advanced (upgrade) with dutch and english language. But default it starts in dutch. Which I don't want because most manuals are in english. Thats why I want the english version. What way can I accomplish this? It is not in the preferences. I'm on a mac. Thx Sabrina
-
- 2 replies
- 6.3k views
-
-
[blurb] OS Level Scripting and Account Privileges: A New FileMaker Server® 11 Feature By: Wim Decorte and Steven H. Blackwell FileMaker Server and FileMaker Server Advanced both allow for the running of OS level scripts such as VB Scripts, Windows batch files, Shell scripts and AppleScripts. FileMaker Pro developers must manage privileges that such scripts require to execute properly in these instances. Because they are triggered by FileMaker Server they run in the Local System bubble on Windows and the fmserver bubble on Macintosh. Frequently these accounts do not have privileges that the OS level script needs to perform the action a developer …
-
- 8 replies
- 15.5k views
-
-
New to FM. Is it possible to have a picture represent a button to go to a report? Example: the button would be a picture of a Barn; by clicking on the button the action would display the report on Farms in the area that have rental Barns. Or is there a way to insert a picture onto a button? evrcarlson
-
- 1 reply
- 2.7k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online