FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Speed issues - v6 vs v7 I have recently translated a database solution from 6 to version 7 and have finally got the whole thing to work exactly the same as before but this time all the separate related files in one single file. However I have noticed that running in version 7 the whole database is significantly slower. Simple routines were faster on my old 400MHz G4 laptop in v6 than on my dual 2GHz G5 running version 7. As a test to make sure it is not coding errors i ran a simple script that 'shows all records' (850) then places a '0' in a single field in each record. In version 6 this takes less than a second. In version 7 this takes over 9 seconds and even sho…
-
- 46 replies
- 7.5k views
-
-
Greetings, we have recently upgraded to FM7 server and FM7 clients recently installed. I have converted the original FM6 files and all seems well apart from the following: When in layout mode whenever I wish to edit an object, the screen refreshes up to 8 times, usually after I click on the object to be edited..this may be a txt box or field or graphic object. Also is FM7 significantly slower than previous releases or is it jusy my FM7 ? And finally, in browse mode, whenever we edit data in a portal or change from one layout containing a portal to another also containing a portal, there is a long delay, 5 secs or so, when re drawing the portal. (have…
-
- 0 replies
- 872 views
-
-
I would like to have the text in one field change color as a result of a value in another field. Field 1 is TASKS: Field 2 is PRIORITY If the priority of a task is urgent, the font would turn red. If the priority of a task is not urgent, the font would remain black. Is something like this doable in FM7? Are there any plug-ins available that would do this? Thanks, Jarvis
-
- 27 replies
- 5.2k views
-
-
I have follwed FileMakers directions with no success. I can not delete a layout from the database file. I have tried to delete individual elements with equally no sucess. Everytime I try to do so FileMaker crashes. Does anyone have an ideas on how to delete a damaged layout other then what FileMaker recommends. I have done a recover, but that has not solved the problem. thanks in advance.
-
- 4 replies
- 699 views
-
-
Hello. I am creating a vendor ordering system for a business and I
-
- 4 replies
- 1.1k views
-
-
I am trying to use the Get (FoundCount) function to show the number of records in the current found set but no matter what I do it only returns the total number of records. This is all part of an attempt to hide the Status Area but still allow users to have all its features. Anyone know why this won't work?
-
- 4 replies
- 3k views
-
-
I have tried to search the board with this question but have had no luck. This is my first post (do I look nervous? ) so a point in the right direction would be nice. Is is possile to launcah a script with a keystroke?
-
- 1 reply
- 686 views
-
-
Hello Everybody, I'm fairly new to Filemaker Pro. I used to use Daylight for Mac OSX for all my CRM Tracking but for some reason my database got corrupted and It would not open anymore. Thank god I had an Excel file with the most recent information. However, I just downloaded the trial version of Filemaker Pro and I'm looking for some good resources on how to make my own database and who knows maybe offer Filemaker costum solutions to my current costumers. My question is. Does anybody have some good advice on how to start, training websites, tutorials etc..? Thank you.
-
- 5 replies
- 1.1k views
-
-
Hello all, I am new to FM. I have a very nice E-commerce system running on a MySQL database. A company asked me to build them a e-commerce system. They are using a Filemaker Unlimited 6 database with product info. I know how to write a script to automate import of CSV into MySQL. The question is: how do i automatically have Filemaker export values of a table to a CVS. I have FM running in trailversion right now and discovered that it is possible to make a script to export certain fields (in a particular/preferred order) from a table into a CSV-file. Can i schedule this script to execute every X seconds/minutes/hours? If so, how? Can i also have FM automatically imp…
-
- 2 replies
- 2.6k views
-
-
I have a coach who uses a runtime version of FileMaker Pro 6. It is a program that keeps track of player stats and weights and such. He has two files that say they are damaged. That I should use the recover command. Problem is, I don't have that option on the runtime version of the program. Is there anyway to get this "Recover" program without buying the full blown version of FileMaker 6 ? Thanks in advance.
-
- 4 replies
- 1k views
-
-
Hiya, I haven't seriouly used FileMaker since high school (long time ago) and I desperately need some help and advice. I'm trying to develop a database (DB) to help with obtaining price and availability. This process involves using a web site to establish what companies are holding stocks of products I require. I search for a given part # and use the DB to record companies that have that part at the time. As I work through the list a company may have more than one part I require so upon completion I need the DB to produce a document that I can fax to the company with all the parts they could possibly supply. My example works but I'm having trouble with repeating fiel…
-
- 2 replies
- 712 views
-
-
Does anyone know how I can determine the "file size" of each table's contents. In past databases (v5) I found the file sizes very telling on the efficiency of my designing. Any ideas? Thanks - Peter
-
- 2 replies
- 1k views
-
-
Hi everyone, I have a question. Is there a limit to the number of characters used in a sort? I have a solution that has a field containing data from 3 different fields. I have a script that uses this field to find duplicates. I sort them first and use a loop and a global field. If the global matches the field then is flags it as a duplicate. I have one item that doesn't flag as a duplicate and the only difference I can see is that it is the longest item I have. The field is as follows: "J 0001463 Connector, Fargo-Bonding And Grounding. GC 164 Fargo, Connect Ribbon Or Braid To Ribbon, Braid, #6 Or Bus.WTR." I tried using the trim function to eliminate a…
-
- 1 reply
- 924 views
-
-
I am running FileMaker 6 Unlimited on a server machine which also serves CDML to my clients. On another Mac I have been testing and configuring FileMaker 7, Network sharing and Instant Web Publishing is turned of on FM 7. It seems that something FM 7 is doing is freezing up FM 6 on the server machine (the colored, spinning beach ball appears). It does not happen all the time, but enough that I have to keep checking to see if FM 6 has frozen up. Anyone have any ideas as to what is going on here? Thanks in advance.
-
- 2 replies
- 760 views
-
-
My database with 3900 records became damaged. I was not at work when it happened so have no history. When I used the Recover command it crashed Filemaker. We have Mac OS X at work and that's where I attempted to recover it. So I did a backup, brought it home and tried to recover it on my PC, Windows XP. No luck, it still crashed Filemaker. Any suggestions?
-
- 4 replies
- 1.3k views
-
-
Hi all, Does anyone know an effective way to Archive old records in FM7 Server for Windows? For example, every year the admin can run a command to Archive all the previous year deleted/completed projects (records) onto another database and then achieve that database in some way to keep the current DB lean. The reason why I need to implement this function is because I afraid after a few year, the database will become too big and might slow down the access speed signficantly. I use audit tracking intensively in the database also, so the db will grow in size very quickly. Thanks! Testinz.
-
- 1 reply
- 2.6k views
-
-
I am using FileMaker 5.5 on a Windows 2000 platform. Does anybody know what the maximum number of records is for a single database? Thanks, ThePopp
-
- 4 replies
- 1.2k views
-
-
Does anybody know of a plug in for making simple bar charts or pie charts? I bought a license for X2Max some time ago. While it is a very robust program, it also comes with a commensurately robust learning curve. What I would like is something that operates with the simplicity of the charts in MS Excel. This might be one of those no pain - no gain kind of things but I thought I would ask. Thanks, Jarvis
-
- 1 reply
- 767 views
-
-
Can I make the scroll wheel on the mouse scroll a page in FileMaker, by default it just scrolls though records and I'd rather just work with one record at a time.
-
- 0 replies
- 788 views
-
-
Hi, I am trying to install the zippScript plugin for FM7 under Mac OS X. I tried to copy the zippScript.fmplugin to both the "extensions" and plugins folders in FM7 Directory and it still doesn't work (cannot find it under FM7 plug-in configuration menu) Please lets me me know how to get this to work in FM7 Thank you, Testinz.
-
- 2 replies
- 1.1k views
-
-
I am getting really frustrated with the graphical "drag" in layout mode. It doesn't matter whether the graphic is a jpg, png, etc. Sometimes it leaves a permanent overlay when it is moved around, sometimes it is fine. Sometimes it will let me put a graphic on top of another graphic, sometimes it won't. I am not trying to do anything transparent. Copy and pasting doesn't resolve the issue. The problem is totally inconsistent--even using the same graphic, one day it will work fine, then the next day it starts all over again.Is this a problem for anyone else or am I cracking up? I am finding it hard to pin point a technique that doesn't make interface design a big pain in …
-
- 0 replies
- 775 views
-
-
After I used the wizard to enable the statistics log I cannot login anymore to the Server Administration Tool it keeps saying cannot login. I suspected that the administrator password unintentional was changed by the wizard. Is there someone who nows how to reset the password. The filemaker support centre only came up with the solution to reinstall the server Cheers, Alex
-
- 0 replies
- 658 views
-
-
For any interested in the new Unicode capabilities of v.7, here's a report of my initial (successful) experiments with polytonic Greek. For context, I'm a prof who teaches ancient Greek (tech. koine) which is polytonic, rather than modern, monotonic Greek. I've used a database of Greek vocabulary words for many years in FMP3 (it started life in v. 2) using a legacy encoded font (actually 2 different ones over the years, most recently my own Galilee font). To move this data to Unicode encoding in FMP7 I first exported it from FMP3 as an ASCII text file, imported it into Word, formatted it as a giant table, changed the font of the GreekWord col. to the Galilee font. I …
-
- 2 replies
- 1.2k views
-
-
We use a Windows 2000 FM webserver and it works fine! But we have one problem: If a person on the console of the Windows FM webserver with the rightmouse button clicks the FM server does give an reaction on the web. Can we prevent this problem ?? Thanks any way for your reaction!
-
- 0 replies
- 909 views
-
-
I know in Mac OS you can print to a PDF, which is really handy... when I try to print to file on windows it exports it in some unknown file format... can anyone clue me into either a readable file format or pdf option? Thanks
-
- 4 replies
- 1.3k views
-
-
The weirdest corruption I've yet seen w/ FMP. I'm building a db for a client using FMP Dev 7.0v3 on Win XP. I've been working on this project for over a month now without any major hitches. I'm building separate front- and back-end files (only 2 files). My habit when developing is to make very frequent copies of the files using File > Save a Copy As. I just let FMP fill up the directory w/ automatically-numbered copies, then periodically save some to zips and delete the rest. Yesterday I did the following, in this order: * Saved most recent copies (from day before yesterday) to zip * opened the working files * after poking around, ran a DDR report a…
-
- 0 replies
- 881 views
-
-
what is the database capacity or size of version 6.0?
-
- 3 replies
- 924 views
-
-
I'm running FM 7 on Mac 10.2.8 and can't double-click to move field names or functions; e.g., in the "Specify Calculation" window, after selecting a function from the list, double-clicking my mouse does not move the function to the dialog box, I have to type the function in the box, and ditto for the field names. Thanks.
-
- 3 replies
- 809 views
-
-
I am having funny problem on fileMaker Pro 7 during printing. I completed a filemaker pro database called ABC.fm7. Then , I decided to duplicate entire ABC.fm7 and call it XYZ.fm7. Everything work well on XYZ.fm7 but the only problem is during printing. I am using Mac OSX. While printing XYZ.fm7 on any of the layout, I open out the printing progress to check the status. To my surprise, I read as Name ABC is printing instead of XYZ is printing. Is that a BUG on FileMaker Pro 7 or am I able to change something on XYZ.fm7 so that I see XYZ is printing instead ABC?
-
- 1 reply
- 751 views
-
-
Hi, I'm a real newbie to databases, but am a computer veteran of some 22 years. I'm using Filemaker Pro to create a really simple customer tracking database, where I just log their details into a single page. Now I want to add some extra functionality: I need to make a kind of sub database that can be attached to the main customer record where I can make lists of what each customer brings in to me to be repaired. I initially didn't think I'd get that much repeat work with what I do, but it's growing and my database is inadequate. Ideally I click a button and it takes me into a sub menu or database with all that customers repaired items. Any suggestions…
-
- 6 replies
- 871 views
-
-
Hi, I just installed Filemaker Pro 7 and also FX.php library. I tried to access data in filemaker using php script, but was unsucessfull. Fatal error: Cannot use object of type FX_Error as array in 'path_to_open_file'. I am using php 5.xx / apache on win xp. Any suggestion is appreciated. Thx, motley
-
- 0 replies
- 636 views
-
-
Would someone please point me in the right direction? I have 19 offices that all have standalone FM databases. I would like to collect all updates to their databases on a daily basis to a central, home office database. The offices only have dial-up internet connections. I am sure that solutions to this have alrady been worked out, and I don't want to reinvent the wheel. Any suggestions where to start looking for ideas?
-
- 6 replies
- 1.1k views
-
-
Hi Team, I've got a client whose been using my application for the best part of a year. He is hosting it on a Windows Server, with FM Server 5.5 and using Exec Backup to his entire drive. We had a hard drive meltdown, so we restored his drive, and all the applications were working as before the harddrive went down (so we thought.) The restored FileMaker Pro databases aren't opening, i've tried using the FM Pro and recover and I've had absolutely no luck. The Message I get is "Invoices.fp5" was not created by FileMaker or is severely damaged an cannot be opened. Any chance of someone guiding me to a utility or advice that will help me extract the data out …
-
- 12 replies
- 1.4k views
-
-
I have been playing around with different fonts in Mac OS X and Windows. I am currently using Verdana, which seems to look OK. The fonts on the Mac look great (because of the font smoothing) and when I run on Windows (remote desktop connection), it looks pretty jaggy. I get the same effect on my Mac IF I turn font smoothing OFF on the Mac. The point is, I know MANY of you have done both Mac and Windows versions and played the "what font should I use" game. Has anyone come up with a font compatible for both OS's that look good on both? Many Regards In Advance, Kevin
-
- 5 replies
- 1.1k views
-
-
I have a Microsoft Word X data merge document that was previously linked to a FileMaker Pro 6 data file via Word's FileMaker Import Wizard. After converting the FM 6 file to FM 7 format, Word no longer recognizes the FileMaker Pro data file. Is this due to an incompatibility between Word's FM Import Wizard and FM 7 files, or am I doing something wrong? Thanks. FileMaker Version: 7 Platform: Mac OS X Panther
-
- 5 replies
- 1.4k views
-
-
I have a set of records in the layout, some 50 or so. I want to be able to add new records, copy old ones etc and then modify them, but I need to put them in particular places. When I copy or make new records, they always go to the end of the list, and I cannot move them. New ones are always the last to show. How can I arrange the order of the records to suit my needs?
-
- 1 reply
- 987 views
-
-
Hi, I've got a DB that lists parts I require. Against these P/Ns I record possible suppliers for each part. I want to generate a list that I can send to a supplier to request availability. Each part may have many suppliers so must appear on each supplier list but not all suppliers carry all parts. The possible suppliers are entered from a drop down list into a repeating field (10) but I could change this as required. What I want to end up with is: Supplier 1 Part 1 Part 2 Part 5 (new page) Supplier 2 Part 5 Part 6 (new page) etc. Thanks Pedro :-)
-
- 4 replies
- 811 views
-
-
Hi! I just started playing with File Maker Pro 7. I got a huge data in excel and MS Access. I would like to import the whole data into a big table and then want to split it into separate tables. Can anybody tell me the best way to do this. I am using the import ODBC wizard but my boss don't like it using the Wizard. He wants me to make use of the File Maker functionality by writing code in SQL and writing some scripts. Any Help...is great.. Thanks
-
- 0 replies
- 1.3k views
-
-
Is there anyone out there that can help me on this? When logged in as an admin in FMPro, and we attempt to delete a record. FMPro stops responding and freezes. The computer is new so speed isn't the issue. I had tem try it on additional PC's with the same issue. So, it isn't an issue with the PC. At this point I am not sure what the cause might be. I am running FMPro 7 server and FMPro 7 clients connecting remote to a 2003 server where the databases are stored. Anyone have any ideas. Any help would be appreciated. Thanks.
-
- 2 replies
- 770 views
-
-
I am looking if some one could help me in converting my fm database in Arabic or Urdu Language. Do you have any information or you can tell from where I can get? Regards, Tusif
-
- 6 replies
- 1.7k views
-
-
Aloha and thank you for any help. I recently requested a trial version of FM Pro v7. I had used the application many years ago and am somewhat familiar with it. My problem is that I cannot figure out how to update some key words that I entered. I am using a template called Photography Catalog which allows for the creation of key words for searching. I input the key words (somehow!) and now cannot figure out how to access them again. I look forward to hearing from you soon. best! Ramona
-
- 1 reply
- 952 views
-
-
Hi all - hope the above subject is an appropriate discription for what I'm experiancing here. I'm using the very neat feature in FMP7 of saving external files into my DB. However I noticed recently that the overall size of my db DIDNT reduce in size after I deleted a number of entries that had a series of big files associated to them. This leads mt to suspect that FM7 does not automatically free-up that space. I've tried "compacting" my db (Filemaker tech support once told me that if you export your db - it causes FMP to free up any blocks) with little change. Have you had any scimilar experiances ... got any suggestions?? Thanks Giles
-
- 2 replies
- 845 views
-
-
-
I have a script (actually 20-30) that I would like to replace with 1 script using a new feature in FM7. The scripts delete a line in a repeating field and set a field in another table. Here is my question... How do I set a specific repetition (the script parameter) of a field to " " or clear it? The clear and set field command do not seem to have a way to use the get (script parameter) command. Any ideas?
-
- 2 replies
- 707 views
-
-
Is there any Filemaker API's available. if yes please mail me where can i get them. [email protected] Thanks CKReddy
-
- 1 reply
- 605 views
-
-
I just updated to Ver 7.3 not Filemaker not responding. Sometimes it works, but can not find the one thing that makes it crash.
-
- 1 reply
- 811 views
-
-
I did a simple data entry screen on File Maker pro 7, and i was wondering if it's possible when i open that window to start on a blank record (and not on the last/previous record) BTW(i'm a newbie on this) thanks in advance for help
-
- 4 replies
- 766 views
-
-
Hi All, Am creating a solution for a customer that has 2 locations, unfortunately one of the locations has no (and can't get it) broadband connectivity, so only dial-up is available. I need to syncronise the two databases. Only the data will change, there won't be any additional tables or rows added at a later stage (o at least they won't be doing it). Is there a way to do this from within FMP or do I need a 3rd party app?? Or is the best option to use FMP web connectivity and force the use of a web browser from the *far away* location??? Opinions/options gratefully received. TIA Dan
-
- 3 replies
- 791 views
-
-
I have a database for a group of people. Information like member addresses, chapters they belong to etc. The plan is to get this database online so that members can access info online and update there contact information, and view certain things in the database. I know I will have to use Server and figure all that out. But I would like to show them next month what FM can do and how it can work for them. Here are some questions I have 1) How to produce a report for someone that would not have the program.
-
- 0 replies
- 662 views
-
-
Seems simple enough, however I'm stuck on this one for some reason. Here's the deal... I have a field called notes_attachment which allows a file to be attached to a note entry in a notes portal. On the portal view I want to have a file icon if there is a file (any value) in the notes_attachment field. I have the file icon in a seperate table as a global field (where all my images are stored). Now, how would I setup a realtionship so that the field only appears on the portal if there is a value in the notes_attachment field? Thanks!
-
- 2 replies
- 759 views
-
-
I do this with serial numbers advancing with each new record and have never had any trouble. But I recently tried to have the same text added automatically to certain fields - defining it for each field - but the text doesn't show up. Any suggestions to fix this? My thanks and happy holiday wishes in advance.
-
- 3 replies
- 1.1k views
-
-
I created an email tool that sends emails using the send mail script. After each email is sent from Filemaker, the record is removed from the found set. Problem is, when the last record is omitted I'm left with zero found records and a blank layout. Is there a way to get the window to close if the found set = 0 ??
-
- 3 replies
- 1.3k views
-
-
I'm new to Filemaker and just created a file that tracks club information. Is there any way to create the file so it can be used by others who do not have the filemaker program? Does FM Developer do this? Required? Are there any other options without purchasing FM Developer? Thanks for any input.
-
- 1 reply
- 1k views
-
-
I have a multi-user license of Filemaker Pro 7. Is it possible to run 2 copies of it on the same mac ? Can I just make a copy of the Filemaker Pro folder and name the folder FMPro-2 ? Surprisingly, I tried copying the FMPro folder from my desktop to my laptop, and the program runs fine on the laptop. The reason I want to do this is that I want to have one copy of FMpro running a script once every few minutes .. but I want a person to be able to use another copy of FMpro on that machine. I tried using fast user switching to have two users run the same copy of FMPro, but the script interfered with the user and vice versa.
-
- 2 replies
- 766 views
-
-
I'm trying to create a field and have it display ONLY the year on a layout. I created a field ... TEST the type is Date. Clicked on Options and Calculated Value and in the calculation window entered Year(Get(Current Date)). I thought this would return only 2004 in the field test. What I get is 6/27/0006. I even tried changing the Get(Current Date) to a known date field and still get 6/27/0006. Has me baffled! Can someone tell me how I can get a field to display only 2004 when the record is created in 2004 and also.... what the heck is the 6/27/0006? I've already double checked that the date on my machine is correct.
-
- 3 replies
- 857 views
-
-
Hello, I searched the posts and didn't see this question posted anywhere. My question seems (forgive me) very basic and I feel silly for not being able to figure it out myself (not for lack of trying!) Does anyone know how to format text fields so that the line doesn't break in the middle of words? Seems simple, but I am using FM7 for a database that houses a lot of notes and research and this small thing is making it very difficult to read and search the text fields because they are broken up in odd ways. I would like the next word to be booted to the next line rather than broken in the middle.. Even a better way to phrase the question would help! Any…
-
- 2 replies
- 903 views
-
-
Is it possible to create/use true variables in Filemaker Pro or are global fields the only option? Thank you, rlbryant
-
- 4 replies
- 1.1k views
-
-
i have two accounts on my file. one admin with full priviledges, and one guest account for data entry only. my file is to open and login with name and pw. my problem is that the file opens into the account with fewer priviledges. im looking for a change user command i believe. thanx travis
-
- 7 replies
- 1k views
-
-
Hey guys, Me again! Don't understand 1. I have downloaded 7.3 painstakingly over the internet using morse code slow modem 2. I have it expanded in it's own folder on the desktop 3. I run a file called SETUP which welcomes to me to AGREE and DISAGREEable information - (has anyone ever been able to continue if you don't agree? Free-will proof!) 4. Insert your original disk of FileMaker Disk in drive - you have to click BROWSE because it immediately selects source as being "1" select D: then you have to go to FILES until you see the only file it is looking for FILEMAKER.MSI Uh, Uh - WRONG FILE! this is not the file - aye? yes i…
-
- 5 replies
- 870 views
-
-
this must have been asked a thousand times... I wasted my whole day on this. I have several tables. assembly, use, components, clients, suppliers. In use, I want to list all the possible assemblies that can be of use for a given location. In both use and assembly, I have a field called assembly_id, which I use to link the tables. I insert a portal into use, with this relationship selected, and try to achieve this: list the assembly name and some related fields from the record all uniquely identified with assembly_ID. Nothing happens. First I couldn't even select the fields when in browsing mode, even if made a popup menu. then I could display them, b…
-
- 4 replies
- 916 views
-
-
Hello! I've got a small Problem. I've got 4 Tables for 4 Different Invoice Layouts and I need to somehow create one Serial Number for all Tables. Basically one Serial Number spread across 4 Tables. Thanks for youre reply!
-
- 25 replies
- 2.5k views
-
-
I've been asked to design a database for up to 60 concurrent users. The awkward side of it is that the company in question use a mixture of Macs (OSX) and PCs (XP) attached to an OSX Mac network. There will be around 50,000 records altogether. I have to confess I am more of a M/soft Access designer than FileMaker but could work in either/both. Can FileMaker link to an Access database file? Can FileMaker run equally well on PCs as on Macs? Is there a more convenient back-end format that could then be linked to separate front-end files (perhaps FileMaker for the Macs and Access for the PCs)? If anyone has been down this road before and has some useful suggestions…
-
- 4 replies
- 814 views
-
-
Hi there, Can anybody tell me how many users Filemaker Pro 4.1 can handle?
-
- 5 replies
- 1.3k views
-
-
I recently upgraded to FM7 from FM3. FM7 seems slower, clunkier, and has even crashed on me loosing a whole file. Now I am trying to regress back to FM3 which suits my purposes but I am having difficulty exporting the data from FM7. The fields I am trying to export are fairly large text fields. I have tried using the various formats but it either cuts the data short or it sees small segments of the text as another field. Is there any method to do this short of cut/paste? Bill
-
- 1 reply
- 806 views
-
-
HELP! I think I have just committed one of the stupidest sins of program development - not backing up recent updates after compiling a run-time version. Within minutes after uploading an updated compiled run-time file to our chef's website for distribution an intruder toasted my drive. I do have an older un-compiled versions in my backups but it means weeks of rewriting. Is there a way to access the scripts, reports, etc. from a limited access compiled run-time version? Accessing the USR file from Filemaker gives me access to the additional fields I created however, the scripts and reports are non accessible. Any assistance would be appreciated.
-
- 1 reply
- 859 views
-
-
Hi, I'm currently trying to convince my employer to get FM 7. I have used FM 5 in the past and even set up some simple db files. If all goes well, I hope to be posting some questions here soon For now I'd like to know how the advertisers at the top of the Forum page can sell FileMaker so inexpensively. Thanks, Deborah
-
- 0 replies
- 626 views
-
-
We use a FM Calendar to transfer files to our website. Our current calendar ends at the end of Dec '04. How can I create/add months for 2005? I have tried all (I think) of the functions in drop down menus along the top of FileMaker... File, Edit, View, Records, Scripts - and I can't seem to find a way to simply start entering months for the calendar year of 2005. Anybody know how to do this? Much thanks. note: I have tried using the "Add New Record" under the "Records" tab, and it does create a month that would serve as Jan '05, but there is no year or place to enter a year, and I can't input data into the month. I receive an error message saying that the date…
-
- 1 reply
- 888 views
-
-
Greetings - We recently converted to FM7. We are having dificulties with searches: 1) Searches on calculated fields are producing result sets of all records or none. We have a calculation integer field that produces a 1 or 0 depending on criteria, then we search for a 0 or 1 depending on what we want to find. Searching for zero produces the result of all records. Searching for a 1 produces no records. The field contains both 0 and 1 (doing a sort on the field shows both values). 2) No matter what field I choose, wildcards are not functioning. Both the * (asterisk - something there) and = (equal - empty) are producing no records found. Any one have any …
-
- 13 replies
- 1.4k views
-
-
I've tried to create an "Advanced Find" feature in my database that searches on 10 fields in my solution. I've tried 2 methods... 1. The first is a 2 part script that enters the user into find mode for them to type their find criteria part 1.. brings you to a search layout, then enters the person into Find Mode part 2.. Triggered by a "Search" button..performs the find and if there are results, brings you to a results layout the problem with this was that after part 1.. if the person hits "enter" it just completes the find and the person is left with their results on the search layout! If this is the best way to go, is th…
-
- 1 reply
- 1.1k views
-
-
I'm trying to create a music schedule that will view all musicians scheduled to play from todays date and all dates in the future, in a portal. My tables are Music Schedule and Music Schedule line item. My relationship is (Music Schedule) "Todays Date" greater or equal to (Music Schedule line item) "Date". I want to be able to schedule musicians in the portal, but when I type in the future date in date field, it reverts back to todays date. Thanks for your help!
-
- 9 replies
- 1.2k views
-
-
Hi Hope someone has used FM Recruiter and can maybe give me some advice - I am a a bit lost! I have just started using FM Recruiter and am migrating all the records across (HUGE job). The person I am doing it for has 4 different existing FM databases. He does not want all the databases to become 1 so he wants 4 different FM Recruiter databases. This is where I get lost. With normal FM databases I would have made 4 databases with different names (the contents and purpose of each if different, but functionality and layout the same). I have tried this in FM Recruiter and they all seemed to be linked even if I put them in different folders. How can I create different FM datab…
-
- 4 replies
- 1.1k views
-
-
How do I display dates > or = todays date in a portal? I have created a music schedule using 2 tables, "Music Schedule" and "Musiclineitem". I want to schedule vocalist to sing on certain dates, but I only want to display dates greater or equal to todays date. What is the best way of going about this in Filemaker 7? Thanks, Sam
-
- 3 replies
- 847 views
-
-
Hi, I have a serial number that's part of a larger code. The number is basically a location code, year code, and serial number code... so "USA 04 1234" would be one example. The three components are all separate fields. Problem One. I wanted to use a portal to retrieve a summary field from another table, but then I realized I couldn't just reference the serial number (the 1234) itself because there are potentially two "1234", one for 2004 and one for 2005. So how do I use a portal? Can I reference via two criteria... the 04 and the 1234? Problem Two. I am used to the primary key concept in MS Acce$$, and one of the reasons why I like FMPro is that yo…
-
- 1 reply
- 760 views
-
-
Greetings - FYI... When printing multi-page scripts I am getting a blank last page. In other words, I have a script that prints three pages and I get a third page that has a header and footer but no detail lines. Can someone else verify this behaviour? Thanks In Advance
-
- 2 replies
- 755 views
-
-
Lets see if I can simplify that: DataBase A DataBase B rec_ID == link (relationship) In order to establish all the records in DataBaseA that are NOT related to B, my idea was to kind of "invert" their relationship. But how? I need to get all the records where link::link is empty... right? I tried it get these records, introducing the field: checkout_link = link::link and the self relationship in DatabaseA: checkout_link =/= rec_ID as the relationship but it doesn't work. Why? Checkout_link is supposed to be empty... I can get these records in find-Mode (seeking for the empty link::link), but I want it to be done with …
-
- 8 replies
- 1.1k views
-
-
Hello, How can you custom sort a radio button set? It appears as though the program defaults to sort alphabetically. Greg
-
- 1 reply
- 1.4k views
-
-
So I have upgraded to FileMaker 7 which has solved a lot of my problems from 6, but I need to convert my 7 file back to a 6 for another client. Any way of doing this? All attempts I have made have come up lame. Thanks in advance. KE
-
- 4 replies
- 793 views
-
-
I have been charged with a project. It sounded fairly simple at fisrt but it seems to be getting more difficult by the minute. I'm completely new to databases. What I need to do is make a contact DB in which you can sort by different criteria. Sounds simple so far. In fact, I think there is a template built right in. Here's my problem: I need to be able to sort by different criteria and then be able to send mass emails to the resulting list of clients. ALSO, I need to be able to print mailing labels the same way. I first looked into this with Access but found there was no easy way to do this. someone told me Filemaker can do it but I'm finding little evidence in thes…
-
- 5 replies
- 1.3k views
-
-
Well time for another problem. I have a database set up with a product table, line items table, and invoice table. It works fine. Now I would like to take it one step further. I would like to make a purchase order table, and keep track of quantity of items on hand, in the product table. So I make a table with vendors: kp_vendorID product product # price then a purchase order table: kp_POID kf_vendorID P.O. # extended price Total Tax etc add a kf_POID to the original product table and a quantityonhand field.. When that is done, and a Po is created where do I put the calc to increase the total in stock in the product table? Is th…
-
- 17 replies
- 2.7k views
-
-
Am I correct that search robots cannot index an online FileMaker Pro (5.5 Unlimited) database? What is the most efficient way to help say Google's robot know the type of information that is in your FileMaker database? Frank A. Reynolds Hunt Institute Carnegie Mellon
-
- 4 replies
- 1.5k views
-
-
Made an earlier post and couldn't find it... Can someone help me with 7.03 update installation? Downloaded the huge file and tried to install it by clicking the setup.exe file. When I did I got..... Windows Installer Dialog box saying... Incorrect command line parameters Windows Installer v2.00.2600.1106 Portions of software are based in part on work of independent JPEG group. All I can do is click OK and close the dialog box. Any help will be appreciated. Thanks Mike
-
- 12 replies
- 2.2k views
-
-
Hope this isn't too stupid a question, I'm no database expert. I need to update/combine a database with new information. I constructed a database (extremely basic voter information for a school levy) we acquired from the board of elections. I imported it directly into Filemaker and manually added phone numbers that we needed for contact info (phone numbers are not included in the original data we purchase). Each year, we get a new database from the Bd. of Elections and I need to update the phone numbers (along with a few other simple fields). Is there any way to match up the old information (name, address, phone) with the new voter data matched to the correct name, addres…
-
- 3 replies
- 1.3k views
-
-
Hi, I realize that FM7 is not compatible with Windows 98 but is anyone out there using some kind of workaround such as remote access software or virtual pc software in order to enable the last few stubborn holdouts with Windows 98 to use FM7? I have a very important user that has already told IT he wants to keep using Win 98, since he owns the company I work for it's not like I can tell him to upgrade. Any help would be greatly appreciated.
-
- 2 replies
- 952 views
-
-
You all probably know about the FM promotion where you buy a copy of FMP and give them the name of a friend to get a free copy. I'd really like to take advantage of this deal. Anyone wanna go in with me on a copy? I've got an educational discount, so it'd be $75 each. Lemme know. -t nb - I don't think that there is anything even remotely sketchy about this since there are no restrictions about who gets the free copy or what the "license" is.
-
- 0 replies
- 737 views
-
-
im having trouble inserting a company logo (PDF format) onto one of my layouts. when i try to insert the file, i only get the icon along with the file name underneath. should i be inserting picture, object, or file?
-
- 1 reply
- 1.2k views
-
-
I heard there is a way to publish a series of events (date, event, time,venue) from filemaker to the ical calendar. Can filemaker be used as suscription server for iCal? If so, how? Thanks
-
- 2 replies
- 1k views
-
-
I've built a layout that I love, but it takes too long to load -- it loads in list mode.. and looks kind of like a spreadsheet but with lots of cool bells and whistles... I'm thinking I can dramatically reduce load time if I only load the first 30 records at a time and then have a "<<prev 30" "next 30 >>" option to scroll to the next/prev page of records. Could someone tell me the basics for how this is achieved ?
-
- 7 replies
- 1.1k views
-
-
I want to be able to reverse the last change a user has made. Maybe the solution is incredibly easy and I'm just not seeing it
-
- 7 replies
- 4.4k views
-
-
My main database file is severely damaged. Not only that, but whatever it was that corrupted the file, was saved with the backup copy as well. The data is still there but the table occurances in the graph have disappeard and all of my layouts give me the "table missing" nightmare. When I go into the graph and attempt to recreate the table occurances, it tells me that the name is not unique. This implies that the info is still somewhere in the file. I've tried running the recover utility and it tells me that the file was not created by filemaker or is severely damaged. Does anyone have any advice?
-
- 1 reply
- 1.3k views
-
-
How can I set a script to re-lookup only in the current found set? Actually what is the best way to Create a new invoice record for every existing costumer record and do a (re-)lookup?
-
- 3 replies
- 680 views
-
-
I am stumped why this isn't working. I hope someone here can help. I have 2 tables. Table 1 has a field named "Value". Table 2 has fields named "Total set value", "Value used", and "Value left". I have a simple script that checks to see if Value in table 1 + the Value used in table 2 is > than Value left in table 2. It looks like this If[(Table 1::Value + Table 2::Value used) > Table 2::Value left] Beep End If My problem is that the computer continues to think that Value + Value used is always > than Value left. Even if Value is set to 1, Value used is set to 2, and Value left is set to 100. Maybe I'm missing something. Any help given is …
-
- 3 replies
- 647 views
-
-
Here is my issue: I have 3 tables, let's say Clients, Client_Relatives, and Client_Past_Address. I want to create a report in the clients table that gives me all of the related relatives and all of the related past addresses in one report. I am unsure how to do this. Can anyone help? Thanks in advance!
-
- 10 replies
- 4.2k views
-
-
Hi all, i'm planning to develop an small applitacion (5 to 10 DB tables) using File Maker Pro. I used to develop applications before, but i'm new to file maker. I would really appreciate any recommendation about which documentation i should use (books, etc...). thanks in advance for help
-
- 5 replies
- 958 views
-
-
Has anyone conducted benchmarks of commonly used techniques to see what the actual fastest way of doing things is? I'm interested in learning how different approaches to the same problem compare with each other. Some examples of things that could be tested: Is a record-processing loop based on an if test of a counter value faster or slower than one using goto next/exit after last? Is using a custom calculation faster or slower than performing the same calculation in a script step? Is it faster to simulate an array by using string functions, or using repeating fields? Rather than just assuming, or listening to conventional wisdom, I'd like to collect some ac…
-
- 4 replies
- 887 views
-
-
Sorry, this isn't very Filemaker related but I'd really like the input of this community. I've only become interested in systems because of Filemaker. I've gotten a lot deeper than I had thought I ever would.. and hold a position that is very Information Systems Management related--- but I kind of fell into it. I love designing and building the systems... my question is.. I want to pursue more education.. perhaps a masters.. Maybe an MBA/I/S Masters or perhaps even some sort of Ph.D. or Computer Science degree. My undergrad degree was in bioengineering... with very little computer programming studies. Do any of you have any leads about any really …
-
- 0 replies
- 662 views
-
-
Is it possible to use check boxes with value lists to input into a repeating field? Right now I seem to be just adding more text to the first repetition.
-
- 5 replies
- 950 views
-
-
Now that my DataBase is really working nice, I start to worry about secondary aspects. One thing that bothers me for quite a while is the constant flashing of the layout, while aparently nothing is happening. It's like a refresh of the window, but sometimes comes like a continious flashing (2-3 times, 2-3 times in a minute). It seems that ever since I disactivated that "show field borders when record is active" tag in the layout Setup, this flashing appears less frequently... Whats the reason for the activitity while apparently the Database is "idle"
-
- 0 replies
- 727 views
-
-
Hi, I have a really tough problem to try to solve. If someone knows how to solve my problem I would be really impressed and really happy. I have a database (FileMaker v6) in which all records have been accidentally deleted by a script (a bug in the script which occurs under certain circumstances), with the script step delete all records. The record count show 0 records. Normally this shouldn't have been a problem because a backup is performed of the database every night to a zip file and then this file is copied to a file with the current date in the filename on a different network share. BUT the backup to another network share has not been working for ma…
-
- 2 replies
- 4k views
-
-
How can I stop the Closedown Script with a function ? My situation: I've got several Layouts but only ONE is allowed to be closed on! (because of Scripts) Appreciate any Help!
-
- 4 replies
- 952 views
-
-
Hey, how can hide the (File, Edit, Insert....) bar? I need to hide it because the user is NOT allowed to Delete anything without a Password! I also need to know how to block the Contextmenu (right Click). Thanks for youre Help in Advance!
-
- 4 replies
- 724 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online