Mike-LI-NY

I have two users who cannot use ANY scripts in the database. This is a file we've had for about 5 years. Once a year we make a copy of the file and it's our new database for the next fiscal year. We've never had a problem. I'm using FM 11.0v1 on a Mac using OSX 10.9 and everything is fine and dandy. No issues. Another user on a Mac is also fine. However, I have two users on Windows (one user on Windows XP sp3 and another on Windows 8) using two different versions of FM (8.5v 1 and 11.0 v1) who cannot run any scripts. If you start any script, it doesn't run. I've even tried creating simple scripts that simply change a field to "9" and they still don't run. Yet, everything works fine on the Macs. The file we're using is hosted on FileMaker server and we open remotely. I've tried also opening it locally and it still doesn't work on the Windows machines. It doesn't seem to be the version of FM - I'm wondering if Windows issued some patch that affected this recently. Has anyone else experienced anything similar? Any advice would be greatly appreciated! Thanks.

What's important to us is always knowing how old the person will be as of July 1st 2007 (if that is the season we're working on - we're a summer camp business, so we start working on Summer 07 in the middle of summer 06). But what we need to know is as of July 1st, 2007 how old someone is. So, for someone who was born in June 2000 - any day in the month - they should be 7years 1 month. For someone born in July 2000, 7 years, 0 months. May 2000, 6 years, 11 months. Does that make sense?

Which of those calcs would be best to customize to my needs? I need to have the result formatted as "10.02" - meaning 10 years, 2 months. Any ideas? I've having a tough time wrapping my brain around this...

I"m having a tough time determining client's ages. I've pasted what I'm using below... I tried a few different things... however depending if I'm looking before Dec 31st in the year previous to the future date (ie Dec 30/2006) - the date as of July 1st/2007 isn't right. However, I think after January 1st it's ok... Can someone please offer some help? CALCULATION 1(Age) 2007- Year (dob) - If ( Date(Month (dob) ; Day (dob) ; "2007") > Date (7;1;2007);1;0) + If ( Month ( dob )=1; .05; If ( Month ( dob )=2; .04; If ( Month ( dob )=3; .03; If ( Month ( dob )=4; .02; If ( Month ( dob )=5; .01; If ( Month ( dob )=6; 0; If ( Month ( dob )=7; .11; If ( Month ( dob )=8; ".10"; If ( Month ( dob )=9; .09; If ( Month ( dob )=10; .08; If ( Month ( dob )=11; .07; If ( Month ( dob )=12; .06;0)))))))))))) CALCULATION 2(AGESEASON): 2007- Year (dob) - If ( Date(Month (dob) ; Day (dob) ; "2007") > Date (7;1;2007);1;0) + If ( Month ( dob )=1; .05; If ( Month ( dob )=2; .04; If ( Month ( dob )=3; .03; If ( Month ( dob )=4; .02; If ( Month ( dob )=5; .01; If ( Month ( dob )=6; 0; If ( Month ( dob )=7; .11; If ( Month ( dob )=8; ".10"; If ( Month ( dob )=9; .09; If ( Month ( dob )=10; .08; If ( Month ( dob )=11; .07; If ( Month ( dob )=12; .06;0)))))))))))) CALCULATION 3 (STAFF) Year (Get(CurrentDate))- Year (Date of Birth)- If(Date(Month(Date of Birth);Day(Date of Birth);Year(Get(CurrentDate))) + If ( Month ( Date of Birth )=1; .05; If ( Month ( Date of Birth)=2; .04; If ( Month ( Date of Birth)=3; .03; If ( Month ( Date of Birth)=4; .02; If ( Month ( Date of Birth)=5; .01; If ( Month ( Date of Birth)=6; 0; If ( Month ( Date of Birth)=7; .11; If ( Month ( Date of Birth)=8; .1; If ( Month ( Date of Birth)=9; .09; If ( Month ( Date of Birth)=10; .08; If ( Month ( Date of Birth)=11; .07; If ( Month ( Date of Birth)=12; .06;0))))))))))))

My DYMO was working fine for me in 8.0v3 and then I tried out 8.5 and it was printing blank labels so I downgraded back to 8.0v3 and they're still blank. Grrrr. Any suggestions? It really is annoying that FileMaker "fixes" things that aren't broken when they upgrade..... btw I'm using OSX 10.4.7

SD - this is getting all a bit too technical for me - I'm a pretty basic user without extensive programming/scripting/calculation experience. Can you make it clearer for me? I'm not sure which calculation to alter and how to do it. Thanks for all your help so far!

Shuold I expect that even if I'm the person making the change in another open window?? Because if I make a change or add an advance in one window, the total advances for that staff member will update on the FORM layout (therefore I assume the change has been committed) and then switch to another open window with the American Payroll, it isn't updated. However, if I were to change the salary on the FORM layout, it will update both individual and summary fields on the Payroll layout. Are you saying that because the Staff Member's Advance total is a sum from another table it isn't refreshing? Interestingly, after you make a change and go to the Payroll layout, and click into the staff member's Total Advances, it will update itself, but the summary field doesn't update. Is there a way to force it to automatically recalculate?

You don't make the change on the American Payroll layout - it's if someone else is working in teh database and makes a change or something - Salary automatically updates but the Advances & Advance Summary field do not.

Ok now the ADP Adv Summary field is correct (changed to a summary field) - thanks for catching that. However, it's only correct if no changes are made while on the American payroll layout - if you change the salary, it is automatically updated, alas taht's not the same for Advances.... any idea why that isn't updating?

Still no luck. Do this. Open two windows (impt) - one to the American Payroll layout, the other to the Form view. Find All. In the American Payroll, see that pat Meadors has ADP Advs of $0.00, and notice the summary field isn't the correct total for all 6 records (yet the other summary fields are right). Rather than giving the total, it's only showing the value of the current record. Now, on the Form view, go to Pat Meadors record and add a $200 advance. Go back to the American Payroll Report in the other window and notice that nothing has changed. Click into Pat's ADP Adv field and the 0 changes to a 200. However, if you were to change her Earned Salary on the Form Page on the Staff Info tab, it would instantly update in the other layout. So I guess there are 2 issues - 1) Total Advance information isn't being updated on the American Payroll layout when it is modified on the Form. 2) The Summary field isn't calculating properly.

Old field names from a file that kept getting migrated from an older version of FM - most of them are gone now... Any suggestions on the summary fields?

I have a staff file ste up as follows: Each staff member has a gross salary field, as well as a portal to another table that creates advances for that staff member as needed. So EmployeeA could have 3 entries in the advance table that total $60 (this result is computed from the original table, using a calc called Advances_total (def: Sum ( Advances::Advance_Amount ) + Cash_Advance_100), where Cash_Advance_100 is simply a number. I then have a report that lists all staff with their total Salary and total Advances, and at the bottom of the report, I have a summary field that calculates the Total Salaries of everyone in the found set, as well as another summary field that Totals all Advances for everyone. The problem arises when you add, delete or change an entry in the advances table - the summary field that totals advances doesn't update itself. Nor does the Total Advances field for that staff member (when on the report that lists everyone). If you click into the field on the report, it will update, but the summary field will remain unchanged. Where did I go wrong? Can anyone provide me with some help? Thanks in advance! 06tlctaff_Clone.fp7.zip

We host our file in house using FileMaker sharing so all of our employees can access the database. However, the host printed something the other day LANDSCAPE and now it defulats to landscape on everyone else's computers - same thing they switch printers (to a label printer) - everything comes out on 8x11 but only prints what would fit within the margins of a label. Any ideas?

I have about 20 workstations at my office, each with their own seperate liscence. Computer1 hosts DatabaseA with Sharing on - Computer1 shows up in everyone else's Open Remote Dialog, however the file doesn't show up (In case you ask, the checkbox for "don't show this file in open remote" isn't checked). However, if I host DatabaseA on Computer2, 3, 4, etc, it will appear in everyone's Open Remote, including Computer1. Any ideas why this would be happening?

I have several tabs on a layout and each tab pulls informaiton from a few different tables... is there a way to restrict access to certain tabs using permission sets? Or do I have to restrict access to certain tables and the fields will just come up as denied? The problem with the latter is that a user should have access to SOME information in one table... Advice?

Immediately after I upgraded to 8v2, whenever I performed a search on an unstored calc fields, I've been getting incorrect result s- both when the file is hosted on FMServer and when it is on a local host. I called FileMaker on Feb 10th or something (I've been escalated to the highest priority apparently) and they kept telling me that they'd get me a patch that week - this has been going on for 2 months and my office has fallen behind on so much work and had to create many workarounds and lots of extra paperwork. It's been EXTREMELY frustrating dealing with this company especially after paying X thousands and thousands of dollars to upgrade to this version. They're completely unapologetic and continually string us along with promises of a pending patch, which I still have yet to see... The amount of wasted time, effort and money has been through the roof - there was a 2 week patch wher ethey had me migrating the databases back and forth between different versions where numerous employees were rendered useless. I used to sing the praises of FM, but after this, my respect fo rthem has gone out the window and I'm already investigating other database products that we could use. Completely disappointing... not to mention every time you call them you have to go through 60 prompts and from time to time type in a credit card number! Agh the frustration...

When printing a merge letter from my MAC (FMP 8 Adv), it prints fine - when User B (Windows XP, FMP 7) prints the merge letter, it gets the first few lines ok, but then the middle of line 4 is blank - but there is words at either end of the line. And then when User C (Win Xp, FMP 8) prints it, there is only text at one end of the line and the rest is blank. The rest of the letter is intact the way it would be - it's like the words were "whited-out". Has this ever happened to anyone? FYI It looks fine on the screen when it prints.

Thanks for your input everyone. We're a sleepaway camp that has everything imagineable: Soccer, Baseball, Swimming, Boating, Water-skiing, Outdoor Adventure, Horseback-Riding, etc etc. We have 500 campers. For most of the time, campers are scheduled by Division or Bunk (groups ranging from 8-30). Larger activities like Soccer can accomodate 30 kids, while water-skiing can only handle 8 in one "period". So, we have to make sure that we're not double booking a time slot at a certain activity, while also making sure that we're not surpassing our capacity. On top of which, we have to make sure that everyone is regularly scheduled for certain activities, while also incorporating individual request s- additional tennis instruction, etc. I'm open to tons of ideas - I'm definitely not a pro, but have taken a few courses and managed to build some great, funcitonal databases with some neat features. Also, if someone knows of a program that would do this for me, aside from having to create this from scratch - whether it be a FM solution or a stand-alone APP, that'd be awesome as well. THANKS! M

I work for a summer camp company and we create individual daily schedules for our 500+ campers. Does anyone know of any good scheduling solution that would allow me to set parameters such as "from this time ot this time X kids can go to horseback riding" and then refuse entry to the X+1 kid? And also have the ability of generating schedules by day per camper or by age group? It's a tall order, but if someone can point me in the right direction, it'd be greatly appreciated!

Ah that's a smart move. But no way to export them right?

Thanks so much! I can't believe I never noticed that! Does it print ALL fields? or only teh ones that are in the current layout?

I'm wondering if there's anyway to export or print a list of all my fields along with their definitions so I can send them to someone - either on paper, or to an excel file or something.... is this possible? Thanks! Please email me at michael@camptlc.com if you can help Thanks!

My "Define Relationship" button is greyed out and I can't access it (I can't access a few other things as well - ie Scriptmaker) - is the file locked? If so, how do I go about unlocking it and viewing my relationships? Thanks so much in advance! Mike Version: v5.x Platform: Windows XP

I'm working on a Database of all my CDs that I own and can't figure out how to put a small graphic of the cover of each CD on each record - what kind of field do I need or how can I get them in there? Thanks everyone! Mike

Hey John After I type the date into the date field in File A, I push a button which runs a subscript in File B. That subscript sets the date field in File B to the date field in File A and then performs the search. Any idea? M