Posts by debasisdas

Have you tried as suggested in post #2.

You need to handle the Key Down event . Set the KeyPreview property of the form to TRUE.

You mean to say the remaining text will go to next line or be hidden ?

Try using looping through all the controls on the form that have font property.

What exactly you want to achieve and what you have done so far ?

Simply try using SUM(column_name) using SQL query.

What name ?
Name of the file ?

or something randomly.

Our little time of suffering is not worthy of our first night's welcome home to Heaven.

Have you tried as suggested in previous posts.

WHAT YOU HAVE TRIED SO FAR ?

If you want the connection string then find it here.

Please do not start duplicate threads for the same question.

Check your other thread for answer. I have already replied to that.

Check that you have enough disc space and RAM.

You need to convert the access database into 97 format .

ASCENDING is default for DESCENDING you need to specify DESC after the field name.

Have you tried refreshing the recordset ?

Are you commiting after every new insert / update ?

What exactly is your project about ? You are using VB only or any third party component ?

My previous code adds the items to listbox on check of check boxes and removes them from the list on uncheck.

Look to be treated by others as you have treated others.

Kindly the post the code that you are working on.

try using this sample code.

Private Sub CHKCOLOR_Click(Index As Integer)
If CHKCOLOR(Index) Then
List1.AddItem CHKCOLOR(Index).Caption
Else
For L = 0 To (List1.ListCount - 1)
If List1.List(L) = CHKCOLOR(Index).Caption Then
List1.RemoveItem L
End If
Next
End If
End Sub

The code uses control array for the check boxes.

How you are saving data. Is it related to database ?

Try to use ADO code for better result.

Try using data report.

Please check for the connection string here

The problem you are facing is not because of this code . You might have specified something else in other parts of the code.

Man can be happy with much less than he seems to think essential.

elow..debasisdas...
by the way the code that you given it not working....
their no error but only listview without any data...
my datagrid contain some..but my listview dont have any one...

That code works fine for me.
Try to run the code in debug mode and check .

Actually that code was to populate the list view from a tree view selection.

Try using on button click event

You need to hard code that.

You can try to refresh the recordset.

Please refer your other thread for reply. I have already answered your second question there.

you need fetch the data from recordset and assign the same to the corresponding text boxes. You need to use index or field name on the recordset.

From you code i am not at all sure what you want to do. Could you explain a bit.

in sql *plus type HOST

in the command prompt type

exp username/password@databasename

then just follow the instructions as prompted

I don't know whether i can post name of other sites here or not. You can easily find all that by investing some quality time by web searching.

He who has learned how to obey will know how to command.

To read binary files use PUT and GET.

Please mention the error clearly.

BTW this is an English only forum so please use English only as your mode of communication.

From where you want to capture the score ?
Are you using any database ?
BTW the above code is a procedure not a function. A function must have a return type and must return a value.

Simply try to use this sample code .
This is the best option.

con.begin trans
con.execute "update table_name set field_name= text1.text"
con.committrrans

Try use this sample code

Private Sub tv1_NodeClick(ByVal Node As MSComctlLib.Node)
LV1.ListItems.Clear
rs.Open "select * from EMP", con, adOpenDynamic, adLockOptimistic

Dim li1 As ListItem
Set li1 = LV1.ListItems.Add()
If Not rs.EOF Then

If IsNull(rs(0)) Then
li1.Text = ""
Else
li1.Text = rs(0)
End If

If IsNull(rs(1)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(1)
End If

If IsNull(rs(2)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(2)
End If

If IsNull(rs(3)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(3)
End If
If IsNull(rs(4)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(4)
End If
If IsNull(rs(5)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(5)
End If
If IsNull(rs(6)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(6)
End If
If IsNull(rs(7)) Then
LV1.ListItems(1).ListSubItems.Add , , ""
Else
LV1.ListItems(1).ListSubItems.Add , , rs(7)
End If

End If
rs.Close
End Sub

Then better change the row width.
It is always better to use some reporting tool than controls for reports.

Go back a little to leap further.

Is that some sort of an assignment for you . Why not use some multimedia tool for all that.

Can you mention your exact requirments in details please.

To avoid duplicate addition you need to check that before adding the item to the tree view.

To run .NET application framework is compulsory.
You can easily install the framework using windows live update.

This one is one of the best in the business.

Then you can directly call the form with its corresponding event. But i am not sure what do you mean by I made a menu with ListView.

I am bit confused with your logic. Not sure what do you mean by that suspect.