Search results for query: *

What version of Excel are you on? That makes a differenece on how many characters a column can hold.

So another way to highlight an item in a ListBox is to use a ListView?" Misread it...just trying to be helpful.

Another way to do that: Private Sub Command1_Click() ListView1.View = lvwReport ListView1.ListItems.Clear ListView1.HideSelection = False ListView1.FullRowSelect = True ListView1.ListItems.Add , , "First Row" ListView1.ListItems.Add , , "Second Row"...

I always thought an update was a delete and insert but looking around I'm seeing "it depends". I see that is this post: http://dbaspot.com/ms-sqlserver/149740-how-does-update-statement-work.html In that post is reference to a book with more detailed information but I don't see it anywhere for...

I don't think you can "Move" table data around like that (where the move pshycially deleted the data). You will have to maintain it yourself. Delete is an integral part of SQL. What issues with that concern you?

I was looking at this on another forum trying to get help. Towards the bottom is a good explanation of wate is really happening. http://www.vbforums.com/showthread.php?710577-Label-does-not-refresh-on-load&p=4347549#post4347549

Leaving the label blank seems to be the key. If it is not when the form loads it hits the Lable changed event a second time putting back the original value not what was changed. Public Class Form1 Private Sub TextBox2_TextChanged(sender As Object, e As EventArgs) Handles...

I can reproduce that now...beats the crap out of me. I'm playing around with it now.

Oops...it is posted. I can't see why it is not working unless something is changing it after the fact.

Must be something you are not showing us. This works fine: Private Sub TextBox2_TextChanged(sender As Object, e As EventArgs) Handles TextBox2.TextChanged TextBox2.Text = "222222222222" Label4.Text = "Works for me" End Sub Post your code.

gmmastros is always worth listening to and heeding his advice [smile] I work in an insurance related field and there are certain calculations like standard premium, tabular reserve, etc. When I started supporting this existing system the calculations were often done over and over again in many...

The SP simply did not return anything. The Catch was not executed. Nothing. But I found the answer! TIMEOUT! I had a time out of 3 minutes.... Changed it to 6 Minutes and voila! It works just fine." Something must be missing from the error handling if it timed out and the application could not...

What do you mean by fails? Returns an "F"? In other words what is the error message?

You code build your select directly into Excel so when you open the spreadsheet it runs the SQL. There is a lot of information available on doing that on the internet. Here is one link: http://office.microsoft.com/en-us/excel-help/connect-to-import-sql-server-data-HA010217956.aspx

One thing about using the Windows schedular as mentioned, unless I set it up wrong when I did it, is when the password is changed you need to change it there too.

Maybe create a DTS package from VB based on the input? That would be MS SQL.

Maybe you could use a sleep API based on the input from the user to wake up the logic and do the database work. http://www.ex-designz.net/apidetail.asp?api_id=537 I'd put some logic in so they can't kick if off if it is already running. If App.PrevInstance = True Then MsgBox "Already...

I've never used a MSHFlexGrid1 before and I was just trying to determine if you were bringing data back. Sorry...I can't help from here.

I suggest you put in some error handling. Try this after the rs.open debug.print rs(0) Anything in there?

Thanks for responding imex. I've been looking and over and partition but I think that is the wrong approach. What you provided was not the desired output but it got me thinking. This seems to work: create table #temp(sectionid int, questionid int, text varchar(100)) insert into #temp select...