Patrice RAUCQ's Q&A profile

• Visual Basic Windows Service with UI

  I want to create a Windows Service WITH a UI and a NotifyIcon in the system tray. I have installed the service to interact with the desktop and the service starts OK. In the OnStart of the service I have added code to show the notify icon with a context menu in the system tray. This displays OK. I also added code to to instantiate and show a form. The form shows OK. But then the form and the system tray icon become unresponsive. When I hover over the form with my mouse the Busy icon is displayed. The context menu does not show if I right-click the system tray icon. If I switch between other Apps/Forms that are open on the desktop my form doe ...Show All

• Visual Studio Run SQL statements from .sql file

  I know, the title is not good enough, but... Anyway, here's what I want to do: 1. I have an add-in exposed as menus under the tool menu. 2. Eventually I'll have a *.sql file with some sql statements (however this file will not be in a database project). 3. I would like to be able to "Run" a statement from the *.sql file as I can do against a query file from inside a database project. Is this possible, if so how Niels This is certainly possible.  You can see how to create an add-in with exposed menu items by using the new addin wizard from the New Project dialog.  There's an option in the wizard t ...Show All

• Windows Forms Novice :)

  I want to do something simple, but I'm from a long time ago and I am only familiar with Batch Files and Basic. All I want to do is make a nice interface application to copy a file from one location, a CD, to my Hard Drive. This is a daily task and I want to make it simple. I just want to have an icon on my desktop, Po ...Show All

• SQL Server attempted to divide by zero

  hi, i had this formula written for a textbox in a table, but yet still encounter the following error: expression: =iif(countdistinct(Fields!room.Value)=0,0, sum(Fields!rate.Value)/countdistinct(Fields!room.Value)) error: attempted to divide by zero. any way i can solve this problem thanks! Hi, Please try out with this formula, =iif(countdistinct(Fields!room.Value)=0,0, sum(Fields!rate.Value)/IIF(countdistinct(Fields!room.Value))=0,1, countdistinct(Fields!room.Value)) I think it will work. Cheers, Shri ...Show All

• .NET Development Web.Config or Machine.Config - which preceeds?

  Hi, If I have a different value for maxRequest length in Web.config and Machine.Config, which  value overrides the other Srilatha Thanks. I got more info on the same topic from this link. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetsec/html/THCMCh19.asp ...Show All

• Software Development for Windows Vista WWF Beta 2

  When is scheduled Beta2 Hi, I did realize that question was regarding WWF, but since WWF is a integral part of WinFX now, it does not make any difference to talk of  it as WinFX which is a superset. Regards, Vikram   ...Show All

• Visual Basic Microsoft.Office.Interop.Access - Open Application Non-Visible / Reference Report/Form

  Hi, I have created an Access object (Microsoft Access 11.0 Object Library) and connected to my db, but want to open it without the Dialog Box where you have to select Open - In fact, I don't want to see Access at all - just open it in the background. I then want to reference my Reports and Forms and then reference the controls on them and then reference the properties for each of those controls. I have been trying to do this for a while now and read a number of articles, but still no luck. Would like to do all of this using VB.Net 2.0 - see my code below with what I have so far. Dim oAccess As Access.ApplicationClass ...Show All

• Visual Basic VB .NET/VB 2005 Express/ VB 2005

  Hi. Ive decided to move from VB6 programming and Im not really sure where to go.. Ive got a copy of VB .Net 2003, and Ive also downloaded VB 2005 Express edition, with a possible view to getting hold of Visual Studio 2005 to program VB 2005. The problem (and confusion) that I have is - what is the difference, and which should I turn to Am I right in assuming that VB.NET 2003 and VB 2005 are different, or am I ok to learn .NET 2003 until the 2005 version comes out I know this might seem like a dumb question, but I want to move onwards and upwards and am a little confused, as I dont want to concentrate on 2003 if I'm going to be learning an ...Show All

• SQL Server multiple-step ole db error

  When trying to connect to sqlexpress, I get the rather uninformative error message: Error No. -2147217887 Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work was done. Here's the connection string I'm using: strDbConn = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & _ DbPath & ";Database=rawtf_1;Integrated Security=True;User Instance=True; " & _ "Trusted_Connection=Yes;providerName=System.Data.SqlClient" What can I do correct this problem Thanks so much Mike. All the obstacles seem to have been cl ...Show All

• Visual C# winform flickering problem with Framework 2.0

  Hi. I have a winform with a background image and a listview control, When i load the form i resize the form to the size of the primary screen on the form_load event. i get a flickering effect before the forms loads. I tried different ways but could not get a work around for this problem ... I appreaciate if anyone could suggest some wayout .... Btw i am using VS 2005 .NET 2.0 thanks Use this .SetStyle( ControlStyles .AllPaintingInWmPaint | ControlStyles .OptimizedDoubleBuffer | ControlStyles .UserPaint, true ); after InitializeComponent() ...Show All

• Visual Studio Tools for Office VSTO Installation Problem

  Hi I installed full MS VS.Net 2005 professional edition on my machine and i have Office 2003 installed on the same machine. Basically i want to write an add-in for MS Word. When i try to create a new project i cannot see the options for office templates. New Project-->Visual Basic -->Windows/Database/Starter kits. But i do not have any "office" folder in my visual basic and no templates installed in it. Do i need to install any extra software for this Thanks in advance Praveen Yes, the Visual Studio Tools for Office tools are not included with Visual Studio 2005 Professiona ...Show All

• Windows Forms Reading Excel Spreadsheets

  I need to create a VB.NET Windows Forms application that can read the data within an Excel spreadsheet.  But, I'm not sure where to get started.  So far, I've found some articles how creating Excel macros, but not about what I want to do.  Do I need to download Visual Studio Tools for Office   I just want to be able to open&nbs ...Show All

• Visual C# System.ArithmeticException (Overflow or underflow in the arithmetic operation.)

  im new to .net . today when i opened my application it gave an error saying "An unhandled exception of type 'System.ArithmeticException' occurred in system.drawing.dll Additional information: Overflow or underflow in the arithmetic operation." kindly please tell me how to remove it. i also searched it on net and i found the following that by changing the following code [STAThread] static void Main() { Application.Run(new Form1()); } to [DllImport("msvcr70.dll", CallingConvention = CallingConvention.Cdecl)] public static extern int _controlfp(int n, int mask); [STAThread] static void Main() { const int _EM_OVERFLOW = 0x00000004; const int _ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectSound issue: any help appreciated

  I realize this question is going fairly ambiguous, however the nature of the problem is somewhat similar. I'm developing the sound engine for a project, and the sound engine initially worked fine within the project. I took a break from the project, and when I came back the audio no longer played. Currently, when PlaySegmentEx is invoked, S_OK is returned... however absolutley no audio is audible. I am currently able to seperate the engine into its' own solution and the audio, strangely enough, plays back flawlessly. This has lead us to believe that somthing was changed within the project settings -- however we have not had any luck discoveri ...Show All

• SQL Server Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo         lName    -----         ------    1           ...Show All