Search results

Hi The two combos on the same tab. Both on page 2 of the tab control. No subform. The problem is when changing combo 1, it does not requery combo 2.

Hi Total = NZ(Me.combobox1.Value,0) + NZ(Me.combobox2.Value,0) + NZ(Me.combobox3.Value,0) Gave me the same error :(

Hi I have a similar question which I hope can be answered in this thread. In page 2 of my tab control, I have 2 combo boxes. The second combo box needs to be linked so that its list depends on what option is selected from the first combo box. How can I do this? I have done this in a form...

I am pretty sure I now know why it is not working, but still need your help to solve the problem. I believe it may be because my combo boxes is in a tab and as I am using code: Me. this is therefore not referring to the combo box correctly. Am I right? How can I correct it?

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 Again Please see the attached database...I hope you can work your magic. Hope you can get back to me soon.

Hi Sorry to be a pain, i don't really want to attach this. It would really help if you instructed me so I can do this by myself. I nearly have the hang of this. If it is not a straightforward process then perhaps I can email this to you? Thanks

So I set selection ID as a primary key and do I set it as an AutoNumber? Also do I set both user ID as a primary key in both user and selection tables? I have made a query by linking User ID in both "user" and "selection" tables. What fields do I need in this query? Thanks for your help!

I am slightly confused by what you have said here. Can I confirm that in my UserSelection table shown below I will have multiple records for one UserID? Also I do not know how i can use selectionID? tUserSelection SelectionID OptionID UserID My database also has a "User" table with details...

ok cheers ..could you let me know how i could do it using quotes then please?

wow cheers that works perfect. Why did i have to enter that?

Hi I think we are nearly there. I am now getting the error message: The expression you entered as a query paramater produced this error: "JC"

I am getting the below syntax error... (missing operator) in query expression "Student ID = JC"

The field name in my table for StudentID does have a blank in it and so is: Student ID I am not sure if this makes a difference. Heeeelp please

I can validate whether password is a blank field so it should work. Yes, I do have StudentID as the control name.

unfortunatly still not working :(

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 Again I have created two seperate lists for 10 and 20 points. How can I capture into a table from my form which people have chosen which options, as I will need to record everyones selections. Also, what does SubmitButtonEnabler do for the code you gave me?

Ok thanks - having seperate lists for 10 and 20 points makes good sense I will work on this and get back to you over the next few days if I have any problems.