Search results

In subroutine1, I call on subroutine2. how can i exit subroutine 1 from a code in subroutine 2?

Hi I have created a login form for users. I was wondering whether it was possible to change the following properties whether the user is an admin or not? enable design view enable layout view display navigation pane This is on MS Access 2007 Thanks

On a form I want to filter a subform according to the value chosen on a combo box. My subform is made from a query and in this query I have the below criteria for one of the fields. Like [forms]![Results_Form].[combo49] & "*" I also have the following code, so it requeries: Private Sub...

Hi I have a table with 10 different options. I also have a table which contains multiple records for users with SIX option columns. These option columns will each have one of the 10 different options selected by a user. How can I count the number of times an option has been chosen? Is there a...

Hi The form closes fine but I do not get a prompt for saving changes. Please help! Also is there a way of tailoring the prompt message that is displayed? Private Sub Quit_Click() DoCmd.Close acForm, "main_form", acSavePrompt End Sub I would actually like to quit the entire access...

Hi I have a validation i would like to use on several combo boxes. I was going to put this validation in a seperate sub routine Is there a way of looping through comboboxes 3 - 6 in a code.

Hi I have several combo boxes that uses a table as its values. My last 2 combo boxes however need a blank value, which would be valid in this case. Can I easily insert a blank value to these combo boxes? Thanks

Hi Can anyone tell me how i can validate two combo boxes, so that a message appears if the values are the same? Both combo boxes contain text.

Hi I have two combo boxes. The first combo box is used to select a category. The second combo box should then produce a list of items according to the category. I have done this in the same manner as the video on the below link using access 2007...

I have a 3 combo boxes each with numbers that are to be selected. when trying to sum the values of the combobox using vba it does not work. Can any1 help. My code is below: Private Sub Submit_Click() Dim Total As Single Total = (Me.combobox1.Value) + (Me.combobox2.Value) +...

Hi I want to check whether a password entered in a form for a student corresponds with the password in a table in access. The code below does not seem to work. Can anyone help? I know the names of my tables and fields are correct. If Me.Password.Value = DLookup("[Password]", "Student"...

Hi I am a relatively new vba user. Problem: I need to produce a form that lists 7 subject options. Each option is either 10 or 20 points. The user needs to choose two or three options, so that the total number of points is 30. Can any1 help solve this problem? My Idea It is important...

Hi I am relatively new to vba. Can anyone please help on the below questions. 1) Is there a simple vba event I can build to automatically open a form up once the file has been opened. 2) Is there a site or a list that you can recommend to me that will help me understand all the different...