Search results

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...

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...

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...

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

Let's say the user hits the close button and I have a msgbox that asks if the user really wants to exit and the user doesn't. If he/she clicks no, how do I stop the form from 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...

I don't actually have any window asking the user to save or anything. There is just a save and close button. What I want is, when the user clicks save and close, I want it to check the first name field, see if that is dirty, and if it is then save, if not then don't save. I think I have to add...

The form is an information form, where a user fills out all the information about him/her. There are two combo boxes, state and country. And in the Form_Load class I have: If IsNull(Country) Then Me.Country = Me.Country.ItemData(217) Call Country_AfterUpdate End If Private Sub...

So to clarify, I also have a combo box in the form that has a default value when you open the form. So I think that's what is dirtying the form. But how can I make it so that it has to check a specific text box and see if that is null or not before entering into the database

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...

So there's no way to add this? I'm surprised, a drop-down list box is a basic feature I see on any registration page or selection menu.

It has the properties of a list box such that -You can't edit it by typing in values, but rather all typed values will be treated as a search And also has the properties of a combo box such that -You can display all the relevant items in a drop down box The microsoft access website says you...

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...