Jump to content

agaperrk

Members
  • Content Count

    85
  • Joined

  • Last visited

Community Reputation

0 Neutral

About agaperrk

  • Rank
    member
  • Birthday 05/09/1962
  1. I was just pointing out that i have the current year and it does not work for me just to add a minus 1 unless there is a new way to do it........ I'm still looking for a solution for the previous year.
  2. I was just showing that i had the current year done but I am having issues with the Previous Year.
  3. GetAsText(Date( 1; 1; Year(Get(CurrentDate)) )) & "..." & GetAsText(Date( 12; 31; Year(Get(CurrentDate)) )) This gets me the current year.. I guess i could use a minus 1 after the current date.
  4. the only problem i need it to do this every year without me putting the year in.... Year ( Get ( CurrentDate ) ) - 1 does not work on 7 it does however put the right year but the find does not work
  5. I would like to have a pull down or even a selct list to click on to have the system go out and find previous year. I already have a script for current year. thanks in advance.
  6. I have two dates the current date today and an expiration of a certificate.... I need a calculation to give me a flag to say Renew, or expired..... Renew if the current date is less than 30 from the expiration and if it past the date in the field to say Expired. Thanks in Advance. Randy,
  7. In Filemaker 7 I have more than one table. One table works fine the related table shows no access would you be able to help me with this if so I will send my password access..... I Have a related database and the teacher is the field.... in one database i have the records limited to the field name and it equal the teacher name when I take it to the related table it gives no access.... I just need simple work around.
  8. the list function is not in 7 at least I cannot find it....... I need like a sum field.
  9. I have a data base that I am keeping track of speeches each event creates a new record and I have it tied to a contact ID I just want a summary field listing all the talks this person gave with a comma between them......... I do not want to do a report layout just a calculation field listing the talks a person would be giving. Thanks in advance..
  10. I have a file that i want to password, I have set privilege sets, The basic privilege set, I have a field that has their name in it and if their name is in the field then they can view that record. That part of my set works fine, were i am having trouble is I have multiple tables but I just need to be able to edit one table and view one table. I have one table which is Student and I have another table form, In the Student table I need to only view certain students that relate to a teacher, again that one I have done, along with being able to edit certain fields. Like notes and such, I have another table in which i want them to view the table and be able to edit or create records that relates to their student. Ok So my calc that i am using is "Joe Teacher, Speech trainer" = Speech -Student table "Joe Teacher, Speech trainer" = Student Contact Management::Speech --- Form Table The records show a no access and I cannot get them to show. If anyone has the ability to help here. Thank you in advance Randy
  11. I have a file that i want to password, I have set privilege sets, The basic privilege set, I have a field that has their name in it and if their name is in the field then they can view that record. That part of my set works fine, were i am having trouble is I have multiple tables but I just need to be able to edit one table and view one table. I have one table which is Student and I have another table form, In the Student table I need to only view certain students that relate to a teacher, again that one I have done, along with being able to edit certain fields. Like notes and such, I have another table in which i want them to view the table and be able to edit or create records that relates to their student. Ok So my calc that i am using is "Joe Teacher, Speech trainer" = Speech -Student table "Joe Teacher, Speech trainer" = Student Contact Management::Speech --- Form Table The records show a no access and I cannot get them to show. If anyone has the ability to help here. Thank you in advance Randy
  12. yes it is unstored. I changed the script to take in the effect of the leap Year. The Calculation works. Let([n = Get(CurrentDate); b = Birthday]; Year(n) - Year(: - ((Month(n) + Day(n) / 100) < (Month( + Day( / 100)) ) Its just is slow to calculate every day, Like the database just hasn't cycled itself.
  13. I have a Calculation, Age, The calculation is right But the Server or Client does not update every day is there a way to make this happen with a opening Script.
  14. I am still having trouble with the age calc. The file is running on a server.. with clients and It calcs right but it is not calculating when the clients open. So the age will change if you make a change in the field and then put back. but if it has been a year since messing with the file it does not calc until you play with the date field. It is like you have to manually change the date. Let([n = Get(CurrentDate); b = Birthday]; Year(n) - Year(: - ((Month(n) + Day(n) / 100) < (Month( + Day( / 100)) )
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.