Search results

It worked! Thank you all very much

OK i think that was because of the name of the field. That works! I am at work now and i have office 2003. I will check it at 2007 at home and let you know if that works too Thank you anyway

Here it is. I work this database at Greek language. I think i changed it to english

Hello there.I am new in access I have a database in which i have created a table. A field in this table is called: Lastname. Now, i want to create a form with some positions. Its for example sales position, secretary postion, management position etc. So, i create these labes. At the right of...

Here is the sample of my database. If you change it let me know what you did. Thanks in advance

I get an error: run_time error "424": object required when i choose an option at combo box Price and the two other fields are enabled

I use microsoft access 2007. I have created a table and i want to fill it through a form. So, i went to new form tab. I drag 3 fields of the table in the form. The names of the fields are "Price", "Tax" and "Priceless". I have defined from the table that the field "Price" will be a combo box...

i wrote over "Price" field this Private Sub Price_Change() If Price.ListIndex > -1 And Price.Text = "<300" Then Tax.Enabled = True priceless.Enabled = True Else Tax.Enabled = False priceless.Enabled = False End If End Sub When i try to test the form, the Tax and...

OK. I have 3 fields of the same table. The names of the 3 fields are "Price" "Tax" and "Date". The Price - field is a combo-box with these values: <100 <200 <300 I want when i select the 3rd option of the field "Price", to enable the other two fields, so the user can fill in. Otherwise, if...

Ok. I created a form and i dragged the 3 fields from the table. I clicked on the combo - box field and i selected the after-update option and insert code and i wrote this: Private Sub Field_Name_AfterUpdate() If Combo1.ListIndex > -1 Then command1.Enabled = True Else...

Thank you. So, the value '-1' at your code, is for the first value of the combo-box field?If i want the second value should i put '0' for example? I have microsoft access 2007. Where should i insert this type of code and how can i use it at my table? thanks in advance

Hello there! I am new in access. I have created a table. My problem is about 3 fields. I have a field that is a drop-down menu. All i want is when i choose a specific option from the drop-down menu to enable the other two fields. Otherwise, the two other fields are disabled. How can i do that...