Results 1 to 18 of 18

Thread: VB - Write (directly) to an MSFlexGrid

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    VB - Write (directly) to an MSFlexGrid

    It is commonly believed that you can't write to an MSFlexGrid, or that you need to use a "floating" textbox. The attached project show how to do it without using a textbox.

    Usage: Create a project for the form, run it, and type into the grid.
    Attached Files Attached Files

  2. #2
    Banned jhermiz's Avatar
    Join Date
    Jun 2002
    Location
    Antarctica
    Posts
    2,492

    Re: VB - Write (directly) to an MSFlexGrid

    Originally posted by MartinLiss
    It is commonly believed that you can't write to an MSFlexGrid, or that you need to use a "floating" textbox. The attached project show how to do it without using a textbox.

    Usage: Create a project for the form, run it, and type into the grid.
    Martin...

    I had changed some code in my application...and now when I enter text into the floating text box I immediately get:

    Subscript out of range error ??

    Can you tell me why ?

  3. #3

  4. #4
    Banned jhermiz's Avatar
    Join Date
    Jun 2002
    Location
    Antarctica
    Posts
    2,492
    Originally posted by MartinLiss
    Hard to tell from this distance Post your project and when I get a chance I'll take a look.

    Err I cannot post it...it is huge and connected to a sql database.
    Can you vnc in ?

    Do you have www.tightvnc.com ? I'll let you shadow me ??

    Thanks,
    Jon

  5. #5

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427
    No, sorry, I don't have that app. Give me some time and I'll try to make some educated guesses as to what might be going on. In the meantime have you tried setting a breakpoint and looking at the row/column,etc variables at the time of the error?

  6. #6
    Banned jhermiz's Avatar
    Join Date
    Jun 2002
    Location
    Antarctica
    Posts
    2,492
    Originally posted by MartinLiss
    No, sorry, I don't have that app. Give me some time and I'll try to make some educated guesses as to what might be going on. In the meantime have you tried setting a breakpoint and looking at the row/column,etc variables at the time of the error?
    Nevermind I got it..stupid column number cause I had deleted a column and forgot to reindex

    Shanks,

    You should still get tightvnc..its great for shadowing

  7. #7
    pathfinder NotLKH's Avatar
    Join Date
    Apr 2001
    Posts
    2,397

    Re: VB - Write (directly) to an MSFlexGrid

    Just saw this thread.

    Nice, Thanks Martin!

    I've always used the cheap and easy input box popup method, but now this is #1!

    -Lou

  8. #8
    Fanatic Member vbPoet's Avatar
    Join Date
    Feb 2005
    Location
    Searching ..
    Posts
    669

    Re: VB - Write (directly) to an MSFlexGrid

    but marty uncle
    i m getting error
    on
    MSFLEXGRID1.highlight ....?
    what is this

  9. #9
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: VB - Write (directly) to an MSFlexGrid

    Quote Originally Posted by vbPoet
    but marty uncle
    i m getting error
    on
    MSFLEXGRID1.highlight ....?
    what is this
    Have you added the reference to the component?


    Has someone helped you? Then you can Rate their helpful post.

  10. #10

  11. #11
    New Member
    Join Date
    Jun 2005
    Posts
    7

    Question Re: VB - Write (directly) to an MSFlexGrid

    Hi, is possible do same in vb .net ? (whit the datagrid )

    Thanks from Mexico

  12. #12

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: VB - Write (directly) to an MSFlexGrid

    Quote Originally Posted by jorgegc
    Hi, is possible do same in vb .net ? (whit the datagrid )

    Thanks from Mexico
    Sorry but I don't know. You should ask in the VB.Net forum.

  13. #13
    New Member
    Join Date
    Jul 2005
    Posts
    1

    Re: VB - Write (directly) to an MSFlexGrid

    When I opened the form, it made the control MsFlexGrid1 a picturebox. Fix by deleting this control, clicking on "components" in "project" (CTRL-T) and selecting the Microsoft FlexGrid Control 6.0. Add the yellow icon thing to your form and call it MsFlexGrid1.

    This is a way of inserting data, but it obviously has its tradeoffs. No copy/cut/paste to clipboard, no selection, no delete key. But it's good for basic input where needed. Cleaner but with less freedom than a textbox.

  14. #14
    Junior Member JonnyPoet's Avatar
    Join Date
    Jan 2006
    Location
    Austria
    Posts
    19

    Re: VB - Write (directly) to an MSFlexGrid

    Hi !
    In the first view I really was astonished how easy that works. But testing a bit more I'm sorry to say, this is neat, but cannot be used in any professional solution. Because
    a) No textcursor in the field during typing, this is the main problem here and because of that
    b) no normal use of arrowkeys (left, right)
    c) no insert mode to be seen by switching Textcursors view
    d) even if you add some codes you will never be able to do what a normal textbox does.
    So IMHO it will stay what it is: A very intersting code example, no less, no more

  15. #15
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: VB - Write (directly) to an MSFlexGrid

    Quote Originally Posted by JonnyPoet
    Hi !
    In the first view I really was astonished how easy that works. But testing a bit more I'm sorry to say, this is neat, but cannot be used in any professional solution. Because
    a) No textcursor in the field during typing, this is the main problem here and because of that
    b) no normal use of arrowkeys (left, right)
    c) no insert mode to be seen by switching Textcursors view
    d) even if you add some codes you will never be able to do what a normal textbox does.
    So IMHO it will stay what it is: A very intersting code example, no less, no more
    Very simple but could be expanded to fit your needs. As an idea, look at this thread/code where TheVader has created a very nice example for LabelEdit-ing subitems in a listview


    Has someone helped you? Then you can Rate their helpful post.

  16. #16
    Member D43x's Avatar
    Join Date
    Nov 2005
    Location
    UK
    Posts
    56

    Re: VB - Write (directly) to an MSFlexGrid

    Which grid would you recommend for both printing and editing? Using vb6.

    And considering the title of this thread is it possible to write "indirectly" to an MS FlexGrid? (Or MSH FlexGrid).

  17. #17

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: VB - Write (directly) to an MSFlexGrid

    Quote Originally Posted by D43x
    Which grid would you recommend for both printing and editing? Using vb6.

    And considering the title of this thread is it possible to write "indirectly" to an MS FlexGrid? (Or MSH FlexGrid).
    I don't really have a recommendation and it probably doesn't make much difference. Also I don't know what you mean by "indirectly" but it should probably be discussed in the Classic VB forum rather than here.

  18. #18
    Member D43x's Avatar
    Join Date
    Nov 2005
    Location
    UK
    Posts
    56

    Re: VB - Write (directly) to an MSFlexGrid

    Well it makes a difference when it seems by default an MSFlexGrid is read only, and you can't actually place the cursor in a cell !
    Did you spill my pint!?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width