nigek's Q&A profile

• Visual Basic Workbooks.open

  Hello all, I have tried numerous ways to modify the responses to "Openening an Excel file from within project" to open an existing Excel workbook and also select and activate a minimized workbook but have totally struck out, Can anyone give me some guidance Also, where should I be looking for samples that answer such basic questions Thanks very much. Noel Rietman This is the code that MSDN says will open a workbook. It Does not work. All I get with this is "Type Excel.Workbook is Not Defined" How do I define it Thanks for any help. Tom Hallmark The Workbooks collection in Microsoft Office Excel 2003 makes it possible to work with all the open workbooks, create a new workbook, and impor ...Show All

• Visual Studio Express Editions I am having a problem with my code.

  I was trying to make an application. the application is very simple but when i was typing the code it said there was two errors. The first error was ('ElseIf' must be preceded by a matching 'If' or 'ElseIf'.) The second error was ('End If' must be preceded by a matching 'If'.) I really need help to get this code error free. The code is at the end of this page. Thanks for helping. The code Public Class Form1 Dim door As String = "locked" Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If door = "locked" Then Button1.Text = "Unlock" Label1.Text = "The door is locked" MessageBox.Show ...Show All

• Visual Studio Team System Custom Generator walkthrough documentation error?

  Hi, I am somewhat new to C# (less than a year though I've been programming for way more than ten years) and even newer to VS2005 (a whole day now!) so there is a chance that I am the problem. Anyway, I think I have found an error in the documentation for creating a Custom Generator or, less likely, an error in the Generator class itself. In the documentation it says that the GenerateNextValues() class needs to be overridden however this method is sealed. The method OnGenerateNextValues() is virtual. Should the reference in the documentation be to OnGenerateNextValues() or is there really a problem in the class In the walkthough there is an instruction to right click on the overridden class name (Generator) in the code window an ...Show All

• SQL Server w3wp causing memory paging, crash on reportserver?

  Summary: We host reports off of one server that are accessed and refreshed 24/7/365. On a daily basis, I receive calls about reports taking several minutes to run IF they run at all. (normally these reports take seconds). There has yet to be an actual "error message" associated with this behavior. When I check the server at these times, I will find that w3wp.exe process is taking up about 4G and is causing paging. It seems that once it gets to that point, it will kill itself and all goes back to normal. However, it's a slow death and is impacting business. We're using MSRS 2005. Hosting the reports is the job of this server--no other applications are hitting it. There is a development SQL db on the box, but not in use at this ...Show All

• SQL Server [SSIS] : STDEV in Derived Columns

  Hello, Does anyone have already tried to calculate a standard deviation (STDEV) in a derived column Any help is welcome ;-) Cheers, Bertrand Haven't calculated standard deviation in a derived column, but rather in an Async script component (i.e. Synchronous Input Id = 0 on the first output). The data being passed in to this transform is DT_CY data type (currency) called TotalDue. The data passed out is a DT_R8 on the output called StdDev. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Private rowCount As Integer = ...Show All

• Visual Studio Error: Subreport could not be shown

  Hello, Situation Dataset One dataset with two unlinked tables in it named 'Group' and 'MainGroup' both tables have a field called 'hgrp_id', no relation existst between the tables. The dataset is filled before I open the report, both tables contain the correct data; Reports On the mainreport(uses 'MainGroup' ) there is subreport(uses 'Group'). The subreport has a parameter that also get's passed to the subreport with the correct name and value; Size The subreport is less wide than the subreport container on the mainreport. Filter I tried changing the type of the parameter from int to string, didn't forget to use CInt(<param>) to cast it back to Int32 when used in the filter-rule. Result Mainreport ...Show All

• Windows Forms How do I set the location of a control loaded at runtime?

  I've created a Button control that I want to locate on the bottom of the form.  How can I use the form's size attributes so that no matter how the form size is changed, the button(s) will always be centered along the bottom of the form At this point, I'm dragging a button control from the tool box and positioning it on the form then, using the button's Location property to use in the code then deleting the button from the form.  I can vaguely remember in VB 6.0 that you would use the form's ScaleWidth and ScaleHeight but these are not in C#. Needless to say, I'm kinda lost. Rhubarb I had the code in the Initialize method: public formWinFormCntls ( ) { InitializeComponent ( ); //* //* Butt ...Show All

• Windows Search Technologies One Note Search Function

  I installed the One note beta and the WDS 3.0 program . I changed index settings to only the folders that contact the one note files and a few other folders . Now when i try n search in one note , it does not search beyond the particular page i am in , if i try searching for something on all the note books . it says it found 0 matches and suggests me to : change my search criteria or unencrypt etc ....although my selection for search is all notebooks . Also after feb-1 wat happens to this software , i am need to know bcoz im saving critical stuff on this application rbarua, It sounds like you ran into a fairly common problem that can happen when WDS 3.0 is installed with OneNote (certain r ...Show All

• Visual Studio Team System Monitoring Version Control Activity

  My company has its own quality assurance system and for now we only want to use TFS only for version controlling. At the moment we are using VSS for version controlling. Now when a programmer check's out/in, adds a file or does any operation in VSS which influenses the project a dialog pops up requesting from him what task this action is for and subsequently the programmers action is recorded in our Quality assurance system. So if the programmer eg checks in a file he gets a popup dialog, selects the appropriate task and the file checkin is logged with the task in our system. In VSS we do this through a COM object that VSS loads automatically on startup. I have been trying to find a way to do this in Team Foundations Version Contr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What units are the x, y, z components of a Vector3 with respect to screen space?

  Hi, I've just got hold of the XNA Beta and have a really basic question really. The following vertex VertexPositionColor [] vpc = new VertexPositionColor [1]; Vector3 v1 = new Vector3 (0.0f, 0.0f, 0.0f); is drawn from what I can see directly in the middle of the game window. I tried varying the x and y components of the Vector3 and found that it does not like values above 1.0. I can move it by incrementing the x or y components by 0.1f. And so my question really is how do the units I provide to vertex Vector3s relate to screen space I am used to systems that a) start from the top-left of the window and b) where if you say Vector3(10, 20, 0) would draw the vertex at 10 pixels across, 20 pixels down. Some pointers on t ...Show All

• Visual Studio Help needed in creating an installer for the guidance package which I've created

  Hi all, I'm trying to create an installer which'll help me in installing the guidance package project which i've created. The thing is when i run the installer, the guidance package project should be activated and get registered into the client machine. And once the installer is run, then the user should be able to find the project template generated by my guidance package. Can anyone who've worked in this area guide me and share their knowledge Thanks in advance, ThunderRock Hi Victor, Thanks for the guidance. But I've some more doubts. Can you please clarify on how to use it since I want to package my guidance package in an installer How do i use this VS Setup project for packag ...Show All

• SQL Server problems displaying images

  Hi I have a query that returns a companyname eg. "ACD". This info is then saved in a parameter. On the logo (which depends on company), I use this parameter value to the pick up the right picture like this: =Parameter!.company.Value &"_logo.jpg" The image is there on the server an the path is correct, but the image is not displayed! What is wrong I think you're misunderstanding. Use a URL to access the LOGOs (not the report). In other words, host your images on a website and access them from there instead of from windows. If you don't have a website, set up an account at http://photobucket.com/ and host your images there. It's quick and simple. ...Show All

• SQL Server A performance increase by SMS

  Hi, I select icons (~10Kb) one by one from a database. The performance is 3 icon per sec. If MS SQL SMS is running at the same time as my application, the performance increase more then 20 times. SMS executing lead to the same result during a sql insert. E.g. an inserting of 5000 rows take 1040 sec. without SMS and 47 sec. when SMS is working in the background. Sql2005 express, SP, PK, VS2005 standard, C#, SqlConnection, SqlCommand Incidentally, MSDE + VS 7.0 led to the same result. How to configure Sql2005 to fast a sql query executing (without SMS) Do MS products (e.g. Sql2005 express) have a back door to IFF detect and slow down a performance Thanks ...Show All

• .NET Development Emails send Through Exchange Server.

  Hi All, I need your help regarding sending Email through Microsoft Exchange Server. Is there any code snippet or any .dll which will give me the brief idea As per my info Exchange server act as wrapper and invokes SMTP internally to send the mail. Outlook is client and been connected to exchange server. I don't want to install outlook on my machine and want to directly connect to exchange server which is located at company network. How Should I connect to Exchange Server I have done googling lot but most of comments have use SMTP Server. I am able to send mail using SMTp Server, I have installed a third party SMTP server(ANSMTP) and used for sending mails. I also tried sending mails through Outlook using C# , it's done ...Show All

• Visual C++ error: Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast

  I got a sample code from MSDN ( http://msdn2.microsoft.com/en-us/library/aa382363.aspx ) I generate a Win32 console application project in VisualStudio 2005 and copy the code into my main.cpp. But when I compiled it, I got the following errors: 1>Compiling... 1>main.cpp 1>.\main.cpp(55) : error C2664: 'CertOpenSystemStoreW' : cannot convert parameter 2 from 'char [256]' to 'LPCWSTR' 1> Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast 1>.\main.cpp(103) : error C2664: 'CertGetNameStringW' : cannot convert parameter 5 from 'char [256]' to 'LPWSTR' 1> Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style ...Show All