Results 1 to 4 of 4

Thread: Sgrid 2.0 [Resolved]

  1. #1

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Sgrid 2.0 [Resolved]

    Ok, so I downloaded this grid from vbaccelerator.com and I'm using it and it's ok so far... problem is this:

    Everytime i do an "addrow", it blanks out the previous rows and the values are only showing in the new row that I added?!
    VB Code:
    1. With flxSP
    2.         .AddRow .Rows
    3.         .CellText(.Rows, 1) = .Rows
    4.         .CellText(.Rows, 2) = txtSpeed.Text
    5.         .CellText(.Rows, 3) = txtTorque.Text
    6.         .CellText(.Rows, 4) = txttime.Text
    7.         End With

    Anyone?
    Last edited by ober0330; Jun 1st, 2004 at 01:50 PM.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Try this:
    VB Code:
    1. With flxSP
    2.         .AddRow
    3.         .CellText(.Rows-1, 1) = .Rows
    4.         .CellText(.Rows-1, 2) = txtSpeed.Text
    5.         .CellText(.Rows-1, 3) = txtTorque.Text
    6.         .CellText(.Rows-1, 4) = txttime.Text
    7.         End With

    TG
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945
    I have already tried doing it that way.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company

  4. #4

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945
    AHHH... I'm stupid. I kept overwriting the old row and dumping the new values in the old row. Just take out the .Rows after the .Addrow.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company

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