Search results

Hi, I have created a macro wherein some functions are executed.This macro is invoked on the click of a button.How do I teminate the execution of the macro when an eror occurs in any of those functions?Pls let me know. Thanks, Savita

Hi, Facing the foll. issue while programming in excel.Pls help. 1)There are two sections of data having 15 rows each in the worksheet.One has forecast sales data and the other has actual sales data. 2)User selects a cell in the first section.Say the row number of this cell is 5. 3)We have to...

Hi, I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can achieve this?Is there a way by which I can fire the double click event of Detail section of the subform from the main...

Hi, I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can achieve this?Is there a way by which I can fire the double click event of Detail section of the subform from the main...

Hi, Is there a way to programatically set the current row in a datasheet(subform) (without clicking the row)?Pls let me know.By default,the first row in the subform gets set as the current row.What do I need to do if I had to set it programatically to, say 4th row? Thanks, Savita

Hi, Is there a way to programatically set the current row in a datasheet(subform) (without clicking the row)?Pls let me know.By default,the first row in the subform gets set as the current row.What do I need to do if I had to set it programatically to, say 4th row? Thanks, Savita

Hi, There is a requirement for 1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented? 2_To click/double click a record in...

Hi, There is a requirement for 1)Populating a datasheet in a subform with a querystring which is dynamically built in VBA.This querystring is constructed based on the search criteria fields selected by the user in the main form.How can this be immplemented? 2_To click/double click a record in...