Anh_Tran

Hi All, I got 3 fields which are Name and Money and dates Name and Money and date Joo 22 $ 2004-01-01 Kii 0 $ 2004-01-20 I try to use find and in my find i use date range from 2004-01-01 to 2004-02-01 , it finds all names such as Joo and Kii . But the point is I want to find only people more than 0$ but same range date. The result I want is showing only Joo. Anybody has an idea? Thanks

Hi Geek, I am using version 6. The local file does not has password , i use only password to open external file , i am not using username. I still do not understand clear how to solve it Thanks

Hi All, Normally, we can execute an external script of a file that has no password to open. What If I want to execute an external script of a file that has password to open , I tried it but it does not work... it says no permission or something like that. Thanks Anh Tran

Thanks All, My problem is a little hard to explain for you guys, my experts, I will solve it later. Anyway, thanks Anh Tran

What I mean is that On given date (2004-july-03)... it will recognize automatically days before july (means june 27 to june 30) and after june is (july 01 to july 3). How does it recognize? Do I have to create 2 fields to calculate or just one field? Thanks Anh Tran

Hi All, I have a problem on date calculation. Let's say on given date (2004-July-03)always on Saturday, I create 7 fields calculated depend on (2004-July-03)...as followed .. Sunday = 2004-June-27 Monday = 2004-June-28 Tuesday = 2004-June-29 wednesday = 2004-June-30 Thursday = 2004-July-01 Friday = 2004-July-02 Saturday = 2004-July-03 If I do a find from 2004-July-03 to 2004-August-03, it will caculate hours from Thursday to Saturday and If I do a find from 2004-June-01 to 2004-july-03, i will calculated hours from Sunday to Wednesday. I don't know if you understand well my point. I got stuck big time here since the design is something different to do this thing. Any help will really appreciated. Anh Tran

Hello Fareye, Other application is ok with Citrix but only FM Server app is problem. It is very weird, sometimes ok sometimes not. That make me crazy. Do you have any idea? Thanks Anh Tran

Hi All, We have the problem connecting from Citrix to Filemaker files on server from the beginning. And I have no clue to solve it. The problem is that some computers can connect citrix to server and some computers can not. Sometimes we have to change username to log in to server through citrix and it works. But sometimes it does not work? Is the problem from connection through Citrix or the problem of filemaker files on server? Someone has the same problem ? Can someone tell me how to solve it ? Do I look for Citrix issue or filemaker files issue ? Thanks Anh Tran

Hi All, I just change the printer on server and I want to print files on server. There is some computer which recognize the printer and there are some which does not recognize the printer? Before it worked fine on every computer , now some work and some does not work. Somebody has an idea about it? I have tried to refresh printer on server but the problem is still there. Anh Phu Tran

Hi All, I have something like this ... Total Money = km * $0.80 for all old records. If i want to increase 80 cents to 1 dollars and i want to keep old records as 80 cents ... just for new records are 1 dollars. It means for new records Total Money = km * $1. And so on if i want to increase 1 dollar to 2 dollars and also want to keep olds records. I don`t want to use look-up since look-up in portal sometimes it works sometimes does not. Any help is really appreciated. Anh Tran

Thanks All I kind of getting it. Anh Tran

Hi All, I have a simple question which i still don't get it. I have several duplicate records and single record but what i want is to show only one time . I used self-relationship and status(recordnumber) but it does not work. let's say i have file and name: dd123 Bill dd124 Goerge dd123 Bill what i want to see is ... dd123 Bill dd124 goerge is there a way to do so ...i know someone has a trick on it . But i use recordnumber but it gives many dupolicate of 1 and 2 and so on. That is why it does not work. Can portal show only one time? Someone can help. I really appreciate it. Thanks Anh Tran

Thanks alot Syborg Sam You have the example or the site that has example I could see? Thanks

Hi All, I have a portalk with 3 fields, I want to know from the main page ...i have 3 buttons, I want each button to sort each field in portal as I want. Is there a way to do so since the relationship from portal and main page is sorted already, i can not change anything? Any help Thanks Version: Developer v6 Platform: Windows 95/98

Thanks All Anh Tran