Search results

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

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

i have a template file and i want to load few fields in that template file with the data from a recordset or however possible. Any code samples to do the job mentioned. Jus to add on i am using Access 2000 cause of some requirement.