Search results

I have a main form containing a subform control that is related to a subform based on a crosstab query. The crosstab query column header and its value records are inserted by the user at run time through a textbox and a button on the main form(but only one field selected as the column header in...

Observations are that mouse clicking a column header, then clicking the menu sort a-z button, it works. That means that Access detected and knew which column header was clicked. How should I code to do the same detecting the clicked column header? I am new to MS access, could anyone shed...

I have a main form contains subform control that is related to the a form based on a crosstab query. The crosstab query column header and its records are inserted by the user at run time. To show the newly added column header records on the right hand side of the subform, I set its...

I created a MS Access 2002 form, which contains the crosstab query. User opens the form and can view the crosstab query pane record and it's cool, then the user clicks a button on the form that will through SQL procedure to add a record to the existing column header (and its values), then the...