Recent content by fabio

SOLVED; Thank you for your answers. ---------- I have added the Row Source Type as "Table/Query" an also selected in the combo box properties the option "Table/Query", then the second column was populate. ---------- Private Sub Command11_Click() Dim conn As ADODB.Connection...

George: Correct, Column 1 is populated but column 2 is not. Thank you for your help. Fabio

I need some help; I cannot see what I am doing wrong in the following code which is part of a Form; the code stop at line (Me.Combo0.Column(y, x) = strProj). I am trying to populate second column in a combo box with data from the recordset rsProjWBS. In Advance, Thank you for your help...

Missingling: Thank you for your answer. As indicated I need to pass the value of this calculated field to another text box (the control source of this text box is a query field) in the same form programatically, any suggestion will be highly appreciated. Thank you again, Fabio

Thank you Poppa Smurf for your answer, the proposed solution works. However please let me know how can be passed the value of this calculated field to another text box (the control source of this text box is a query field). It is my final purpose. and I want to do this programatically (VBA)...

I have a subform embedded in a main form, the subform has a field (text box) that is doing automatic calculation so no manual entries are needed from the user. I have tried to pass automatically the final result to a text box in the main form, but all events are not working (afterupdate, On...

I need some help, I have a database of documents, in a field is indicated the document revision, this field can cointain a letter or a digit, the greater number is the latest revision, I want to know what funtion is the correct one to be used in VBA to filter documents with teh latest revision...

I need some help, I have a database of documents, in a field is indicated the document revision, this field can cointain a letter or a digit, the greater number is the latest revision, I want to know what funtion is the correct one to be used in VBA to filter docuemnts with teh latest revision...

Hi, AprileC I want to add a progress bar to my form, cna you help me? I have successfully added a progress bar to the MS Acces Status bar, however I want to add my own bar to the form.

I have added an If to check the "Filterclause" and now it works very well. I am not able to insert code on this answer, so please check the indent for all llines. ---------------------------------------- Private Function StockSearch() On Error GoTo Error_StockSearch Dim FilterClause As...

CyberLynux, I am trying to use the Dynamic Filter, initially it works very well, however when a combo is cleared through the button the filter is not updated or refreshed.

CyberLynux, I am trying to use the Dynamic Filter, initially it works very well, however when a combo is cleared through the button next to the combo box, the subform is not updated. could you please help me?