MSFlexGrid Wizard

[eyeRmonkey]

Ok, I am at a complete loss as to where the MSFlexGrid Wizard is or how to use it. Dglienna posted an example for me a few days ago, but that was after using the wizard and I still don't know where it is.

Also, what other controls are similar to the flex grid? I am looking for one that gives the same effect as iTunes and selects the entrie row when you select 1 item in the row (although I bet that needs to be coded in). And I need to be able to have fields in the grid be editable, but not all of them. Are there other controls out there that can accomplish this?

[dglienna]

I've never used the wizard, just learned here and on my own. Search for floating textbox, and you will find samples that let you edit cells. And about selecting the row column:

Look at the properties.

AllowBigSelection Property Example
The following code example allows an entire column or row to be selected when the user clicks on the header.

Sub Form1_Load ()
   MSHFlexGrid1.AllowBigSelection =True
End Sub

[eyeRmonkey]

Hmmmm... Okay, then can you point me to a tutorial or something. Nevermind: "Google is my friend"

I'll go re-read the comments in that mini-app you posted for me. I thought those were generated by the Wizard, so I ignored them.

[dglienna]

Search vbf for "floating textbox" and you will see szlamany's posts that got me started last year. For my main project, I just use a few text files, but display all my info in textboxes, and print it to an rtb using tables generated in Word and saved as rtf.

[eyeRmonkey]

... For my main project, I just use a few text files, but display all my info in textboxes, and print it to an rtb using tables generated in Word and saved as rtf.

Maybe I am tied, but you totally lost me there.

[dglienna]

I use the floating text box to enter and edit data, and then print it out into Word documents, and replace tags using a richtextbox. This gets 45 fields and an image printed into nice boxes that are supplied by Word (they call them tables)

[eyeRmonkey]

I guess I am missing the point of including a word document and RTB. Maybe I should read up on how to use the floating text box/flex grid first. That might help me understand what your talking about.

[eyeRmonkey]

dglienna, back in the day when you knew about at much as I do now:
http://www.vbforums.com/showthread.p...oating+textbox

I'm still kinda lost. I guess I should go play with stuff instead just expecting to understand it after readin about it. I'll post in a little while if I am still lost.

[dglienna]

Yup, I got about 1/5 of the way into my program, and found out that there might be better ways than to use a console app and write to the screen (like I did for the previous version in QB). I was using all this data that was stored in arrays, and needed a way to show it to the user. It worked out very well. I here they took them out of Net, though.

[eyeRmonkey]

Now that we are quite off the subject: Anyone know where I can find the wizard?

[eyeRmonkey]

I figured out how to select by column:

.SelectionMode = flexSelectionByRow

[dglienna]

You use flx.textmatrix(row,col) to select/change a cell.

[eyeRmonkey]

I know that. Like I'm sure you know by now, I am trying to make it like iTunes and I needed a way to force the user to select a row at a time and this does it for me without me doing any extra coding.

[eyeRmonkey]

I'm still wondering if anyone knows where I can find the MSFlexGrid Wizard.

[dglienna]

Post #2. Lets you select a row or column by clicking on the heading. If you want the user to select a cell, then you'd have to do it programmatically.

[dglienna]

The only flexgrid wizard is actually a Data Form wizard, used with ADO Data Access. I just found it in the help section, searching for MSFLEXGRID WIZARD.

[eyeRmonkey]

Post #2. Lets you select a row or column by clicking on the heading. If you want the user to select a cell, then you'd have to do it programmatically.

Yeah, but I need to be able to do it when they click any cell. And I figured out how to do it, and I posted it incase anyone else was wondering.

The only flexgrid wizard is actually a Data Form wizard, used with ADO Data Access. I just found it in the help section, searching for MSFLEXGRID WIZARD.

I finally got ADO 2.8, but I'm still not sure what to do with it. I guess I could go check out those examples you gave me that I couldn't get to work before.

[-terry]

MSFlexgrid wizard is a component. Project/components/MSFlexgrid wizard