Why Why why ??


    Sponsored Links


  • 1. Restoring edit/delete privileges to Web Companion users
    Awhile ago, I vaguely recall disabling edit/add/delete privileges for the data bases I have shared using FMP Web Companion (6.0v4 Unlimited with Mac OS 10.2.8). Now I want to restore those privileges, but I can't figure out how. I have spent inordinate amount of time poking around in the dialogs and help files, but haven't made any progress. What am I missing? BTW, I find FMP's Access Privileges dialogs to be very confusing, in general. Especially, the Access Privileges Overview. What use is that dialog?
  • 2. Help needed with calculations using Stones and Pounds
    Hi, Have just started using Fm and run a small diet and fitness club! We have set up a database with members name and addresses and would like to see the total weight loss to date in stones and pounds.We have weight at joining the club and then a current weight section and then hopefully a small calculation would determine weight loss to date!Apologies if this is well documented but please may we ask for a little guidance in this matter. Thankyou for time in this matter, Caroline
  • 3. Sub-Summary Question in Report?
    Hi: I created one report which has four parts Header Sub-sumary by Name "{in the part definition dialog}" Body Footer. names show in "browse" mode, but they did not show upin the "preview" mode. I wonder whether I miss any configuration or there is any special requirement for the field sorted by. Thanks a lot. Tony
  • 4. text format during copy/paste
    I have 2 text fields "fielda" and "fieldb". I enter text into fielda, then copy/paste it into fieldb (currently using ctrl-c / ctrl-v). Fielda's font size is 14. Fieldb's font size is 10. I want to force the pasted text to fieldb's size (10). I can do it by using the commands: [edit - paste special - unformatted text - OK], but is there a quicker or automated way to do this? TIA, Rick

Why Why why ??

Postby JF » Tue, 03 Apr 2007 01:17:11 GMT

Hi me again, yes i'm working this sunday and that's why I have many 
questions today....

I have a calculation field that result a "text" and it's display in a layout 
as a merge field.... the result is a calculation with expiration date base 
on a field (contrat start) and another one that ask user to enter duration 
(1 year, 2 years .....) and the result is the expiration date....

My problem is that the merge text doesn't refresh and display the instant 
result. I use those seting on the field, Its not storing the value, and I 
uncheck "do not evaluate...."

So when I change the duration field, the text will not change right now on 
screen... commit record, enter, clicking anywhere on screen doesn't change a 
thing, switching from browse to layout to browse, bring the right result on 

What iM doing wrong, or it's just FM8.5.... I remember with FM6 never had 
this behavior.

Thank you


Re: Why Why why ??

Postby JF » Tue, 03 Apr 2007 05:29:14 GMT

Yes that's what I said in my mail..... does'nt change a thing !



Re: Why Why why ??

Postby Howard Schlossberg » Tue, 03 Apr 2007 05:58:10 GMT

Would you share with us exactly what your calc says?  Is it that the 
calc field itself is not updating or that the screen is not refreshing 
to show that changed calc?

Howard Schlossberg              (818) 883-2846
FM Professional Solutions, Inc.    Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Re: Why Why why ??

Postby JF » Tue, 03 Apr 2007 07:25:59 GMT

I don't know if the formula gets update and/or it's juste the screen refresh 

OK this is a simplefy form of my calc. formula

cPPM_Expiration is a Custom Fonction
 Date ( Month ( Min ( Entretien_Mois_Visite::EM_Mois_Visite ) ); 1;Year ( 
Min ( Entretien_Mois_Visite::EM_Mois_Visite ))+LeftWords ( 
Entretien_Data::ED_Dur_Contrat; 1 ))

Basicelly this take the earlyest date entry in a relationship and transform 
it into a date format and adding up the amount of year(s) in the field 
Entretien_Data::ED_Dur_Contrat [ value list of : 1 year, 2 years, 3 

The formula is:
"Contract will expire on "    & Monthname ( cPPM_Expiration )& " " & Day 
(cPPM_Expiration) & " " & Year ( cPPM_Expiration )

Is that possible the custom fonction make the formula not update ??


"Howard Schlossberg" < XXXX@XXXXX.COM > a rit dans le 

Re: Why Why why ??

Postby Ursus » Tue, 03 Apr 2007 07:53:07 GMT

"JF" < XXXX@XXXXX.COM > schreef in bericht 

I see the fault, you are trying to add a number to some text.

The number part is:
Date ( Month ( Min ( Entretien_Mois_Visite::EM_Mois_Visite ) ); 1;Year (

But LeftWords is a textfunction.

You have to make a number of this part first.

GetAsNumber ( LeftWords ( Entretien_Data::ED_Dur_Contrat; 1 ))

That should do the trick

Keep well, Ursus

Re: Why Why why ??

Postby JF » Tue, 03 Apr 2007 10:29:54 GMT

Thanks but the calculation was working anyway.... I was searching for that 
fonction (in FM6 it had another name ?!?!) but the result was good, it's 
only the redraw of the awnser that was not working....... If I change record 
and come back.... voila! it change...... the funny thing my calculation is 
longer then what I told you, I take information if there's a check box check 
and change the text base on this 1st validation..... as soon as I check the 
box, the result change automaticaly... but not when it need to do some 
calculation using the custom fonction ?!?!

It's not working as a standard field and a text merge field.....


461037cb$0$79450$ XXXX@XXXXX.COM ...

Re: Why Why why ??

Postby JF » Tue, 03 Apr 2007 10:52:19 GMT

I have found the problem...... it's the CustomFonction !!

I have replace in my calculation field the custom fonction by its equivalent 
data and now the result is instant !! the text change the second I change 
the the duration field......
haaaa let me see if FM8.5v2 fix that problem ??? I did'nt install it at home 


D0ZPh.26687$ XXXX@XXXXX.COM ...

Similar Threads:


FMP 10a WinXP

I wonder why it should be the case that a button on a layout connected to a 
table with no records will not work. (the connected command being go to 

Keep well / Hou je goed


2.Filemaker is really really slow starting - why?

I recently moved a computer from one part of my network to another.  In the
process it was necessary to uninstall Filemaker Pro and re-install another
copy on the computer.  I am using Filemaker Pro 4.1 on a Windows 98(se)
350MHz Pentium based computer. After the reinstall, Filemaker Pro now takes
almost 5 minutes to just start the Filemaker program.  The computer is on a
network, but Filemaker is not being used in a network mode. The only other
program on this computer that wasn't there before is Norton Anti-Virus 2003.

After it has once been started, it only takes 2 minutes to start up!(still
unacceptably slow).  I know this is an older version, but for the time being
I have to use this one.  It used to be faster on the same machine.

Does anyone have any ideas as to what I might do to troubleshoot the slow

Thanks for any info

3.[Ann] See why FXForge is the easiest way from FileMaker to the web

4.Why does database not open to the last record visited


I using FMP8 on a Mac G4 with System 10.4.11.

I recently migrated to 8 and it seems to me that in prior versions,
when you closed a database and reopened it, it would open to the last
record you were on when you closed it.

8 doesn seem to do that.  It seems to sometimes open to the last
record visited but other times it seems to open to an earlier search.
I really studied this but I can figure out why.

It would seem to me that nothing should change when you close a
database and reopen it.  I don have any scripts set up to run upon
closing or opening of the database.

But 80% of the time, it doesn open to the last record I was on, and
when it does, I have no idea why.  Ie tried everything I can think
of.  Does anyone know the answer to his, or have a solution?



5.Why am I Having Problems ?

On 8/2/03 1:08 PM, in article 6TUWa.216121$ XXXX@XXXXX.COM ,

> Hi,
> I am having problems defining relationships between two file.   I have e
> defined the relationship and I have defined the field with the relationship
> Name and the incoming relationship field, and still nothing.   What else is
> there that I should be doing that I am NOT doing.
A Relationship requires matching data on both sides to work.
File1 with Field1, defined as text with the value of "Smith"
File2 with Field2, defined as text with the value of "Smith"

If the relationship is set up in File1 using Field1::Field2 and the value is
the same on both sides of the relationship matching data from File2 can be
pulled across into File1 using the relationship.

Now a field can be placed on the layout (in layout mode) in File1 to display
other related data from that record in File2. There is a pulldown menu at
the top of the box that appears after a field is placed onto the layout.
Change the pulldown to reflect the relationship and then choose the desired
related field.

Maybe if you could better explain what you are trying to accomplish the
group could provided a detailed explanation.

6. portal row not blank;why is this happening?

7. why does this calculation not work?!??!

8. Why is my inline not updating a record?

Return to filemaker


Who is online

Users browsing this forum: No registered users and 4 guest