Search results

Hi I want to make the text box disabled so that user is restricted for entering any thing but the text must be displayed in black color(default one). For this i made locked = true but still user can enter. Then i also changed the enabled to false. this restricted.. but is displaying the text...

syntax to throw exception from a method. i believe within a method i can handle errors like following: private sub method1() on error goto error1 call method2 statements1 statement2 error1: end sub private sub method2() '' here i want to throw an exception so that it bounces back in...

hi, i want help to implement the following logic. i have a table like this below: id description order k1 test1 1 k2 test2 2 k3 test3 3 now i want to load this data into a listview in front end arranging according to the order like test1 test2 test3. Till here i have implemented. now...

any ideas how to detect whether any workbooks are open? So that if they are not, then have code to open it ?? any sample code..

hi, i am trying to validate the data in the excel by taking it in the rowset and looping through that. Now if i find any invalida data i want to highlight that particular row. How can i do this. ??

hi, i am trying to validate the data in the excel by taking it in the rowset and looping through that. Now if i find any invalida data i want to highlight that particular row. How can i do this. ??

while using objWkb.Saveas method it gives me a pop up if the file already exists asking for replacing the file. How do i default it to yes and replace the file without prompting any message to the user??

I am trying to export the excel data to sql server using the following code. It works fine. but i want to select a range of data from excel starting from R5 ..instead of select *. How do i do that...??? any valuable replies?? Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset 'Dim...

I want to import data from excel to the sql server using ms access. I also want to identify the rows in the excel which are modified and then update only those in the respective tables in the sql server database. Any code samples to accomplish the above requirement??

Hi, I want to export the data from SQl server to an excel and then allow the user to modify the excel and update back the data to the sql server. Any suggestion on how to implement the above. The first part i.e exporting to excel is now working fine it will be great to know about the import...

Hi, I have two list box controls in a form . I want to delete the items from listbox1 after moving those to listbox 2. any help on this??

Hi, I want to know if i can access a word template file and add respective field values from MS - Access form. If so how?

Hi, I want to have a outlook window open and the To, Subject and Body to be automatically populated on click of a button in the access form. I should also be able to format the mesasge body. Can we use HTML tags here? If not any other means to accomplish the same. Message body should be as...

Hi, I am trying to create controls dynamically in the detail section and able to set the control source to the respective columns. But when i bind to the recordset the data is not getting bound. Any help on this .