Search results

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

Did I do something wrong? I still get the message about creating duplicate values. Private Sub idbox_AfterUpdate() Dim varReturn As Variant Me.RecordsetClone.FindFirst "[employeenumber] = '" & Me![IDBox] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark If Me.[employeeNumber] <>...

I'm getting an error message: Block IF without End IF Gayle Ann

I'm doing a database with employee records and a subform of employee work assignments. The primary key is the employee ID. I know this is a common procedure, but... How can I have the form take me to the employee's record if it already exists, or begin entry of a new record if it doesn't...

Hello, I have three forms (one main and two subforms) I can't remember how to go from the last field in one subform to the field in the next subform. My thought was to do it through the ENTER key. Tab, going to a new record in the same subform, and Enter taking me to the next subform. I...

Hello, I have few reports with 2-3 columns. A few of the fields are numeric, and I had the wizard calculate, sum, avg, etc. Hoowever, when printed the GRAND TOTALS are somehow forced to a brand new page. They won't print out at the end of the info form the last column. Example: One report...