Recent content by JeepsR4Mud

I'm jsut setting it up now... but I'm not sure I understand your reply about a field for the opportunity, and a field to accept the grade. I won't know until the end of the term, which 2 of the three exam grades will be accepted. One student may use Exam1 and 2, and another 1 and 3, etc. My...

I'm teaching this term, and have put my grades and roster in Access. Each grading opportunity is a separate field. Students will have to take 3 exams (Exam1, Exam2, and Exam3); however, their grade is based only on the 2 highest exam grades. There are other grades...FinalPaper, Attendance...

Is there a way to change the formatting of a cell, based on the value? Like the conditional formatting option in Excel? I have a yes/no field, and in the report, I'd like the NO values to be red and bold. Thanks. Gayle Ann

I designed a database for someone at work, and they wanted the report in a datasheet view. Now, they would like every other row shaded. Is there a way to create that type of display? Thanks. Gayle Ann

I have a report that displays a checkbox. However, I want to export the report to RTF or some format ti use as an e-mail attachment, and when I do, the checkbox disappears. I've also tried exporting it to Excel. In a query, I changed it from a checkbox to a Yes/No textbox, but the checkbox is...

Actually, they are not both null. I have a date in the first field and need for it to be the default in the second field. After the person completes probation a new value is enterd in the second field. During the first 60 days I need a default for the query to work. Is it possible to use a...

I'm doing a table regarding employee hiring and evaluation. I have 2 fields: Last Promotion Date Last Evaluation Date I want the defalut value for Last Evaluation Date to be Last Promotion Date. Is that possible? I keep getting an error message when I am in the table design view, which...

Figured it out! Thanks!

Hello, I tried it, but it lists ALL the employees as permanent, not just the ones with 180+ days of service. My actual field is "days in class" Thanks. Gayle Ann

Hello, I'm doing a query that calculates the number of days between NOW() and the date of hire. I'd like to have a field called probation, that displays the word probation if the employee has been with the company less than 181 days (probabtion being 180 days). I think I need an if/then...

Hello, I'm working on an employee incident database. In my main form, which is the actual incident, I have a subform of employee information. One of the fields is a combo box that draws off of a query, which draws from a table called Staff Names. The query, staff name sort, sorts the...

I keep getting an error that I have to save the field before the requery. I must be putting the docmd.save command in, but must be putting it in the wrong place. Gayle Ann

How can I set the combobox list to refresh? I have a macro to open a form to add a new record if the record needed is not in the table/query on which the combo box is based. However, when I close the form used to add the new record, the new information is not in the combo box in the original...

Hello, I have a subform which is a datasheet. Is there a way to set the column width? I've tried in the properties, and using the menu, etc. My fields are case number, employee name, and a Yes/No column. Obviously, the employee name can expand or shrink the column, but I'd like to set the...

THANKS! It works perfectly. It will save me a lot of time! Gayle Ann