Recent content by nisha

actually the textbox used is an Active x control (OLE Class - Microsoft Forms 2.0 and class - Forms.TextBox.1) . Guess that is locked is not making it not editable. For normal textbox i tried and it is getting locked fine.

both the properties if i set it turns out grey..:o and the border also is set to transparent... i made locked = true.. but still user can key in values in tht text box..

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

thanks for ur response.. i used listbox instead of listview n now it works fine... [:)] Thanks all...

sorry for the late response.. was stuck up with some other issue. However.. have not got any solution for the same.[:(] I have used on error goto statement and no errors. The code is executing fine and finally the focus is also getting set. Let me know anyone wht else next..:confused:

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

i am using access 2003 version. The control class reads "ListViewCtrl" and OLE class reads "MSComctlLib.ListViewCtrl.2". yes its an active x control

thanks for the code.. But still its not working... is there any difference between a listview and a list box.. the sample mdb is using list box but in my code i am using listview control. StrItem = lvSeqList.ListItems(nIndex).Text Me.lvSeqList.RemoveItem (nIndex) Me.lvSeqList.AddItem...

oh ok... the problem is though i select an item to move it down the statements in the code are getting executed fine but still the list view items remain in the same order. I want anyone to validate on the logic i have tried to implement.

I am using this following code to move the list item down. but some how its not working.. please let me know wht needs to be done..... Private Sub cmdDown_Click() On Local Error Resume Next If lvwLinks.SelectedItem.Index < lvwLinks.ListItems.Count Then Dim strTemp As String...

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