FileMaker General Discussions

Hi, I'm new to FM and am trying to crunch some numbers in a file which has over 460K records. (A Whopping 411MBs after a few relookup). I keep crashing the program when I try a summary field (named TOTALAMT) which adds all the number values in a field called AMT from each record. Is there any way to handle this much info at one go or would I need to break this into smalled files? Help please Thanks -J

• 6 replies
• 726 views

LiveOak

January 13, 200124 yr

Hello Everyone, I am just learning FM5, and am struggling with something that I thought would be a relatively straightforward procedure, namely converting FM5 files so that they can be read by FM4. Is there any way that this can be done? I thought it would be as simple as using the "Save As" command, but this doesn't seem to work. I desire to convert my work into FM4 files that can be read by the others in my group who are using this earlier version of the software. I realize that there potentially could be some loss of data in the conversion process, but our database is a pretty simple one so I am not worried about it much. Anyone care to give this extreme novice so…

• 2 replies
• 655 views

danjacoby

January 13, 200124 yr

I administer a FM Pro 5 database which contains, among other things, e-mail addresses for a group of contacts. I would like to be able to send e-mail to specific contacts using FM. My e-mail software is Groupwise 5.5- however I am having difficulty integrating the two pieces of software. Does anyone have any advice on how to make this happen? I can get as far as using the send mail script in FM, but nothing seems to happen except a "Print" job is generated. All help is appreciated! Sincerely, Andrew Murphy [email protected] ------------------ Andrew Murphy

• 1 reply
• 624 views

danjacoby

January 13, 200124 yr

Ok. I read your posts, and several others, regarding the limits on using scripts. While everyone agrees that the Go to layout script/button should work with instant publishing, I'm not able to get it to work when accessed from a browser. I have FileMaker Pro 5v Unlimited published database using the "wheat" option on a Beige G3 running OS 9.0.4 . (The button/script works without a hitch on the G3 server, just not when published and accessed from the browser.) All suggestions welcomed.... Thanks, jeff

• 0 replies
• 845 views

jjacques

January 13, 200124 yr

Hi, I connected filemaker 5 file on the web with a web style soft grey and it shows on top Home, Help link. How can i remove it or add more links there? Could anyone give me a hint to do that? Thanks

• 2 replies
• 664 views

tilmes

January 12, 200124 yr

anyone know about an admin/status window that tracks open databases/connected users for fmpro 5 unlimited? similar to what's built-in to fmpro server. we run 40+ fmpro 5 unlimited databases with web companion and need to tidy-up the desktop a bit. thanks.

• 3 replies
• 1.1k views

Kurt Knippel

January 12, 200124 yr

Would like to be able to tell who is adding records to a simple database. Is there any kind of script to poll the windows and auto enter a unique number/name from the particular machine or sign on info?? Thanks in advance.

• 1 reply
• 810 views

Kurt Knippel

January 12, 200124 yr

Have Filemaker 4 and have bound a solution for commerial sales. Am ready to release an updated version which will allow users to change layouts and define new fields. During binding, I am not checking "Permanently remove access to Define Fields, Define Relationships, Scriptmaker, and Access Privileges" yet they are not available on the outputed bound soultion. I have removed all passwords from the document preferences before binding. Any help would be appreciated. Thanks, Bob

• 2 replies
• 635 views

centelec

January 12, 200124 yr

I have looked in the FMP User Guide, help, FileMaker's web site, and this formum for information on how to show/hide a given field (radio button) and its label in a custom form contingent upon whether one of the buttons ("yes") has been checked. THe goal is not to encrypt information, but rather just to show the field in the custom form if and only if the "yes" button has been checked. Can someone please point me in the appropriate direction to accomplish this? Many thanks in advance!

• 7 replies
• 1.6k views

Barry F-H

January 11, 200124 yr

Has anyone encounterd a problem where The FMServer 3.0 won't start, and gives you an error message saying "returned error code 50." Do you know what this code means? And if you do, how can I fix it. Post here, or email me at [email protected]. By the way, I can't uninstall the server. I've tried reinstalling, and using the patches, but neither worked. This is in WinNT also. Thanks in advance. Luis

• 0 replies
• 631 views

KingLouie11

January 11, 200124 yr

Thank you very muh for the response but I'm still a little confused. To be more speific: I have a "JOBS DB" with a customer name field and a job status radio field with "open and closed" Now I have a DB named "BILL" I have a field to choose active customers with a pop up menu field. I need my field "job" to be a pop up menu to list only open jobs for the particular customer previously choosen in the customer field. Sorry, but I hope other people are learning something besides myself.

• 2 replies
• 692 views

dtrots

January 11, 200124 yr

I'm sending a company a copy of a FMP5 database I developed for them to consider purchasing. I want to limit them to only 25 records for this demo version. Any suggestions on how to put this limit into the file I'm sending to them? Thanks

• 3 replies
• 726 views

john.daly

January 10, 200124 yr

I want to make a contacts table with First Name, Last Name, Title. These fields are repetitive and my form should display a table showing all with a scroll bar beside it. Can anyone help me please? Jess. ps. I heard that related fields are not good. Why? Is there limitations? Alternatives?

• 6 replies
• 924 views

Jessica

January 10, 200124 yr

Does anyone know how to set up multiple validations for a single field? For instance, I have 3 fields that use the same value list. Once someone selects a name for Field1, I don't want them to select the same name for Field2 without a warning. I've tried using the "Validated by Calculation" function with the following formula: not Field1 AND not Field3 (this would be for Field2). This validation does not seem to work (ie the validation returns as okay when it should return a validation error). If I only use one field in the calculation (for example: not Field1), the validation works. However, this doesn't solve my problem. Any help would be greatly, greatly apprec…

• 1 reply
• 672 views

BobWeaver

January 10, 200124 yr

We created an importer database in filemaker 4 for PC, in the Dutch language using European number conventions. (4.000,00 = 4,000.00). When data is imported from a simple comma delimmited data file, the numbers read (for instance) 41,99 for 41.99. However, when the data was exported to another file and used in calculations, the comma was not treated as a decimal and the number became (in value) 4,199 (as opposed to $41.99). We then converted the files to my Mac, converting to US number conventions and the same thing is occuring. We played around with all the system formats, etc. Has anyone heard of such a problem and any suggestions on how to fix it??? Thanks

• 1 reply
• 689 views

BobWeaver

January 9, 200125 yr

I have a couple of databases running on FMP5 Unlimited, on Win NT4.0. FMP5 cache set to 9999. I have several scripts written in FMP5 to email lists of people that are triggered from web events. These scripts take several minutes to complete. While one of these scripts is running, access to the other databases is halted until the scripts complete. Also, if i do a time intensive search on one database, access to the others seems to be suspended until the long search completes. Shouldn't FMP5 be capable of more than one web operation at one time? This is why I bought the unlimited package.

• 1 reply
• 1k views

Anatoli

January 9, 200125 yr

I need some expert advice. I am using FMP to generate announcements for a class web page at a university. I have the professor use a web-based entry form for the records. For the body of the announcements, he needs to be able to use indentations and other formatting styles that he writes in a visual-based web design program. I want him to be able to just cut and paste the HTML straight into the announcement field. When he does it as is, it scraps all the code and treats it as text. Is there a plug-in to do this, or is it simply a matter of writing extra CDML into the page to recognize HTML. Any help would be greatly appreciated.

• 4 replies
• 1.1k views

Anatoli

January 9, 200125 yr

I am using File Maker Pro 5 to create a school e-mail service to inform teachers when they are to cover lessons. However when I import the information about the staff the data for one record is automatically divided into 2 different records, is it possible to combine 2 records, because if it isn't I will have to send each member of staff 2 e-mails, which is very unhelpful. So if it is at all possible could you inform me of any methods in which it is possible to combine 2 records into just one. Thank You Miss Betteridge [email protected]

• 3 replies
• 1.3k views

Barry F-H

January 9, 200125 yr

I need some HELP! We use FileMaker Pro 4 We have a classified database and I can't get the issue number to show as an active ad. Status: should be active If(CatFlag="S" or CatFlag="H","ACTIVE HEADING",If(WeekofYear(Today+5)-1 * Start Issue No. and WeekofYear(Today+4)-1 * End Issue No. or (End Issue No.<Start Issue No. and Start Issue No.+Run For>51),"ACTIVE",If(Classification Number="99","ACTIVE",If(WeekofYear(Today)=End Issue No. and PAY METHOD*"FREE","ACTIVE","INACTIVE")))) Start No.: should be 2 If((DayName(Date Entered)="Sunday" and Time Entered >61200), WeekofYear(Date Entered+5),WeekofYear(Date Entered+4)) End No.: should be 3 If(Run For="99" or…

• 1 reply
• 767 views

birdman

January 9, 200125 yr

Is FMP patched to 4.1v3? Is the TCP/IP networking on the computer configured correctly and working?

• 3 replies
• 743 views

Wain Allen, MD

January 9, 200125 yr

It's times like these, i feel inadaquate (like when i can't spell too . . .) Anyway, this seems like it would have to have a simple solution, but i just don't know it. I have to develop a inventory control that keeps track of different companies shells (printing term). It obviously needs to subtract and add from the number of Quantity on Hand each time some are removed or added. I was thinking initially 3 DB's. Main with all company info and Current QOH. Then a Removal DB and an Addition DB. IS THIS THE BEST WAY?:? and if it is, i have already tried it, but i can't figure a calculation or script that would correctly update the Current QOH?!?!?! Is it just me, or…

• 7 replies
• 989 views

LiveOak

January 9, 200125 yr

English Hi, all 1)I have my DB with a some repeting fields, my questions is. Can I paste the Current date, just with a click? or a tab? this is in a repeting date field 2)In the same DB I have a script to paste some information from 2 fields (pay, date) the script it's to paste this 2 filed in a last repeting field and when the repeting filed it's full send a message i.e.: SCRIPT Cut [select, "date"] Go to Layout ["Payments"] Set field ["Last(howpay)"] Paste [] Go to layout ["oroginal layout"] Cut [select, "date"] Go to Layout ["Payments"] Set field ["Last(howpay)"] Paste [] Go to layout ["Original Layout"] With this script doesn't work, you know…

• 3 replies
• 725 views

LiveOak

January 9, 200125 yr

I need to input chinese words into my FMP5 database. But the words inputed are not what i have typed!Why? And, how to solve this problem? Anyone know the solution, please feel free to reply me.

• 2 replies
• 646 views

meteor

January 9, 200125 yr

I run an automobile dealership here in Arizona and am looking for something that will allow me to keep track of the number of contacts, sales, write-ups, demos etc that my salespeople are taking. Is there any template or fully written program I can use with filemaker out there. I am attempting to do it myself but I don't have a lot of free time to devote nor do I have an in-depth knowledge of Filemaker Pro 5.0. Any and all help would be greatly appreciated... John R. Ellegard [email protected]

• 1 reply
• 1.5k views

LiveOak

January 9, 200125 yr

I have a customer DB I have a job DB which has a menu filed for customers. It also has a radio field for open or closed. I have a invoice DB which will have 2 fields to connect it with a customer and a job. After choosing the customer, I would like the job field to only show "open jobs" for the customer previously choosen. Any help is greatly appreciated. After seeing this, it should help me with a lot of future relationships. Thanks in advance

• 1 reply
• 629 views

BobWeaver

January 8, 200125 yr

I'm using FMPro 4.0 on both a Mac 9600 with 248mb ram and a G4 with 384mb ram, and on both systems, all FM dialog boxes display text that is small, jagged and compressed to the point that it is unreadable in most cases. It has done this from day one. Is there anything I can do to fix this problem? None of my other programs do this. Thanks, Michael McKenzie

• 1 reply
• 738 views

Vaughan

January 7, 200125 yr

When using the "Send Mail" script step, what happens to the "mail" that you want to send? How does FileMaker communicate with your email server. I am using FileMaker 4.1 on a Mac that is connected to Tufts University's network. I use Netscape for email. I have been told that FileMaker can't export email to Netscape so I downloaded Eudora and set that up. I am still baffled. I would like to be able to send a personalized email message to members of our mailing list. I can export a usable list of email addresses easily enough, but I was hoping to use the "Send Mail" feature to personalize them. Anybody know how to do this? Chuck put a useful link to an article he wrote--…

• 2 replies
• 737 views

Vaughan

January 7, 200125 yr

I am currently using FMP 3.0v4. I am trying to set up a report that will give me turnaround time of working days (mon-fri) on how long it takes to complete jobs. I've set up two fields and date in and a date out. Using these 2 fields I'd like to calculate the number of days. For example if a job comes in Thursday and out on Monday I'd like the result to be 3 days. Please let me know if there is a way of doing this. Thank you in advance

• 2 replies
• 1.3k views

Vaughan

January 7, 200125 yr

I have a Vendor database that I have set up radio buttons to show active or inactive. I have the hoices manually put in in the field format. I have a separate database for invoices. I have a menu field for the vendor name but I only want it to show active vendors from my vendor list. Sorry if this has already been asked or answered but I am stuck. Dave

• 2 replies
• 652 views

dtrots

January 7, 200125 yr

We are using Filemaker5 Unlimited currently as a web server along with Filemaker5 Pro Server as a site for our databases. Both computers are Macs. We are using Home Page 3.0 for Web interaction. How do we make our Web server site secure? This would be the first step to taking payments over the Web. I'm new at this, please help.

• 1 reply
• 1.3k views

Anatoli

January 6, 200125 yr

On the first of january 2002 a dozen countries or so in Europe will convert to a new currency, the Euro. Like every other currency this one has a special symbol (like $, or fl). It may seem aerlu to start this now, but in due time we'd like to show dutch guilders as well as euro's on our invoices.... So: can anyone tell me how to get this currency symbol in Filemaker? TIA ------------------ Yeti

• 3 replies
• 1k views

BobWeaver

January 6, 200125 yr

I am trying to find a way to get a summary of how many projects were done this year. The way my database is set up is that for each sku there is a separate record. However eash project has several sku's with the same project number. I want a summary that will count all records that have the same project number as 1. For example: Project # 463-01 has 4 sku's Project # 475-01 has 10 sku's Project # 480-01 has 2 sku's in total there is 16 records created what I am looking for is a summary that will let me know that 3 projects where done. Please let me know how to solve this problem. Thank you in advance.

• 1 reply
• 849 views

LiveOak

January 5, 200125 yr

I am wanting to use FileMaker Pro 5 as a front end for MSSQL Server 7.0 -- on a Mac. Is this possible? I was just on the FileMaker site and it appears that only Windows is able to access SQL Server. Any ideas/help would be awesome!

• 0 replies
• 928 views

ShaneBeeMe

January 5, 200125 yr

Does anybody have a solution for including formatted text in a calculated field that is used for the Email Body? I have a calculated field that emails users Username and Password back to them and I would like it to look like this: Save this information for future use- Username: Whatever Password: Password I type the calculated field this way but when the email is sent, no carriage returns are displayed and the text just shows up in one long sentence.

• 2 replies
• 736 views

SNS

January 5, 200125 yr

It might be the time of year (miracles and Santa Claus) but when I delete a record in a related file (invoices) the record also dissapears in the adressfile! I checked the relation and the box for whiping related records if the record is deleted in the active file, but it's unchecked. What's going on??? It's my last day at the office this year, so I wish you all a merry x-mas and a happy new year. Keep up the good work!!! ------------------ Yeti

• 2 replies
• 591 views

Yeti

January 5, 200125 yr

Sorry, but how can a cost be <25 and >50 at the same time? Give this a try. Case( Cost <= 25, Cost * 2, Cost <= 50, Cost + 30 Cost <= 100, Cost + 50 Cost <= 200, Cost + 75, 100) The last value is a default, if none of the tests succeed. The Case statement performs the tests in order, so an "and" criteria is not needed. -bd (engineering major)

• 2 replies
• 737 views

WBlanchard

January 5, 200125 yr

I have a solution that has a lot of value lists which have default values that are then added to by the user. I also have global field values and some global repetition fields (I know, I know, I shouldn't use them). How do I move all this 'stuff' to an upgraded solution without having the user involved? I'm running version 5 developer under Windows.

• 2 replies
• 668 views

LiveOak

January 5, 200125 yr

Capt Kurt: I want to transfer all of items in all of the value lists to the new solution, as well as other global values. Since the solution may exist on hundreds of PCs (or thousands if I'm lucky), it must be a totally automated process. I know I can get the value list items out using the design functions, but how do I put them into a new solution? What about other globals that need to be moved? Someone must have needed to do this before me!!!

• 0 replies
• 703 views

SteveB

January 5, 200125 yr

FileMaker Pro 3 We have G4s, G3s and IMacs, most using the 9.04 OS, and when we print the program crashes. This is only happening when we are trying to print. Any suggestions? Thanks Heather

• 2 replies
• 1.1k views

BobWeaver

January 5, 200125 yr

I am a systems manager new to a school and I am currently creating a database of student records as well as schedules of each class. The way my database is setup is one layout that would contain that student will all information classes, grades, first name, last name broken up into 12 quarters. Then separate layout for each quarter for grades classes, class location, teacher, and day, ECT. Example: Jim Smith Class name Time Day Teacher Grade Classroom Math 1 4-7 Tuesday Bill 10 201 Science 5-8 Wed Mary 10 202 History 7-10 Thursday Jake 10 219 The problem I am having is that the fields

• 1 reply
• 641 views

Kurt Knippel

January 4, 200125 yr

I have a large number of fonts on my system because I do a lot of graphics work. Whenever I start FMP5 it takes it forever to load because it scans through all my fonts. Is there any way to stop FMP5 from scanning all the fonts? Thanks in advance for any advice!

• 1 reply
• 664 views

Terrell

January 4, 200125 yr

Hi I know you shouldn't style individual text elements within a field but... I need a calculation to find italic/Bold text within a text field and replace with "tag & StyledText & tag" (any plug-ins out there). or if this is not possible, have a dictionary of words that should be replaced. If the former is not possible has anyone got any pointers for creating this! T

• 1 reply
• 774 views

Chuck

January 4, 200125 yr

Hi. When exporting the ''return'' key in a text calculation field and importing into Quark Xpress I actually get the ''enter'' key which forces a new text box in quark instead of just returning the line. I have tried using <n> an Xpress Tag that gives a soft return to bodge the job, but this isn't ideal. Grateful for any ideas. Cheers.

• 2 replies
• 723 views

andycarless

January 4, 200125 yr

Does anyone know how to configure DDE Share so that a Filemaker data copy will paste into Excel under NT? I've got a rough idea but working out the exact configuration is proving a pig.

• 0 replies
• 768 views

Wotan

January 4, 200125 yr

Hi this is what I am trying to achieve I have three number fields "begin" "end" and "interval" I want the values of begin and end to be based upon interval so the user sees this all in years... Begin End Interval 0 1 1 1 5 4 5 10 5 10 15 5 I know it can be easily done with a script but I want the user to see the values being entered automatically for begin and end any help is greatly appreciated!!! THANKS [This message has been edited by krusader (edited December 28, 2000).]

• 11 replies
• 1.1k views

krusader

January 4, 200125 yr

This would be done by creating a "compound key" upon which to base the relationship. For instance, in a timecard database is would be fairly inconvient to have a separate file for each employee's timecard records. With a simple key, each entry might be a date. With a compound key, each entry in the timecard file could be based upon an employee ID and a date. For instance: CmpdKey (calculation, text) = Right("0000" & EmpID, 4) & Date The perferred solutions is to use one file. For example, with four separate sections a report needing data from all four would be very difficult to create. -bd

• 1 reply
• 1.1k views

[email protected]

January 4, 200125 yr

quote: Originally posted by namadany1: I have a large database saved as an SDK (don't need the software to run it). Can this run on a PC as well as a Mac? I assume you mean that you created a runtime with the SDK. All executable files are OS specific, unless you are running some kind of emulation software. So you will need to use the Windows SDK in order to create a Windows runtime. However the actual Filemaker database files are cross platform. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Consultant Database Resources mailto:[email protected] http://www.database-resources.com =-=-=-=-=-=-=-=-=-=-=-=-=

• 1 reply
• 3.4k views

Guest

January 4, 200125 yr

I have a small network (up to 8 users) running an application in Filemaker v4.01 Would like to install the Server version to improve performance, but I can't find it anywhere! (I used to see it all over the web, but since version 5 came out, nobody carries v4 anymore. Puzzles me, as from what I understand, the 2 versions are not compatible to be networked, so there should still be a large demand for the older version) Any help is appreciated

• 1 reply
• 1k views

BobWeaver

January 4, 200125 yr

Hi All-- I am currently working on a database containing over 100 layouts. However, I will end up with over 200 layouts by the time the project is finished. I have these reports grouped under a heading like (QTR1 Reports, QTR2 Reports, QTR 3 Reports, Yearly Reports, etc.) The new upgraded version of FileMaker Pro only displays 1 column of layouts (instead of all layouts in multiple columns) with an down arrow so you can navigate to the other layouts, very slowly! This just makes creating other reports very time consuming. Is there a way to turn OFF this option so that all of the layouts are shown in multiple columns or is there a way to organized layouts in extended …

• 4 replies
• 818 views

Chuck

January 3, 200125 yr

Need help resolving this: I have a DB that allows clients to assign dates to records. When those dates have arrived FM does a search for records whose dates are valid and displays the items. It works like a To Do list. Problem is this: Clients need to be notified daily of birthdays. Birthdays are in the past. So a simple Status (Current Date) match does me no good, but I need to be able to find birthdays that are today and any days that have not yet been checked. (If my clients do not run Filemaker for a few days, they need to be notified of all birthdays that have happened since the last time they were notified.) Another trouble area for me is the fact that if they run …

• 1 reply
• 583 views

BobWeaver

January 3, 200125 yr

Is it possible to display related fields, under condition one of these fields matches a given condition (=, <, >, ...)? Actualy I have members of a company, that I'd like to display with the company informations but only if they are still in the company (0/1 field). However, I'd like to keep these records and the company they used to belong to even if they go away... Thanx for help and happy new year! Nico

• 2 replies
• 647 views

Ndesaint

January 3, 200125 yr

Hi All, Have a big problem with printing in Filemaker (version 4.0). I have a database designed for a company. The main purpose of the database is to generate reports. The reports tend to be big, like 200 plus pages. The printer (which is shared) is linked to one computer (windows 98)in the network (windows 95/98/NT network). If anyone sends the report to print through the network to the printer it prints about 30 pages and then just feeds the rest blank. They called me and I went in and did a workaround. I set up filemaker on the computer that had the printer. It still printed only 30 or so pages and fed the rest blank. I determined that maybe it was a memory problem …

• 3 replies
• 1.3k views

LiveOak

January 3, 200125 yr

I have created a FMP db for the web. I have got it hosted using Web Companion from my home using a cable modem. The 'problem/question' is this: It's sloooowww. It doesn't look anything like the actual file does on my desktop. What do I need to do to make it look and run like it does on my Mac&PC? Any help and suggestion will be greatly appreciated. It

• 0 replies
• 791 views

alkhall

January 3, 200125 yr

I have been supplied a Microsoft Access Database, and was wondering what would be the best way of importing it into Filemaker Pro. Could I use the ODBC driver for Access? I am on a Mac, and understand that Access is not available on Mac, but could I do the import from a PC?.....Or, should I export the data into an Excel spreadsheet, then import it into Filemaker. I have tried this method, but it didn't export all my records...only 65536 out of the 79000+ records. Is there a limit?

• 3 replies
• 1.5k views

kim

January 3, 200125 yr

I can't get auto-filled data to appear in a new record.htm so the user can see the info for those fields. After the record is submitted the info is there correctly but it doesn't show in the new record.htm. I've tried to use the cdml tag: [FMP-Field artNumber] in a textbox and not in a textbox as is used for the display. My guess is it's not accessing the dB in order to display this info only the field names. Thanks Wayne

• 0 replies
• 940 views

wayne

January 3, 200125 yr

I have a web page where I have automatic filled fields for a new record. Unfortunately I can not seem to get the auto-filled info to be displayed when adding the record. It appears the problem is that the dB is not being accessed BEFORE displaying the new_record.htm in order to display the auto filled areas. How do I get the web page to see the auto-filled areas so it can be seen by the user as the record is created. I have used the cdml tag: [FMP-Field artNumber] within a text box and without for testing. Neither pull the data from the dB. Thanks Wayne

• 0 replies
• 663 views

wayne

January 3, 200125 yr

I am having difficulty sending email using Outlook Express 5.02. I am using the following formula "mailto:" & STDBNHGVencon::email & "?subject=" & subjectforemail & "?body=" & emailmsg Copy The subject and body text both appear in the Subject field of the email msg. Any ideas? Thanks.

• 5 replies
• 908 views

Chuck

January 3, 200125 yr

Hi I need to return a date in a text calculation as 11-Mar-00 from an existing field example Name & " " & Date & " " & Cost "John 02-Jun-00 10.00" I'm currently using DD/MM/YYYY with "DateToText(DateFrom)" in the calculation but need it formatted with short month name for export! Can anyone help? Happy New Year T

• 4 replies
• 708 views

DykstrL

January 2, 200125 yr

For some reason, Filemaker Pro 5.0 v3 takes over 2 minutes to initialize when I first run it on my Win95 Pentium PC, 64M RAM. I've uninstalled and reinstalled it and still a problem. Resetting cache doesn't help. I also tried installing it as a test on a good Win 98 running laptop and it initialises fine there. MS Access also starts up just fine on both machines. FM used to be much quicker in the past on this machine. Anyone know what it's doing for so long behind the splash screen and Initializing.. message? Mike

• 0 replies
• 953 views

Mike Tomlinson

January 2, 200125 yr

Hey, I was wondering if anyone has run into this problem & if they were able to solve it? When printing a report with a field that is larger than one line & it is set to slide up & reduce the size of the enclosing part, there is a large blank area at the end of a sub-summary when near the bottom of the page, instead of continuing to print. While not the end of the world, I was hoping someone knew of a way to avoid having this blank space appear. Thanx in advance, I hope I'm being clear. [This message has been edited by PinnWal (edited January 02, 2001).]

• 0 replies
• 782 views

PinnWal

January 2, 200125 yr

Hi, I'm an FM newbie and have in mind the solution but no idea how to achieve.... I'll describe what I'm after and if you're of a mind please respond. Opologies if this is all too simple ...... File A : People file / FirstName, Surname, FullName, PersonDodID File B : Time sheet / EntryDate, EntryTime, PersonDocID The issue I have is that there are going to be many many people listed in file A and I would like an elegant method for selecting a person. I could use popup fields, but feel they are only good for 25 or less selections. In my mind I'd like a feature where users could enter the first few letters of the firstname or surname which would then restrict the p…

• 3 replies
• 558 views

aqualand

January 2, 200125 yr

I am unable to create ODBC DSN entry for a FM database. The FM drivers appear in the list; however, I am unable to create a System DSN or User DSN. I am able to create a File DSN; however, this setup is much slower than User DSN and even slower than System DSN. Has anyone else encountered this problem before? I get the following message, "The Setup routines for FileMaker Pro ODBC driver could not be loaded due to system error code 126." Then the next error displays, "Could not load the setup or translator library." Can anyone help me out? ------------------ Thanks, Kevin Yahoo! Messenger: prof_bunsen

• 5 replies
• 3.4k views

kwebb

January 2, 200125 yr

I am new to FMP and I am having problems with relations. I have four DBs. One contains information about user (Name, Address, etc). The second contains information about the vendor (Name address, etc.). The third contains information about sales using info from the other DBs. The fourth contains a list of Cities, States & Zips). I have ID numbers for each record in the City/St/Zip file as well as the User and Vendor files. The city/state/zip in the User file is displaying the City/St/Zip combo using a popup list and the relationship. Every time I change the spelling of the city/state/zip everything works great. Now when I create a record in the sales DB it bri…

• 0 replies
• 616 views

jstrack

January 2, 200125 yr

Hello all... This would be the final key to my scheduler file I am working on. I have fields named 'Start' and 'Ship'. I need a 3rd field (call it 'Dates') that will do a calc that I cannot figure out.... If I enter 1/1/2001 in 'Start' and 1/5/2001 in 'Ship', I need the 'Dates' field to look like this after the calc: 1/1/2001 1/2/2001 1/3/2001 1/4/2001 1/5/2001 I have written out the script, to figure it out logically, but I'm not sure how to translate it into a FileMaker calc... 'Ship' - 'Start' = 'x', 'Ship' (new line), 'Ship' + 1 ('x' number of times) (new line). Am I think of this correctly...? Basically, I need to have the 'Start' and 'Ship' - and all d…

• 4 replies
• 706 views

Jerremy

January 2, 200125 yr

I don't know what I'm doing wrong and I've tried following the manual but that was hopeless. With sentences like -"The master file for one relationship can be a related file for another, and a related file of one relationship can be a master file for another." I don't know how anyone can get any useful info from the manual? Here's what I did: I created two separate files (TEST 1 and TEST2), each file contained a Field Labeled TEXT and the field type therefore was text. Then I created another FIELD, in both files, labeled NUMBER and this field type was numerical. Now both of the files had different names (TEST 1 & TEST 2)and both live in the same folder on my h…

• 0 replies
• 577 views

Dieter

January 2, 200125 yr

Okay, I've played with FileMaker 5 and have been impressed. I'd like to publish a few databases on the web but I'm finding the "Instant Web Publishing" limitations unacceptable. I've worked with GoLive 4 and found it a useful tool. With GoLive 5 now available, it provides some useful upgrades. I've got a Beige G3 300Mhz machine with a static IP hooked to the University backbone. I'd like to combine these resources.... Is someone using GoLive5 with FM Pro Unlimited on a Mac? Is it reasonable to combine these tools to create educational college level courseware for survey research classes? Can you recommend some useful resources that will enable efficient integration…

• 2 replies
• 1.3k views

Anatoli

January 2, 200125 yr

I have a scrolling text field which is physically located on Layout Pg 1. The text field is rather long (about 2 full pages). When I print Layout Pg 1, the scrolling text truncates at the lower limit of the physical page. Anyone know how to get the scrolling text field to print out in its entirety when Layout Pg 1 is printed? Thank you. Respectfully, Eun Mi

• 1 reply
• 891 views

Kurt Knippel

December 31, 200025 yr

I am using fm 5 and have created an invoicing app. I have inv_hdr and inv_items tables related by invoice number. In my customer table, each customer has a discount level of 1-10. My products each have a price for each of these values 1-10. So if a customer who has discount level 3 is created an invoice for product "abc" the invoice lineitem would retrieve the price that is in retail3 from the products table and place it on the invoice line item. This all works well on the second and greater line items of the invoice, but not on the first line item. I have a relatively simple line item layout of "Qty, prodid, length, description, price, extended". I can fill in the…

• 0 replies
• 705 views

George

December 31, 200025 yr

I want to write a script to allow a field containing HTML code to be sent as an email that will show up as a web page (not the HTML code itself.) Can this be done with the built-in mail function and Eudora?

• 2 replies
• 1.2k views

Jake Sterling

December 30, 200025 yr

I use summaries to print checks. Thanks to Bob Weaver, I can now number the checks sequentially. My problem is I need to put a checkmark beside each check number when I reconcile, and of course you can't enter a checkmark when in Preview. I don't want to export to Excel. Anyone have any ideas?

• 7 replies
• 807 views

LiveOak

December 30, 200025 yr

Hey, thanks in advance for any help... I'm developing a replacement for a contact/mailing list.... Currently, there is one list with about 2000 users, and a whole bunch of other specialized ones. The difficulty is that many desired finds are composed of records from multiple lists. Thus, I am combining all lists into one master database. Simple enough... The difficulty is that the original list of 2000 is very important data, and should only be modified by one person, whereas I want people to be able to add/modify other records. Question: What are some ways that I could go about having one main database, but making certain records (say, primary key # < 10000) un…

• 3 replies
• 680 views

Flail

December 29, 200025 yr

New to FM, and I'm creating a database (for class) with the need to add a button feature to play (or bring up ) a QT movie. I can't figure out how?

• 0 replies
• 624 views

washbn

December 29, 200025 yr

Hello all. I hope someone has an idea for me: We have a Job Info file that contains project Job Number, Start date, Ship date, estimated hours, etc. We also have a Calendar file that, when using portals and relationships, we had it pull the Ship Date for each job and place it on the correct day. (Our calendar is set up as 1 record contains 1 week)... Also in the job file, using a FileMaker Tech Info article, we are able to calculate how many business production days we have (No Saturdays or Sundays) between the Start Date and the Ship Date. Using that number (say 10), we divide that by the estimated hours (say 400) to get hours needed per day to complete the project. …

• 1 reply
• 572 views

Jerremy

December 29, 200025 yr

I have a portal from a media library database. The media library has a field that notes which project each tape in the library belings to. There is also a project database, in which there is a portal that lists all of the tapes from the media library that are for each particular project and is related by the library's project number field and the project detail's current project number. This works fine for tapes that have only one project number in the project field, but for tapes with, for example, "1001, 1002" in the project field, the tape will not be displayed in those project's portals. Is there a way to get them to be listed, possibly by looking for a partial s…

• 1 reply
• 764 views

Kurt Knippel

December 29, 200025 yr

I am new to Filemaker. I have the job of changing an existing file that has a repeating field in it (6 repeating unique payments). Which I have to show calculations for commissions with things like (Should Be Sold Price : / Total Lot Price * $ Value Shipped) for several sales people in a repeating fashion. I currently only seem to get 00.00 on entering new payments! I tried get repeatition but this only seems to work for one. How do you set up repeating calculations....perplexed!

• 8 replies
• 976 views

LiveOak

December 29, 200025 yr

I would like to see if I could create a field that will give me a running count of record used in a cretin field. Example: I have a value list with "boy", "cat", "dog" in it. I would like this NEW field to contain a running total of all the records that are using "boy", totaling with a Number. So if "boy" were used in 6 of my records this field would contain the number 6. Can this be done? Thanks, RET

• 1 reply
• 721 views

PinnWal

December 29, 200025 yr

Problem is this - I have created a cheap "installer" using Aladdin's Stuffit. I create a self-extracting archive and it extracts the files of my runtime solution on the desktop of the windows user. I have it place a shortcut on the desktop so the application can be easily opened. When users start the program using the shortcut, they are notified as each file opens that the files are write-protected and cannot be modified. If they open the files directly by clicking the application icon, the files open and can be modified. -No problems- Any ideas?

• 0 replies
• 1.5k views

jwallace

December 29, 200025 yr

I really do need help with my problem. I have created a collection program using 3 files: "CASES", "NAMES" and "PAYMENTS". In CASES I maintain the general information on my clients (the following are self explanatory field names), eg fileno, casename, originalamountowed, dateofclaim, balanceowed. In the PAYMENTS the fields are fileno, casename, transactiontype, dateoftransaction, transactionamount, balanceowed. The CASES file will only have one of each fileno. The PAYMENTS file may have many payments relating to each fileno. My problem is creating a formula that uses the originalamountowed from CASES, and the fields from PAYMENTS to record payments in PAYMENTS so th…

• 0 replies
• 663 views

TonyParris

December 28, 200025 yr

Is it compatible with Windows 2000 professional. Can I go from 3.06 to version 5 as an upgrade or do I have to upgrade to version 4 first. Need help.

• 1 reply
• 738 views

Kurt Knippel

December 27, 200025 yr

I'm creating a database for a group that has ever changing reporting requirements based on the values of a few different fields. I want the default requirements to be set as a new record is created, but then the user should have the option to change those requirements. My current plan is to use a categories and an items database in the following way: 1 -- Include in the Categories database one field for each possible requirement. Each category will have a binary value for each requirement, designating whether the requirement is a default for that category. 2 -- In the item database, various information will be entered, followed by a "Choose Category" value list and a…

• 7 replies
• 5k views

aricm

December 23, 200025 yr

I have a service call database. I need to assign a unique number for each call. The first part of the number is the date. The second part of the number is to be the number of calls taken that day up to that point. So, the first call on January 4th 2001 will be #010104-001. The fifth call on that day will be #010104-005. The second call on January 5th 2001 will be #010105-002. Any clues on how to generate that 001, 002, 003 sequence and then restarting the next day automatically. Thanks.

• 3 replies
• 627 views

Chuck

December 23, 200025 yr

The straight forward (and clean) solution is to put all four price lists in the same file and use the index to select one. Another option is to use four layouts, one with a portal to each of the four files. Enter the price list selection into a field (could be a global) and test the field to select a layout to jump to. -bd [This message has been edited by LiveOak (edited December 22, 2000).]

• 1 reply
• 830 views

rior

December 23, 200025 yr

I would like to know if you can use seperate records that are indexed records? I have 7 indexed records in one form that i would like to seperate in different froms, reports. Can this be done? RET

• 1 reply
• 628 views

LiveOak

December 23, 200025 yr

Hello, I'm evaluating FMP because I'm setting a database shared through an intranet, with a few data and low access requests (a priori). FMP seemmed to be a good solution, but I have some questions that I couldn't find the answer, on this forum, neither on the fmp web pages. - Am I constrained to have one web page per data file or could I built many of them? - If yes, isn't it sometimes easyer to write scripts intead of using the fmp interface? - There are layouts, but what if I want a page holding requests on nearly all of my datas? And what if I want to show informations only if a related field has a correct value? - How are the read and write access handled? …

• 8 replies
• 833 views

Kurt Knippel

December 22, 200025 yr

Any one who will listen, I know every one hates repeating fields here but I was thinking... If I use a main file with a standard field containg "x". And I have a releated file with repeating field containg 2 records with values "x,y" for rec 1 and and "y,x" for rec 2. Both records are accessable via the relationship. Doesn't that make a strong case for repeating fields? G

• 7 replies
• 898 views

spragueg

December 22, 200025 yr

Does anyone know if there is a way to get FileMaker to interface with Quickmail. I have read that it only works with Claris email programs. I was hoping there might be a third party plugin.

• 2 replies
• 795 views

Chuck

December 22, 200025 yr

Hi-- I am using a modified version of the solution for Security Access at the FSA site: http://www.filemaker.com/fsamembers/downloads_fsa/files/Security_Article.sit.hqx (basically, limiting certain records so that they can only be viewed by the user who created them or the Admin for the file). This solution works fine, however, I can

• 0 replies
• 736 views

rlinsurf

December 22, 200025 yr

I'm trying to import a scheduling database created by a third party into FMP so I can show on the web and have it be interactive. The problem: how to import this data that has been created in this form: Date Bball Wrestling Squash 11/01 H@COR COL@B PR@PE COL@B H@COR D@Y 11/03 D@B COL@PR H@Y I want it to end up in FMP with following fields: Date Sport Matchup How can I do this w/o spending much time preparing my excel database? If it took too long, I'd just retype all by hand, and insist that the schedulers from this point on use my FMP web site to enter. Thanks Bevin

• 4 replies
• 1.3k views

BobWeaver

December 22, 200025 yr

Does anyone know how to activate a script based on a particular popup menu choice? For example, if there are three choices under a popup menu, A, B, and C, choosing A would run script A, choosing B would run script B, and so on. Thank you! Jeffrey

• 2 replies
• 796 views

rlinsurf

December 22, 200025 yr

I have a company file and a related contacts file. I am keeping track of the contact phone numbers in a repeating field. I know, I know, don't use repeating fields. But, over in Company I can see all of the contacts for the company in a portal. As I enter or highlight a contact in the portal, how can I show the phone numbers for the contact? I thought if I just put them on the layout they would show up. However, only the phone numbers for the first record in the portal show no matter which contact I am working on in the portal. Thanks.

• 0 replies
• 683 views

jpkrey

December 22, 200025 yr

Is there a script that when user name and password are entered correctly within database "A", it will then open database "B" that corresponds with the individual who has been assigned to that database. Database "A", would be used to authenticate access - It would contain 3 fields username/password/and database Any help would be appreciated!

• 6 replies
• 896 views

yafreax

December 22, 200025 yr

In FM 5.0, is there still a limitation on text-based relational keys of no more than 20 characters? One of my relationships is creating odd results that could be explained by this limitation. Can anyone confirm this, and possibly provide a workaround? I have some fairly long compound keys that I'd like to use.

• 2 replies
• 807 views

Chuck

December 22, 200025 yr

Hi I want to setup a timer for a quiz type of program I am developing the timer would count down to a certain number and then would automatically take the user to the next layout how can I make a timer like that???... THANKS

• 3 replies
• 718 views

Chuck

December 22, 200025 yr

I am trying to create a formula to calculate square footage. I have a field to enter the area and a field to identify the local measure via radio button selections: "sq feet", "sq meters", "sq tsubo". If sq feet is selected = 1 x area; if sq meters = 3.3 x area; if tsubo selected = 35.5 x area. Thanks

• 3 replies
• 703 views

aricm

December 22, 200025 yr

Hello, I have a web page that makes a find request to a articles DB using a single text field, the value of this field is used to find the articles in the database. I thought that if I captured this value I could then do a calculation field that could give me the number of occurrences of the search term, this could be done with a PatternCount function, and this way I could sort the found articles by their relevance. How can I do this? I have not found a function to catch the current search word. I thought there was a CurrentParthArgs or something with web companion but I can't seem to find it. If you do a Find at the FileMaker web site it brings results with a "Relevance …

• 0 replies
• 723 views

Daniel_T

December 21, 200025 yr

Hi, Just some questions about filemaker. I come from using Access2000. Recently, a friend told me about filemaker and after visiting filemaker website, I am quite impressed by it. However, I like to know its limitations before buying it. This is what I found out. Access uses 1 database file with tables, relationship, VBscript etc in it. FileMaker uses many files as tables. So how does it do the relationship? This the script as good as Visual Basic? When hosting a website in a NT with Access support, I can use ASP to connect to the database since the webhosting also has the driver. Can filemaker database be connected through ASP? What if the hosting company does not hav…

• 5 replies
• 913 views

Mike Precious

December 21, 200025 yr

I am trying to delete a container field; however, it is not doing anything. I have already removed the field from the layout and when I try to delete the Container field from the list of defined fields, nothing happens. I don't get a confirmation, warning, can't perform operation, you don't have rights...NOTHING. I am not sure in this DB was created in FM 5.0 on a PC, and I am currently working in FM 5.0 Unlimited on a NT Server. Can anyone help? ------------------ Thanks, Kevin Yahoo! Messenger: prof_bunsen

• 1 reply
• 815 views

kwebb

December 21, 200025 yr

I got this .fp5 file and when I run it I don't see any duplicate record in the form view or table view, but when I export the data using file-> export I see duplicate records in the text file... Please help !! Thank you, SB

• 2 replies
• 627 views

sb1010

December 21, 200025 yr

I need to know how to perform an "if" function within a relationship/portal. For example, File A is related to File B using 2 relationships. One relationship is based on a number, the other relationship is based on a profile. It is possible (and probable) that a record in File A will be related to a record in File B using both the number relationship and the profile relationship. I need to run 2 different reports - one based on the number and one based on the profile. The problem is, if the record in File A is related through the number relationship, I don't want it to also appear in the Profile relationship. I can't simply omit the record because this same record m…

• 4 replies
• 679 views

slbr549

December 21, 200025 yr

I have two db's, one for construction sites, one for all of the separate jobs we do at each site. There is a portal in Sites that shows the jobs. I have script in Jobs that sets a global field with the Site number and then runs an external script in Sites that finishes the job by entering find mode, setting the Site number field to the freshly populated global field back in jobs and then performs the the find. It works. So all is well. But, when I try and go back the other way, it stalls. I have a button in the portal, so when I click the button, it sets a global field in Sites to be the job number of the portal row. Then it runs an external script in jobs that en…

• 3 replies
• 631 views

jpkrey

December 21, 200025 yr