Search results

I am attempting to set up a search on one of my forms to allow me to skip straight to a specific individual, however when I use the search it goes to the record BEFORE the person I selected. The search code I'm using is the same I've used in a previous form, so I'm not certain why it does not...

Currently I have a due date field that uses the following expression: =IIf(IsNull([Training]),"Not Completed", IIf(DateAdd("m",12,[Training])<Date(),"Overdue",DateAdd("m",12,[Training]))) I also have a checkbox that makes a date field become visible if checked. I am trying to figure out how...

I have an If/Then statement in VBA for one of my forms, under Form_Current() that displays "Not Completed" in the due date box if the original date box is blank. If IsNull(Me.Field) Then Me.Field_Due = "Not Completed" Else Me.Field_Due = DateAdd("m", 12, Me.Field) End...

I have a Report that pulls its values from a query. The problem I am having is that I need the query to display "Not Completed" if the value for the other field is empty, display a date (using: DateAdd("m", 12, [FieldName]) ) if there is a value, or show "Overdue" if the date in the original...

I created a form to display a number of training dates based on a query that combines two of my tables. In the query I used an expression to automatically enter "N/A" into any fields that didn't have dates in them. After I created the form I created several text boxes with the DateAdd...