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

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

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

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