Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AMHCLH

    Using tab to leave datagrid overlaid with combo box

    I have a data grid that displays a list of items for an order. It has a dropdown box to allow selection of item descriptions. Capturing the description from the combo box and placing it into the grid works fine. I then update an item file (in addition to the order file) with the description...
  2. AMHCLH

    Datagrid two line caption

    Is it possible to create a two line caption in the data grid? I have tried the following code: DataGrid1.Columns(2).Caption = "Mon Qty" & vbCrLf & "12/3/03" But this doesn't have the effect I wanted which is to have the date under the Monday Qty caption. Any other ideas?
  3. AMHCLH

    Datagrid highlight cell

    I tried changing datagrid1.MarqueeStyle=dbgFloatingEditor. That didn't work. But removing the increment of the row/column did. Here is the working code: Private Sub DataGrid1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyDown Then DataGrid1.SelStart = 0...
  4. AMHCLH

    Datagrid highlight cell

    CCLINT, It moves to the end of the right row, but doesn't position the cursor in the cell. Here is my code: Private Sub DataGrid1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyDown Then DataGrid1.Row = DataGrid1.Row + 1 DataGrid1.Col = DataGrid1.Col DataGrid1.SelStart = 0...
  5. AMHCLH

    Datagrid highlight cell

    CCLINT, Thanks for responding. I tried the change and get an error that the method or data member (.selstart) is not found.
  6. AMHCLH

    Datagrid highlight cell

    I have datagrid navigation set up, but I want to allow the user to move to the next row by pressing the arrow key after entering data(while still in the cell) and move to the next row same column. I capture the key stroke and it moves to the next row, but doesn't highlight that particular cell...
  7. AMHCLH

    Datagrid increment selbookmarks

    CClint, Thank you! It works perfectly! You get a star!
  8. AMHCLH

    Datagrid increment selbookmarks

    My code now looks like this: Do While DataGrid1.SelBookmarks.Count <> 0 Set DataGrid1.Bookmark = DataGrid1.SelBookmarks(0) If sFirst Then sQry = (&quot;{JOBCOST.Contn} = '&quot; & DataGrid1.Columns(0) & &quot;'&quot;) sFirst = False Else...
  9. AMHCLH

    Datagrid increment selbookmarks

    CCLINT, Thanks for the response. I changed the code and now it loops through the correct number of times, but the value DataGrid1.Columns(0) doesn't change for each record. It is always the value of the first contract selected. Any ideas?
  10. AMHCLH

    Datagrid increment selbookmarks

    I have a datagrid and want to allow the user to select multiple records. The program will then use the contract numbers of these selected records to build a query to be passed to a report printing only those selected contracts. This is the code I am using to create the query, but it never...
  11. AMHCLH

    Display last ten rows in datagrid

    tedsmith, But with what property? I have tried .firstrow and get an error that the bookmark is invalid. If I set datagrid.row then the cursor is positioned there and I want it to remain on the record that is currently being added.
  12. AMHCLH

    Display last ten rows in datagrid

    I use datagrid to display the items in a contract. When the number of items is large and the grid view becomes full of items, the next item causes the grid to display only the last item. Although the first items are still in the grid and available when the user scrolls back, they would like to...
  13. AMHCLH

    MSHFlexGrid/MSFlexGrid Row Deletion

    jonathanmb, Did you ever find a solution to removing rows from the flex grid? I am having the same problem... I also am running Windows XP.
  14. AMHCLH

    IF FIELD IS BLANK, PRINT ANOTHER FIELD

    Thanks! It works now. Gave you a star.
  15. AMHCLH

    IF FIELD IS BLANK, PRINT ANOTHER FIELD

    Thanks for responding. I changed the formula to check for null as well, but I still don't get any value to print. If ({BIDDTL.ShortItem}<>&quot;&quot; And {BIDDTL.ShortItem}<> &quot; &quot;) Then {BIDDTL.ShortItem} Else {BIDDTL.Item}
  16. AMHCLH

    IF FIELD IS BLANK, PRINT ANOTHER FIELD

    I have created a formula field to print a field called Short Item if it isn't blank; otherwise, I want the field Item to print. This is my formula If ({BIDDTL.ShortItem}=&quot; &quot;) Then {BIDDTL.Item} Else {BIDDTL.ShortItem} It works to print the Short Item when it is filled, but...
  17. AMHCLH

    PDW quits without creating setup package

    Have you found a solution to your PDW problem? I am having exactly the same problem.
  18. AMHCLH

    Error 3219 &quot;operation not allowed&quot; after ADO data grid updated

    I am updating my programs to use ADO. I have bound my ADO recordset to a datagrid and allow the recordset to be updated automatically. The problem is after an update in the grid- the next time I try to close the recordset and open it for another select, I get error 3219 &quot;operation not...
  19. AMHCLH

    Text Box with MSHFlexGrid

    Thanks, Mark! It works fine now.
  20. AMHCLH

    Text Box with MSHFlexGrid

    No, there is no container or frame. The items are just on a form. The puzzling thing is that it worked with the MSFLEXGRID, but now it doesn't with the MSHFLEXGRID.

Part and Inventory Search

Back
Top