Shari

The report is in Excel. But I only want to send that managers information. So if I can sort by manager and break out the other managers and then send the email to the approprate manager would that work and how would I script that?

I have a script to find a class and sort by manager name. The file contains multiple data fields with multiple managers. I want to send each manager a file with only their employee's information. So the report looks like: Class date - Student Name - Manager Name - Entrance score - score 1 - score 2 4/12/2004 Paul Mary 100 98 87 4/12/2004 John Mary 89 98 98 4/12/2004 Tracey Steve 99 87 100 I want to send Mary the data on Paul and John only; and I want to send Steve a report on Tracey only. How do I divide to automatically send my exported report to only the immediate manager? Thanks, Shari

I have an excel export that uses specific fields from a file. I would like to sort and only show certain data from the file in the export and agian in another export with different information. For example: Name Bob Bob Susan Susan I want to have all Bob's information on the excel spreadsheet only and then have another spreadsheet with only Susan's information. Than I want to e-mail to the appropriate person with only their information. How do I accomplish this? Thanks, Shari

I tried your suggestion and I must be doing something wrong for I cannot get the pop up to stop.

The dates are from a value list from a related file. The format is month/day/4 digit year. The field is empty until a date is picked from the list. This is the problem. If anything in the file is clicked the message appears before you can get to the field.

Thanks. I'll try that.

I changed the calculationto the one you listed, but I am still getting the pop up when I don't want it. I changed from a text to a date and back again, it didn't seem to make a difference.

Thanks. I'll try your suggestions.

If I check that box, then the error message does not display if I choose an earlier date. Which is the reason for the message.

I have a value list of class dates. I also have a validation field that calculates if the date is prior to today's date to send a message. The field is blank otherwise. The problem is when I am in the file and want to do other activities, the message appears. I do not want the message to appear until I enter data into the date field. How can I stop the message from appearing when I click on other options? Thanks, Shari

Hi, I have a label size that is used by my company that is not available in FM. I tried to enter the width and height of the labels, but the sheet the labels print from has a small header and the labels do not line up. If I adjust the height for the first row, all the proceeding rows are not aligned. Is there a way to add the Avery label number to the list or accomadate for the sheet header? Thanks.

All the files have the same password and access privelages. However, when I open the first file I am prompted for a password. The user cannot go to layout mode. When I click on another file that I have a script to open it does not prompt for a password, which is good. But I can access the layout mode which should not be allowed per the privilages assigned by the password. I must be doing something wrong. Can you help.

So I need to tell my user's to press and hold the shift? How can I handle restrictions on related files? Do they need to enter a password for each file they go into from the main menu? I would like to have only one password they enter when they log-in, but it would effect all the files they view. Thanks, Shari

Hello, I'm a bit confused. I set up a group with a default password so the user does not have to enter the password all the time. I have a separate password that allows for all access. When I access the system it does not prompt me for a password. How will the system know what users are which? Any help is appricated. Shari

When I set Error capture it deletes all.

Hello, I have a script that finds duplicate records and deletes. However, If the script does not find a duplicate it returns a message "No records match this request". What should I add to the script to not show this message when a duplicate is not found? Any advise would be appreciated. Shari

Thank you all.

Hello, I have two different fields, Store QCM and Store RTS. They both contain store numbers from different files. I need to combine the fields or make on field that has both values so I can report the data. Like Store QCM or Store RTS = new field.I cannot figure out the calculation. Please help. Thanks, Shari

Thank you.

I set up a validation with the calculation I used to display a message. It seemed to work ok for a few records I added, but then I got a message: "Filename" is defined to require a value, but it is not available on this layout. Use another layout to assign a value to this field. So, now that's all I get. Can someone help? Thanks, shari

Hello, I'm new to this programming stuff and need some assistance. I want to have an Error message Pop-up window display or grey out a date from a drop down menu when certain criteria is not met. I have defined the message and it displays under the field when the incorrect information is entered. However, I would like to only see the message as a new window pop-up when the error occurs. Also, I would like invalid data to be greyed out so it cannot be selected from a valuelist drop down menu. Example: I have training dates in a value list for a year(Jan- Dec). I want to grey out past dates so the user can not select dates in the past. How can this be accomplished? Thanks.

Thanks. I was afraid of that.

Hello, I have a value list that has 26 different comments. When a teacher updates the final class documentation they select comments about the student from the value checkbox. They can select any amount of comments per student. I would like to have a count per class on the comments selected. For example: Class 2 Comment 1 Total; Comment 2 Total; etc. What would be the best way to handle this calculation? Thanks, Shari

Thanks Ken, This is fine. However, I want to view each class only once with the total of all records. This gives me the Class ID and then each record with the totals. I only want to view the totals once for each class. Example: Class A Total Registeted Total Corp. Emplyoees Total Canadian Employees 8 3 5 Class B Total Registeted Total Corp. Emplyoees Total Canadian Employees 6 5 1 Thanks, Shari

Hi, I need to produce a report that shows counts of field information for all records of a given class ID. For example, I have a field called Polling, the data is either yes or no. I have another field called status, which has different data. I need a report that shows the specific class, with a count for each data element in the different fields. I need this for all the classes. How can this be accomplished? Thanks.