Search results for query: *

I am trying to simulate the Microsoft Excel "Freeze Panes" function on a Visual Basic .NET form using two ListView controls. Key_ListView: The control on the left will have one column entitled "Key" and have a numerical value. Data_ListView: The control on the right will have about 30 columns...

Rick, I found the parents MDI child Forms collection. It is called .MdiChildren. How weird is that? :) I added the code below to close all MDI children in a parents Forms collection. Thanks for the tip. Sub DeleteImageForm() Try For Each f As Form In Me.MdiChildren...

Q. How can I close an MDI child form programatically, as opposed to the user closing the form with the top-right X? Here is the scenerio. - I have a listview control that lists inventory items. - Each item contains the path to a .jpg file. - When the user selects a listview item, I create a new...

The autoclick property pretty much did the trick. When clicked, the radio button "dot" doesn't get set but the control does appear to be selected with the dotted box around the text. That's potentially misleading to the user, but I am willing to allow it as opposed to completely disabling the...

I am using Visual Basic .NET 2003 Standard with Windows 2000 professional. This is the only machine I've tested it on so far. When a textbox is disabled the backcolor is changed making it less readable. Fortunately the RichTextBox can be used insted and I simply set the ReadOnly property to...

When I set the .enabled property of a radio button to false the forecolor turns to this annoying turquoise looking color by default. How can I get the color to remain black?

Late-Binding was the solution. Here is what I did. 1) Removed the Excel COM reference via the Solution Explorer 2) Commented out the prior declarations and replaced them as follows: 'Dim xlApp As Microsoft.Office.Interop.Excel.Application 'Dim xlBook As...

After setting the application object to nothing add this: System.GC.Collect()

After setting the application object to nother add this: System.GC.Collect()

Business requirements should focus on "What" or "Why" business objective are being addressed. Is it a product/process improvement or a compliance issue. Are you looking to achieve improvements in cost, time, service or quality. They should be linked to relevent objectives in business plans...

A major correction on my previous post. My users have Excel 2000 or earlier. They do NOT have Excel 2003.

I am using Microsoft Excel 2003 on my computer in development. I added the COM reference for "Microsoft Excel 11.0 Object Library". Via VB .NET 2003 I create and Excel file without a hitch. My users have Excel 2003 and possibly earlier. I have no problem creating the Excel files but they get...

Everyone, thanks for the multiple suggestions. The star goes to miket26. I added "System.GC.Collect()" to my code after all the objects had been set to nothing. Now the Excel.exe process stops running when Excel is shut down, just as I wanted. And it doesn't matter if the VB application is...

xlApp.Quit() will shut down Excel and release the objects, but the process still runs. I don't want the application to shut down Excel. I want the user to have control of that from within Excel. I Released the COM objects as follows...

I cannot seem to end a Microsoft Excel process. I create the Application, Workbook and Worksheet in that order. I load the worksheet data and save the workbook. I make the application visibile and pass usercontrol to it, then close (set to nothing) the Worksheet, Workbook and Application in...

Here is a frustrating problem I've been experiencing while developing a windows application in VB .NET 2003 Standard. I have a Tab Control which I've added tab pages to with unique content to each page. the Tab Control has 12 tab pages in the TabPages collection. I use the TabPage Collection...

Shatch, Thanks for the suggestion. It helped me to achieve my objective and I have a few observations as well. 1) By declaring the form objects up front in the module the application will carry the overhead of those form objects throughout the life of the application. This may affect...

I am running VB .NET 2003 Standard. I have a project that has several forms and I need to move from form to form in a natural flow. When I want to open a new form I use the code: Dim oForm As frmNewForm1 oForm = New frmNewForm1 oForm.Show() oForm = Nothing When that is executed the new form...