DataGrids are always fun to program with. Even a simple ComboBox can end up with heaps of code behind to it make it work as you wish. As you say you can't change the DropDown Style, this is a pity if the one you currently are using isn't sufficient (ListBox), as you must use Combo-style.

You can force appearance to change on the fly by using WinAPI Calls such as SendMessage(cbo XXX.hwnd, CB_XXX, True, ByVal 0) and SetWindowsLong....

Thank you,

the question is however should I keep the CMD objects open all the time, or should I close them and open them again when I need to recreate the Recordset? Or atleast set the connection to nothing after refreshing the recordset and then resetting the connection as required. I do not need to destroy and recreate the CMD objects to achieve this I believe.

I am concerned about the number of open connections...

Pass the OLE Picture Object and the ADO Database field to the following code. It's not pretty since it uses an intermediate Windows File, but it is the shortest piece of code I know. There are other methods using In Memory files, etc.

To be honest I use the LEAD Tools Image Object that has a SAVE command.

Neon K.


...

I create a number of Global ADO Commands on Application Load. Every 30 seconds I use these to recreate Recordsets (Most of the RS are not global, so are recreated each time instead of just being refreshed/requeried). Those that are Global in scope can just be refreshed.

My question is, is what I'm doing correct, or should I close and recreated the Command Objects every 30 seconds. Currently I keep about 20 ADO Command Objects constantly...