partsgb.martinw

Agreed, However if this is a file that is updated every week from a SQL server, it's a lot of work to keep "saving As". The rebuilt of the child table was also taking out fields that i really didn't need which is encluded in my filemaker templete that i have created. However another note is that an un-control shut ( PC Crashes) down can cause file damage and although filemaker has the recovery mode.In my case i felt the recovery did't fix everything and the best thing to do was start again. Take Note >>> MAKE BACKUPS Regards, Martin

Hello All, Many i say thankyou for the April 1st joke. Good one and i will always remember this....

Hello Again, Many Thanks to everyone on this issue, To solve this problem i re-built the child table and at this stage everything is working fine. A 56 meg file was re-built down to 21 meg. ( Think i did a good job ) Once again many thanks, Martin Williams

Hello All, New version of filemaker 6.0 is being release on April 12th. I have seem previews and it will be worth upgrading from 5.5 Does any have any information about the server 6.0 and what filemaker has for it's developers in the new server version. Regards, Martin Williams

Hello Again, I have tried un-installing and re-installing filemaker but still getting the same problem. Could it have something to do with the amount of data that i am bring in on that layout. Their is a portal that some of the data is being brought in on. :? Regards, Martin

This File is becoming a real problem for me. Filemaker seems to be crashing with this error (fmeng10.dll) it happens when i go into one of my layouts that is pulling in a lot of data from my child database file. All fields that it is pulling in a indexed and is holding 102356 records. Master file is still very small at this stage. The problem is once this error accours, opening the file sometime damages the child database which means i then will need to do a recovery on the file. Could anyone help me on this issue. My solutions goes live on 02/04/02.......... Many Thanks, Martin Williams

quote: Originally posted by AndriesV: I hope someone on the Forum has some experience with the DDE Execute scriptstep. I am trying to get Filemaker to 'make a phonecall' through 'Call Centre Assistant' which is an Ericsson application running on all FileMaker clients - - - - - - The following information comes with the Ericsson documentation: Command: MakeCall (Other applications can issue a MakeCall command toward CCA to initiate a call on the telephone. Note that no error checking is provided, i.e., it is assumed that the device is in a state where a call can be initiated.) Server Name CCA20 Command : MakeCall Command Type: DDE Execute Return Type : True/False Topic : CallControl Parameter : The number to be called. Example : MakeCall 17145551234 Description : Place a call on behalf of the currently monitored device. - - - - - - I tried to enter the right options into the DDE scrip parameter fields but can't get it to work. The advise for a 'pause' step from the FileMaker help file didn't help as well. We are working with Filemaker 4.1 on Windows NT Any suggestions are welcome. Andries Hi Andries, OK first of all are you using MD110 or MD 9. Open up the DDE Execute window. In the Service Name Type "DM" In the Topic Fields (text) Type "CallControl" Commands Field > this could be a field or text either way is must start with "MakeCall" and telephone number.. Hope this helps > any problems then let me know and i will send example file to you.. Regards, Martin ( Volvo )

quote: Originally posted by GregFM: Is there a way to close a multifile FMP solution if it has not been in use a specified number of minutes? Is there a way to take a user to the log-in layout of a multifile FMP solution if it has not been in use a specified number of minutes? [ June 02, 2001: Message edited by: GregFM ] Hi Greg, The new version of filemaker 5.5 can handle this kind of thing. Also i am using filemaker Server to disconnect my users after 1.5 hours if there has been no movement. Hope this helps Regards, Martin

quote: Originally posted by LiveOak: Go to layout mode. Draw a square, select a red fill, select a red line for outline. Copy the square to the the clipboard. Go to browse mode, click in the container field, paste from the clipboard. -bd Hello All, Here is the update on my solution OK, No Global fields, No Container fields required. Following case statement. Case(Follow Date <= Status( CurrentDate),Follow Date,DateToText("")) Calculation result would be whatever the field was. It this case the calculation result was date. Change text colour to RED. What i have in my solution is when the follow-up data has lapsed the whole monitor line changes colour. >>> GREAT <<<< Works well. The next step in this solution would be placing a time event in. I am also think about when user puts a follow-up data in it must be greater than the current time. (ie) Current date > current time... ( Something like that ) Thanks to everyone who took part in this issue. One more question. As i has delvelope 65 database systems now, Can i now upgrade my membership from Junior Member to Member. < gg > or at least go up one level. Regards, Martin (ps) Could i also say a big thankyou to the iTeam in Greensboro,( USA ) for there help.... [This message has been edited by partsgb.martinw (edited February 23, 2001).]

quote: Originally posted by LiveOak: Two cases. Changing the color (er, colour) of text involves stacking calculated fields, one for each text color (defined as transparent) and having only one at a time display. Background colors are changed by having a calculated container field pick the color displayed in a container placed in the background. Let us know what you want the Case() statemen to do. -bd Hello Again, Thankyou for the reply. I have worked out the case statement and global container fields. I an having a problem placing onto my monitor screen and the text turn a different colour. I know that the calculation field has to be over laping the follow-up date, but its not working yet. Here is my calculations.......... Follow Date > Date Field _gStatus Colour > Global, Repeating, Container _cStatus Display > Unstored, = Case(Follow Date <= Status(CurrentDate),"") _cDisplay > Unstored, = Case(_cStatus Display = 1, GetRepetition(_gStatus Colour,1),"") Hope the above helps what i am trying to do. If my calculations are wrong or i should be doing this another way, Please let me know... Many Thanks, Martin

Hello All, I have a monitor screen whereby all user can see outstanding cases. Within the monitor screen there is a follow-up. What i would like to do is when the follow-up has lapsed this date changes colour. I'm sure that i would have to use a case statement but not sure how i would write it. Please Help....... Regards, Martin

quote: Originally posted by cfoster: We'd like to send broadcast faxes from our database using WinFax, and I've come across three products to help us accomplish this: - Fax9Connect plug-in from e4marketing - WinFax plug-in from Soft Communications - Fax Tool from Data Designs Has anyone had experience with any of these three, or perhaps another option? I'd appreciate any recommendations. I have been using a package from Red Rock. It's called FAXNOW !. You can also use there plugin for filemaker as well. We send about 50 faxes a day using this software. Here is their web site address:- www.redrocksoftware.com Regards, Martin

quote: Originally posted by SNS: 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. Hello, In your Calculation field use the following "

quote: Originally posted by captkurt: Try this version. Basically you need to tell the function that 00 is 2000. TextToDate ( Right (tempDate, 2) & "/" & Middle (tempDate, 4, 2) & "/" & If ( Left (tempDate, 2) = "00", "2000", Left (tempDate, 2) ) Hi Kurt, That would work fine, however when this download is done in Jan 2001 there will be back orders for both the year 2000 and 2001. Can you think of anything else. I will look at this solution again today to see if i can somehow get around this.... Thanks for your continue support on this issue.. Regards, Martin

quote: Originally posted by captkurt: Import the "date" into a text field and use a replace calculation on the actual date field as follows: TextToDate ( Right (tempDate, 2) & "/" & Middle (tempDate, 4, 2) & "/" & Left (tempDate, 2) ) Hi Kurt, Works fine, however for some reason when converting it seems to pick up that the date was in the year 1900 instead of the year 2000. ( e.g ) 00-07-11 coverts to 11/07/1900. Is there anything i can add to your script ?? ?? ?? Regards, Martin