msflexgrid Q.

[ukmdb]

when a user performs a search.
I have a msflegrid that shows the result.

the user can print them results listed.

BUT. i need to add an extra funtion. and i am stuck.
i want the user to be able to click on the rows they want to print from the search results given

ie. Say a list of 22 results was listed, Instead of printing all 22 results, They just want to click on the first 3 and the last 3 and click on print and it will print them 6

hope it makes sence.
and thanks for all your continued help.

I am using vb6 and msaccess 2002 with the database converted to msa97

[chatty]

What you can do is add another column called print or something like that and this code

Private Sub MSFlexGrid1_DblClick()
If MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) = "" Then
    MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) = "Y"
ElseIf MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) = "Y" Then
    MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) = ""
End If
End Sub

and when you print the information go and look at the grid and select only those that is marked Y and print those files.

Hope this is what you were looking for

[James Stanich]

My selection in grid example :

[ukmdb]

Thanks guys, Your rearly increasing my learning curve.

James.

There seems to be an error here
Type mismatch

Me.lblText(2).Caption = _
FormatCurrency(CDbl(Me.lblText(2).Caption) + Me.MSFlexGrid1.TextMatrix(LGROW, 1), 2)

Looks like i could use this example if i can get it to work.

Thanks

[James Stanich]

Weird, I am not having the problem over here...