Recent content by George82

Please see attached print screen... Thanks in advance!

I uploaded my DB.. I removed anything unnecessary..

Still does not work… It prompts debug error in line : If A.Value = 0 And B.Value = 0 And C.Value = 0 And D.Value = 0 And IsDate(returned.Value) Then Moreover I don’t want to use it in the AfterUpdate event of the Returned Date as it’s not the last parameter that will be filed to disable...

I am using a table linked on a form to register our products and for our clients. On the form the trextboxes a,b,c,d I am mentioning are the number of accessories that come with the product and textbox f is the returned date. I want when user enters the value zero ‘0’ in text boxes...

I have a form with 5 text boxes. A, B, C, D and F. Text boxes A, B, C, D have numeric values. Text box F is date. I want when text boxes A to D have the value 0 and text box F is filled with the date to lock edit for this registration and the corresponding row on the table. I want it to...

It worked just fine!! Thank you very much!

I don’t get any errors while executing.. The RowSource of the combobox is: SELECT MODEL.MODEL, MODEL.TYPE FROM MODEL WHERE (((MODEL.TYPE)=[Forms]![STEPS]![TERM TYPE])); I have set it to take each values according to the selection of another combobox (Term type). I select...

Thank you for your instant reply ! Unfortunately I still don’t get anything on the text boxes… What parameter could I be missing?

I have a combo box on a form that has the model of the product. I want when I select the type of model on the combo box to fill automatically the text boxes on my form with the quantities of the accessories for this model. For example… I select model A on the combo box I want to be displayed...

It worked fine!!!! THANKS AGAIN!!!

Thank you so very much for your reply! Anfortunately I am ferly new in access and I will need some additional help. The is no Before Update event in form… So the “Private Sub Form_BeforeUpdate” should it be for the Target filed I am using The name of the field I am referring is MID...

Or I could use it in Before Update event....

I have a text box on a form that I need for every new entry to be automatically increased by 1 on click event. My first value would be 520000001 and when the user makes a new entry and clicks on the text box I want automatically to take the value 520000002 and for the next record the value...

Thanks you very much for your replies! It worked with the “AND NotIs Null” statement. [COLOR=black]

Thank you for your reply. I used Nz function and set “Color” is NOT NULL, but what it does now is turn the records with values to blanks. Ps. “Color” I used to describe my example. Those are not the actual names of my fields.