[RESOLVED] Tabstrip controls

I have a TabStrip control with 2 tabs. The first tab (circulation) has a ListView showing all the movies in the database. The second tab (details) is suppossed to display the details of the movie. I want to code it in such away that as long as a movie is highligted in the ListView, when you click on the details tab, the details of the movie that was highlighted is shown. The same effect should be seen if I double click on a selected movie in the ListView. How can I code thatt?

1 - u should use the SSTab Control - its better since it is a container control ;)

but here is what I would do..

VB Code:

Private Sub ListView1_ItemClick(ByVal Item As MSComctlLib.ListItem)
 
End Sub

put you code in here that fills out the movie details.. so it load when u click the item

I like the TabStrip Better all you have to do is to put the controls into a Picture Box or other container and hide and show depending upon which tab is clicked.

Just wanted to mention that the TabStrip is working fine except I don't know how to code in order to display the details in the 2nd tab based on the selected item in the ListView control on tab1. Any suggestions will be welcome

are you able to load the details in the second tab based on the selected item in the listview?

ganeshmoorthy, I am unable to and that is what am really trying to establish how I can do it. Mind teaching me how it is done?

Any one out there who might be having an answer for me?

I have text boxes inside a frame and this frame is one of the tabs on a tabstrip control. I want the controls filled with values from a recordset. Am using:-

txtFirstName.Text = rsr!FirstName

but the text does not show in the textboxes on form load event. Could it be that there is a special way of referencing these textboxes in a tabstrip environment?

txtFirstName.Text = rsr.Fields("FirstName").value

not like that?

Hi Kaine,
Your method and mine work in a similar way. The thing I dont understand is why the textboxes are not getting filled with values when in the tabstrip control but appears on anormal form that has no tabstrip control.

I have sorted it out. It was my program flow that was causing this problem. However, I still have one problem. How do I ensure that the controls on the details tab are filled with values from a recordset corresponding to the selected item in the listview control in the first tab? Does it include a SELECT code that has a WHERE clause? If so, how can I code that?

Thanks

i think, yes. it's like msflexgrid. the code below is similar to what u want i guess, i know the tab code is wrong, heh, eg:

VB Code:

SELECT * FROM your_table WHERE your_table.XXX = '" & selectedlist & "'"
 
details_tab.(somthing i forgot) = msflexgrid.textmatrix(msflexgrid.rowsel, column)

I have written a SELECT code as:-

VB Code:

Private Sub ListView1_DblClick()
Dim strSQL As String
strSQL = "SELECT * FROM users WHERE UserNo = " & ListView1.SelectedItem & ";" 
rsMovie.Open strSQL, cnAddMovie, adOpenDynamic
txtFirstName.Text = rsMovie.Fields("FirstName").Value
txtLastName.Text = rsMovie.Fields("LastName").Value

But when I double click I get an error stating " Operation not allowed when the object is open." What could be the problem?

i think u missed the table for UserNo? shouldn't it be users.UserNo?

VB Code:

Private Sub ListView1_DblClick()
Dim strSQL As String
strSQL = "SELECT * FROM users WHERE users.UserNo = " & ListView1.SelectedItem & ";" 
rsMovie.Open strSQL, cnAddMovie, adOpenDynamic
txtFormat.Text = rsMovie.Fields("UserId").Value
txtTitle.Text = rsMovie.Fields("LastName").Value

Am still getting the error " Operation not allowed when the object is open."

What could be the problem?

mm.. try to add this code below the txtTitle.text

rsMovie.close
set rsMovie = nothing

Still same error

VB Code:

strSQL = "SELECT * FROM users WHERE users.UserNo = '" & ListView1.SelectedItem & "'"

try that

Same error. The rsMovie.OPen statement is the one highlighted

I have sorted it out. The controls get filled. Thanks all for your support

i think u have two recordsets of the same name opened, that's why it states to that error.

My tabstrip control is named tabCirculation and the controls are in a container known as fraDetails which is an array. I have managed to fill the controls with the values from a recordset. My next question is:- When I double click the selected item in the ListView control, the second tab in the tabcontrol should be opened. How can I call the second tab on the double click event in the ListView?

on your double click event write

VB Code:

tabCirculation.Tab = 2

Am getting a compile error: Invalid use of property (.Tab = 2 is highlighted)

Im sorry, I thought you are using SSTab. I never used TabStrip. Why dont you try with SSTab.

If I place the code :- fraDetails(1).ZOrder 0, it displays the controls on the second tab but the tab itself is not selected.

Anybody experienced with tabStrips out there?

sorry osemollie, even i use SSTab. why don't you give it a try? lots of people use SSTab.

HI Kaine,

Thanks for your suggestion. Am learning VB and I just wanted to know how I can use different controls in VB. I know how to use the SSTab but I will also benefit if I know how to use the tabStip. Actually am almost there! It is just this one hiccup and I will be done. I know someone out there must be knowing how to use the control efectively. Thanks.

I do not know if this will help, but I learned a little reading this post.

I read up on tabstrip in VB Help. It says you want to use .hide and .show instead of useing .zorder=blah. Dunno if you already tried using hide and show instead of zorder.

If it doesn't help sorry =)

maybe fraDetails(1).tabindex(index).show?

Un fortunately those do not seem to work.

why dont you consider my post#25. you will have a good control over SSTab

I give up! Should someone get an answer, let me know. Thanks ALL

NOT SO FAST!!

I got it!!! For any one who might be interested, use

tabCirculation.Tabs(2).Selected = True

Thanks all for your help!!

good, finally you got it by your own....congratulations...