Visual Basic .NET | Forum profile

You're passing a String to a method that expects a number. While it's not necessarily the best solution, you've been provided a solution to that already too: Quote: Code: math.round(val(textbox1.text),0)

Don't post code and say "Hopefully doing it not wrong". That just makes it look like you aren't trying the code yourself, but fishing for someone to just do it all for you. If you tried it, and it didn't work, then post back with the specific code you are using, and what SHOULD have happened, and what ACTUALLY happened, and that will make people more inclined to look at your issue and help you with a resolution.

Amend as applicable Code: Sub Sample() Dim frmDate As Date = Date.Now.AddDays(-180) Dim toDate As Date = Date.Now.AddDays(-90) Dim SaleDate As Date = New Date(2008, 12, 3) '<~~ Example If SaleDate > frmDate And SaleDate < toDate Then Sold.sold1slddatetxt.ForeColor = Color.Yellow End If End Sub

The thing is when you add the values to your arraylist, you only add the SKU number Code: SKUSheet2.Add(currentField) However, the value you assigns to Pachow is some SKU number + " Total" Code: Pachow = textSKU.ToString & " Total" And that's why when you do an indexof, it never finds the item in the array list because none of the items in the array list has the " Total" suffix.

Re-think that design. Adding new controls for every type of new entry is going to cause you no end of headaches. Take what is entered into the textboxes, store that information somewhere (database, text file, XML, or just in Lists, if you don't want it to persist in the program), then clear the textboxes so that they can be re-used.

Quote: Originally Posted by koolsid Amend as applicable Code: Sub Sample() Dim frmDate As Date = Date.Now.AddDays(-180) Dim toDate As Date = Date.Now.AddDays(-90) Dim SaleDate As Date = New Date(2008, 12, 3) '<~~ Example If SaleDate > frmDate And SaleDate < toDate Then Sold.sold1slddatetxt.ForeColor = Color.Yellow End If End Sub Thanks I dont understnad the line Dim SaleDate as Date = New Date ????

Thanks! That's great! I'll test it out tomorrow.

What are you trying to do that would require that?

Quote: Originally Posted by mickey_pt @Pradeep1210 I think the problem it's other... He says that can copy the files to the folder manually, and when try to do that by code, it throws the message that the file it's in use, so the problem it's in the code, i think he after sending the email doesn't release the file... It could still be a file access problem rather than something in his code (though I don't deny this)....

The image looks good. But I can't think why you want to tile it rather than scale it. Your DrawImage statement will take care of scaling - just change the size of the rectangle. If you do, use e.Graphics.InterpolationMode = HighQualityBicubic for the best results. As one who has taken a vow of Option Strict=On, I envy the terseness of this: Code: Me.Location += (e.Location - DM2) Get thee behind me, VB6 But I think you could do without...