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...
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?
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...
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...
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...
My code now looks like this:
Do While DataGrid1.SelBookmarks.Count <> 0
Set DataGrid1.Bookmark = DataGrid1.SelBookmarks(0)
If sFirst Then
sQry = ("{JOBCOST.Contn} = '" & DataGrid1.Columns(0) & "'")
sFirst = False
Else...
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?
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...
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.
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...
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}<>"" And {BIDDTL.ShortItem}<> " ") Then {BIDDTL.ShortItem} Else {BIDDTL.Item}
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}=" ") Then {BIDDTL.Item} Else {BIDDTL.ShortItem}
It works to print the Short Item when it is filled, but...
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 "operation not...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.