FileMaker General Discussions
Older discussion forums for previous versions of FileMaker
-
Hello! I need help to make a Mailing List (or a Listserv) Forum with FM 4 for Mac. I have already create a e-mail adress for my forum and I need to create a DB who take all the messages who are send on this e-mail adress and store it. After I approved the messages I want to resend all of them to all the participants of the forums. And I want that this messages was also posting on a wab page. Can it be possible to make this? How? If someone help me it's very appreciated! Thank!
-
- 0 replies
- 618 views
-
-
This seems like it should work, but its giving me a hollow square instead of doing a carriage return in my field.. I have: Trim(First Name) & " " & If( MI, "", Trim(MI) & " ") & Trim(Last Name) & "
-
- 2 replies
- 720 views
-
-
I have 2 databases setup, for simplicity I'll call them 'A' and 'B'. 'A' has a relation with 'b', their product id's are connected. There isn't any problem here, It's later, when I added 'Customer Notes' field to database B. If I add a new record to 'A' then if there was any text in "B's" Cust. Notes field, it'll be copied correctly into 'A". If I goto a field that was created BEFORE I added the relationship (cust notes in 'b') then the relationship is still empty, (because i didn't add anything to it yet) but if I goto 'B' and enter in notes on that customer, and them go back to 'A' it's still blank. The only way I can get it to make the connection if to re-enter…
-
- 6 replies
- 866 views
-
-
HELP!! I am trying to import an EPS file but I get an error saying "FM cannot complete the operation because of an OLE (0x80010001) error" What does this mean? I really need this files for the graphics. And how do I import fonts that were used on the MAC? (I have the font files but my PC doesn't recognize them as font files.) Help! J.
-
- 1 reply
- 663 views
-
-
In helping a client with some computer problems, I needed to delete preferences for FM 3.05. Now the screen view of form page is smaller than previously. as i am not well versed in FM, I'm not sure how to get the full view back. According to the book there should be a selection under preferences for view, but when i open preferences, that schoice is no where to be found. I know that you can increase the view size from 100% to 150%, but 150% is too big and 100% does seem a bit small (it only fills about 3/4 of an imac screen). Any help is appreciated. Jeff
-
- 3 replies
- 873 views
-
-
I'e just accidently deletedthe last recoerd in my Filemaker 4 database that I spent 2hours creating!! Is it possible to recover a deleted record? Very gratefull for any asiistance that might enable me to recover this record and save me from another 2 hours of toil. living in hope, BB
-
- 3 replies
- 2.4k views
-
-
I am new to this forum, so please bear with me. I am hving a problem with accessing the layout menu dropdown list (the one above the graphical rolodex file). The button depresses, but no drop-down menu appears. I have made sure that the layouts are all checked--indicating that they are to appear in the layout menu. The only way to access the layouts is to be in layout mode, and to click page by page down the rolodex (or to use buttons that are included in layout screens). The data is stored on a network server. Other computers accessing this database do not have this problem. I have reloaded FM Pro on the computer in question with the problem remaining. Any suggestions fo…
-
- 1 reply
- 726 views
-
-
Hi, All-- I have a solution with 3Files. The first file is Projects, which contains information on current and past projects. It has a Project ID for each project. The second is Personnel. It contains all the personnel working on either one project or several at the same time. Each personnel is assigned a Personnel ID. The third is Billing which shows all Bills on both projects and personnel, but each new record is based on the personnel. All the information for billing is collected back into a portal in Projects. I want to be able to collect all the data for a particual personnel and show all that info in the Projects portal, however, it is showing me several records fo…
-
- 2 replies
- 698 views
-
-
Is anyone else having problems moving objects when working in Classic? Everything else seems to be fine, but moving and sizing graphics is very jerky, have to move in small increments. Any word on when FMP for osx will be released?
-
- 2 replies
- 625 views
-
-
I've created several scripts to manipulate imported data from a Lotus worksheet. One of the functions is to delete duplicate records that were imported. When I run the script, it finds the duplicates and performs the deletion. The problem is, it requests input (confirmation of delete) from the user for every record it needs to delete. Is there a way (in the script) for me to bypass the record deletion prompt?
-
- 1 reply
- 1.1k views
-
-
Hi, Newbie question here. Can I put a button in Filemaker Pro 5 that links to an external website? The only mention in help I could find didn't seem to do it. Thanks for any suggestions.
-
- 1 reply
- 646 views
-
-
I need to rotate an entire layout by 180 degrees, so that I don't have to spin the page around before stapling it to the preceding page (the first one is portrait, the second is landscape). Everything will rotate using the Rotate command in the Arrange menu, except for the portal. I can't find any way to rotate portals. ... and no, I can't change the layouts so that both pages print the same way; the invoice page has to be portrait, and the financial summary has to be landscape. Does anyone have any ideas? Thanks. Paul
-
- 1 reply
- 643 views
-
-
I have problem with netscape 4.08 and up (not tried with NS6), i have my own HTML file with CDML and i built it with GoLive. The problem happen when i try to access to the data after a search. Everything is working well with IE 4 and up, any idea , is it the %20 for spacing :
-
- 4 replies
- 1.1k views
-
-
I have a field with "yes" and "no" radio buttons. I want a second field to automatically enter "none" if the "no" is selected in the first field. How do I do it, please? Thanks for your help.
-
- 1 reply
- 708 views
-
-
I'm new to Filemaker, so please bear with me (no pun intended). Here's the situation... I have an invoice file, and a parts entry (inventory entry) file. I buy (say a qty. of 5) of a part and enter the information & qty. into the parts entry file. When I need to write up an invoice for someone buying one of the parts, obviously the inventory should then update to show the "on hand" quantity as one less. My question is this... is there a formula/relationship setup that will let me do this? By all means feel free to e-mail me with as much info. as you can. As I said, I'me very new to all of this. Thanks!
-
- 4 replies
- 1.1k views
-
-
I have a found set of records. How do I code a script to print each record on a separate page. My current code will print some of the found set on individual pages and the other pages will be printed with two or more records on the page. I am using FM Developer 4.0 on my G4 Mac. Thanks for your help [ March 28, 2001: Message edited by: Neil ]
-
- 1 reply
- 1.6k views
-
-
I have multiple users scattered over the planet. I need to be able to keep up with all changes to their databases (runtime solutions) on a main database that I keep at home office. As they make changes I can update those records at home. If they create new records They are tagged and The main server creates a new record. That's what I'm thinking. How do I get the stuff out of the runtimes and tranfered to my main system? Poosible hundreds of people doing this each business day. Any plugin ideas or other ideas? Thanks
-
- 0 replies
- 629 views
-
-
I had reinstalled FM5 (yes, it is a licensed version) on my new computer and everything seems OK. Suddenly I cannot start FM anymore. Would appreciate any advice.
-
- 11 replies
- 1.2k views
-
-
Was connecting to DB on enet LAN installed X and FM tells me file wasn't closed need to recover blah blah. It tries but then quits and tells me something about not locking the file. Anybody?
-
- 6 replies
- 591 views
-
-
I have a fairly complex (24 interrelated files), bound solution distributed on both Macs and PCs in kiosk mode. One (and so far only one) PC implementation gets occasional, random 'Abnormal Program Terminations'. It's a Windows 98 application. The termination affects the files by destroying the font references assigned to displays. This customer is NOT happy. On two occasions the termination allowed me to get 'details'. In both cases the dll referenced was fmtools.dll. In addition to losing font assignments, one other symptom of the failure is corruption of the 'wallpaper' the user has assigned to his desktop. It gets 'chopped' up. Any clues or similar experiences? I'm …
-
- 1 reply
- 732 views
-
-
I'm using Filmaker Pro 4.03 to develop an order/invoicing/inventory system. I have all the files setup and it seems to be working just fine however now that we have nearly 300 records in the order file the other filemaker apps that connect to the host are terribly slow to bring up and update records. This is what I have going on. Our sales people enter orders in the orders file. The entry fields here are actually fields created in the invoice file and layed out using a portal. You create a new order record and you get a new invoice. I also have seperate files for items received (stuff we have bought to resell) and a seperate inventory file. In the items received file and …
-
- 3 replies
- 955 views
-
-
I have about 40 files, some of them are related while some not. Are there any way to clear ALL fields from ALL files? it's a pain to do it one by one...
-
- 7 replies
- 943 views
-
-
I have a pasted jpeg file for each record. THEY WON'T PRINT!!! Everything else, including images placed in the layout will print fine. If I go to the preview window, it gets all wacked out, placeing ONLY the images that WONT print?!?! I have tryed restarting and reinstalling. PLEASE Help. I have a p4, 1.5ghz, 512 ram, windows 2000. Thanks -Nolan
-
- 0 replies
- 603 views
-
-
I need help with my report. The report is structured as follows: Header: Normal information date, title of report, etc.. Subsummary by c-first of month (Leading): I have this set to break by month. This part contains 1 field (c-first of month) calculation ="Date(Month(Run End Date), 1, Year(Run End Date))" Subsummary by substrate number(Trailing): I have it set up to break on product numbers. In this part has 7 fields. (Substrate number) text field (Cat Num) calculation= Case(IsEmpty(Substrate Part Number)," ", Substrate Part Number = 123456789,"AB123", Substrate Part Number = 123456987,"BA124", etc..) (Sum of lot) summary field = total of Lot …
-
- 3 replies
- 690 views
-
-
Is it possible to have information from a portal appear in a pop-up list in a field that is not in the portal? IE: A line item number from a portal being put in a field for an external cost so the external cost can be referenced to its associated product? Having line item numbers appear in a list is way more secure for data entry than transposing them or even drag and drop. Any ideas/help would be greatly appreciated. Thanks, Chris
-
- 0 replies
- 801 views
-
-
Company is networked. Network protocol is Tcp/IP. The Layout pop-up menu is displayed in columns on some users and with one long column with a scroll on others. None are Mac, all PC and under either Windows NT, 2000, or 95. Cannot figure out how to get the layout pop-up menu in the status area to show in columns and not one long vertical column with a scroll. Help???
-
- 1 reply
- 613 views
-
-
I've imported an old dbase (DOS) mailing list database into FM5. The file imports fine, but I have one field called "citystate" inherited from the original containing, as you might imagine, both the city and the state. Is there an automated way to separate this data? The FM5 Help menu or printed documentation don't appear to readily address this issue.
-
- 2 replies
- 805 views
-
-
Is there a way to email directly from FM5? I am for some reason under that impression. I maintain a mailing list database and would like to be able to email new records to my fulfillment house to ship my product. Then, upon successful transmission, I'd like the new record's status to no longer be considered "new", thus paving the way for more "new" records. Thanks.
-
- 1 reply
- 1.2k views
-
-
It was comforting to find the Development Standards by CoreSolutions www.coresolutions.om.ca . It's nice to have field naming coventions and such. It just makes the whole process feel more professional. I know there must be a good reason, but I've got a question about one of the standards. It states that, "No portal shall be formatted to allow the manual creation of related records- ie all related record creation shall be done via scipts whic are called by a button on or near the protal." What is the reasoning behind this one? [ March 25, 2001: Message edited by: BruceJ ]
-
- 1 reply
- 542 views
-
-
When setting up a report with the layout assistant, is it possible to re-open the assistant to review all the settings.? It took a couple of tries to get a sort/ report working. Now I have to recreate it. I did not record all the wizard settings. I do not see all the settings in the pull-down menus.
-
- 1 reply
- 586 views
-
-
HELP This is a big one for me. Do you know any experts in File Maker Pro that could advise us. Contact Software/Database Requirements Expediciones Chile is a adventure travel company in which clients from the United States come down to Chile to participate in kayaking, rafting and other activities. Currently the company is based on a Macintosh platform using Now Contact (TCP/IP) as the primary contact management software tool. The server for Now Contact is at a static ip address. The sales force can update with the server. However if one of the sales force is unable to connect to through TCPIP they can continue to enter data in their copy of the contact …
-
- 2 replies
- 918 views
-
-
I am creating a FMP DB that will contain 60,000+ reference only graphics. It would be a great time saver if the application preferences allowed the user to set "insert reference only" as the default. Since that is not the case, I am wondering whether there might be some area in the registery (Windows NT 4.0) that could be modified. I am of course totally open to any other suggestions you may have. Thanks. [email protected]
-
- 0 replies
- 628 views
-
-
Hi All, Can you have a second variable in a lookup? What I mean is this: One file ("Quote") showing records from another file ("Line Items") in a portal based on a "Quote Number". I want to have another file "Purchase Order" bring records from the related file (the one used for a portal in "Quote"), but I want to show only those records that have a certain "supplier nubmer" in them. Can you do someting along the lines of a sort and and then omit the other records? I can't figure it out for the life of me. Any help would be greatly appreciated
-
- 4 replies
- 770 views
-
-
Since my data base requires lots of text I am looking into linking my FP5 solution, on the Mac operating with OS9, with a speech recognition program. Has anyone out there had any experience with this, and if so, any recommendations?
-
- 1 reply
- 676 views
-
-
-
Is there any way to activate the second button in a "show message" command without using the mouse?
-
- 1 reply
- 621 views
-
-
I've a serious problem with wheel Mices and FMP : I used to mask the toolbar to prevent users to browse through the database entries. But, on PC, he can still use the wheel to move from a record to another. Anybody had the same problem or any idea to prevent this ? Yves Savonet
-
- 1 reply
- 679 views
-
-
I have a FM 5 data base I need to use on ver 4. How can I save FM5 to be opened on ver 4?
-
- 1 reply
- 632 views
-
-
Hello all. I don't see how I can do this in my database, so I hope you can help. We have reports file. In this file, we have reports that are as short as 1 page, to as long as 14 pages. I have made a calc field that determines the number of pages used. However, if one of our users finds 15 records (reports) they need to print, it takes them a long time... They have to click to each record and print pages 1 to x, then go to the next record, and so on. Is it possible to script this process? I can't seem to find how to set the page values in the print window based on a value from the record being printed... I could then loop this, and they will have their 1 click - print …
-
- 6 replies
- 758 views
-
-
I have several computers in an office and want to share/host a database via TCP/IP. When I go to document preferences and try to change it to multiuser, I get a FM message saying that the fiel couldn't be set to mulituer do to a network error. It sometimes returns the code (-2) and other times returns (-10). Thanks in advance. ------------------ Bruce J Kansas City [email protected]
-
- 2 replies
- 681 views
-
-
FMP5 will "convert" v3 files to v5, allowing you first to save the v3 file (renaming as desired), then to save the v5 file. As far as I can tell, the conversion won't change a thing. You can't "save back", so once a file is v5, it's v5 forever -- of course, you can export the data and import it into a v3 file. Yes, v3 and v5 can live together -- I've got ... well, actually I have v4 and v5, but it amounts to the same thing. HTH, Dan
-
- 1 reply
- 910 views
-
-
I have read here, and you can do a search for the thread, that you can export or open the Access table with Excel and then FM can import the spreadsheet with fieldnames.
-
- 3 replies
- 674 views
-
-
Hi. I am setting up a database for sailboat rental to calculate time at a certain rate, with one field for culmative time for each sailboat. I had it set up in excel like this: DATE DAY FROM TO TIME USED CULMATIVE The culmative time being a calculating field that would calculate the whole time the boat was out for a certain period, say, a month. Transferring this out to filemaker has been a headache; I know I have to think "outside the box" but I'm having trouble with that field. FYG I used the time sheet template to start with and am changing field names within, deleting fields I don't need. Any help with the culmative field would be appreciated.
-
- 2 replies
- 676 views
-
-
Talking to an MS Access programmer today he told me he always splits his .mdb file into two separate files, one containing only the app data and the other only the app structure. Can FM do this? If yes, how? TIA gary
-
- 5 replies
- 639 views
-
-
-
I HAVE A FIELD THAT IS HAS REPATITIONS SET TO INDEX 7 TIMES. I NEED TO TOTAL UP ALL THE NUMBERS FROM ALL SEVEN REPATITIONS IN A SEPARATE FIELD. DOES ANYONE KNOW HOW THIS CAN BE DONE?
-
- 6 replies
- 846 views
-
-
My boss and my bosses boss are interested in using Filemaker Pro for our sister companies. I have given them a "dog and pony" show in regards to the databases we have and how this company uses Filemaker, but they would like to know other users of Filemaker. I have given them a list of users that I know of but I was wondering if anyone knows if a list exists?
-
- 2 replies
- 976 views
-
-
We have Filemaker Pro Server v3.0v4 running on a PowerMac with lots of RAM. Both Windows and Mac users access the database with the v4.0 client (patched to the latest versions) over ethernet. Now, some of my Windows users occasionally can't access the shared databases. There's no reason to it- Mac users have no difficulty at all. Other Windows users- no problems. But when certain Win98 users try to open FM4 and access certain files (via File->Open->Hosts), they get the hourglass cursor, and wait- often for over 10 minutes. I should add that the database appears immediately in the "Hosts" screen, the delay is when the file is actually being opened. Sometimes the dat…
-
- 0 replies
- 670 views
-
-
We have Filemaker Pro Server v3.0v4 running on a PowerMac with lots of RAM. Both Windows and Mac users access the database with the v4.0 client (patched to the latest versions) over ethernet. Now, certain of my Windows users occasionally can't access the shared databases. There's no reason to it- Mac users have no difficulty at all. Other Windows users- no problems. But when certain Win98 users try to open FM4 and access certain files (via File->Open->Hosts), they get the hourglass cursor, and wait- often for over 10 minutes. I should add that the database appears immediately in the "Hosts" screen, the delay is when the file is actually being opened. Sometimes the …
-
- 0 replies
- 744 views
-
-
Well, with all the great solutions provided through this forum, who needs a new one?
-
- 3 replies
- 1.3k views
-
-
I just downloaded the Trial version because our company would like to make sure it can do what it wants before it is purchased. I went through the tutorial but I'm confused I guess because the tutorial did not relate to our business. What we need is really something basic and from what I can tell Filemaker pro will do this. I'm hoping someone can help me start from scratch if I tell you what our needs are. I've heard so many good things about this program but unfortunately the company will not invest unless it knows it can do the job.
-
- 9 replies
- 1k views
-
-
We are trying to network 2 x PCs. and keep getting error code 10. Can you tell us what this means?
-
- 0 replies
- 626 views
-
-
I currently scan reports into container fields but this eats up lots of memmory. I am looking for recommendations for a character recognition plug-in or software that can work well with FMP5 solution to convert the scanned data into text that can be entered into a text field. Many thanks. Greg
-
- 1 reply
- 869 views
-
-
Go to the FileMaker Inc web site http://www.filemaker.com/ and download the latest patches -- you should be using FMP 4.0v3 or 4.1v3.
-
- 1 reply
- 623 views
-
-
Is there a way to print a layout from a main menu screen, even if it is not currently in view?
-
- 1 reply
- 612 views
-
-
My database is set up with a main menu which leads to several seperate layouts for entry of different data. When I navigate from the main menu to a new layout, the previous data entered in the various fields is displayed. Is there a way to show blank fields in the layout every time I go to that view? Thanks Pavel
-
- 1 reply
- 1k views
-
-
Hi all, I'm hoping someone has a solution to what I'm trying to figure out: I have a portal list in one layout for products. In another layout, I have a portal list of the same products, only there is loads of information you can enter about each product (custom products) and the portal rows are very large. Because of the nature of our business, all this info on one product is necessary at time but not at others. This is why I created a simple list. My problem is this: Can you click on a button in a portal row and have FileMaker switch to another layout with that same portal in it and go to the row you clicked from in the other layout? Thanks for any help, Chris
-
- 1 reply
- 653 views
-
-
Q: I'm confused... If I find a plug in that works well ina solution that I want to share/host will the guest user who accesses the database have to have the Plug In installed on thier computer as well? Along those same lines, if I'm hosting files with a server version, do the plug ins go in the server and/or the users applications on their local computer? ------------------ Bruce J Kansas City [email protected]
-
- 2 replies
- 1k views
-
-
A FM application I'm using/troubleshooting has a button that calls a script that adds a new record. A subscript runs as part of this script and creates 3 related records. When adding a new record, a FM warning pops up saying: "This field cannot be modified until RECORD NUMBER is given a valid value" I click ok, it comes up again. Three times total. Then the script dumps me in the right field in the right layout, like I was creating a new record. But there is no record number assigned. I think the message results from the record number not being created by FM before the 'create related records' subscript runs, which then fails three times. The scripts seem to be …
-
- 4 replies
- 648 views
-
-
Whenever I try to insert a picture into the database I get the following message: "Error-2804 occurred during initialization of Claris XNTD" I am unable to import any type of graphic into the database. How can I correct this problem?
-
- 1 reply
- 521 views
-
-
hello there.. well, we have discovered what would appear to be a Filemaker pro black hole of information.. nestled somewhere in the deep fissure between idiot knowledge and hi-tec egghead type computerese. We
-
- 5 replies
- 673 views
-
-
Ok, I'm a new kid to FMP. I'm stuck on something. I have a field that is defined as a value list. The list is of different types of equipment. In the layout I designed for data entry, I set the field up for check boxes (as more than one type of equipment may be applicable). I want to do a report layout that will summarize all of the checked entries for this field as compared to another field. EX: Failure (equipment value list) Team (Team name) If Team A has 3 failures, the check boxes allow for multiple entires in the failure field. I need a report that will allow me summarize all of the failures for Team A collectively, say, over a 30 day period. Does t…
-
- 3 replies
- 795 views
-
-
Hi... 'nother question. When I look at my database in Filemaker, it looks just like I want it to- in a table view, all the columns are on the screen, sized according to the contents. However, when I activate the Web Companion, and view the file thru Internet Explorer 5.5, the columns are all evenly spaced so that the table occupies probably 3 page widths so you have to scroll over to view everything. How can I change this so the online view matches the internal view? I have tried everything I can find or think of, to no avail (not saying much...) Jim
-
- 0 replies
- 638 views
-
-
Hey there, I just attempted to upgrade from 2.1 v3 to version 5. The message I get says "Unable to Install" and prompts me to search for my previous full version of filemaker pro or qualifying upgrade. When I browse into my Filemaker Pro 2.1 folder and click on the icon I get "Filemaker Pro is not a proper upgrade product." According to the documentation that came with the upgrade package, I should be able to upgrade if I'm running Filemaker Pro 2.1 v2 or higher. Anyone have any guesses as to how I can get this baby up and running before customer service opens up Monday morning? Thanks, Greykell PS: If it matters, I upgrade to Pro 2.1v3 from Filemaker II a looooo…
-
- 2 replies
- 609 views
-
-
As a DB newbie, i will try to explain this, please do not flame me for newbie stupidities. At the office i am able to connect UD4 on my NT machine to a MS Access DB, while using a BEA server. Though i accomplished this today, i am already cooking up some JSP pages that allows me to update/delete records in the Access db and also perform login/logout functions. Thought this was pretty easy, i want to do the same thing (building jsp pages) at home, on a Mac (G3/233mhz/192ram). On the Mac i have copy of UD4, FMP5 and i have a Java server running. I was able to make UD and my java server communicate, but also make UD recognize the FMP DB. For the sake of it, i was runnin…
-
- 5 replies
- 986 views
-
-
If I have a numeric field and enter the value of 1.0E4 how can I format the field so that it shows 10000?
-
- 3 replies
- 1k views
-
-
Someone in our school district has created two separate dbs with the same fields. When she creates a record in one database, she wants it to automatically create the same record in the second database. I suspect that this requires a script. Can someone offer some advice, please?
-
- 1 reply
- 690 views
-
-
I'm trying to do a simple loop to find a matching record. I want to loop through a d/b to find a matching record but I don't know how to exit if I'm at the last record. How do I do this? "If this is last record, exit loop" THanks
-
- 2 replies
- 1k views
-
-
I am using Chinese Win98/ME and file maker pro5 (Eng). I can't input chinese word into my database by typing but i can input an excel file which containing chinese words. Does anyone know the solution to enable me to input chinese words directly in FMP5?
-
- 1 reply
- 726 views
-
-
I'd like to compare the database here in the office to the database that I allow web users to modify and script it so that I can see what files have been deleted by web users, any ideas?
-
- 1 reply
- 659 views
-
-
I know that FMP historically has limited duplicate checking/catching abilities. I am wonsdering what the best way to prevent duplicate information from being entered and/or imported is. Thx. -B
-
- 1 reply
- 698 views
-
-
Hello: I am beginner and I wanted you to help me to carry out the following thing: My project is to register all the attendances to 3 different machines in oneself file with 3 layout: 1file=test-machine 3 layout=(machine1=layout1,machine2=layout2,machine3=layout3) field1=shift field2=week field3=date field4=start-tim field5=end-time field6=system My main problem is: when I change a data in layout1 for example "shift" this data also modifies in the layout2 and layout3. Other problem is: I place a button in layout1 to generate new record and this button also affect to the layout2 and layout3. The only thing that I am happened is to define fields …
-
- 3 replies
- 779 views
-
-
This is the problem. Quiz Database. I have one database that stores several different cateogories of questions. Once I find the subset of questions, I need to randomly pick a certain number of questions for a test. When I tried it, the randomly picked questions are from the whole database not just the subset(category) of questions. I am thinking I need a field to mark as the found set and then have the random number generator pick from that marked set. But how? Thanks in advance for any help!!!
-
- 1 reply
- 1.3k views
-
-
I am FileMakerPro 5 user. (Windows 2000 professional, FAT 32). Problem is: Menu command "Save a Copy As" is not save properly. Error message: There may not be enough disk space to complete this operation. But I have got a lot of disk space on hard disk. Please help me! Thank you in anticipation, Gabor Jakab
-
- 1 reply
- 608 views
-
-
We are using FileMaker Pro 4 and we are having a duplicating field problem. When enters a new record number (i.e. 2000-365) and the number already exists on different record there is no warning saying "This number already exsists." Is there a way fix that? Thanks
-
- 1 reply
- 628 views
-
-
-
I am creating a project tracking system which has 3 time tracking files that relate to a master Projects file, based on departments. Data is entered through portals there and lives in each respective department file. In each TT file there are a few summary reports for time tracking which are sorted by month and year. These are fine on their own. What I am trying to do is consolidate all three of these files for a report within the master projects file, where the time totals are already stored according to project. It is no problem to summarize the hours - the problem is to list everything by month and year in a nice neat consolidated report. Otherwise I have 3 Janua…
-
- 1 reply
- 655 views
-
-
Hi.. Need help- I'm 100% new to File Maker. I am building a database for my book collection. I have it set up nicely for what I want it to do, with one exception- how can I make it so that there is a link- button or other on the page that when clicked, it will open a new page, layout or whatever with a photograph on it? That way I can have a large photo of the book, signatures and all on a page that can be printed separate. Otherwise a photo on the same page will be too smalfor detail. Ideas? Jim
-
- 3 replies
- 645 views
-
-
I have a text field in a filemaker db which I am using to store notes. The text extends beyond the frame boundaries and I use scrolling to access different parts of the document. Here is the difficulty. If I scroll to read a particular position, and then select another window- either a different filemaker window or another application window, then the pointer position automatically scrolls back to the top of the document. This is a big problem if I want, instance, to see the bottom of the filemaker record while inputting into another application or into another filemaker window. How do I make filemaker maintain the "pointer" position in a field when switching applic…
-
- 2 replies
- 667 views
-
-
Is there a simpler way to "lock" a record from being modified other than going into the "validate by calculation" settings? I have one form where there is a field called allowedit which is either empty or contains "T". I would like for the user to not be able to alter any fields or portals if the allowedit field = T. I have added a script to set the value of the field to empty if the user definetly wants to alter the contents of a record. Thanks
-
- 2 replies
- 1.1k views
-
-
I've just discovered several Filemaker II (Mac) files created ca. 1992 which I neglected to re-save in subsequent versions. Now my Filemaker Pro 3.0 won't open them
-
- 1 reply
- 649 views
-
-
-
I want to simulate an input box or a dialogue box for a user to input data into one field. To achieve this I duplicated my original layout, then proceed to draw the dialogue box over top of it, disabling all the fields underneath. However, I have a portal underneath, and when I click on the dialogue box, it highlights the portal row right through it. Is there any way I can disable it? Kim
-
- 3 replies
- 777 views
-
-
Is there anyway to store a PDF file in a field within a FM5 data base?
-
- 2 replies
- 1.3k views
-
-
I see where to print out scripts and field definitions, but not relationships. Is that a missing feature or am I just thick and don't see it. Thomas
-
- 6 replies
- 819 views
-
-
I'm attempting to make my first database using filemaker pro. Currently I am making a checking account database. One of the fields is a value list, and one of the options in this field is check. I would like to have another field (check number) pop up when I select check from the list. If anyone could help me with this, it would be extremely helpful.
-
- 1 reply
- 576 views
-
-
Is it possible to duplicate automatically the data from one field to another field in the same database. I want to type in the data in one field (which has automically entered data) and the data has to go automatically into another field (which has other auto-enter data).
-
- 3 replies
- 1.1k views
-
-
Hi, I have insert a pdf file as an object into a container. (E.g. Define field as container. In the container, right click and select Insert Object-> Browse-> Select a pdf file). A pdf file icon is displayed in the container. Then in the asp file, I tried retrieving the pdf file, but failed. In the browser, it displayed as a pdf file icon. May I know what syntax to use in order to retrieve the pdf file? I use response.binarywrite to retrieve the record, but cannot work(E.g. response.binarywrite Recordset1("PDF").value).
-
- 0 replies
- 697 views
-
-
One of my clients is running FM3 and FM3 Server (latest updates). We have opener files setup on all the client machines (all Macs) to automatically open all the necessary files from the server. Everything works fine until someone tries to use the opener file when the server is down. At that point, the opener script permanently loses the reference to the hosted file that it needs to open. Even after the server is back up again the opener script remains broken and must be re-edited to choose the file again. Has anyone found a way to make an opener script that won't self-destruct if the hosted file can't be found? Also, does this problem exist with FM5 and FM5 server?
-
- 2 replies
- 877 views
-
-
On my PC I have several DB's with the master one maximising the display on open. This I would like to retain throughout but my other DB's need to be opened and retain their size and state. however this doesn't happen. does anyone know how I can retain the window size and shape?
-
- 2 replies
- 600 views
-
-
I am new at Filemaker. I have FMP5 on a pc. When I enter a character for a pop-up list it goes to the correct character, but I figure when you pick the second character it should go to next second character match. It goes to another selection on the list with the first character match. Is this normal? Also when I select Print: Script definition for . . . all scripts -- it only prints the first script on the list. Help! Thanks [email protected]
-
- 1 reply
- 710 views
-
-
-
I have a cfml webform. When users check a checkbox it updates the file properly. If they return to edit the record and uncheck a checkbox, the update will not take....any other updating takes (text fields, dropdowns, etc). Any ideas? Unlimited 5.02 Thanks
-
- 4 replies
- 615 views
-
-
Hi Guys, Occasionally when I define a field I find it impossible to delete it afterwards, or to change its type (e.g. text to calculation). Is this a common problem & if so is there a work round? Cheers, Frazer
-
- 5 replies
- 1.2k views
-
-
I have a database that has fields that use the Text Index option, with the max set to 7 repetitons for each field. Example: Field 1 = class name (each repetiton has different data) Field 2 = time (each repetiton has different data) Field 3 = teacher (each repetiton has different data) Each record is by student name. I would create a layout that would make this easier to use. I would like to have one layout that I could show all the student in that class for that teacher. No matter how hard I try I can not get this to work
-
- 1 reply
- 621 views
-
-
Our setup: one database hosted on dedicated G4 runing FMPro Server 5, and seven workstation/clients (each with independent licenses of FM Pro 5). Every time we restart a workstation application the Page Setup defaults to 75% sizing. Each client can individually reset it to 100%, but once the application is "quit" and restarted, it reverts back to 75%. This is true of all the client workstations. Did not have this problem with older versions of FM Pro.
-
- 5 replies
- 769 views
-
-
When using Global fields in a Multi-shared DB over the network, are Global fields unique to each session (client) running?. The idea is as follows; I would like one DB to accept the users ID number and hold this in a Global field, that way everytime they do a new time/material entry the user ID gets automatically stamped with the ID they entered into the Global field. This saves them entry their ID for each new entry. Hope this makes sense. Thanks
-
- 2 replies
- 631 views
-
-
When I send emails, if the field containing the email address has a space at the beginning or end of the address it is ignored and not sent although the only way to discover this is to check sent items in my email package. Is it possible to prevent this from happening? I email a lot from the database and it is very inconvenient. Cheers Nick PS I am using Microsoft Outlook to send the mails
-
- 1 reply
- 847 views
-
-
I have 4 computers that need to access filemaker files over the internet through a proxy server. 3 of the computers are Windows 95 and 1 is W2K Pro. The proxy server is running Microsoft proxy 2.0. All 4 machines are set up the same. One of the W95 machines will not open a file. When I try to open the file, I click on Host, specify the IP number-- The squiggly line comes on for a second then goes away with no connection. What do I need to do to make the one work like the other 3? The version is Filemaker pro 5v3. Any help would be appreciated.
-
- 7 replies
- 661 views
-
-
I opened the program on the computer(server) which keeps the file, and then run it on another computer(client) thr' the LAN. The connection and computers should be good enough to run any program, but now the running speed is extremely low. Are there any way to make it faster thr' the LAN? Please Help!! -jimi
-
- 16 replies
- 961 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online