FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
After converting to FM 7, many of my layouts which have sliding text boxes with merge fields end up neither printing nor displaying the sliding text boxes in preview mode. Browse mode looks fine. If sliding is turned off, the text boxes appear, but obviously don't slide. Sometimes the first text box or 2 will appear at the top of a page, and the rest dissappear until the next page, where the first one appears (as though the rest had been there invisibly) - and the rest are gone. The text boxes are set to print in the sliding - printing dialog box. Does anybody know what's going on?
-
- 0 replies
- 767 views
-
-
I am setting up an invoice system that will have different services attached but some of those services need to be related. I find that if all services are related to the invoiceID, I will not get a proper 'A' description when service B is a child of service A. If B is must be related to A should it only be related to A and not the invoice. Or would you keep it related to the invoice as well as a second relationship to A?
-
- 1 reply
- 810 views
-
-
My company is getting ready to upgrade FileMaker (v6 for clients, v5.5 for server) after having used 5 (both Server and client) for many years. We've just upgraded all the Macs in the office to OSX so the Classic-only 5 is far too clunky now but we're not quite willing to take the plunge into the all-new 7 yet. Can someone give me an idea of how easy/hard it'll be to update our FM5 software, including client and server, to FM6? Will our database files be ok? How about custom records we've made (layouts, fields, info, etc.)? Anything else we should know about? Thanks, m19
-
- 6 replies
- 1.2k views
-
-
I need to figure an efficient way to duplicate data from one layout and get it to a second layout. my fields are address1, city1 , state1, zip1 and prim address, prim city, prim state, and prim zip. The majority of the time the original data will be the same and need to be entered in the prim fields. So what I want to do is figure a way to check a box and have the info duplicated into the prim fields. My thought was similar to those used with credit card billing info and shipping addresses. Check the box if the shipping address is the same as billing address. Any thoughts on how to go about this.......
-
- 4 replies
- 1.2k views
-
-
Can you change the highlight colour in FP7 and is it possible to highlight the whole field. At the moment the system highlight combines with the background colour.
-
- 1 reply
- 768 views
-
-
To call me a newbie would be generous. I understand just enough to be dangerous (or to think I can do anything I can imagine...) I have been given the task of tracking the distribution of motion picture photography to various media outlets. I need to look at this information from two basic angles. 1) We have sent X media outlet (magazines, online, etc.) these pictures. or 2) X picture has been sent to these media outlets (magazines, online, etc.). I started by using 3 FMP files. One to hold the list of Media Outlets. One to hold the thumbnails of the photos and their Number. One to track each mailing, combining the Media Outlet info and the thum…
-
- 4 replies
- 1.1k views
-
-
Is there a way to reverse the FieldBounds fuction where instead of the computer telling me where a field is, I can type in the numbers and the field will change to the postion and size of the numbers I just put in?
-
- 3 replies
- 862 views
-
-
Hi everyone: I am writing a comparison report on Access and Filemaker and trying to describe the advantages of using one over the other. I found a really excellent comparison on the website (http://www.filemaker.com/downloads/pdf/datasheet_fm6.pdf) which gave a very thorough overview. What I am looking for specifically is the overview of the socket specs etc. Basically, i want to have a good idea of how many users can be concurrently running on either system. Where can I find this information? Sincere regards, Jim
-
- 3 replies
- 1.1k views
-
-
I am trying to figure out how to make a database with 3 tables, clients-invoices-products. Pretty easy I would think. But in the process of trying to make it work, sometimes Filemaker starts spinning the color wheel of death, and goodbye database. has anyone else had this annoying problem? I would think that FM would at least give an error code.
-
- 4 replies
- 1.1k views
-
-
well, at first when i came to FMP7, i just wondered why it would drop support for Chinese version when it was in FM 5 or something. this is odd for me. FileMaker doesn't want to take a stand in today's China's database market? or was it Oracle and MS SQL stepped into China way too early and FM is not going to step in? well anyway. i wanted to localize FMP7 to simplified Chinese version since most of my clients are Chinese. so far i have been implementing layouts all in Chinese, but when they use FMP7, they are just not used to see English menus. although they can do everything they can with my layout design as from the menu, they still prefer to be able to read …
-
- 2 replies
- 1.6k views
-
-
I have 7 related databases that are used to keep track of audio recordings (and orders for those recordings), for a church community. I've been using them for about a year on this machine, 2 yrs total - without any major problems. Yesterday, when I tried to open the main database, "Orders", FM "unexpectedly quit". So I recovered Orders and tried again, same thing. Next I recovered all 7 dbs, tried again, same thing. Tried to open the other 6 dbs, and 4 opened fine, 2 more unexpectedly quit (I'm guessing that maybe only one of the 3 that unexpectedly quit may have a problem, but since the default layouts may instantly call up the other 2, any of the 3 will cause the c…
-
- 2 replies
- 1.1k views
-
-
Ever since I upgraded my machine to 10.3, FMP 5.5 Unlimited hangs once a day. It hangs so bad I have to force quit. Has anyone else experienced this? I'm using FMP 5.5v2, web companion 5.5v4. I've even reinstalled FMP. I suspect the problem is one of my many applescripts that interact w/FMP, but it's almost impossible for me to isolate what exactly is causing it to hang. I also noticed (thinking out loud) that my URL access scripting scripts became flaky in Panther, and I rewrote many of them as curl scripts, so perhaps I need to make sure I haven't missed any. I'm also all over the place w/how scripts are called: some reside in FMP fields, some are called using the…
-
- 8 replies
- 1.5k views
-
-
Does anyone understand the following comment from FMI's "fm7_converting" document: "The Store compatible graphics preference is no longer available. FileMaker
-
- 1 reply
- 890 views
-
-
I have a very simple database that contains 5 fields. We use it as an archive of all stories that have run in our weekly paper. headline byline date page story I would like to set up this database to be served on our intranet only. our employees would be able to search the database for a word or string of words and the search result would highlight where the word appears in the field. very similar to "cheesy word highlighting" by James Mastrianni. i have tried to share that file but it will not work over the intranet. seems to be an issue with overlapping fields. are there any other solutions similar to this? is this something that would work usi…
-
- 4 replies
- 872 views
-
-
I've got a layout with about 130 calculation fields on it (mostly numeriical) which involve both related fields (from only 1 other database) and each other. I'm getting up to 15 second delays every time I do anything (change record, enter data into a field, run a simple script) from this layout. The computer has over 500MB of ram, it's a 2004 G4 iMac. This thing can handle 3D real-time graphics but not filemaker calculations? Seems like something must be wrong. A while ago, the related database had its name changed, could this have affected the performance? Anybody got any ideas? Thanks, Dan
-
- 4 replies
- 1.2k views
-
-
hi all~ is it possible to restrict access to certain records on a table by access privileges...? if so, how? or does it have to be another way of doing so?
-
- 2 replies
- 780 views
-
-
Problem # 1 My boss doesn't want to spend any money. Problem # 2 We HAVE been spending money and upgrading our PCs and not our Macs Of our 19 computers running FileMaker... 9 are PCs, most of them new and running Windows XP. 10 are Macs, most of them iMacs running Mac OS 9 (1 is running OS X, and I'm having printing problems with it) The graphic design workstation I am working on is a B&W G3 400 MHz. We bought it new in January of 1999. I recently requested a G5 upgrade costing 1/2 the amount of our latest PC purchase, but the request was rejected due to budget constraints (we don't actually have a budget, its more like, "What do we want to pursu…
-
- 2 replies
- 1.1k views
-
-
Okay, I'm not a very experienced FM user but I can't work my way round making a database and use script functions and all that. I have a little trouble with relationships though, and while I was changing relationships trying to figure out how to link two files to show the relevant information, I decided to delete all relationships and start again (coz I got myself confused). Though when I closed the "define database" window all the fields in my database file were saying <table missing>. When I click on a field in layout mode to relocate the field, there is no option for choosing from the current file. Its like it can't find/see the file that its on. It look like to …
-
- 1 reply
- 2.5k views
-
-
I am trying to insert a MS Word doc into a FMP6.04 db container field. I get "FileMaker Pro cannot complete the operation because of an OLE (0x80004002) error." message. Any advice? I am running Windows 2000 with Office XP. Thanks DG
-
- 2 replies
- 2.7k views
-
-
We are a non-profit with a membership database of almost 2000 records. We keep old members, current members & life members in this database. I have set up another database for deceased members, as we don't just want their data to disappear, but don't want them on the 'mailing' list anymore, either. Trouble is I add new fields to the membership database at least 3 times a year, ie, amt, method & date of payment for membership for the new year, and donations-we sent out two mailing to our members asking for donations each year, so I need amt & date for each of those, plus we work on specific projects each year, so the donations can go to different specific proj…
-
- 8 replies
- 1.3k views
-
-
I feel as though I'm asking to be spoon-fed, but here goes: I have one week experience with FMP. Look up the word beginner in the dictionary and you'll see a picture of me in a few select dictionaries. I am trying to make a movie database similar to the way IMDB works. So far, I have three tables: , [Person], and [MoviePerson]. The tables and [Person] have unique serial id numbers to distinguish people from people and movies from movies. [MoviePerson] is the middle table that creates a relationship between a person and a movie. I did this so that one person could have multiple roles in one movie. I.E. M. Night Shyamalan produced, wrote, and directed …
-
- 3 replies
- 900 views
-
-
I am displaying a portal window, which when a line item (UPC) is entered, it (the UPC field in my Items DB) does a lookup of an inventory item (in my Inventory DB). When using the [Full Access] log-in, the portal window refreshes after each line item is entered accurately displaying the new line item. When using any other account access (i.e. Data Entry only), the portal window fails to refresh automatically after each line item is entered. Does anyone know a work around or why the portal window behaves differently with access priv's? Thanks for any help!
-
- 2 replies
- 1.1k views
-
-
I am trying to create a report in Tasks 2.0 based on two search criteria not being included in the results. Under saved finds, I enter the first criterion I want omitted. However, when I try to enter the second criterion in a new saved find, it reverts both saved finds to the same criterion. For example, I first put in that I want all completed projects to be omitted in the search report. Then, I say I want to omit all cancelled projects. When I run the report, only the cancelled projects are omitted. When I go back and check my saved finds, they both show up with cancelled being the criterion as opposed to completed and cancelled. Can someone tell me what I am doi…
-
- 3 replies
- 838 views
-
-
how do you control the size of message box. on my xp machine it covers the whole screen. Thanks
-
- 8 replies
- 1.1k views
-
-
I need to import a file which is always located in the same directory. The file always starts with "SEL". One week the import file is SEL01X.xls, the next week it may be SEL28W.xls. I would like for FileMaker to automatically find this file in the designated directory and import it. After the import then for FileMaker to automatically rename the file from SELxxx.xls to XSELxxx.xls, so that it would not import automatically again, because it placed a "X" in front of the file name. Can this be done and how? Thanks.
-
- 1 reply
- 1.5k views
-
-
Hi, I really hope someone can help. Firstly, here's what I'm trying to achieve: I have two tables: 'members' and 'letters'. I want to be able to send any given letter to all of my members. So all the letters are common to all members. However, I'm really finding this difficult to implement in FMPro7. Any suggestions would be really great. Cheers, Dan
-
- 5 replies
- 855 views
-
-
I know there must be a way to do this, but I haven't done much with text field manipulation. What I'm doing is replacing a SQL database with a FileMaker database that tracks memberships in a non-profit organization. Membership submissions come in as an email in the following format: John Doe 12345 Anystreet Anycity, US 12345 999-999-9999 [email protected] There is also the possibility of a middle initial, additional address line, and the phone number is user formated. What they've been doing in the existing database is to copy each part of the submitted info and paste it into the repective fields (first name, last name, address, city, etc) Wh…
-
- 3 replies
- 959 views
-
-
Hello there, nice board! Hope you can help, I've lost a 1200+ record database... I don't know where to post that, sorry if it's in the wrong section! After an unsollicited reboot, one of my FMP7 databases (that was open when the PC crashed) has been corrupted, FM tells me to recover it. But when I try, the whole thing just crashes too, I just end up with the stupid Windows error report. Is there any way to save my data??? Config: WinXP SP2, FMP7, AthlonXP 2000+, 768Mb RAM, corrupt file definitely too big to be posted here (160 Mb!!!) (could there be a compatibility issue with SP2?)
-
- 4 replies
- 985 views
-
-
I've just converted a database from FP6 to FP7 in it, there is a field that prints a number with two decimal places onto a form.. I need to leave out the decimal symbol so that it will print correctly on the form. In FP6, this worked fine, I just went into Format/Number and deleted the decimal symbol.. when I converted the database to FP7, the "." started showing up.. I went in to Format/Number and to my surprise, the settings were set correctly.. there was not supposed to be a decimal symbol printing.. but there it is on the report. Any ideas on how to get rid of it, without turning it into a text field. Thanks
-
- 3 replies
- 1k views
-
-
I install my FMP solution on a new computer Win XP platform. When I try to print something in this dbase, i obtain this message: ---------------------------------------------------- PRINT JOB FAILED The print job failed to complete. Reason: The request contained an invalid parameter. ---------------------------------------------------- I try on another computer an its works well. Did anyone already see this problem? Need help to resolve this. Thanks GuyC
-
- 0 replies
- 977 views
-
-
I want to e-mail a letter to a found set in my database. The letter will have record specific data in it. Is there a sample script? Should the letter be its own layout? I'm really clueless as to how to get started. I did a search in the forums, but couldn't find a solution. Thanks for any help or pointers to some other web resource!
-
- 1 reply
- 951 views
-
-
Is there a way to make the fields on LayoutX default to be read only (not editable), then with the flip of a global switch and some clever scripting LayoutX becomes editable. I understand I can do this with two layouts, however this would make the solution more cumbersome to manage. Any help would be much appreciated. Thanks
-
- 1 reply
- 795 views
-
-
hi all, i seem to have a problem creating a relationship between a calculation field with another calculation field, or a number to a calculation field. the calculation fields returns numbers. is this something i am supposed to know that calculation fields cannot be used in relationships? i tried to match a calc field and a calc field and it shows nothing, neither does a calc and a number. it only shows records if the relationship is a "X"...
-
- 10 replies
- 1.3k views
-
-
Hi, I'm new to this forum and have a (probably) simple question! I know FM7 has the ability to change text colour depending on an answer using a calculation. I would like simply to change the results of 'PO Received' if "no" to red and "yes" to green in the field. Every time I try I get messages telling me I have too many or too few '(' ')' I know I'm doing something wrong. Can anyone help me please? Thanks Lorraine ps - I have searched the forum but couldn't find any topics relevant.
-
- 9 replies
- 1.4k views
-
-
I have a script that adds the user name, date etc. into a text field called "CS Notes" the user then carrys on typing what they have to say about the customer. I would like to set the script to use a certain colour for the text entered by the script and then by the user. Is this possible??? I have read about a calculation changing the font style but not through a script like this. Thanks guys... my 1st post oh and thanks to any girls out there too. ... in advance Mike
-
- 6 replies
- 956 views
-
-
Question. I have lots of scripts that I would like to include on some sort of drop down box. For instance, the conference management database that I have has about 10 scripts that print different items. Is there an "If" script that I can create that has a field "conference scripts" and have the 10 scripts as value labels, then if I select one of the value labels it runs that script? Seems like that should work, but when I created the script steps it doesn't work, seems like I may have missed a step. PLEASE HELP any suggestions would be appreciated. Patti
-
- 2 replies
- 741 views
-
-
I am trying to develop a medical database that gives choices for a physical examination. ie I have check boxes ie DEVELOPMENT (Normal Delayed) I want the print out to say a. DEVELOPMENT (Normal) or b. DEVELOPMENT (Delayed) or if no box is checked I want the print out to say nothing as below c. however if left unchecked, the print out will look like: d. DEVELOPMENT () Selection d. doesn't look nice so I'd rather have nothing. Is there any easy way to do this? I've tried using a script to input data into a DEV2 field as below If (Devlopment = "") Set Field (Dev2; Dev2 = "") Else Set Field (Dev2; Dev2 = …
-
- 3 replies
- 734 views
-
-
I am wondering if anybody knows how I could perform a find where the find is performed over mutiple fields as opposed to just one field. So, for instance, how do I search for Bob and the request returns all the records where Bob appears in either the first name or the last name field. Thanks, Nick
-
- 3 replies
- 711 views
-
-
Hi, I am hoping somebody could help me out here. I have an Evaluation table. The table consists of fields - Job Title, Department, Years of Experience etc. In my layout, I want to be able to choose a particular Job Title, say "Professor" and find the percentage of Professor records. And similarly for Department. If I choose "English" Department, I want to get the percentage of English department records. This is my first step. My next step is to choose "Professor" and "English" department and find percentage records with Professors from English department. I hope somebody can help me out here. Thanks in advance.
-
- 2 replies
- 1k views
-
-
I'm maintaining a dual platform solution which I recently upgraged to fm7. There is a place where mailing labels can be printed in my application and in the preview mode, the lables appear 8 or so to a page as it's supposed to but when i print the job, only one label spot is filled with an address. I've tried recreating the layout, and Printing to several differnt printers (since this is to be a bound solution for both mac and pc) with different results for different printers. I believe i'm to the point where the labels print as expected on a laser printer, but not on an inkjet. When I print to a PDF file all the addresses tile as expected also. Any thoughts?
-
- 1 reply
- 783 views
-
-
I have a list of town and some of the need to be linked together. So if I I am viewing town A and town B and C need to be linked to it, I will need to see that A and C belong to B when I am in that record and when I am in C I will need the portal to show me that A and B are related. So if a town is related to two other towns there would be six relationships in a 'join' file. A town related to three town would have nine relationships. How can this been done? Note I have considered that the records share a common 'join' id but that would be plan B
-
- 6 replies
- 819 views
-
-
Hi all. I am in a bit of a situation. Prolly really easy to fix, but yeah. I have figured out how to creat merge fields etc, and how to apply them within a letter made in fmpro. My problem is how can I do a mail merge for say 40 clients all with the same letter. I was hoping something that would physically show on a layout page, the 40 letters (as you scroll down) and each indivdual clients details merged. I guess problem is 1. Actually merging more than one record. 2. Being able to select the records that you wanted for the mail merge. Any help would be greatly appreciated. Regards, Daniel
-
- 1 reply
- 716 views
-
-
New to FMP7, I have searched the Forums for an answer but I must not be using the correct terms. I am building a db that will track mentors for a community program. Some of the mentors have provided me with their Profile in MS Word. I plan on storing a Link to the doc file in a container field. How do I display one icon if a profile document exists for the mentor and a different icon if the document doesn't exist? Additional if the file doesn't exist how do I script an object insert so that all the user will have to do is navigate to the file location?
-
- 1 reply
- 2k views
-
-
here is a little demostration that shows how a record is before ur very eyes, and cannot be found!~ ok here is what u do in the program 1. enter a record in [style Details], this is the thing that u want to order. 2. press the "Order" button, which will generate an order form for you. and now u see in [style Details] that shows the order number it is being ordered. 3. now sometime later things happen, and u have to cancel the order. so u go to [Order Form], and press "Delete", the computer deletes the entire order, and then it tries to set those styles that holds the particular order number to nothing, so u wont have any styles that has an order number th…
-
- 4 replies
- 1.3k views
-
-
I have been hearing of general weirdness with filemaker 6 on OSX in native mode. My lcient run's a bound solution and they've been reporting things like it crashing when they follow a script call that uses gotorelated record between two files. Also I've been told of records changing their relationship so that the point at a different record as in an invoice with line items scenario. A friend of mine was also getting reports of these until he upgraded to filemaker 7 (though he passed off the records getting modified or changing their relations as user error) and his users don't complain of crashes or general record silliness anylonger. I'm wondering if anyone els…
-
- 1 reply
- 955 views
-
-
Would it be possible with FM pro 7 to automatically check the field contents with a filename? For instance I have a text field with "babe.mp3" filled in and a container field with the mp3 matching file called "mister.mp3" (stored only as a reference to save disk space). I want to (automatically) check if the mp3 file in the container field is still in my folder "mp3s". For this I used the solution provided through the thread: http://www.fmforums.com/threads/showflat...=true#Post98226 Would be something for the weekend to figure out! Greetings Thomas
-
- 1 reply
- 789 views
-
-
I've been intensively using FMPro6 as a text processor for letters and press releases, and as a web archive. Many new features are interesting, but: 1. I am astonished to see that v. 7 (Trial) turns any text pasted from the clipboard (or dragged and dropped) to plain text! (v. 6 would deal with rich text). And once you've restored your text formatting, there is no way to move it out, since the Export Field Contents command, as well as the copy-paste or drag-and-drop methods, only generates plain text. 2. On the other hand, justified paragraphs are clipped, with unequal line length! Some last words in a line are shortened by 2-3 characters... 3. Italic fonts…
-
- 15 replies
- 2.9k views
-
-
I know I can get a count of the active users, but can I get a list of the active 'account' name and a list of acctive 'user' names
-
- 3 replies
- 2.5k views
-
-
Folks, Having upgraded to fm7 from 5.5 now find can't open databases one at a time, ie all relational db's ask to be opened if they are involved - this is different to earlier versions. Is this the case or is there a way round this? (Should mention this is sharing on a network with 5 users..) Look forward to hearing any ideas... Cheers
-
- 2 replies
- 755 views
-
-
This is a first. Maybe I'm beyond tired and just don't see it. I exported some records (FM7, WinXP) as .fp7. I can open that file directly and the fields display fine and all records are displayed. But when I try to import that set into another file, I get the FM error sited in the subject. I am on the correct table (layout Activities). I get the error even before I can attempt field mapping - as soon as I select the file. But the fields are in that file - along with the records! Do I need a very long vacation or is something going on? I posted on a few forums, sorry. I know the weekends are a bit slow and I need to resolve this before I attempt any more im…
-
- 8 replies
- 2.9k views
-
-
hi all... when i use the "Adjust Window" script step, it adjusts all opened windows within Filemaker. is it a way to make it adjust only the active window? thanks...
-
- 10 replies
- 1.5k views
-
-
Hi, i am having trouble solving a date calculation. i have fields like this: [Date due assigned by Customer] (data type Date) [Date due for ordering materials] (data type Date/Calculation/Number???) Then [Date due for ordering materials] is by calculation, [Date due assigned by Customer] - 60 (in other words, 60 days before customer assigned due date). i don't know which function will return a Date type for this kind of calculation or just to satisfy my demand. i tried using simple calculation, and it returns a large number, representing the Date in actual number of days!~ Fo example, [Date due assigned by Customer] = 2004-09-10 then, [Date…
-
- 2 replies
- 660 views
-
-
is their a way to make a 2 columns portal to allow my price list to fit in a single page. I can't see how to do this... I haven't seen this question in previous post. Thanks
-
- 1 reply
- 1.6k views
-
-
I've just discovered that while FileMaker Pro 7 includes JDBC support, it is implemented in such a way as to make it impossible for FileMaker databases to be used as data sources. This functionality is required to use WebObjects and Filemaker 6 via the WooF plugin. Does anyone have any idea why this has been dropped in FileMaker 7? Is anyone aware of FileMaker's plans? To perhaps include this facility in FileMaker 7, via an update, for instance? It seems strange that this was dropped. The question for me is: was it dropped due to development time or product strategy? That is, was it taking the developers too long to incorporate this functionality in time for re…
-
- 8 replies
- 1.7k views
-
-
Does anyone have "inside" information as to when FM will release bug fix v3? I am holding off upgrading our offices until v3 is relased. I can not spend time reprogramming around the Value List bugs. I am making a huge assumption that that bug will be fixed in v3.
-
- 1 reply
- 971 views
-
-
I'm creating a script that will send an email to people that have an appointment. In the email body I'm using a calculated result that pulls over the person's appointment time. Could someone please share with me how I can format the time as text with the appropriate AM or PM tag ?? I've searched for this but can't seem to find anything.
-
- 1 reply
- 649 views
-
-
I am new to FM Pro, can it automatically send emails from data it receives. Thanks
-
- 1 reply
- 796 views
-
-
I know I should be able to do this easily, but I'm just back from holiday and my brain is still fried. The problem: I want to populate 11 fields in one table called "games" with names of players selected from a pop-up that refers to a second table "teams" which contains a portal to a third table "players". That part is easy. However, if a name has already been selected for one position, I do not want the name to appear in the pop-up for other positions. I just can't get it to work. Anyone got any ideas???
-
- 2 replies
- 1k views
-
-
I have an inventory related problem. I have two simple databases for verifying stock counts in a warehouse. The first has the fields "Barcode", "Description", "Size", and "Cost". The second has the fields "Barcode" "Description", "Stock Count", "Stock Count Total", and "Cost Value". What I would like to do, is be able to set up the first database with every item in my warehose, and then use the second to walk the warehouse with may laptop and barcode scanner, scanning each items barcode, enter the "Stock Count" number, then have it update the "Total Stock Count". I have managed to relate the databases so that looking up the barcode number works to pu…
-
- 21 replies
- 4.3k views
-
-
I just installed the developer version of FMP Advanced. Now when I try to open a file located on our FMP 7 Server I get the message "THe maximum number of licensed users are currently using this copy of FileMaker Pro. Please refer to the license key section of your software documentation for further instructions. I don't have the server version running on this computer. Our server is running on win 2000. If I turn on my server advanced copy on this computer I can run the files. If I run local files it runs fine. I really wish FM had some kind of support. The knowledge base has almost no information. I hate calling and paying for help to work around Filemaker bug…
-
- 1 reply
- 820 views
-
-
Does anyone know if there is info you can download somewhere that you could use to make some kind of lookup table for finding the extended 4 digit zipcode for a given address that could interact with FileMaker? What I need to do it to type in an address and zip code and have FileMaker return the zip+4 For example, "123 anysteet, OH 12345" would return "123 anysteet, OH 12345-6789"
-
- 1 reply
- 2.2k views
-
-
I know 6.0 has a pretty poor method for data syncing, my only question here is does FMP7 handle things differently, or are we still unable to sync a local database to the server in FMP7? I appreciate any help anyone can give, as every source of info I've perused seems to tell me that this method hasn't changed from FMP6 to FMP7.
-
- 4 replies
- 1k views
-
-
I posted this in the import forum, but it's a bit low traffic. I'm converting an older version of a database into a newer one that we've developed for a non profit doing fundraising. The old DB has "home phone", "address phone", and "other phone". The new DB has a 5-field array of phone numbers, and a corresponding popup menu with phone types, including fax, work fax, etc. Is there any way to map the separate fields from the old DB to be imported into the array? Otherwise, I can only import the home phone, essentially. Can someone let me know if this is feasible with FMP, or if I'm going to have to do this manually (yikes)? Thanks
-
- 5 replies
- 1.2k views
-
-
Hi, I have 5 radiobuttons with different values. Is it possible when i click one of the buttons that a script is automatically performed? thanks
-
- 3 replies
- 858 views
-
-
I'm working on a program for our office to make balancing the Visa a bit easier. Its fairly simple, and doesn't need many protections from user error, although I guess in the future a reliable annual report would be nice. This is what I have so far, but the one thing I am having trouble with is providing subtotals (For GST, Post, and Total) for each "category", being the account names. The post amount is the amount we need to pay, the GST is the tax (that we don't have to pay; it's the 8% PST tax that we do have to pay). Any ideas how I can get this to work, easily? I don't want to have to flip between three different windows just to put in an account name (li…
-
- 5 replies
- 1.3k views
-
-
Is it possible to export records without returns in the text string? What I want to do is to generate an email "To" field separated by semicolons for inserting into an Outlook (or Eudora) To field. If I can get it into a text file, one copy and paste will address the email. (I don't want to send many emails, only one with a single list of addresses in the To or BCC field.) Or is there a better way to do this (on Windows; AppleScript isn't an option in this case)? There is only one field to be exported, but all the options I've tried result in a return between each record. Thanks for any tips, RD
-
- 1 reply
- 753 views
-
-
Hi everyone, I am new to this forum. Can someone tell me why sometimes when I have a pop up value list, you can click on it and it automatically tabs into the next field and sometimes it stays in the value list field? This drives me crazy Thanks
-
- 1 reply
- 869 views
-
-
I've been working on my first big FM7 project and have noticed a naging problem. Popup Lists (not Popup Menus) are very slow to display once clicked. In addition, after the list pops up and a selection is clicked, there is another pause until the value is actually entered into the field. It takes about 2-3 seconds for the menu to appear and then another 2-3 seconds for the selected value to be accepted. This is painfull. As a test, I created a new database and saved it locally on my hard drive (to rule out any network issues). I created one table with one field. I also created one value list with 10 "custom values". I formatted the single field to be a popup list usi…
-
- 7 replies
- 1.4k views
-
-
Hello. I've done a search and cannot find an answer to my question. Hopefully someone here can help me. I have created a database in FM7Pro and have turned on Instant Web Publishing with guest access to enter data. I enter the http address on my computer's web browser and I can see the file. However, when I enter the http address from any other computer's web browser (Mac or PC) it says that it is an invalid web address. Any ideas?
-
- 12 replies
- 1.9k views
-
-
This is a complete newbie question, but I cannot find an answer for it anywhere in the help information, the user guide, or online. I have created a new database from scratch, and I cannot figure out how to resize the layout so it only contains the information entered, and not a large white space to the right of the layout that goes on seemingly forever! How does one do something as simple as this? Thanks for your help!
-
- 2 replies
- 1.6k views
-
-
I am not an avid FM user, although I have created a nice DB that I would like to share with other professionals in my trade. Most likely none of these end users will have any type of FIleMaker app so is there some sort or free version or third party app ala stuff-it or win-zip that will allow others to take advantage of my DB?
-
- 5 replies
- 960 views
-
-
has anyone tried to develop a collaboration solution product based on FMP 7? or just a collaboration platform that includes task assignments, project tracking and processes... instant messaging (is it possible?), sharing files (this should be possible?)... etc. if so, how's the outcome compare to commercial products... is it as good as it can be like those good ones? easy to develop? much limitations? or easy to use? thanks~ p.s. i am thinking of developing a complete collaboration suite accompanied with database system with FM7... should i go for it or...? :-D
-
- 2 replies
- 727 views
-
-
Hi, I've been trying to figure this out for a while now... I have Clients and Events tables and they are related through Registration -which has EventID(primary key from Events) and ClientID(primary key from Clients). Each Event has an Evaluation from different Clients. Currently I have different Evaluation-session tables such that a set of EventIDs with the same Session Name(from Events table) are in same Evaluation table. So each Evaluation table has a global field which is Session Name and is related to Events through this. On a layout based on Clients, I have a portal showing "Registration history" of that Client, i.e Eventcode and other fields fro…
-
- 0 replies
- 785 views
-
-
Heya, I have a database that tracks tasks. Our SQL server holds employee info, but I've imported all of this into another DB. This second DB has the fields Last Name, First Name, Employee Code, Office, and Extension. I would like to pick, from a list that shows last name, first name, and when I make the selection, I want to see the code, the office and the extension get filled into the appropriate fields on the tasks DB. I've been able to create the drop down list, with last name/ first name, but haven't been able to get the other fields filled in when I make a selection. Again, I'm a newbie at FMP, please be gentle. Thanks in advance, D…
-
- 0 replies
- 644 views
-
-
Hey folks, I've been pulling my hair out trying to get this to work. Here's the prob. I have three drop down lists with around 10 choices each. Depending on what is chosen on each list, I want a value dropped into a fourth field. i.e. Type -this type selecting this should auto enter the number 1 -that type selecting this should auto enter the number 2 -the other type selecting this should auto enter the number 3 etc. there's three of these and i need each choice made by the user to automatically enter the related value into the fourth field, each one after the other, so that the values from the choices are strung togeth…
-
- 5 replies
- 1.2k views
-
-
i have a calculation field that displays the balances of some numbers. the criteria are as follows: greater than 0: green smaller than 0: red equal to 0: blue now, TextColor works perfectly. however, if you happen to use "Number format" on the field, for example, adding a leading "$" sign. the TextColor function will fail to work. please try yourself and see if it so for you too. I am running on Windows 2003 enterprise server, Filemaker Developer 7v02. should this be considered a bug? but not being able to use the leading/trailing signs and number formats with TextColor is a great imperfection...
-
- 5 replies
- 1.3k views
-
-
Been a dabbler for years, but still a novice. I've got this simple project tracking/invoicing app I've built. One of my layouts contains a list of active projects with various data (dates, client name, the usual). But once in a while I need to make a lengthy note to one of my projects. Right now I've made a second line on my layout. But it clutters up the list view, or leaves a blank line when nothing is there. Is there a simple way to click a button and bring up a popup window so I can load in the detailed notes then close it again when I'm done? Kinda like a web page popup. Is that possible with FM6? Any thoughts would be appreciated.
-
- 4 replies
- 1.2k views
-
-
I'm wondering if fm7 doesn't lower the DPI of images or something atleast on it's conversion process to fm7. My solution in fm6 and below left the image files at 1.06 GB. after converting it to fm7, I was shocked to find the file the images where in is at 300 MB. I like that it's storing them more efficiently, just would like to know how it's doing it. As long as it's not standardizing the images down to like 72 DPI and lowering the color depth as my solution needs to have the images print nice and be capable of doing higher than 72 DPI. Thanks for the info!
-
- 1 reply
- 836 views
-
-
I'm new with FMP, so this may be a silly question - I'm working on an employee database and want to display the employee picture (along w/their personal info.) using a container field. Do I have to insert each employee picture or can I generate a script to automatically populate the container based on url location of the picture. All pics are stored in the same directory and the pic name is username.jpg. I have the username in a different field - so I'm hoping I can pull the picture name and url and somehow populate the container field.... Any advice would be great!
-
- 4 replies
- 1.2k views
-
-
I have created an asset tracking database which I need to create a report for. I have a table containing an entry for each asset no, the equipment type that it is and the make and model. I then have a second table containing an entry for each asset tracking entry. This includes a field for the date of the movement and a field with radio buttons containing 6 options for the location of the movement. What I require is a report telling me the totals of a particular type of equipment, make and model which are deployed, tested etc (the options of my 6 locations) at any one time. The report would have to take into consideration where a particular piece of equipment was at…
-
- 0 replies
- 737 views
-
-
We have a solution that has several databases. We us an interface that writes to all of the related records in the various databases. Example: A unique # is assigned to a case. That case will create records in DB1 DB2 and DB3, the unique# being the relationship. When a user opens the frontend interface they can write to DB1,2,and 3. In FM 2 people can't be modifing the same record. Is there a workaround were they can. We need the user to be able to go into the frontend and modify DB1 on one screen while another user is modifing DB2 on another screen. thanks in advance for your help
-
- 3 replies
- 1.6k views
-
-
Hi Folks, I have a layout that needs to print a number as a barcode - code 39. I have downloaded a free code 39 font and configured a text field on my layout as this font. It happens that the font works 100% on Mac Os Text Edit. but on my Filemaker layout "disapears" The text is there, But I can't see it! If I copy the fields contents and paste on Text Edit. Voul
-
- 9 replies
- 1.4k views
-
-
I am writing a bookkeeping application and would like to display balances outstanding for invoices overdue by 30 60 90 day periods. What I would like to acheive is have 3 fields 30 60 90 which dynamically calculate balances based on age of invoice and result is balance of those invoices. Can anyone point me in the right direction
-
- 4 replies
- 1.1k views
-
-
I am trying to create a database for an adoption project, where it will hold thousands of people with their DNA profiles. As new people are added it must check all records to find matches based on their DNA profiles. Is this possible to do with a real-time calculation using a cartesian product of 2 tables, or does this have to be a script that loops through records? Any ideas are appreciated.
-
- 9 replies
- 1.1k views
-
-
I have been trying to do this script that will print a document for a record but it will not work correctly. What I want it to do: User on a data entry layout in browse mode, clicks print button. Window stays on this layout (from users view point) and a print dialog pops up. They choose the stuff in print dialog and click print. Document prints. During this entire process the user should never see any other layout on screen except the data entry and the print dialog. What script really does: When the user clicks the print button on data entry screen, the layout that is being printed, is displayed in preview mode in the window while the print dialog is …
-
- 8 replies
- 2.2k views
-
-
Sorry if i'm posting this in the wrong forum, I haven't been here for a long time and I'm not sure where this fits exactly. I have a simple database which will track "meeting minutes". It will be used by three managers with about 25 employees each. I created a database with three tables: MeetingMinutes, Staff and Attendance. I can't seem to figure out a way to flag Staff members with a checkbox in the Attendance table so only those that attended a specific meeting show up in a portal in MeetingMinutes table. To be more specific: A manager enters text into several text fields containing the minutes in the MeetingMinutes table. The manager then goes to the Atten…
-
- 5 replies
- 910 views
-
-
I'm trying 2 figure out how to store a graphic in a repeating global container field. If you refer to this link http://www.fmforums.com/threads/showflat.php?Cat=0&Number=113016&an=0&page=37#113016 you will understand more what i'm trying to achieve. I just can't get the image to load and i know I must be doing something fundamentally wrong even though i've done it once before several weeks ago. Can someone help Regards Dave
-
- 9 replies
- 1.6k views
-
-
Does someone know if it is possible to make a database linked to one record so that each record have the same database linked but with other values. Because if i make a hyperlink to another database i have to make each time that i make a new record a new linked database. Could someone help me PLS THX
-
- 7 replies
- 995 views
-
-
I have a portal setup for a card collectors DB. I have it setup with different colors to reflect the different options the user has to pick from such as 'own', 'trade', & 'sold'. When the user selects a new record for the portal I want the new record to be first in the portal. I want the sort to be 'own' first, 'trade' second, and 'sold' third as they are listed in the portal. The 'own', trade',& 'sold' are listed on the form as checkboxes, so they either have a value of '1' or '0, zero'. I have tried setting up the order through sort portals, but it never comes out right. Is there something else that would setup the portal to list the cards in this order? Ano…
-
- 6 replies
- 819 views
-
-
I have written a script in FM7 to print a job to the network printer. The printer has 3 trays, and the script should print one page from each tray. However the script seems to lose its settings after a short period and starts printing all 3 pages from just 1 tray. How can I write the script so that it does not lose its settings?
-
- 6 replies
- 961 views
-
-
Records created via a portal (quote records via relationship from a source record) started to vanish today. I went troubleshooting the relationship (both in the same file), and found that it seemed set up right, and was still treating old records correctly. Records created directly in the related quotes table seemed to be stable. (The solution had been in use for months, one of my first FM7 creations.) So, I created an external table, and had it import all the quotes table records. I set up an "allow creation" path in my main file to the new table and then redirected the portals in my source layout over to the new external table, to see if it would help. I went …
-
- 8 replies
- 1.2k views
-
-
By default, I need to input Date by entering DD/MM/YY. Can I change it in another way, eg. YY/DD/MM??
-
- 2 replies
- 736 views
-
-
TRYING to print a billing statement with two portals: invoices and payments. Each portal is 100 rows to allow for plenty of activity during the month. Everything is fine except the second portal. The headers above the second portal properly slide up to near the bottom of the first portal. But the second portal itself starts after 4 or 5 blank pages. Yes, sliding is turned on for all necessary objects. Yes, the body is reduced to the point that it's touching the lowest object in the body. Is this yet another bug? Thanks for any tips. --Frustrated.
-
- 9 replies
- 2k views
-
-
How do I get a found set from one file to another? Files: I have created three files, one file holds the date, second file holds the interface (layouts for data entry), and the last file contains my report layouts (printable ones). Problem: A user does a search in the "Interface" file and a found set in listed. Now the user wants to print the list if records. I need to move the found set over to the "Reports" file to be printed out on one of the layouts. Is this setup possible with FIlemake 7? Do I need to move all the layouts back into the "Interface" file, where the searches are performed? Or should I move the search and list layouts into the "…
-
- 5 replies
- 777 views
-
-
Just wondering if anyone had bought the new version of Filemaker Mobile 7 and if anyone knew whether it's as bad as Filemaker Mobile 2 was or is it this time a proper DB app for the Palm ? Thanks
-
- 11 replies
- 1.9k views
-
-
Hello, I can't seem to find more info on Portals. I have a couple questions: 1. I have the relationship setup to create new record when the user finishes a line in the portal and hits tab or select a field in the next line they can start the new record in the portal. How can I set this up so the user has to hit a button to create a new record for a portal and not have FM auto create the new record so the user can't do this in error? 2. I have 3 check boxes in a portal row (this is for a card collecting DB), 'own','Trade', & 'Sold'. I would like to change the color of the background for the portal when a user selects one of these buttons. I figured I could do a b…
-
- 5 replies
- 1k views
-
-
Very noobie question here. I have a table called purchase_invoices which is bound to a data entry layout (Purchase order entry), on this layout I would like to place a button which would list all records in a new laylout. I only wish to list certain fields and each record must be in a single row with the next record below etc. I do not wish to do this as a report as I would like to add some addition functionality like click on button to go to selected record in original layout. Any ideas would be welcome. Many thanks
-
- 0 replies
- 754 views
-
-
i found that in table view, the table's header's display and fonts seem to be preset, and i can't find where to configure them. Filemaker cannot display foreign characters right at this preset font when printing, but it displays them right on screen. bad... when printing in table view, those foreign characters all turn into... squares. whileas preview actually shows them displaying correctly. i tried printing into a PDF file... same result... so it's mostly Filemaker's problem, not the printer's.
-
- 4 replies
- 3.6k views
-
-
I've got this database with a number of form letters in it. We are in the process of migrating part of the database from FMP 4.0 to Access 2K3. Is there any way to extract the (static) letter part? The rest of the relevant data I've already exported. In pointers to docs or suggestions will be greatly appreciated. Thanks.
-
- 2 replies
- 965 views
-
-
Hi, I'm trying to change some features on a student database solution which was designed by someone that we no longer want to employ (don't ask!). It was originally a FM6 solution but I've converted it to FM7 whilst still keeping it as 16 related separate files. What I'd like to do is track whether students have handed in a specific assignment by using a handheld text scanner to input the student's id number into a field in the Assignments table which then copies the student's details into the Completed Assignments table. At the moment we have 2 portals in the Assignments Tracking layout. One of these shows the students who are registered on that modul…
-
- 2 replies
- 735 views
-
Recently Browsing 0
- No registered users viewing this page.