Comments by Member 7940184

Member 7940184 21-Sep-11 0:56am View

ThankQ for yor reply.Without any Settings is it possible?bcoz i want to run this excel in number of systems,changing settings in each and every system is not good..
Thanks in advance

Member 7940184 27-Jun-11 2:41am View

Thanks for ur replies prerak,its working fine for some extent.
But i am having cells content>10 for some cells and<10 for some cells.I want whole name in the cell and format also should be correct.Is it possible to do it??great thanks for ur reply

Member 7940184 27-Jun-11 2:23am View

Thanks for ur replies prerak,Its working fine for some extent.
But i am having cells content>10 for some cells and <10 for some cells.I want whole name in the cell and format also should be correct.Is it possible to do it??great thanks for ur reply

Member 7940184 24-Jun-11 3:04am View

Error is coming at String() not at pad()

Member 7940184 24-Jun-11 2:59am View

Call pad(Sheet6.Cells(j, i).Value, "", "Left", 10)

Sub pad(svalue, spad_text, stype As String, imaxsize)
Dim length
length = Len(svalue)
If stype = "Left" Then
svalue = String(imaxsize - length, spad_text) & svalue
else
svalue = Value & String(imaxsize - length, spad_text)
End If
End Sub

Error:Invalid procedure call or argument

Member 7940184 24-Jun-11 2:47am View

it is giving error at:String(imaxxsize-length,spad_text)
Whats to add instead of this

Member 7940184 24-Jun-11 0:41am View

It is showing Error:Invalid procedure call or argument at

svalue=String(imaxsize-length,spad_text)& svalue

Please update and send me the code..Even i try with replace also but i am not getting correct result

Member 7940184 24-Jun-11 0:39am View

Deleted

It is Showing Error: Invalid procedure call or argument at

svalue = String(imaxsize - length, spad_text) & svalue

please update and send me the code

Member 7940184 25-May-11 4:39am View

Deleted

Sorry for not giving full details about my last post…
I have written insert and update queries in DGV_leave event as

sql = "insert into table1(Sno,BriefDescription,Jan) values(" & DGV(0, e.RowIndex).Value & ",'" & DGV(1, e.RowIndex).Value & "'," & DGV(2, e.RowIndex).Value & " )"
adp.InsertCommand = sqlcon.CreateCommand()
adp.InsertCommand.CommandText = sql
adp.InsertCommand.ExecuteNonQuery()

sql1 = "UPDATE table1 SET Year=" & cbyears.SelectedItem & " where Sno=" & DGV(0, e.RowIndex).Value.ToString() & " "
adp.UpdateCommand = sqlcon.CreateCommand
adp.UpdateCommand.CommandText = sql1
adp.UpdateCommand.ExecuteNonQuery()

queries are executing fine and databse is also updating……
As I hve written this lines in dgv_leave event, every time this code is executing and getting error as:Validation of primary key constraint:cannot insert duplicate key..
Even while form(having DGV) loading also this error is coming..
When I perform changes to my DGV then only row_leave event wants to be execute,how?

Plz give any idea..

Member 7940184 23-May-11 7:11am View

Ya its working thank you..

Member 7940184 23-May-11 0:56am View

But my table have primary key already and am using identity for autoincrement that value.is it the problem for getting those error.

Member 7940184 20-May-11 7:06am View

ThankU

Comments by Member 7940184 (Top 12 by date)