Recent content by gabrielbatistuta

Hi there, I have created a new query based on a pivot chart that I want to display and print. When I open the query in pivot chart view, I can see the chart. Now I want to create a button so that it will show the chart automatically. Could you some provide a sample code for On Click event of...

Yes I did. As I mentioned earlier, I am looking for changeover and NOT unique products. How many times does a product change from one to another?

Are you sure this is correct? Because in the report for Product ChangeOver = #ERROR field name = Product

Can you please tell how you would paste the code? Thanks.

Thank you Aceman. So you would paste this code in the report vba and set a textbox called "product changovers" to = ChgOvrs()

Hi there, I have a column called Product in my report. And I would like to add a data that will tell you the number of product changeovers. Could someone please provide me with some sample code. It is probably a while loop that will go through all instances of product and will increase the...

Dear PH, This should be really simple to do. I don't understand why I have to go through tons of replies. If you tell me exactly what needs to be done (I already have explained what my problem is) then everything works out fine. You told me to filter the second form when I open the first form...

Thank you for the code. The code just filters the second form based on the first form EWOID. I can even see that on the second form properties->filterns = EWOID = 138 which is the EWOID of the first form. But when the second form opens, no information from the first form show up in the second...

DoCmd.OpenForm ("frmEWOPDC",,,"EWOID = Me![EWOID]") First of all, please let me know if what I am doing is correct? EWOID is the same control for both forms. So I want to say that show me the second form with EWOID that is the same as the EWOID of the first form. Both EWOID have the same...

DoCmd.OpenForm ("frmEWOPDC",,,"EWOID = ) I am a newbie in VBA. How do I say EWOID = second form EWOID control.

Please ignore the code. You mentioned the 4th argument. Could you please post a sample code that will solve the problem. Thank you.

Hi there, The second form is opened when the user selects a particular name from a combo box in the first form. Could you please provide a sample code? I have Code: If combobox = name Docmd.Open("frmEWO3") tHANKS.

What do you mean? Could you please be more specific?

Hi there, I have created two forms where a selection in the first form will open the second form. These two forms are based one table, let's call it "Enhanced Work Order". The relationship is one to one. That is why I put it all in one table. I would like to be able to synchronize the two forms...

I have created a combo box and when the user clicks for ie "People Development" a form will open. I have done that. But I want to display a message box with Yes and No and when the user clicks on Yes the form will open automatically. How do I store the value of the response in VBA. A sample...