Micky G's Q&A profile

• Visual Studio Tools for Office How to detect item class in outlook object model

  I'm working on this outlook automation in visual basic and I need to dynamically figure out what type of folder (mail, contacts, tasks, etc.) the current folder is. I tried both olFolderInst.Class and olFolderInst.Items.Class and they always return the same value of olfolder and olitem respectivly regardless of what the folder is. How do I go about doing this Something like this should work: Outlook.OlItemType type = oYourFolder.DefaultItemType; switch (type) { case Outlook.OlItemType.olAppointmentItem; // We have an appointment case Outlook.OlItemType.olMainItem // We h ...Show All

• SQL Server Table partitioning with multiple keys coulmns

  Table partitioning with multiple key coulmns Hi champs! I have one table with around 600 million records. I want to partition this table on 5 different coulumns. year, month. coulumn3, coulumn4 and coulumn5. How do I do this best What is the best way of doing this; is there any best practice on ths The obvious thing is to make a partition funktion based on the year and month coulmns, but I also want to partition on coulumn3, coulumn4 and coulumn5. Many thanks Kurlan There is no direct way to create partition on multiple columns. You will have to create a computed column using the multiple column values a ...Show All

• Visual Basic Mapping value of variable and value of object

  Hi, I am doing UMI design in VS.Net 2005(basic). This project is relative to DAQ, so the data structure is not standard, but many variables I need to set up from user interface or get from my hardware equipment. In order to make easy operation and control, I am thinking to find a solution to make a map between the variables and component in the interface. for example, I declare: dim a1 as new string dim a2 as new string in my user interface, I have label1 and textbox, I would like to build such relation: a1 and label1.text, a2 and textbox.text can exchange their value each other when any of them change value. Becaus ...Show All

• Windows Forms Customize Progress Bar

  hello, i need to make my  1 ) progressbar to embed on the status bar 2) it should be an "gradient" progress bar How do i do this Thanks Apart from the autogenerated code that is the full source code. You must set the ShowPanels property of the StatusBar to True, and the Panels Style property to OwnerDraw. ...Show All

• .NET Development What Iam doing wrong?

  OK. What Iam doing wrong here I have wrote this function, but it doesen't work :S. ReadHTMLFile() is a function that reads whole HTML file. GenerateMenuBar() is a function to generate menu bar for the HTML file. Then I do what I need to do (is in WriteHTMLFile() function) and when I write the file I get a page like some tags are missing (truncated :S). I compare the html files (the original one and the generated one) and Ive notice that at the bottom of the file some tags are in very strange place (see below the code). public void WriteHTMLFile()         {          &nb ...Show All

• Visual Basic Updating Main Form Control from a thread or a class.

  First of All i am using Vb.Net 2003 well! guys here is the scnario. i have created a set of classes. that are as follows: 1-Database 2-Browser 3-Responser now Responser is what is using these other two classes no.1 and no.2. i am calling a method from class 3. in my Main Form as a thread. and then this thread works so that main form won't effect. but i want to update my main form accordingly so that user can see what is happening, and don't think that nothing is happening. how can i update my Caller(Main Form) from the that thread of else what Technique or Application design i can use to perform this task. Hi, Take a look into Contro ...Show All

• SQL Server SQL Server 2005 Express & Windows Reporting services

  Hi, I've just installed SQL Server Express 2005 on our shiny new Windows Server 2003 R x64 server. It has an Intel 830 D chip that uses x86 and 64EMT. Problem is that I get the message "64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit)." Is there any way that I can remedy this Thanks in advance Robert Hi Robert, This should fix your problem (taken from the SQL Server 2005 Readme): 2.5.13 Configure IIS to Run 32-bit Reporting Services in WOW64 Mode This readme item provides an updated version of the "Ho ...Show All

• SQL Server Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

  No wonder Microsoft is giving it away for free. It’s not worth anything. I am very disappointed in this version of SQL server. I decided to start learning VB so I downloaded and installed VB 2005 express edition and SQL 2005 express. I tried to build a personal website using the starter kit. I kept getting the following error message, for which I have seen numerous postings on this forum. “Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.” I went out and bought the Standard version of VS 2005 thinking there may be a feature that the free exp ...Show All

• Visual Basic "Can't add a reference to selected file."

  I'm in new territory on this, and after an hour of searching on the net and MSDN, I can't find a satisfactory answer, so here goes. I am using VS 2005 B2 and have Excel 2003 installed. I wrote a simple class library using C++/CLI (C++ with the clr switch).  It seems to work just fine when used from, say, a console app written in C#. But I want to be able to use the component from within an Excel macro.  While in the VBA environment for Excel, I choose Tools, Add reference, and browse to my component DLL, and it gives the the error "Can't add a reference to selected file." I am aware that fxcop catches issues with COM interop, but I ...Show All

• SQL Server Appending to a recordset destination

  Hi, We have a data-flow that extracts from a raw file and inserts into a datareader destination. The data-flow requires DelayValidation=TRUE because of the raw file source ( http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx ) Unfortunately it also requires DelayValidation=FALSE because of the Datareader destination ( http://blogs.conchango.com/jamiethomson/archive/2005/10/20/2284.aspx ) So basically we can't do it this way. We'd like to replace the raw file destination with a recordset destination but we have to be able to append to it. Is there a way of appending when using a recordset destination Thanks in advance! ...Show All

• Visual Studio Express Editions MSDN OpenGL and VC++2005 Express

  I found an area in MSDN that has files to show how to use OpenGL in VC++ but get over 250 error when I attempt to compile.  Am I going to have to fix them so I can see hoe to use it with VC++ Express Is there a conversion utility Location of MSDN area:  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnopen/html/msdn_gl1.asp   Thanks, RON C I would appreciate help.  I have never programmed on a Windows machine before.  Did some DOS stuff years ago. What I'm doing is that I used VCExpress to build a Windows program with a split pane.  I have buttons in the right pane ...Show All

• SQL Server Group Filter Not Working

  I'm developing a simple client application, using local reports populated from a local dataset, which is in turn saved and read from xml.  I am trying to set up a VERY simple group filter expression and I'm running into problems.  What I want to do is display all rows where a date column matches a parameter passed to the report.  I'm setting the filter up using something like this: Expression                 Operator             Value =Fields!SampleDate     &n ...Show All

• .NET Development Help: DotNet Tcp Client Bound

    Hi All, I am using a TCP server to accept connections from n TCP clients (with Socket.Select()).  It seems that there is a strange bound on the value of n in Socket.Select. Steps to reproduce the problem. 1. Bring up a TCP server on port 19999 in a thread.  This thread use a socket arraylist as the first parameter for Socket.Select(). 2. Bring up client threads one at a time, with 1 second inteval between two client threads.  Each thread creates a client and connects to that server.  The number of client thread is n. 3.  When  the number&nb ...Show All

• Software Development for Windows Vista Parallel Webservice Invocation

  Hi! We'd like to invoke some time consuming webservices in parallel, but it seems that the InvokeWebservice activity is synchronous and the workflow scheduler is not able to execute the webservices simultaneous in a Parallel activity. Are there any plans to improve this behaviour or other ways to archive the needed functionality Martin That particular activity executes the service call synchronously. You could build custom activities that execute asynchronously. take a look at the web service examples in the activity gallery at www.windowsworkflow.net Matt ...Show All

• Visual C# Multi-interface properties

  Hi, I have an interface that should declare a Property whose type should implement two interfaces. E.g. given a method T GetAsset<T>() where T : ILocatable, ITypable; I want to use a property Asset instead of the method GetAsset. My first attempt was to use T Asset<T> where T : ILocatable, ITypable { get; } That doesn't work as properties can't be generic (for whatever reason...). My second attempt was to declare a type using 'using': using MyType = ILocatable, ITypable; that doesn't work either :/ Is there a nice & clean solution without defining a new interface ILocatableTypable and without making the whole class having the ...Show All