Thanks for your reply. could you tell me the steps to attach them to new installation? I hate mcafee it created too many problems for me!!

Hi all. A few days ago i installed mcafee total protection 2007 and that disabled my internet connection totally!! I couldn't fix it so i had to uninstall it. After uninstalling mcafee total protection 2007 still i couldn't join Internet!! So i got mad and went and made repair installation of windows xp pro. After repair installation i couldn't activate it since Internet connection was still not working!! So i went and installed another copy of xp pro on different folder and named it WINDOWS (old one was WINDOWS2).Thanks god now i could join Internet but all my shortcuts and menu items are not visible. Unfortunately I can't even start sql server 2000 either!! could any one tell me what should i do in order to get access to all database tables and data that i had in sql server and make a back up. I didn't install any new sql server yet. I be happy if an expert tell me what should i do. The installation folder of old windows(WINDOWS2) is still available along with sql server installation folder.Thank and looking forward for reply.

same overflow error:-(( Private Sub Form_Load() mStart = Timer 'Set up the listview ListView1.View = lvwReport ListView1.ColumnHeaders.Add , , "Artist" ListView1.ColumnHeaders.Add , , "Name" ListView1.ColumnHeaders.Add , , "Image" ListView1.ColumnHeaders.Add , , "Rating" 'ListView1.ColumnHeaders.Add , , "Song ID" ListView1.ColumnHeaders.Add , , "Total Votes" ListView1.ColumnHeaders.Add , , "Page" ListView1.ColumnHeaders.Add , , "Referrer" ListView1.ColumnHeaders.Add , , "pageWindowName" Timer1.Interval = 1000 ' <-- 10 seconds Timer1.Enabled = True End Sub Private Sub Timer1_Timer() ListView1.ListItems(1).ListSubItems(4).Text = Format(TimeSerial(0, 0, CLng(Timer - mStart)), "hh:nn:ss") End Sub

Now i get this error in the same line: Run-time error 6: overflow

I tried it i get the following error: compile error: syntax error pointing at : ListView1.ListItems(1).ListSubItems(4).Text = Format(TimeSerial(0, 0, cint(Timer - mStart), "hh:nn:ss")

I have frame and listview1. I want to hide the frame when i click(left click or right click) on white area of listview1 where is there is no data (As shown in attched pic).could any one show me how this can be done?Thanks Private Sub ListView1_Click() gstrSomething = ListView1.SelectedItem.SubItems(4) gstrSomethingElse = ListView1.SelectedItem.Text Frame1.Visible = True End Sub Private Sub ListView1_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single) Dim lvwItem As ListItem If Button = vbRightButton Then Set lvwItem = ListView1.HitTest(x, y) If Not lvwItem Is Nothing Then Frame1.Visible = True lvwItem.Selected = True PopupMenu mnuEdit Else Frame1.Visible = False End If End If End Sub

Hi all i created 3 tabs so i be able to switch between webbrowser and listview. I want the first tab to be select by default onload of the form. could any one show me how this can be done?Thanks Private Sub SSTab1_Click(PreviousTab As Integer) If SSTab1.Tab = 0 Then WebBrowser2.Visible = True Else WebBrowser2.Visible = False End If If SSTab1.Tab = 1 Then ListView4.Visible = True Else ListView4.Visible = False End If 'If SSTab1.Tab = 2 Then ' WebBrowser4.Visible = True 'Else ' WebBrowser4.Visible = False 'End If End Sub -- modified at 19:55 Thursday 10th May, 2007

Many thanks for trying to help me:-). I am working on vb6 for this project. VB6 has listviews by selecting Microsoft windows common controls 6.0(sp6) component. I have seen a few applications not sure what programing language they are written it .They add timer to listview without noticing any flicker or reload!!

I placed "private mStartDate As Double = Now.Ticks: inside a module. Then i added timer to the form an set its interval to 1000.Then i added following code: Private Sub Form_Load() Timer2.Interval = 1000 ' <-- 10 seconds Timer2.Enabled = True End Sub Private Sub Timer2_Timer() Static lngMin As Long lngMin = lngMin + 1 'every 2nd timer tick reload the listview If lngMin Mod 2 Then Dim s As String = TimeSpan.FromTicks(Now.Ticks - mStartDate).ToString ListView1.ListItems(1).ListSubItems(4).Text = s.Substring(0, s.IndexOf(".")) End If End Sub then i get compile error : Expected: end of statement pointing at: private mStartDate As Double = Now.Ticks

Thanks for you reply. I tried the following and it only display the current time!! I wanted to start from 00:00:00 and start running ListView1.ListItems(1).ListSubItems(4).Text = Format(Now, "hh:nn:ss")

Thanks for you reply. could show me how to add 'now' and format it to be hh:nn:ss ... I am adding item to listview like this : ListView1.ListItems(1).ListSubItems(3).Text = "changed2" so how to add running time instead of change2? Do you think using this method will make the listview reload every seconds? i hope that is not the case since it will disturb form focus. I have seen applications that they add running time to listview column without any listview reload every seconds .

could any one show me how i can add clock timer that shows hour:min:seconds to a perticuler listview column ? I want to add running time as a listview -item. I have seen applications that they added timer to listview item and ability to freez it or reset it when diffrent events happens. There are a few other columns in my listview too. So i want add running timer to 3th column.I hope there be a solution that doesn't disturb the focous . I want to add this running timer in the 3th column of a row that i specify. Not all rows at once.So by default other rows i want it to have - and when i decide for example add running time to row 3 then it be added.I want to have the abiliy to freez the time when i want or remote it.

Dave thank you for reply.I am not very experienced vb6 developer.So i need some more information about this process. In my case i have a listview that it gets data from a dynamic xml file. I use timer to re populate the listview every few seconds. Obviously this cause lots of flicking and lose of form focus and i see lots of unnecessary listview reloads. Could you consider this case and let me know how to reload listview ONLY when new data has arrived. I have seen it many applications doing that but don't know how they do it!! Looking forward for some examples.Thanks

Hi all. I have seen many applications that listview ONLY updates when new data is avilable or when current data changes. I am making an application that deals with similar case. But i don't know how these applications achive this task. I tried to use timer to refresh my listview every few seconds(I am loading data from dynamic xml to listview.)But there is a big problem that i keep losing focus on the form and i see many unnecessary refreshes!! Could any one show me a better solution to avoid these unnecessary refreshes?I know these professional applications are using a method that i am not aware of.Thanks

which one ? how to use it in insert statemtn and how to query the table so i get output baced on time and date user entered my site.

so could any one show me the insert statemts that records both time and date in a way that can be quried and sorted baced on time and date. The page is triggered when a visitor visits my page and i records its visit history and later on show the logs baced on time and date of visits.Thanks

Hi all.I use $Timestamp=date("g:i A l, F j Y."); to collect time and date the visitors entered my site . It inserts the data in to mysql database in this format : 3:02 AM Monday, July 24 2006 [CODE]mysql_query("INSERT INTO logdisplay VALUES('$ID','$column1','$Timestamp','$column2','$columns3')"); $affected_rows = $sql->a_rows;[/CODE] But when i query the database and use order by ,the data does not get displaied in order of newest on the top!! [CODE]select * from logdisplay order by Timestamp[/CODE] could any one help me so that i get newst log records on the top .In another how to query my table baced on time an data.Thanks :confused:

well i do not know how to use it . could u show me how to extract it using either method and populate the listview.thanks

Hi all . could any one show me how to use [B]Microsoft HTML Object Library [/B] in visual c++ 6 to extract data from html and populate it in listview. I have done this in visual basic 6 and i posted the code below . I be happy if an expert help me convert it to visual c++ 6 since i need it for a project that has to be done in visual c++ 6. My current visual c++ code retrives html of url and all now i need to be able to do extract the data i wanted from html and populate the listview with that data. I shown a picture of output in the pic.Thanks code that retrives the html for me in visual c++ 6: void CFindUserDlg::OnButton4() { // TODO: Add your control notification handler code here HINTERNET hNet = ::InternetOpen("MSDN SurfBear",PRE_CONFIG_INTERNET_ACCESS,NULL,INTERNET_INVALID_PORT_NUMBER,0) ; HINTERNET hUrlFile = ::InternetOpenUrl(hNet,"http://www.mysite.com/Display.php",NULL,0,INTERNET_FLAG_RELOAD,0) ; char buffer[10*1024] ; DWORD dwBytesRead = 0; BOOL bRead = ::InternetReadFile(hUrlFile,buffer,sizeof(buffer),&dwBytesRead); SetDlgItemText(IDC_EDIT2,buffer); ::InternetCloseHandle(hUrlFile) ; ::InternetCloseHandle(hNet) ; } visual basic 6 code: Private Sub Command3_Click() 'this function places data into listview ' requires that you add a reference to the Microsoft HTML Object Library Dim mydoc As HTMLDocument Dim wombat As IHTMLElementCollection Dim lp As Long Set mydoc = New HTMLDocument 'mydoc.body.innerHTML = "

" & _ ' " > " & _ ' " " & _ ' " " & _ ' " " & _ ' " Name color tony 33023 cindy 16711935 sarah 3434343 " mydoc.body.innerHTML = RichTextBox1.Text Set wombat = mydoc.getElementsByTagName("TR") ' Get the rows For lp = 1 To wombat.length - 1 ' Ignore first row Set LI = ListView1.ListItems.Add(lp, , wombat.Item(lp).All.Item(0).innerText) ListView1.ListItems(lp).ForeColor = wombat.Item(lp).All.Item(1).innerText LI.ListSubItems.Add , , wombat.Item(lp).All.Item(1).innerText Next End Sub picuture of the output: [IMG]http://i5.photobucket.com/albums/y180/method007/ListViewPop.jpg\[/IMG\]

led i want to thank u i fixed that code it works good! :-))