Search results

  1. A

    Sum of subform fields in text box unbound.

    I want to add a sum of all fields in a subreport called 'Index' the field is called 'Salary Increase'. I want the sum of these fields to be displayed in the unbound textbox called 'Salary'. Please help.
  2. A

    If statment vba button appear.

    When I tried it I got this: This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event...
  3. A

    If statment vba button appear.

    It is on the main form.
  4. A

    If statment vba button appear.

    I need an if statment that will show a button if a subform number is above 500. The button is called 'Pass' The subform is called 'Agesubform' The field that will be over or less than 500 is called 'Days Employed' it is on a query called 'age' and also the subform above mentioned. I Here...
  5. A

    Entering text into a textbox with if statment.

    Do you know how to use vba code that deletes a subform when a button is clicked? But only for the one record that the button is pressed on.
  6. A

    Entering text into a textbox with if statment.

    Forgot to mention that the loyalty bonus is on a query called age.
  7. A

    Entering text into a textbox with if statment.

    This is what i have so far. I need it to fill textbox 53 with the text. If loyalty bonus is more than or equal to 500. Sub BONUSDUE() End Sub If ([LoyaltyBonus] >= 500) Then Textbox53 ("Loyalty Bonus Due") End If
  8. A

    If statement in a calculated field problem

    How would I make it display a button or a textbox. instead of a message box
  9. A

    Age validation rule 17-65

    I need to use a validation rule that checks how old a person is by their date of birth. Here is what i have so far, 6205 is the number days a 17 is alive, the difference in the date of birth must be more or equal to this, however it must be less that 23725 the number of days a 65 year old...
Back
Top Bottom