FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hello, I am running a report where I really want to visually show a field formated with radio buttons or check boxes. When I run this report I want to remove the labels associated with the buttons/boxes and bring the buttons/boxes closer together (without making the font smaller). Since I can only fit so much stuff with an 8" width limitation for printing, I naturally want to bring the buttons/boxes closer together and put the labels at the top. Does anyone have any ideas? I've tried putting white boxes over the labels and that works, but it dosn't bring them closer together. I've also tried creating a value list without labels (only a single space is re…
-
- 1 reply
- 3.1k views
-
-
Apologies if this is in the worng forum but I wasnt sure where else to post it. I have a problem with an existing FM DB which has just started to manifest itself and I am hoping someone may be able to shed some light on it. I have a small home LAN on which I keep all my files on a central server. I have 3 pcs [one being the server] all of which I use to access the DB from various rooms in my house. I only ever use one PC at a time to access the DB and have a single user licence. The issue is this: Up until a few days ago, I was able to access the DB using any of the 3 pcs and was able to do whatever I wanted in terms of data and layout editing, repor…
-
- 3 replies
- 867 views
-
-
I have a database in Filemaker 6 which contains the following files: "members.fp5" "events.fp5" "feedback.fp5" What I want to do is change the file name of the "members" file to "contacts.fp5" The question i have is, since there are scripts, calculations and maybe even some formulas contained in the "events" and "communications" files which relate to the "members" file, will they still work? Does Filemaker 6 know to automatically update the referred-to filenames within the dependent scripts when/if i change the "members" filename to "contacts"? Thanks!
-
- 8 replies
- 1.1k views
-
-
Hi, Is there a way to click a link or button and open a popup web browser from the filemaker page? Also if it's possible, can I pass the username and password so that I can go to the page directly without login? The web site is running on Win 2003 and MS SQL server. Please let me know. Onnuri
-
- 2 replies
- 787 views
-
-
filemaker timestamp - 15/2/2005 11:09:03 am when retreived via xml for web publishing is turned to 15/2/2005 11:09:03. its no use to me because i can't tell whether the time is in am or pm. i tried to change the filemaker timestamp to display time in 24 hour format by setting the time format(format>time) to 24 hours. this however didn't change the format of the time nor the xml output. has anyone worked with timestamp in webpublishing? if so please write so inputs. many thanks.
-
- 1 reply
- 3k views
-
-
I have a DB which we use for attendance absences. I am writing a simple script for a report to find records where the creation date and the modification date differ. Both Fields are set to auto enter the date and are unmodifiable. For some reason FM will not allow me to compare these two fields. Am I just missing something? again any help would be appreciated.
-
- 4 replies
- 692 views
-
-
I am trying to use a illustrator file as the background for a letter. When the letter prints the image quality is very poor. Can anyone instruct me as to how to maintain the 300 dpi or so image quality when printing?
-
- 1 reply
- 1.2k views
-
-
I am trying to write an Opening File Script that will work with our FM setup. Currently we have several files containing data ranging from accounting information to data pulled directly from our production line. We have many different computers accessing this information; mainly apple's running panther but we do have some windows machines as well. We are using the same login/password authentication for FM as we do for our machine login procedure. I am trying to cut down on the time/fear factor for novice users to log into their respected FM files. However I cannot seem to find a solution that will work with our password structure. This is important because we rely …
-
- 3 replies
- 911 views
-
-
Trying to find a way to highlight certain words in a textfield. 1stField (text) holds a text: "the quick brown fox jumps over the lazy dog" 2ndField (text): holds the text I want to style: "fox" Script: Goto Field (1stField) Find/Replace [2ndField ; TextStyleAdd(2ndField ; bold)] It does not replace 'fox' with 'fox', however but simply with 'fox'. Can anyone give me a pointer?
-
- 2 replies
- 866 views
-
-
Hello all, Example: I have an Item Database referenced by a Purchase Order Line Items File. In the Line items File i dont really need any other Info than Item ID and Price to be actually existing. I still want Users to see Item ID -- Category -- Sub Category though when they browse the Line Items. Should i make a new Field in Line Items via my Relationship between Line Items and items, or should i actually create a new Field and make a Lookup via the Relationship? For me it seems to be more clean if i make a field using the relationship, so basically only displaying the fields content rather than actually looking-up the data. But on the other hand i feel look-up is a …
-
- 6 replies
- 963 views
-
-
I wanted to print a script from the Scripts menu, and it keeps crashing. Is there a known issue about this? The script is very large, and I'm guessing this is what is causing the crash. However, I can print the same script from FM6. Thanks
-
- 5 replies
- 783 views
-
-
I'm a newbie to Filemaker Pro and any input would be nice, i tried searching the forums for similar topics so forgive me if this topic has already been covered. I wanted to see how i could create an invoice number that after each new record it would increase the number by one. Thanks! ESY
-
- 1 reply
- 1.1k views
-
-
Any insiders know when it is supposed to be back up? Is there an alternate site to upgrade to ver 7.3? I need to upgrade asap Thanks
-
- 0 replies
- 856 views
-
-
can it be scripted so that the user can go to a related record in a window that is already opened?
-
- 6 replies
- 2.1k views
-
-
I need to integrate a cash register into my FileMaker 7 POS system so when user click on
-
- 7 replies
- 2.4k views
-
-
Is it possible to do this? I have a field that I put the search data in, then a search button next to it, I keep geting complaints from people that they should be able to put the data in the search field and press enter. can I make it do a scrpt off of the enter key inside a field?
-
- 6 replies
- 961 views
-
-
I have filemaker on 2 computers here at the office, and I have to run the other filemaker all zoomed out where i can barely see it for the correct layout to show up or most or all of the text is missing? Im stumped, checked all my video drivers, windows XP is fully updated, both computers are identical. But the other one wont show the ******* layout! im so frustrated please help me resolve this annoying issue. HERE IS HOW IT SHOULD LOOK HERE IS HOW IT LOOKS ON THE OTHER COMPUTER, can you tell the diff? -Thank you, Adam
-
- 7 replies
- 1k views
-
-
I like to keep several windows open during development so that I can quickly see how a change in one layout/calculation, etc affects other layouts and calculations. However, I soon have a proliferation of windows all named 'window'1, 'window'2, etc. is there any way, using FM7 (not developer) to rename windows other than scripting a 'go to layout/new window' which may or may not be the layout I'm concerned with at a particular time. Abbe
-
- 4 replies
- 779 views
-
-
In filemaker 6 there was a script step to exit record. I don
-
- 8 replies
- 1.1k views
-
-
I am new to Filemaker and was wondering what the limits for number of layouts, tables, and scripts are for FMP7. That being said, how do you determine the minimum system requirements for the db? I know this is not a trivial answer in that the size of the layouts, graphics, script length / complexity, etc.. all come into play. I would just be interested to hear how high people have gone and what machine they are running their database on. Thanks in advance for any feedback. John
-
- 1 reply
- 2.5k views
-
-
My apologies if this is not the right forum. Admin can move it if needed. Question: Just hos intuitive is Filemaker for someone who is not even a programmer? I need a fairly simple set-up to manage a magazine and wonder if I could do it myself, or if I am better off buying someone else's? Second, how easy is it to take modify the samples that Filemaker7 comes with? Does it come with something close to magazine management? I'm also ging to want to rebuild one of the student tracking modules to make it work for tracking athletes' training programmes. Is Filemake going to be too deep for me? I've never made databases before, but am pretty good at using Excel o…
-
- 3 replies
- 727 views
-
-
I was sent a clone of a .fp5 database, I would like to link that clone to my own Fm database files already set up, and be able to add/delete fields I have already set up. How? Thanks!
-
- 1 reply
- 792 views
-
-
Is there any way to redefine a field that has been formatted as a button without removing the button formatting first? Seems like a lot of work (and chance for errors) to do something that should be simple and straightforward. Abbe
-
- 2 replies
- 718 views
-
-
We have a major issue with cross-platform compatibility of Fonts. We are using Mac OS X 10.3.8 and Windows 2000 with FileMaker 7.0. This issue has actually plagued us for many versions, not just 7. Basically we have layouts that are for Memos and Proposals, where we have large text fields. On a Windows machine, in Browse Mode and in Preview mode the fonts track differently then they do on the Macintosh. On the Mac it will browse, preview, and print exactly the same. On Windows when we print we get the exact same results as the Mac, but the Preview and Browse does not show it the same, so the user sometimes will reformat their text to make it look good, only to have …
-
- 5 replies
- 1.3k views
-
-
I'm not sure which forum is the correct one for this question so I'll ask here. I'm making a quote program and it's being used to make quotes for Canadian, American, and British companies. I'd like to be able to calculate the current exchange rate by making a script that looks it up on a website if possible. eg. The quote is listen in American dollars, I'd like to be able to click on a button and it would convert it to Canadian dollars at today's exchange rate. Thanks for any help.
-
- 0 replies
- 892 views
-
-
I have the invoice set up with a portal for the line items. I've got the calculation for the total working fine. Until I try to print a statement of unpaid invoices. Since the total is an unstored calculation, the total doesn't show up properly on the statement layout - I just get the tax. The only way I could think of to accomplish the statement was to add another field: Total2, making it a lookup to copy the total. It even seemed to work when I did a Relookup, at first. Then that failed. There's probably some way to simply post the invoice to a separate database, thereby ending the unstored calculation problem, but I haven't figured that out yet. Any help ap…
-
- 6 replies
- 1.3k views
-
-
After reading a fair bit about FileMaker 7, I decided to try the demo and liked it. For a living I maintain a dental website that now requires a user login screen and site search facility. Can FM help me do this?
-
- 2 replies
- 795 views
-
-
1 contact table (contact ID) 1 teacher table (teacher ID) 1 student table (student ID teacher and students have unique informatio that is stored in thier respective tables, common info (first name, last name, etc.) is stored in the contacts file. My question is that each student and teacher have stats that are common and unique. Do you think it would be best to create a 'STATS TABLE' that ultimately relate to the contact table? what are the pros and cons?
-
- 2 replies
- 735 views
-
-
Hello, I just found this forum and it looks like there is a huge amount of talented people here. As a newbie I am having trouble getting a pulldown list to be in alphabetical order. I made a list of all the inventory I use at my company. Those lists are fine. When I go an area where I create my invoices and select the pulldown menu that has all my 300+ items I sell, they are in a scrambled order. What do you suggest that I do to get them in the order? Thanks! Maji
-
- 1 reply
- 732 views
-
-
I really hope some one can shed some light on my problem, even though I highly doubt it. Let me first start off by saying I really truly hate filemaker and think it is a sub-par application and have absolutely no clue how anyone can even consider using it for anything important. Any application that runs as lousy and crashes as often as this should never be used for anything important... Ok so after getting that out of my system. We have a bunch of old old old windows machines here that do nothing other than run filemaker web companion... They're junk...I want to replace them with virtual pc's. So using the Qemu virtual pc, I was able to install windo…
-
- 8 replies
- 2.6k views
-
-
I'm wondering if anyone else has encountered what I'm pretty sure is a bug: I'm running FileMaker Pro 7v3 I have a file with 68 fields and 9 layouts in which this bug happens. In one layout, I only have a Header part, no Body part, since it's just a custom search form that displays results in other layouts. When I am viewing more than 8001 records at a time in this layout, any fields viewed as popup menus don't work at all. Any edit fields work oddly in that they never show a flashing I-Beam cursor and never give a visible selection, but I can click in them and edit. This will only happen on the 8001st visible record and above. The first 8000 visible re…
-
- 1 reply
- 704 views
-
-
I just upgraded to FMP 7 (converted my FMP 6 databases) and I have 2 related databases (Projects and Invoices). When I try to edit anything in my Invoices database now, I get an error: "This record cannot be modified in this window because it is already being modified in another window.". This has never happened before. I don't understand what is generating this error. Any ideas or help would be greatly appreciated. Thanks.
-
- 4 replies
- 941 views
-
-
I've read through all the posts I could find regarding fonts but did not see this one. It doesn't *appear* to be related to the font smoothing issue. I commonly create layouts for printed reports that have 7 and 8 point text. It seems that Filemaker gets a little confused when displaying on the screen text this small. Consistently I will see any number of the following: 1. Extra space after the last character in a text object. In this case the text insertion cursor will blink in the extra space (as if there were three or four spaces after the last character), but when you press the backspace key will delete the last character. This is especially annoying when tr…
-
- 4 replies
- 1.1k views
-
-
Trying to run FM Pro 7 installation I get an error about installation files problem: Is that because of my Windows? Or is it about installation package damaged, any ideas? Thanks.
-
- 3 replies
- 762 views
-
-
If you don't use a Commit Records/Requests script step after a Set Field step, FM 7 will not exit the record, even if you weren't in it to begin with. This is much different than previous versions where you could take it for granted that a refresh would be forced as long as you didn't use a Go to Field [field] step in your script and had forced an exit of the record at the beginning of the script. I've only converted one file and this new feature caused it to be flaky. Version: v5.x Platform: Windows 2000
-
- 32 replies
- 3.5k views
-
-
-
I have a compiled (runtime) FM7 solution that gives the following error message on Windows 98SE when you try to open it: "support.dll file is linked to missing export netapi32.dll:netapibufferfree" Anyone know why it is doing this and if there is a fix? Thanks.
-
- 2 replies
- 697 views
-
-
I've been using FM 5.0 for quite a while and am used to both a 'User' & 'Developer' version. Does the same concept exist in Filemaker 6 &/or 7? I had to purchase both products separately in 5.0, but have been lead to believe that they are now both combined in version 6 an beyond. Thnx for the input
-
- 2 replies
- 902 views
-
-
Greetings - We have an import script that reads text lines from a *.txt into a FM text field. After importing we have a script that parses all the data into the fields. This worked correctly under FM6. Under FM7 the text line that is read in is being truncated at the first comma. So the complete line does not come in. Any assistance would be appreciated.
-
- 1 reply
- 734 views
-
-
I am very new to filemaker and I have just started working for a client who already has a database built in FMP 6. we are trying to share this database using the web companion plugin. When I first tried to enable the plugin, the app freezes. Somehow I figured out that If I try and enable the plugin when I have a database open, it works. However now, when I restart FMP, the app freezes at the startup window. The only way I fixed this was by enabling a Network Location with an IP of 10.10.10.10 and appletalk enabled. This has happened on two computers and seems very weird. I searched the forums and found nothing related, although it seems like this sort of thi…
-
- 3 replies
- 860 views
-
-
Hi, this is my current problem, i recently have changed my old pc for a new one, now every time that i want to open one of my filemaker files, there is always the same dialog at the opening: "The date and time formats associated with FILENAME are different than the current system setting. What date and time formats would you like to use?" Ok, i know that if i save a copy of the database as a clone in the system that this is showing up, it will be no more problem, but the issue here is that the file is used in 3 diferent machines, so, if i do that in my computer, the other 2 will have the same problem. Is there any way to make the choice automatically, for exampl…
-
- 2 replies
- 1.2k views
-
-
Hi all I'm currently preparing to upgrade to v7 but before I perform this I would like to make a record of the database structure. I have managed to print all the scripts off for the different files but cannot see how to print the Define Fields, Define Values and Layouts. BTW, I'm using version 5 and 5.5 Many thanks in advance eSBee
-
- 7 replies
- 1.1k views
-
-
Hi, I am designing a medical database using FM v5, and will need to do advanced "cross-tabs" reporting. Is there a 3rd party extension available that will allow me to do "cross-tabs"? Is this kind of reporting available in FM v7? Thank you, Richard
-
- 3 replies
- 803 views
-
-
I uploaded the FM v7 trial version about a month ago. In browsing it I saw and actualy used a Menu Item/or Button that was something like Find Dulicates. My boss said he would Buy it if it would do what we want. So On anothre computer I UL's the trial again. Now No such Menu Item exists. The tech support Knowledge base article all tak about creating scripts. I know I am NOT crazy, it WAS there, just a standard Menu Item. Where is is now?? Was I using some version with special plug-ins or something. Please if someone knows what I am talking about, tell me why that itm is gone!
-
- 5 replies
- 784 views
-
-
Is it possible to design a file that sorts like Microsoft Excel. I designed an Excel Sheet that consisted of 31 names of employees viewed vertical. The Excel Sheet is based on employees taking overtime and distributing it equally. When an individual employee takes overtime, I place a number in the column on the right of their name and perform a sort. After the sort is completed, their name goes to the bottom of the list. I would appreciate any help that I can get. Sincerely, Steve
-
- 3 replies
- 1.1k views
-
-
Hi, I'm attempting to write a database that uses the account, which is their badge number. In the db there is a script that I am trying to have their account placed in a text box, but I only see "Insert Current User Name", there is no "current user account". Another curious question I have is that when you initially start up FMP7 and go to log it it automatically assumes your account is your windows login name, (not the same as the badge number I am trying to use as my account). This affects it as well because under properties I wanted to make an automatic field that says the FIELD=account name (not user name!). But when it automatically does this it is plac…
-
- 1 reply
- 1.6k views
-
-
I've got an FM 7 server on a machine in my office, and I have FM 7 Dev on my laptop. My laptop uses the name GHOSTFROG. Sometimes when I try to log into the database, I get warnings about a license key violation when I try to connect. This is happening fairly often, and happens regardless of whether I close FileMaker properly or get disconnected.. "The maximum number of licensed users are currently using this copy of FileMaker Pro. Please refer blah blah blah... License Key conflict occurred with user "GHOSTFROG" In other words, the server thinks I'm still connected and trying to connect a second time, even if I properly shut down the application previously. I e…
-
- 2 replies
- 975 views
-
-
Is it posible to format a field using HTML? like if the contencts of that field were HTML and it would be displayed correctly?
-
- 1 reply
- 1k views
-
-
I'm having an awfully hard time learning FileMaker. (My wife says I went through this six years ago, too, when I first learned MS Access.) I really want to believe that FMP is easy-to-use, but I just don't know... I think part of the problem is that I've gotten used to solving/analyzing problems in Access-think, and FMP really does represent a different paradigm. Is anyone aware of a resource which would "translate" procedures from Access-speak to FileMaker-speak? Thank you very much.
-
- 3 replies
- 884 views
-
-
I have a windows xp machine that has lost it's tcpip network protocol in it's preferences settings within FM ver3. They can't open a database in multiuser. Other people on the same network, on differnt pc's, can but they have the tcpip protocal as an option where the problem user does not. It was working fine before. Nothing has changed on the computer. Any help is appreciated.
-
- 2 replies
- 1.2k views
-
-
I am having a problem with the Delete record function - from the menu and from a script step. I am using a separate interface file to access data in another table. When Delete record is selected/performed, the regular dialog box is displayed - "Permanently delete this ENTIRE record?" When "Delete" is selected, a progress dialog is displayed "Gathering records..." - if it is not cancelled, all the records in the database are deleted - has anyone seen this behavior? I may be overlooking a simple cause/solution - I've spent a lot of time searching the regular resources - can't even find a reference to the dialog, "Gathering records..."
-
- 3 replies
- 1.6k views
-
-
in a layout with many portals what is the cleanest way to calc an overall modification date based on the latest date of all related sections.
-
- 1 reply
- 826 views
-
-
Hello, I desperately need help. I'm kind of new in FileMaker, so I hope you can help me. I'm trying to do a find in a column that will give all the numbers that start with 1, but instead I get what appears to be, everything that has a one. What am I doing wrong? I was able to do this with no problem in FileMaker 5. I'm kind of frustrated because I need to finish this soon so I can print it. I appreciate your help
-
- 3 replies
- 887 views
-
-
Is there anyway to hide the annoying View As drop-down box in the web page status area? It's confusing the employees. I can't find anything in the Help pages. Thanks!
-
- 0 replies
- 723 views
-
-
Grumble.... no idea how to start describing this... I've got an account table, and it's linked to a table of teachers which is linked to school which is linked to district. On my account layout, you select the teacher from a list box (the list was generated through a relationship by school district, but I guess that's not important) Anyway, right after selecting that, the first thing I do is run a script that copies the teacher's address (or school's or district's) to the account's billing or shipping. But most of the time, it copies nothing. I have to click on the background of the layout a couple times before it will register the relationships and let me copy.…
-
- 3 replies
- 681 views
-
-
How do i delete duplicate records and keep one email me at [email protected]
-
- 1 reply
- 759 views
-
-
I just converted my database from v6 to v7. I made a "goods costing", where it loads up information of raw goods" from other related tables through calculaded values (e.g: goodscosting/field1[u.price]=rawgoodsfield7[u.price]. this would give me the value of other calculations that goes on inside goods costing. On version 6 used to work excellent but not on v.7 . on version 7 (now) When I input new data on the "Goods Costing", It fails to bring up the u.prices. But then, when I close and open Filemaker- the data shows up. Is this a glitch? I am just about to go back to FM6 Hope I was clear with my explanation.... Any suggestions, or help? thnk …
-
- 2 replies
- 758 views
-
-
Hi: I have a G3/10.2.8 which I have installed the WSC and a copy of FMP 5.5 Unlimited to serve a working CDML shopper I have written and tested via web companion. The box is sitting on my switch with a static ip to my T1. I am trying to run this with the connector and apache so I can use ssl for credit cards, as opposed to just feeding it through web companion server. The WSC install went fine and let me add all 6 of my databases correctly. It is set to use port 591 so that the CDML doesn't conflict with port 80 on Apache. Checking the webcompanion via filemaker shows 591 as its defined port. I have the html/cdml format files sitting in the Filemaker Web f…
-
- 1 reply
- 1.4k views
-
-
I want user to enter into the layout mode via a script button so they can add fields to a list that is in 'view as table' mode. Can anyone tell me where to find this.
-
- 2 replies
- 1.5k views
-
-
I am looking to use FMP7 as a frontend for MySQL. Is this possible using the ODBC drivers that come with FMP? What are the limitations if this does work? Any help you can give is greatly appreciated. Colin
-
- 1 reply
- 855 views
-
-
Hello All, I've decided to take the plunge this weekend, and convert my FM6 files to FM7. Question: I have a number of files that have THOUSANDS of records in them. 60,000 to 100,000 records. Is Filemaker 7 Faster if it is in the same file? Is it better to rebuild these files into Tables on my main file, or keep them seperated the way FM6 does. I use my database over a VPN, and I'm concerned about speed. I'll have about 500,000 records in a single file between the different tables, and after using FM6 so long, that number scares me. Thanks! Munchieman!
-
- 4 replies
- 815 views
-
-
I need some help and advice setting up a database for an academic project. I have just purcahsed Filmaker Pro7 software but have never used it before. I am about to begin a research project looking into children's early reading books and the words that they contain. I am specifically interested in how frequently the most common 500 words in the English language appear in those books. So, what I need to be able to do is to type in the text from approx. 1000+ reading books and then be able to analyse the frequency of those 500 words across all inputed texts. I want to further analyse the frequency of words according to: a)the publisher the level of difficulty of t…
-
- 1 reply
- 705 views
-
-
I would like to have a seperate letter DB on all client machines that reference an account DB on the server. How can I move a found set move to the letter DB on the client machine? So the user would do a search in the accounts file that is on the server, and then click a button to send a letter to found set.
-
- 2 replies
- 856 views
-
-
-
When opening remote hosts in FMP 6, the host name is not as specified in the Filemaker -> Preferences-> Applications-> User Name-> Custom. I have tried restarting Filemaker after changing the custom User Name but it still displays as the System name. Can the System name be changed? Any assistance will be much appreciated.
-
- 5 replies
- 2.5k views
-
-
Hi, I am working on an advanced solution for photographers. Any success importing or obtaining data from camera RAW files? I am not concerned with importing the image, only the filename & path. EXIF data too would be a bonus... I do not want to use commercial plugins, looking for some tips or an open source solution. Thanks Darren Sweet www.PictureChasers.com
-
- 0 replies
- 702 views
-
-
In FM5 it was possible to do finds and print while the window/file was hidden. Is this possible in FM7?. So far, my experience with FM7 is that the window must be selected for finds to be accomplished. Is this true?
-
- 1 reply
- 1k views
-
-
Hi all, I am suddenly getting an "Out of Memory" error when I run a simple script in a very simple and small database. The script is as follows: -Go to Layout ["Report View"] -Perform Script ["Sort for Report"] -Enter Preview Mode [] When I manually run through the steps, everything is fine. I have not seen this problem before. Any thoughts? Thanks, Matt
-
- 1 reply
- 875 views
-
-
I have a solution that is going to be accessed by people in various offices. We want to have a training session at a retreat where all these people will be together. Every office has its own copy of FMP7, but they are installed on desktops, so it is not feasible for them to bring their computers to the retreat. Can I install the free trial version on the computers at the retreat and use it to remotely access our database for training? My concerns are: (1) is this legally OK (every user already has a legal copy back at the office) and (2) will it work--I just want to walk them through the operation of the database and show them how to access records, generate reports, …
-
- 1 reply
- 778 views
-
-
On my multiple-user machine, the only user who can use a user dictionary of any kind is the main (administrative) user, no matter where (or with what permissions) the non-admin users choose to place their user dictionaries. All you get is "Cannot load user dictionary" errors! Even after having FileMaker create a user dictionary (which it does just fine), these users cannot edit or use these dictionaries. Permissions are completely fine for each of these files, BTW... This is incredibly annoying. So annoying, in fact, that I am thinking of scrapping a planned upgrade to version 7 if I can't figure out how to address this. Thanks for any help anyone has to of…
-
- 1 reply
- 2k views
-
-
Hi I am thoroughly confused by the following problem I have 4 tables Estimate Table ------------------->EstimateLineItem Table One Estimate can have many EstimateLineItem Records Estimate Table-------------------->WorkOrder Table One Estimate can have many Work Orders WorkOrder Table------------------->WorkOrderLineItem Table Once an Estimate is approved, I want to create a new WorkOrder for that Estimate and also want to import EstimateLineItem records for that Estimate into WorkOrderLineItem Table. My Script has the following : Copy EstimateID from Estimate Layout Go To WorkOrder Layout Create a New Record Paste t…
-
- 5 replies
- 826 views
-
-
I am in the process of converting .fp5 files to .fp7. I have had much success so far, however I currently have two files that will not convert. The conversion log ends with "1/25/2005 2:02:49 PM, Master List Workers.fp7, -1, Unknown Error: ." I get an error message that says "File Conversion could not be completed. This file seems to be damaged." What can I do to get the files converted?
-
- 4 replies
- 1.7k views
-
-
Is there anyway in filemaker i can prevent the user to close the program manually, or make it in full screen so i can make a personalized button for exiting filemaker?? Any idea would be appreciated..
-
- 2 replies
- 1.2k views
-
-
It just locks me out. Asks for account name and password or whether I want to change the password. I never created a password. I create a file, save it and the next time I can't get in. What is going on?
-
-
- 4 replies
- 4.3k views
-
-
Hi, I have developed a contacts / projects / call tracking application that uses 14 files. I need 10 people in my company to have access to it. My plan was to run FM Pro 6 on a dedicated machine and to open the files on that machine in Multi-User mode (all my users have their own copies of FM Pro 6 on their desktop machines ...WinXP). However, I read somewhere that you can only have a certain number of files in your solution if you want to share it with 10 users without buying FM Server 6. Does anyone know what the limits are? Can I do this without using FM Pro 6 Server? What is a runtime application? Should I consider that? Many thanks to anyone w…
-
- 2 replies
- 1k views
-
-
I recently converted my database which is fairly simple to version 7. It has been working fine in version 5 and now I am having trouble with a time field. I use the time fields for calculations of timecode. The fields having trouble function like this. I enter a start time in the format hh:mm:ss and a end time in the same format. The database then calculates the difference between the two and displays it in another field (ie;length) in the same format hh:mm:ss. Now that I have upgraded to version 7 that no longer works. I put in a start time and recieve a format error saying that the time is entered incorrectly. Same goes for the end time. Then when both numbers are …
-
- 27 replies
- 2.6k views
-
-
Is it possible to have a MySQL solution incorporate data from a filemaker database on the fly ? eg. MySQL database of Interviews will automatically include the current body of data from a filemaker file named Possible Interviews so, if I delete something from the Filemaker database, it will automatically not show in the MySQL database ?
-
- 0 replies
- 675 views
-
-
I have two files User Interface and Data. I have my users part of a privilege set (in the data file) that does not allow them to create or delete records. In my UI file, I am opting to create buttons for record creation, etc. However, even if I run the script (in the UI file) with full access privileges, it does not work across external files. Do I need to create scripts in the data file that run with full access, then call those from the UI? I was just wondering if I was missing something because duplicating scripts seems redundant. Thanks!
-
- 1 reply
- 649 views
-
-
Two users are sharing a database. When one copies text from a 12pt text field into a 9pt text field the copied text is properly displayed as 9pt text. When the other user does this it is displayed as 12pt. text, making it too large for the field (as it is displayed in the layout). The desired result is for the copied text to take on the formatting of the field it is being copied into. Both users are on Windows XP Pro. and both are using FM Pro 6. Any thoughts on what to look for? The problem machine does not have anything unusual about the keyboard or keyboard configuration. The user also gets the same result when using Ctrl+V versus using the menu. The only way s…
-
- 2 replies
- 899 views
-
-
I'm working on a "navigational" system, where user can "return" to where he came (with several tables, layouts etc). My idea was to store RecordID and LayoutNumber into 2 globals. And then use them if the user decides to "go back" from the previous record he saw. Anyway. Am I missing something ? But looks like FM offers RecordID but do not allow to use it with a proper function. The function Go To Record use RecordNumber (which is the number of the record whithin the found set, so it can change of course) :? Do you know a way to use RecordID instead ?
-
- 3 replies
- 2.3k views
-
-
Hi, I have never used FMP and have little experience with any "back-end" database stuff (i.e. I have created relational databases in Access, but have not dealt with anything server related). My boss wants me to give him a run-down of what the different options for FMP are including just getting the software or buying the server as well. Can anyone help me? Or point me toward a website with this kind of information (in relatively simple terms). Thank you! j9
-
- 5 replies
- 789 views
-
-
Hi folks, If there is somebody here with experience under both Windows and Mac this would be great. I wrote a rather complexe appliction (32 tables, about 60 relations) that works fine under Windows (Pentium 4, 256 MB). Under OS X (iMac G4) it takes a horrible long time to display a new record, with all data shown in the portals and two windows that are actualized by script. I really do not understand the reason for that problem, because the G4 should definitely not be slower than my old Pentium - and FileMaker was designed for Macintosh in the beginning, wasn't it? If anybody has any sort of idea if there could be a solution for my problem, that would be…
-
- 4 replies
- 801 views
-
-
I dont know if I'm wording it right but I was wondering if it was possible to do sub databases with this program. Like say for instance, instead of having-- Table 1 Table 1.2 Table 1.3 Table 2 Table 3 You would be able to do something like... Table 1 -- Table 1.1 ----------- Table 1.2 ----------- Table 1.3 Table 2 Table 3 So that you wouldnt have 30-40 something databases and could merge them into groups. Is this possible with FM7 pro or would I need to use Access or another program? Thanks for the help.
-
- 5 replies
- 981 views
-
-
Is it possible to detect what the screen resolution the user is using and change the zoom rate of the database accordingly? Most likely a startup script.
-
- 1 reply
- 842 views
-
-
I have a client that relies heavily on Filemaker for internal database needs. Some of those files also serve as the back end for web pages. FileMaker Unlimited 5.5 is installed on an iMac 350MHz with 512MB memory. The files are on a QuickSilver G4 with FileMaker Server 5. Both machines are in a server closet at their site with a T1 connection to the net. Both machines are running OS X 10.3 Panther. There are 91 web files in the web folder on the Unlimited machine. Perhaps 10 to 20 of those are dormant, out of date, or otherwise not active. There are 94 files open on FileMaker Server. One file is the launch file for FileMaker Unlimited 5.5. It opens a set of 25 files …
-
- 5 replies
- 1.7k views
-
-
I hope someone can help me with this! I use an old iMac running system 8.6 and FileMaker Pro 4.1v1. I have created a layout for keeping track of client's name, address, phone, fax, email, etc. and all of their payment information for any given year. At the end of the year, I just duplicate the entire group all at once so I will have a set of records to enter payment info for the upcoming year. Then, I go into Layout mode and change the heading to the new year, i.e. "2005". It's seems easier to do that than to recreate each person's record all over again, since I have at least 100 clients at any given time. The problem is that when I duplicate the record, …
-
- 3 replies
- 1.6k views
-
-
I just got the damaged file message and went to run recovery to extract recent data to import into a backup but the recovery command won't run. I'm able to run it to the point where I name the recovered file and save it. At that point, I get a very rapid dialog box that I can't read, then nothing. No message about blocks recovered, etc. I've run recovery before on files with no problem (under Mac OS and Win98) but wonder if there could be a problem running it on XP. I can try recovering to FMP5.5 or to 4 on Mac OS9. Thanks for any suggestions. BTW, we're a small non-profit, hence the old FMP and why I can't just send it off to FMP for recovery on the hope…
-
- 1 reply
- 1k views
-
-
A client of mine managed to attach too many high-resolution photos to a database...which then crashed. Now, I can't open it to delete the photos, and I keep getting the error message that Filemaker is "searching for more room in file" and then that "maximum file size has been reached." Indeed, the file is slightly over 2 gigabytes, which I know is the limit. What do I do now? I just want to get into the file and delete the images (and not lose the data). I tried to recover the file (in Windows), but that didn't work.
-
- 9 replies
- 3.9k views
-
-
Hello Everyone, Is there a way to use two monitors with a database in FM7. Ie: Have one table on one monitor and another in on a second? If I drag the window across both and open a table in a new window that seems to work until i want to open a PDF page on the scond and type off of into FM. What you can guess is that it hides the pdf when I go to type in FM... Any way of doing this with two monitors Joseph
-
- 0 replies
- 1.1k views
-
-
Hi guys and gals, I did a search and didn't find anything on this - also looked it up in my christmas present "Using FileMaker 7" - "The only book I need!" and can't find anything in there either so I am now asking you. I have created a database which is an invoicing database - yet another variation upon an old boring theme. In there I have a relationship to a table that shows me different addresses that are related because of the client name. I have three address sections to fill in on my invoice - Client, Accounts and Delivery. I have an 'Assign Address' for each address section. When you click on the button, it opens a window which lists t…
-
- 4 replies
- 1.4k views
-
-
Does anyone know where I can find 6.0v2 or 6.0v3 updaters for download. I am running 6.0v1 unlimited and need to upgrade to either 6.0v2 or 6.0v3. I have looked everywhere and cannot find either. Any help would be great!
-
- 1 reply
- 1.1k views
-
-
Does anyone know if the Filemaker applications like "Work Requests" will allow to edit the layouts? I would like to purchase it and need to have some of the Layout in another language.
-
- 0 replies
- 670 views
-
-
This is so simple, I know it, but I have just been dorking out for like an hour unable to make it work and looking for advice here. Don't laugh, it's so stupid. I've got the email and a button already set up that I can hit anytime to send a certain email message to a small group of users. That's cool, but I want to automate it...ALL I want to do, so simply is: When we open Filemaker each day, I'd like the start-up script to find the set of records with "today's date" in a certain field and then auto-send an email. We have this short email set up to say "Reminder, this customer needs a callback today" bla bla. It's just internal, no biggie, and it's been w…
-
- 1 reply
- 763 views
-
-
Hi Guys, I've decided to start developing using FM 7. I've encountered a small problem with the Freeze command, im hoping someone can assist. In my sample file , I have two table occurances - Main and Portal. In table "Main" I have two fields Key (Auto Enter Serial) Copy Field - Text. Table Portal Key - Numeric Field1 - Text Field2 - Text I've written a script "Copy", which copies data from the copy field into the Field 2 in the related portal record. I use a gotorelatedrecord, with the Freeze command. The script works apart from, the gotorelated record script isn't "frozen" - like it would be in FM v6. Can someone show me how to freeze…
-
- 1 reply
- 783 views
-
-
I have developed a system for a client using FM7 and my client asked for some changes and will also include extra features for this system. I had this same problem with Filemaker 5.5 to add new features to the system at the client. We had 2 ways of doing it. 1) We used to add all the new features at our office and save a copy as a clone. At the client I would import the records to the new copy and substitute the system with this new copy. This isn
-
- 4 replies
- 994 views
-
-
I have a database which records students grades. There are several tables, but the main ones are Students and Grades (one Student to many Grades relationship via a unique student number). When a pupil leaves school, I don't want them appearing in finds any more, but still need to be able to have their details available. I thought of two ways of doing this: 1. Have a field which states whether a student is "current" or has "left school" This could cause problems when searching, however. 2. When a pupil leaves, have a script which deletes their record from the Students table and pastes it into another archived "Leavers" table. This can't be a new …
-
- 2 replies
- 1.1k views
-
-
I had a great working database...but then all of a sudden CRASH...now it says index missing on some of my fields...how can I correct this? HELP Brahim
-
- 9 replies
- 13.4k views
-
-
I think that is better to add save exe file to filemaker pro7 so that when create some program we can save as exe file and no need to install full fm7 software.also no need to buy to software one for design one for create exe file.. as i bought filemaker pro7 i cant convert to exe file i need also to buy the filemaker developer ?? Please Help : [email protected] [color:"red"]
-
- 1 reply
- 1.7k views
-
-
Need some help on this one. I have created a database for a friend. It has a purchase order section and a job sheet section, both of which need sequential numbering. I have made the purchase order field auto-numbering but need to be able to create a button that when you click it gives a sequential job number as well as being able to enter a job number if needed.
-
- 1 reply
- 792 views
-
-
I recently installed FileMaker Pro 6 Unlimited on a client's server (Windows Server 2003, but shouldn't matter). The version of the software installed is 6.0v1 -- I have an old CD for the software. Obviously, there have been updates to FileMaker since then. But, when I visit the FileMaker web site, I can't find any updaters for FileMaker 6 Unlimited -- only for FileMaker 6 Pro and FileMaker 6 Developer. Are there updaters available for FileMaker 6 Unlimited? Where do I find them? Thanks!
-
- 5 replies
- 1.6k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online