Results 1 to 9 of 9

Thread: [RESOLVED] Autoloader.............

Hybrid View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Resolved [RESOLVED] Autoloader.............

    i have developed a Form Called Outward Entry in VB 6.0 & Access as Database.
    i Stores Item Details in MS Flexgrid.
    User sends a Request of Items in Excel Predefined Format.as there r many no of items user will require more time to feed that data.
    so am thinking of Autoloader as Request Comes Excel Format as no of items to be dispatched are more than 40,
    can i use Excel format Directly into the Flexgrid


    pls guide me on this issue

    thanks

  2. #2
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Re: Autoloader.............

    Yse U Can Do It
    Just Define The Field In Grid And Put It As An Editable Format
    Now Editing The Iten In The Grid U Are Able To Save In The Database

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Autoloader.............

    Actually i wants to Put data into Flexgrid from Excel Sheet

  4. #4
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Re: Autoloader.............

    Is Data Are Saved Any Where?

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Autoloader.............

    Request For Items in Predefined Excel Format on Click Event All data From Selected Excel Sheet should be Transfered to MS Flexgrid
    After when i Click save button saving in Access Table

  6. #6
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Thumbs up Re: Autoloader.............

    There are several ways of doing it. One of them is to copy the desired cells to the clipboard and then paste from the clipboard to MSFlexGrid


    VB Code:
    1. private Sub Command2_Click()
    2. PasteIntoGrid MSFlexGrid1, Clipboard.GetText(1), true, 15, 15
    3. End Sub
    4.  
    5. private Sub PasteIntoGrid(byref Flexgrid as MSFlexGrid, byval ClipboardText as string, optional ExtendGrid
    6. as Boolean = true, optional StartCol as Integer = 1, optional StartRow as Integer = 1)
    7. Dim intRows as Integer
    8. Dim intCols as Integer
    9. Dim aryRows() as string
    10. Dim aryCols() as string
    11. aryRows = Split(ClipboardText, vbCrLf)
    12. intRows = UBound(aryRows) + 1
    13. aryCols = Split(aryRows(0), vbTab)
    14. intCols = UBound(aryCols) + 1
    15. With Flexgrid
    16. If .Rows - StartRow < intRows then .Rows = intRows + StartRow + 1
    17. If .Cols - StartCol < intCols then .Cols = intCols + StartCol + 1
    18. .Col = StartCol
    19. .Row = StartRow
    20. .ColSel = StartCol + intCols
    21. .RowSel = StartRow + intRows
    22. .Clip = Replace(ClipboardText, vbCrLf, vbCr)
    23. End With
    24. End Sub

    The key thing really is that you need to select the appropriate size area in the flexgrid to contain
    the pasted data otherwise you only get the first element in one cell.



    SHAKTI

  7. #7

  8. #8

    Thread Starter
    Addicted Member
    Join Date
    Jan 2006
    Location
    PUNE
    Posts
    222

    Re: Autoloader.............

    Thanks Bushmobile, Jcis & Shakti


  9. #9
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Re: [RESOLVED] Autoloader.............

    if u like the thread then rate it

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