sykot

Thank you very much it works I want also this for the previous year. i have 2009 as latest records. how can do it for previous years?

Thats true... i tried something but the original code is this

Hello guy's I have a question. as you can see on the image the layouts shows the records of current year 2011. i have a script that allows me to go to the next year (script on the image), but if the layouts shows the current year i want to prevent that the scripts stops because there are no records at the moment of year 2012. I tried something but nothing helped, how can i do this? Kind regards, Serhat

Thank you for your reply, The field 1.Year is set to YEAR date field. The activities has also a date field. Here with this image you can see if i select 2010 i want that i see the activities of year 2010 in field 1.activiteit

Hello guys, (FIND MODE) I have a question: if i select the year 2010 in field (1. Year) i want to show only the activities that was in 2010 in the field (1.Activiteti) How can i do this? I have attached a image. My question is based on Find Mode Regards, Serhat

I got it but whats the difference with if i do Month ( Get ( Currentdate ) ) =1 and the way what you are telling?.

Thank you for your help it works thanks.... Well i make this for membership. The membership starts at September and ends September of new school year. So my point is if some one want to sign out in january, it need to stay in the list until month september and from september it need to signed out..... Will this work?

Hello guys, I have a question i got two Tables 1. Want to sign out 2. Signed out With the function i want that if Want to sign out = Yes and its the month ( 1 ) then the field Signed out need to be YES but if its not Month ( 1 ) then it need to be still remain at NO Can some one help me i am going to be crazy Here a screenshot http://webdisk.planet.nl/dalga000/publiek/album/functiefout.jpg

Hello guys, I have a small problem... I have two tables Table 1: Want to sign out (YES) Table 2: Signed out (NO) My question is: If table 1 is "YES". I want that table 2 sets to "YES" when i pass or in the month (example: march) I have tried some things but it didnt work (worked with time to test) (This is the script in table 2) If ( Want to sign out = "YES" ; If ( Time ( 0 ; 5 ; 0 ) = ( Time ( 0 ; 5 ; 0 )) ; "YES" ; "NO" ) ; "NO" ) Can someone help me with the script Regards, Serhat

Hello guys, I have a question, i am connected remotely to my database. The server is installed on a computer with FM 11 server advanced. When i want to import from MySQL i got this error ( i can read and see the information in MySQL) The file “?” could not be opened. (Not Found) The previous script step, “Import Records”, could not be completed because of an error. Do you wish to continue with this script? Privilege for the Admin user is FULL ACCESS And the script has also the function FULL ACCESS ODBC is enabled in the server. Does some one know how to let it work? Greetings, Serhat Dalgara

Hello guys, I have a question, i am connected remotely to my database. The server is installed on a computer with FM 11 server advanced. When i want to import from MySQL i got this error ( i can read and see the information in MySQL) The file “?” could not be opened. (Not Found) The previous script step, “Import Records”, could not be completed because of an error. Do you wish to continue with this script? Privilege for the Admin user is FULL ACCESS And the script has also the function FULL ACCESS ODBC is enabled in the server. Does some one know how to let it work? Greetings, Serhat Dalgara

Well thank you for your help i did make a backup of the script but it was using the old script so the new one had no effect my mistake its works now thank you very much for you help :

Thank you for your help do you have a tip which email plugin i can use?

Thank you for you help. I tryed what you say but it doenst work if i turn my connection off it does continue to set the field. :

Hey guys, I have a problem with my script. What i want that the script does is that if there is no internet connection, the script must not go further to set the field to "ja". i have made this script but its not working good. Can someone help me? for a script when internet is available that the script need to stop but when there is internet to send email and set the field to "ja" Here the screenshot