Search results for query: *

I'm tring to do something that is similar to thread68-1615386 but I am not having much luck. I'm using excel 2010 and I am trying to do this. Given a lookup table Range markup 0-10 4 11-20 3 etc I need to take a value and return the markup. So $10.36 would return 4. $11.89 would...

Using SQL 2000 I have two tables. At the begging of the day both tables are identical. However, at mid day the dynamic table updates and it takes about 40 minutes to load the updated data (about 2 million rows). During this reloading time, my application is in a blackout time since this huge...

Im using vb 2005 and have a question about the return code I'm getting from WNetCancelConnection2. I am getting a huge numbers like 1244963895005677770 and 1239615827498500096 It is disconnecting my network share as I expect but why the weird return results? Private Declare Function...

Hey all. I'm using sql 2000. I have a query that I need to speed up. It only takes about 3 seconds to run it but I'm running in a cursor at the moment..I know that's bad. It takes about 26 minutes to run and need to reduce that as much as possible. I'd post the execution plan but I'm not...

using sql 2000 I've been working through a report and managed to get to where I need. Only problem is I used a cursor! It is VERY slow. Anyone willing to try to help me get rid of the cursor. Here is the query. Declare @Parent Varchar(25),@ChildPer int,@HLA_REQ int,@LLANeeded int,@ChildPN...

Hey all. using VS 2005 and excel 2000 I've create an excel spreadsheet and populated it with the data I need. In the same spreadsheet on a new tab I need to create a pivot table. I've read various articles and looked at examples but I still can't get it to work. Here is how I populate my...

This is kinda of a VB 6 VB 2005 question. I posted it in the .Net forum but if anyone would like to take a look and offer any advice I'd be greatful. thread796-1617693

I have a program that displays a schedule in a nice visual format that is easy to see and understand that is written in VB6. It updates from a form timer every 5 minutes. I've re-written the actual scheduling program in VB 2005. The 2005 application feeds the database with data that the VB6...

Using Vb 2005. I have a listview that I allow the user to drag and drop items up and down the list. I need to put some rules around how far certain items can be dragged up or down the listivew based on a column in the listview items that it is being dragged over. An example would be something...

Using SQL 2000 I've got about 4000 records that have 4 columns with numbers in them. I need to take the minimum number from the 4 columns and place it in another column. Is there a way to do it without selecting each value and gonig through the if this one is less than that one..... The...

I'm moving an app from vb6 to vb 2005. In vb6 I have this code. For x = .ListView1.LBound To .ListView1.UBound For y = 1 To .ListView1(x).ListItems.Count LVData(x_ary) = "Exec [dbo].[USP_Save_Data_Master_Scheduler] " LVData(x_ary) = LVData(x_ary) & "'" &...

I'm converting a VB 6 app to 2005. I'm having a hard time getting back my paraments from a SP. Can someone help? SQLCmd.Connection = clOpenConn.clOpenConnSQL SQLCmd.CommandType = CommandTypeEnum.adCmdStoredProc ' adCmdStoredProc SQLCmd.CommandText =...

For some reason the auto generated code is showing up in my code window. Is there a way to turn this off so I can't see it? This is an example of what I see now. I don't know what made it start being visible. <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Partial Class...

I'm trying to move a picture box randomly around a form and make it smaller each time. I can't seem to get the picture box to move to the upper right and lower left. Here is what I have so far. Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

Using sql 2000 I need to update only rows that have changed data. The incoming data is from a VB front end that passes parameters to the SP. I currently update the rows whether they need it or not, but this is causing the LAST_UPDATE field to be changed when none of the other data changes. I...

Hi all. I've used the answer in thread183-1571629 to unpivot a sql 2000 table. Now I need to take it one step further but I'm not sure where to start. I now have data that looks like this. RELATIONSHIP ASSY PARENT 011212001013T CHILD 120989007013 PARENT 011212001013T...

I'm trying to take the weekends out from a date range. What I'm doing is letting the user look forward or backward any number days, months or years and tell them how many days there are with and without weekends. It's part of a planning tool that I've been trying to build so we can get a ball...

I need to reference an aliased column from my select list in another part of my select list. I have it currently where I just repeat the way I got the aliased column but it's hard to ready and looks bad to me. If this "look" is ok then I'll go with it. Just want to try to be as friendly as I...

I have an SSTAB control which has a listview control array on the tabs. When I first load each listview control array on the tabs everything is fine. I have a refresh button in the tool bar that calls the FORM_LOAD event again. What's happening is that after running the form load event again...

Using SQL 2000 I have a SP that I run when asked to provide some data. I've been asked to make this available real time. No problem, just plop the SP into a view and I'm done. Not so easy I'm finding out. The view doesn't like the line in red: create view V_ON_TIME_DELIVERY as set...