Visual Basic

10-Dec-03 17:24

By dafault form1 is the active form . How can we change the active form
to form 2 such that after closing form1 our application wont be closed.

neha

Dave Kreskowiak11-Dec-03 2:52

11-Dec-03 2:52

Are you saying that you'll have multiple forms open at the same time and that the user can close any of them and still keep the app running? Sounds like a job for seperate apps to me but I don't know all the details about what your doing...

Ummm...You might want to try having either a Main function that declares and shows all the forms, or you might want to do the same thing in a hidden form. You can then go into the Project Properties and change the startup object to either Main or the hidden form. Now, you'r also going to have to handle the Close events of these forms so your Main or hidden form knows that all of your visible forms are closed so it knows when to quit.

RageInTheMachine9532

neha1219-Dec-03 22:12

19-Dec-03 22:12

Thanks for the reply , but in my appln there are 7 forms & once I start executing the appln , My main startup form appears. ok. Now once I go from this startup form to form2 , I would like to close the startup form(form1).
when I close the startup form (form1) then my application gets closed.
So for this can u suggest any remedy so that I can transfer the active control from form1(startup) to form2 & can close startup form??

Dave Kreskowiak20-Dec-03 12:48

20-Dec-03 12:48

Then you might want to try something like Me.Hide() on your main form. Or Form1.Hide() when you enter the Activate code on Form2.

RageInTheMachine9532

neha1220-Dec-03 21:24

20-Dec-03 21:24

Currently Iam doing that only but then when Iam closing the main form ie
form2 then my application is not getting closed. ie I am required to go to
the close button from the VB menu to stop execution of the application.
I dont know how far u can understand what I mean to say !!

Dave Kreskowiak21-Dec-03 6:39

21-Dec-03 6:39

Now it sounds like your first form is a splash screen.

What ever form is your startup form CANNOT be closed unless you want your entire app to be closed with it. Your startup form does NOT have to be visible when you app starts. You can start your app with Form1.Visible=False and have it Form2.Show, Form3.Show, whatever... But! You have to keep track of which Forms are open in your main form (Form1) and determine when Form1 either shows itself to be closed or closes on its own.

RageInTheMachine9532

Dave Kreskowiak21-Dec-03 6:49

21-Dec-03 6:49

I think there is a problem with your design assumptions and how Windows Forms apps work. It would appears that you think your application can stay open so long as there is ANY form in your app open:

             Application
                  |
                  |
  +-------+-------+-------+-------+
  |       |       |       |       |
Form1   Form2   Form3   Form4   Form5

This is just not the case. Your application depends on a main class, or Form, that is the central hub of your application. Something like this:

             Application
                  |
                Form1
                  |
  +-------+-------+-------+-------+
  |       |       |       |       |
Form2   Form3   Form4   Form5   Form6
                          |       |
                        Form7   Form8

Only when Form1 is closed can your application close, and in opposite terms, only so long as Form1 is open, even if its not visible, can your app stay open.

In the latter example, Form2 can be your splash screen, Forms 3-6 can be options dialogs, editors, print previews, subsections of your app, whatever, ... But in all cases, Form1 MUST keep track of which forms are open and closed.

RageInTheMachine9532

neha1221-Dec-03 16:33

showing method descriptions in VS

21-Dec-03 16:33

Thanks

,, Thanks a lot ..
My doubt is completely cleared...
Thanks for explaining it so nicely ...
Now I will implement this in my application.
If I have any doubts later then again I will write back.

Mesrop Simonian10-Dec-03 13:18

10-Dec-03 13:18

Does anyone know how to show method or property descriptions for a particular class in Visual Studio's code-view? I do the following but it doesn't work:

Imports System.ComponentModel
Public Class JobSeeker
...
<Description("asdfasdf asdf asdf asdf")> _
Shared Sub delete(ByVal Name As String)
...
End Sub
End class

I want to be able to see the descriptions of my own methods when I'm calling them.

Microsoft says the description will show (if you use DescriptionAttribute) when you CLICK on the property, my guess is this is only for visual components, because in code-view you don't click on properties...

any ideas guys? your input will be greatly appreciated.

Regards,
Mesrop

Günther Meusburger10-Dec-03 20:05

Günther Meusburger

10-Dec-03 20:05

the DescriptionAttribute is just shown in the propertywindow( at the lower border). i think you like to see the description by intelisense...so if you know how to do this let me know

Dave Kreskowiak11-Dec-03 2:48

11-Dec-03 2:48

You need a 3rd party extension to Visual Studio for this to work. VB.NET can't output the XML file needed for Intellisense to show you the description. Currently, i don't know of any extension that will do this for VB. The C++ and C# compilers WILL do this though.

The Description attribute only work in the properties window...

RageInTheMachine9532

Mesrop Simonian11-Dec-03 5:50

11-Dec-03 5:50

another blow to VB, they claim C# does nothing VB doesn't, apparently that's not the case...

Ian Darling11-Dec-03 5:54

Ian Darling

11-Dec-03 5:54

Unless you install the XML Commenter powertoy. Then you can.

--
Ian Darling
"The moral of the story is that with a contrived example, you can prove anything." - Joel Spolsky

Mesrop Simonian11-Dec-03 8:07

11-Dec-03 8:07

I'm not sure powertoys are the way to go, doesn't the 3rd party need to have the same powertoy to be able to see the descriptions? what if I want to ship user friendly marketable components, so when the developers program, they can see description tags for each method, just like they expect to. I know it's not a language issue, but yet what this means is those who program in C# can create quality components, whereas we can't... If there is 1 limitation, you can bet there will be more.

Ian Darling11-Dec-03 12:37

Ian Darling

11-Dec-03 12:37

Mesrop Simonian wrote:
doesn't the 3rd party need to have the same powertoy to be able to see the descriptions

No, because all it does is generate the XML that the standard tools need. All it does is plug the gap for VB.NET

Mesrop Simonian wrote:
those who program in C# can create quality components, whereas we can't...

Do VB Programmers traditionally write components anyway?

VB (and VB.NET) is a productivity language before all else, and this usually means gluing together existing bits to solve a specific problem more than writing new components. So it's not a big issue for me at all, and with the powertoy, it isn't an issue at all.

I'm comfortable with VB.NET as a productivity tool (much more so than C#), and if I really need to ramp up performance or do something really tricky, I'll break out the C++ tools and use those.

--
Ian Darling
"The moral of the story is that with a contrived example, you can prove anything." - Joel Spolsky

Dave Kreskowiak11-Dec-03 5:55

11-Dec-03 5:55

Actually, from a language point of view, they DO do everything. This is just an output from the compiler that isn't supported...yet! Wait 'til the 2004 version...

RageInTheMachine9532

Solution

Mesrop Simonian11-Dec-03 13:01

wait for user to close the excel

11-Dec-03 13:01

After a lot of pondering I finally decided to turn to my highest VB authority on this matter - Francesco Balena. Here's what he said for all those who asked me to keep them posted on this matter:

----
That feature is based on descriptions held in an XML file held in the same directory as the DLL containing the actual types and methods. To see what I mean, see all the DLLs and the pairing XML files in the C:\Windows\Microsoft.NET\Framework\v1.1.4322 folder

The guys that say that it can be done only with C# are partially right, because C# makes it _easier_ to generate the XML files that the Object Browser (and Intellisense) use to store descriptions of each methods. The C# compiler has an option that gathers all the comments interspersed in code (in a special format) and generates the XML file that VS.NET uses.

With VB you must generate this file manually. However, there is a tool at http://www.gotdotnet.com/team/vb/ that lets you do that with VB as well.

It is true (unfortunately) that C# can do things that VB can't - most notably, operator overloading, unsigned integers, and unsafe code - but this feature isn't one of those.

regards,

Francesco

pnpfriend10-Dec-03 10:41

pnpfriend

10-Dec-03 10:41

I wrote a program (VB.Net) that takes the exiting file name, opens it, formats it and allowing the user to change/format the file and wait for the user to close the excel applilcation

but my WaitForExcelToClose function is not working..
Can someone please help me.

<br />
<br />
        Dim wBooks As Excel.Workbooks<br />
        Dim wBook As Excel.Workbook<br />
        Dim sheets As Excel.Sheets<br />
<br />
        excelApp = CreateObject("Excel.Application")<br />
        wBooks = excelApp.Workbooks()<br />
        wBook = wBooks.Open(filename)<br />
sheets =        wBook.Worksheets<br />
' some other functions<br />
 sheets.PrintPreview()<br />
 WaitForExcelToClose()<br />
 excelApp.Quit()<br />

<br />
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long<br />
    Private Declare Function GetLastError Lib "kernel32" () As Long<br />
    Private Declare Sub SetLastError Lib "kernel32" (ByVal dwErrCode As Long)<br />
    Private Declare Function FormatMessage Lib "kernel32" Alias "FormatMessageA" (ByVal dwFlags As Long, ByVal lpSource As Integer, ByVal dwMessageId As Long, ByVal dwLanguageId As Long, ByVal lpBuffer As String, ByVal nSize As Long, ByVal Arguments As Long) As Long<br />
    Private Declare Function GetWindowThreadProcessId Lib "user32" Alias "GetWindowThreadProcessId" (ByVal hwnd As Long, ByVal lpdwProcessId As Long) As Long<br />
    Private Declare Function OpenProcess Lib "Kernel32.dll" (ByVal dwDesiredAccessas As Long, ByVal bInheritHandle As Long, ByVal dwProcId As Long) As Long<br />
    Private Declare Function WaitForSingleObject Lib "kernel32" Alias "WaitForSingleObject" (ByVal hHandle As Long, ByVal dwMilliseconds As Long) As Long<br />
    Private Declare Function CloseHandle Lib "kernel32" Alias "CloseHandle" (ByVal hObject As Long) As Long<br />
<br />
<br />
  Public Sub WaitForExcelToClose()<br />
<br />
        Dim hWnd As Long<br />
        Dim buf As String<br />
        hWnd = FindWindow("XLMain", excelApp.Caption)<br />
        If hWnd = 0 Then<br />
            buf = Space(1024)<br />
            FormatMessage(FORMAT_MESSAGE_FROM_SYSTEM, 0&, GetLastError, LANG_NEUTRAL, buf, 200, 0&)<br />
        Else<br />
            Dim pid As Long = 0<br />
            Dim lngThread As Long<br />
            Dim lngReason As Long<br />
            lngThread = GetWindowThreadProcessId(hWnd, pid)<br />
            Dim lngProcess As Long<br />
            lngProcess = OpenProcess(SYNCHRONIZE Or PROCESS_ALL_ACCESS, True, pid)<br />
            lngReason = WaitForSingleObject(lngProcess, INFINITE)<br />
            CloseHandle(lngProcess)<br />
        End If<br />
    End Sub<br />

thank you

Dave Kreskowiak11-Dec-03 2:44

11-Dec-03 2:44

Seems like alot of work for waiting for Excel to close. Could you declare the excelApp object WithEvents and then handle the WorkbookBeforeClose event?

RageInTheMachine9532

pnpfriend14-Dec-03 4:09

pnpfriend

14-Dec-03 4:09

how?

Dave Kreskowiak14-Dec-03 5:01

14-Dec-03 5:01

Possibly something like this:

Dim WithEvents appExcel As Microsoft.Office.Interop.Excel.Application
Private Sub appExcel_WorkbookBeforeClose(ByVal Wb As Microsoft.Office.Interop.Excel.Workbook, ByRef Cancel As Boolean) Handles appExcel.WorkbookBeforeClose
    ' do something here!
End Sub

I don't know if this is going to work the way you want, but...

RageInTheMachine9532