Recent content by Savita

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

Section2 is below section 1 on the worksheet.

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

Thanks.The issue of displaying data in datasheet view and reading data from a selected record got resolved.I have created a new form in datasheet layout and opening it from the main form. Is there a way to embed this form in the main form instead of opening it in a separate window.I would like...

Thanks. Any solution for 2nd point?I need to double click/click a record in the datasheet and populate some textfields (which are on the main form) with the data in the record. I tried associating DblClick event with the subform(child0) with the foll. code.But the event Chil0_DblClick gets...

Thanks.Let me make things more clear. The issue is that I am enhancing existing code .There is a form with some textfields and comboboxes.I select those values,click a search button to display records in the listbox.There is a function which builds a SQL dynamically and populates the listbox...

Thanks for the response. 1)Pls let me know a way to populate the subform(datasheet view) with a querystring passed from the main form.The query string has a join on 2 tables. 2)How can I extract data from the datasheet on double clicking the record.I want to populate textfields and comboboxes...

Thanks for sending the link.As per the example given in the link,I used the following code in the form_load() event to populate the subform(Child0) and display records in the datasheet view. Me.Child0.Form.Recordsource=strSql (strSql is a query string which has a join on 2 tables) But I got the...

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