o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Changing Grid Cells with the Mouse -

Somebody please help me !

I have a project I'm working on that uses a grid (any type it doesnt matter). The grid shows the result of a recordset. The recordset is made up from fields from a database that contains 4 tables. The recordset has one field from each of the 4 tables.

I want the user to be able to click on a cell on the grid and whichever cell he has clicked will automatically change to a different set of data, i.e. the name Fred would change to Bill, etc.

It is essential that this change is made by simply clicking on the cell. The only thing is I can't figure out how its done.

Once the change is made, the recordset and the underlying database should also change to show the changes in the grid.

Someone please help me here as I'm tearing my hair out !!

Thanks,

Mike

 

Changing Grid Cells with the Mouse -
Somebody please help me ! I have a project I'm working on that uses a grid (any type it doesnt matter). The grid shows the result of a recordset. The recordset is made up from fields from a database that contains 4 tables. The recordset has one field from each of the 4 tables.

I have a grid problem. -
I am using the MSHFlexGrid which up to now has been working fine but I am trying to add a new feature. I want to bring up a Popupmenu when the user right clicks on top of a selection on the grid. The problem is the grid does not respond to a right mouse click on the grid. What I me

Send message to cells in grid -
I want to set text in some cells in a grid in another program. I know that the other program was written in C or C++. Through APIs I can find the window for the grid. It is class GXWND. The GXWND window has two children of GXEDIT class. The problem is that once I have the handle for th

Gurus - Help!!! --UNRESOLVED-- -
Hello, I'm using VideoSoft's VSFlexGrid (Light) Version 7. I have some rows in the grid and there are some cells in every row that need to be in a different forecolor than the others. I use CellForeColor to control that, but when a row is selected, all the cells are in the same fore

Snap Mouse to a Grid -
Hi, How would I snap a mouse to a grid, I've tried doing it using the API SetCursor, with a mouse move event, but theres some phantom like movements with the mouse, it keeps getting inputs, even when the mouse is stationary Thanks!

Tooltip in DataGrid -
Hi, I have a datagrid with 2 columns. The second column displays the name of some files. I want a mouseover/tooltip functionality on the cells of the datagrid. Every time the mouse cursor is moved on the filename column of the DataGrid, depending on the cell, it should display the ful

Cell containing Function Keeps Changing -
I have a column of cells, each cell contains the same function -- the function takes values from three cells and returns a value. The problem is this: after several seconds, the values in the cells all change -- sometimes to another number, sometimes to zero, sometimes they put out t

flexgrid ! -
hello ! i've a flexgrid control and i'm using the click event to change the background color of the cell when clicked. the backcolor is toggling on click of mouse. now my prob is when i click outside the grid also, then the border cells are getting clicked. that is they're changi

how to get Row text from a Grid on just moving mouse on Grid's Rows -
I want to retrieve text of rows in a Grid on just moving mouse on Grid Rows.This is some what similar to Getting List box items text on moving mouse on List box . For this i am using SendMessage API function.In list box it works fine . I am using the Constant LB_ITEMFROMPOINT which giv

MS Flex Grid control -
Hi There, Can i know how to edit the cells in the MS Flex grid control in Visual Basic. It seems the MSflex grid control does not allow to update the cells with in the grid. Please reply soon. Thanks Srini

Datagrid control, enter data like a excel sheet -
Hello I have implemented a datagrid which is connected to a database. I want the user to be able to press the tab key to be able update the cells in the grid, and also be able to select certain cells with the mouse and update them as well. It is possible to have some code on how

Grid Control -
Anyone know how to highlight individual cells in different rows and columns on a grid (discontinuous cell selection by holding down the CTRL key clicking on different cells). Just like it can be done in Excel.

Grid without datasources -
Hi all! Is it possible to use the datagrid (or some other net grid) without any database connected to it. I need just a grid for editing some cells, something similar to the grid of the property window. Can someone help me? Thank you!

changing the windows mouse scheme from vb.net -
Does anyone know the VB equivalent of going to the Mouse Properties in the Control Panel, changing the mouse scheme, and saving/naming that scheme? i'd like to write a simple program that changes the mouse schema to one i made, and i got the setup to move the cursors to the right pla

Help! S-Grid is changing my cells a different color!! -
Hi everyone, I have a form with the S-Grid 2 control in it, and I have one column which is white where all the data is entered in. If I click on any of the other columns, which is either gray or black, then when they lose focus they turn white. I can't figure out what is causing this s

MS Flex Grid Merge cells -
helooo am using a Ms Flexgrid ,where in i do have 5 rows and 3 columnns i now merge the first row , where all the cells are merged , the data is appears as a heading of the grid, my problem is when i click on the merged cells, the data gets moved towards the left side. how can i

MSFlexGrid clear rows -
I have 250 records displayed in my grid. After a new sql command the result is 2 records. How can I get rid of the other 248 blank rows. I tryed grid.clear, but that only clears the cells. I only want cells who are filled with data. Isn't there anything like grid1.rows.clearall

Grid Information -
I'm looking for a way to have a list with checkboxes and able to be scrolled, and still be able to refrence the seperate cells. It would be almost the exact thing as a microsoft flex grid control, but with the first few cells of the row being checkboxes. I can do everything except the

Standard msflexgrid question... -
Yet another question about this grid... How can I disable the multiselect option of cells? (done by selected a cell, holding down the mouse button, and dragging, thus highlighting/selecting more cells). My reason : I have built-in a sort mechanism, and if the user selects, say 3 ou

Flex Grid With Mouse -
I need to move a item in a flex grid from position x to position y using a mouse hold-click, like in the Winamp playlist. but the flex grid no have the capacity for it own. can somebody help me with a subroutine

MouseMove as well as MouseDown -
Hi, I have a grid of square labels (used labels just because they are clickable) and I need to be able to change their colours as I move the mouse over them but only if the mouse is clicked. I tried to use Button = vbLeftButton, within the MouseMove event but it doesn't seem to even e

help needed in GRID... -
Hi, I have a TABLE with 3 fields, FirstName LastName EMail Database is in ACCESS 2000... now what I need is a program which basically displays them in grid and without any extra controls like textbox I want to modify data directly in GRID itself... Just like EXCEL CELL

MSHFLEXGRID Restrict Merged Cells -
I need to merge cells in ONLY the first 2 rows for all columns, example: Unmerged Grid: A B B C D D E A F G H I J K 1 2 3 4 5 6 7 1 2 3 4 5 6 7 Desired Merged Grid: A B - C D - E - F G - I J K 1 2 3 4 5 6 7 1 2 3 4 5 6 7

[2005] Tooltip over datagrid column -
Hi, We have a datagrid column say Spaces and the description for this column is present in a hidden column in the same datagrid. We show this description in the tooltip of the Spaces column We are using the inbuilt tooltip property of the data grid for achieving this functional

[2005] Changing DataSource of Data Grid View -
Hello all! This is my first post here. I have two data grid views...both are connected to two different databases. I just recently figured out how inefficient this is. I combined the two databases (1 table for 1 db...so 1 new db with 2 tables). What's the easiest wa

changing data range for an excel chart... -
Hi, Im having some trouble changing the range of data for an existing chart.... I want to change the number of columns of data a chart is using, and have tried this: ActiveChart.SetSourceData Source:=Sheets("Pareto").Range(Cells(3, 3), Cells(3, nocols)), Plot

Is there a method for sending mouseclicks (similar to SendKeys) -
Hello I have a grid control that won't show that the cursor is on first column of grid when the grid receives focus, until the left mouse button is clicked. Is there a way to send a left-mouse click (similar to SendKeys for keyboard strokes) when the grid receives focus? Or could

Small problem I think -
I have a grid with on each row 2 cells. grid sample: cel 0 cel1 1 Alfa 2 Bravo 3 Charly 4 Delta 5 Echo What I want to do is following. When the user

save unbound datagridview -
vb 2005 Hi, I have an unbound datagridview that has 2 columns. The grid is populated with text held in various files by looping through a file and assigning line text to a newly created datagridviewrow before the row is added to the grid. The grid may then be edited. I have a s

grid over drop down list -
hey all, i have a page with input boxes and drop down lists. I have a button that shows an html grid over all of that (for searching) and then removes it. When the grid is shown, the ddl appear over/on top of the grid. It looks like the ddls are part of the grid, when they are n

Issue with BlockInput API, HELP -
I'm using the BlockInpit API in the RowColChange event of a MSFLexGid, set it to true at the begining and set BlockInput False at the en of the sub, now the issue or the problem is that the grid star hto highlight wherever I move the mouse even outside of the grid , the grid looks lik

Filling cells from a list -
I am using Excel 2003 and have a question about taking a list of objects and filling those objects in other cells. I will get a list like this: ID Animal Num 6000 Cat 3 7000 Dog 2 8000 Mouse 5 I want to be able to read the ID and the

Windowed DirectX and mouse -
Hi, I know its possible for a windowed directx program to trap a mouse in the window so that the cursor is based on the directx info instead of windows but I'm trying to figure out how to do it. The problem is I need to be able to return correct mouse coordinates (Based on the x,

MS Flexgrid / MSHFlexGrid Bug -
I came across a interesting bug in the MS Flexgrid and MSHFlexGrid. Put a grid on a form. In its MouseUp event, put a debug.print message. Now run the app. Left-click on the grid and drag off the grid. Release mouse button. You see the message. Now do the same with the right mouse

Locking row selection with MSFlexGrid -
I just started learning VB, so be gentle... I have a form with an MSFlexGrid and some text fields. The grid is set so that the user selects entire rows at once and when a row is selected, the fields fill up with the data from the cells of the selected row in the grid. The user

Drag n Drop is causing me headaches ! -
I have a flexgrid, well actually I have 10-Techs excellent iGrid control, but thats no matter. I have highlighted all the cells, and have opened up an Excel workbook and sat myself in a particular cell. I want to paste the contents of the grid using drag and drop. Can someone

Pictures in flexgrid cells -
Hi, I would like to insert pictures into my flexgrid cells. I cannot seem to figure out how todo it. I am used to using MS Grid which is rather simple for doing this. However, since I switched to VB6 and it only has Flexgrid (and no MS Grid), I do not know how to proceed. Any

Button -
how to make button picture changing when mouse is over and changing back when not? i tried mousemove event but it's not good because it's makes the button blink at every move of mouse over it and i couldn't make the button restore it's original picture once mouse is not on button anym

Drag 'n' drop issues -
Hi, I hope I'm not going over covered ground, but I have been looking for previously answered questions and tutes to answer my queries but haven't been successful. My question is: In my program, I'm dragging an element from a label array, onto a picture box which has a grid drawn on

Changing mouse icon -
I want to know how to change the mouse icon during a mouse down and or drag-drop event but it's not workin. How is it supposed to be done all i'm doin at the moment is assigning the pictures and forms mouse icon to a .ico picture. Thanx Bruce