Search results for query: *

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...

I have created an OLE OBJECT for one of the control. I have decided not to store the picture in the database (embedded) rather to link it (linked). So I have changed the property to "linked". Now how do I display the image automatically on the form when it is opened. The way I have it now is...

I have created two forms based on one table "tblEnhancedWorkOrder" with their own underlying queries. Let's call the table "tblEnhancedWorkOrder" and it is linked to the table "tblProductionRun". For each production run there could be more than one enhanced work order. If the user select...

thanks a lot. That worked great. Micosoft should seriously think about fix the problem.

I am working with a huge database that has a lot of forms. I would like to rename a form as it is not user friendly but if I do that I have to manually go to all the controls that uses its name and rename it. I have tried to go into the VBA code and useed "find and replace by" function to...

I have created a form with a tab control that has several pages and I have chosen sumi painting for the form layout. When I move my cursor to a text field or label on any of those pages in the tab control the screen or the form flashes or blinks. The problem is resolved when I choose standard...