Results 1 to 18 of 18

Thread: VB - Write (directly) to an MSFlexGrid

Hybrid View

  1. #1

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

    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,431
    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
    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).

  12. #12

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

    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.

  13. #13
    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