Search results

  1. R

    Creating a Query based on table values

    I am working on an absence database project for employees in an office. I have a form with the following list of absence codes: The user first creates all the employees and then as the days go by can edit their profile and mark down absences based on specific reasons from the above choices...
  2. R

    Handling Unload Event

    Lets say the user enters some information into the textboxes in the form window but decides to scrap it so he/she clicks the X button. I know I should handle this in the form unload event but I don't know how to prevent the form from saving to the database. This is what I thought the code should...
  3. R

    Form still saves

    I'm trying to work with the form unload event but even when the user wants to exit the form without saving the information, the info still gets saved into the database. Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull([First Name]) Then Cancel = True End If End Sub Private Sub...
  4. R

    Preventing Form Close

    If the user clicks the close button on the top right of the form window, or the big X, I made it so that it pops up a window asking the user if they really want to exit or not. If the user clicks no, how do I prevent the window from closing? Thanks
  5. R

    Form Closing

    My goal is to prevent anything from saving to the database if the user just hits the close button on the top right of the form. I'm not positive but I believe the form calls the Close command when you click the X, so I tried something like this Private Sub Form_Close() Form.Dirty = False End...
  6. R

    Form Window exit checking

    For simplicity's sake let's say I have one text box with an exit button on my form window. Currently, my problem is that if the user opens and then exits the window without entering in anything into the text box, the program saves a blank entry into the database. What I want is for the database...
  7. R

    Creating a Drop-Down List Box

    I'm trying to create a drop-down list box on my form. I am able to create a combo box and a list box but not a drop-down list box. The microsoft help page says you can just select them from the toolbar and add them but the only things I see in the toolbar are the combo box and list box, there is...
Top Bottom