Search results

  1. I

    Unable to Close Form

    Hi All, I am trying to close a form with a subform. I enter data in the main form and then the subform. The main form has a save btn with an on click event which includes at the end of code If Me.Dirty then Me.Dirty = false DoCmd.Close DoCmd.OpenForm "FormName" however the Form will only...
  2. I

    Third combo box optional

    Hi, Any advice on how to get a third combo box on a form to be optional. I have a form with two combo boxes which filter out the results on a query. However I want the third combo box to be optional i.e. if it is blank then just the results of the first two combo boxes are shown. If the user...
  3. I

    Expression DCOUNT with Last Month Date criteria

    Hi everyone. I have looked on similar posts here and the internet but could not find the answer. I am trying to count the amount of records that were created and closed for last month but I am having problems inserting the correct criteria along with the DCOUNT syntax. Closed...
  4. I

    Delete Button

    Hi Is there any way for access to keep the record to be deleted on the screen after the Delete button has been pressed until the user clicks the Yes button to confirm deletion? (My first post)
Back
Top Bottom