4 people report to me and the average age of all 5 of us is 57. 64,63,63,60,37 My boss (36) and I discuss legacy planning all the time as any of the 4 can retire at any time. I'm one of the 63s, plan to retire 12/2025 but have a two week vacation coming up which will make me consider retiring soon.

ToDoList ToDoList 6.1 Beta Release - A simple but effective way to keep on top of your tasks[^]

you can bind multiple combo boxes to the same dataTable if each has its own binding source

SharpZipLib is a freeware component you can add to your toolbox: http://www.icsharpcode.net/OpenSource/SharpZipLib/Download.aspx

Quick Windows Forms Control... a Label with a 3D Line... http://blogs.duncanmackenzie.net/duncanma/archive/2005/04/14/1306.aspx[^] and some followup: http://vbfeeds.com/post.aspx?id=133[^]

here are a few things to look at from MS http://tinyurl.com/2rnq7 http://tinyurl.com/nz9v and here is an excellent series of 15 lectures: http://www.lakeforest.edu/~hummel/webcasts.htm the audio webcasts are accessed thru this part of that site "Audio broadcasts should be available from here"

here is a free listview that can handle that: http://vcreations.net/product.asp?pid=1[^] here is a free grid: http://vbaccelerator.com/home/VB/Code/Controls/S_Grid_2/index.asp[^] here is a very good grid that I use in my apps where appropriate: http://www.janusys.com/janus/library/[^]

if you are using VB6, you want to use the ExitProcess API call Private Declare Sub ExitProcess Lib "KERNEL32" (ByVal uExitCode As Long) normal end: ExitProcess 0 useful if you run your app from a batch file or shell and wait for it to finish from another app

check here http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForSQLServer[^] or here http://www.able-consulting.com/ADO_Conn.htm[^]

check out http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp

winsocklib from here http://killervb.com/Libraries.aspx[^]

http://www.codeproject.com/netcf/compframe4.asp[^]

It is I Am The walrus. The dialog is from a BBC broadcast of King Lear (Act IV, Scene 6).

From www.janusys.com support forum Saturday, July 12 2003, 02:29 PM GridEX control does not support automatic drag. To start a drag operation you need to call the OLEDrag method and handle the OLEDrag events to perform such operations. Note: The position of a row is taken from the position of the record in the Recordset and because you can not change that position in a Recordset you won't be able to provide such functionality if the control is bound. Further in the thread is a sample: We don't have samples that change the position of a row using OLE Drag & Drop. Here I'm attaching a sample project that handles the OLEStartDrag and OLESetData events when it is acting as drag source and the OLEDragDrop event for when it is acting as ole drop target. The sample was done to show how to copy rows from one instance of the application to another but with it you can get the idea of what events can be used. I can download and send to you if you need it

you could trap for keycode of 13

you need to put mdac_typ.exe in C:\Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist>

Here is how I format columns in excel using a CExcel class module: Set objExcel = New CExcel With objExcel .OpenExcelFile strFilename, "Visit List" .StoreExcelRange "A1", lngRecsProcessed + 3, 13, varDataArray .FreezePanes "A3", True .SetExcelRowBold 1 .SetExcelCellWidthAutoFit .FormatColumn "A", "000000000" .FormatColumn "E", "$#,##0.00" .CloseExcelFile End With Set objExcel = Nothing Here is the actual code in the FormatColumn m_objWorksheet.Columns(p_strColumn).NumberFormat = p_strFormat To see exactly what code excel uis doing you could record a macro in Excel as you format the column. The code you need will be in side the macro code and is easily migratable to VB

Remove listitem: ListView1.ListItems.Remove(lngI) As for the form: The QueryUnload event has a second parameter called UnloadMode. By testing this mode, the program will know what is causing the form to unload. Then you can decide what you want to do, etc These are the constants and a brief explanation: Select Case UnloadMode Case vbFormControlMenu 'The "X" button or the "Close" menu 'from the form's System menu. Case vbFormCode 'The Unload statement is called from code. Case vbAppWindows 'Windows is shutting down. Case vbAppTaskManager 'The Task Manager is closing the app. Case vbFormMDIForm 'The form is an MDI child and the 'MDI form is closing. Case vbFormOwner 'The form is closing because its 'owner is closing. End Select "Since we don't know where we're going, we have to stick together in case someone gets there." - Ken Kesey 1935 - 2001

wininet.dll InternetOpen InternetOpenUrl InternetReadFile I have a small sample i wrote years ago. let me know if you want a copy.

You can find it at organic food stores. I felt great. my allergies disappeared. Thinking of doing this again soon