Mark Anstice's Q&A profile

• Microsoft ISV Community Center Forums Problem with integer function

  I have been trying to troubleshoot the following code, but cannot figure out what is causing "Type Mismatch" error. Sub PutData() '\ called by other subroutines         If Me.CheckTech.Value Then Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = Int(Me.TextD) Else Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = 0 End Sub When I take out the integer function a number is written as text.  Also, when I execute the code in the following fashion it works: Dim iCount As Integer . . iCount = Int(Me.TextD) . . . Sub PutData() '\ called by other subroutines      &n ...Show All

• Windows Forms crystal reports not displaying data

  Help! I'm developing a desktop application that uses several crystal reports.  I use an ADO.NET dataset and set the datasource for all my reports in code.   Up until a week ago, I never had any kind of problem with this.  Then suddenly - as in it ran fine one minute and not the next - all my reports stopped showing data.  I get ...Show All

• Windows Forms Error at design time in visual studio 2002 and not in visual studio 2003

  Hi to everybody. I have a big trouble ad I hope that someone can give me an hint. I made a simple component. A rich text editor, just like the wordpad. I developed it in visual studio 2003 and it works fine. The problem is that they asked me to make it work for visual studio 2002. I made a new project, I added the code, and compiled. No& ...Show All

• Visual Studio Express Editions ActiveForm question

  Ok, I know that the ActiveForm object returns the, well, active form. But what about the active form's controls I can't access those because they don't appear as one of the ActiveForm's objects, and when I try to compile like that it says that the property doesn't exist. So how can I access the controls of the active form Please help! The ActiveForm property returns a Form reference because it can be any type of form.  You need to cast that reference to the appropriate type to be able to access the members of that type.  If the ActiveForm may be any of several types then you're going to need to test what type it ...Show All

• Visual Basic Comparing data within datarow.

  Hi, I would like to know if it is possible to correctly compare value between 2 data fields in a dataset. I am trying to put this in my final year project. So far I have managed to make some head way through it from books and a lot of help from this forum. Heres the deal. I am trying to make my app compare two data values in the same datarow which will then cause an output to be entered in another field within the datarow. So I have tried to do it like this If perTable.Rows.Item( CInt (sC1))> perTable.Rows.Item( CInt (sC2)) then..... (the data set is not typed hence the long line thing) but since I've turned option strict o ...Show All

• SQL Server Optimize for CPU load

  What are the best practices to avoid CPU load in SQL Server >>optimal query plans hmmm.Does not mean no Joins no triggers no Unions which one is the worst ...Show All

• SQL Server The multi-part identifier "alias.field" could not be bound???

  Hi, When I try execute one query in SQL 2k5, with alias in order by clausule, I retrieve the follow message: Server: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "alias.fields" could not be bound. Where alias is a any alias and, fields is a field of the table with alias. Already exists one fix to patch this Thanks This was a bug in the older versions of SQL Server. We fixed the problems with the ORDER BY clause in SQL Server 2005. This is documented under the following topic:   http://msdn2.microsoft.com/en-us/library/ms143359.aspx   You should also check out the other bac ...Show All

• Visual Studio Team System Unit Testing a Web Project

  When creating unit tests in the past, I'd create a Visual Studio project specifically for the NUnit tests and then add a reference to my web application's .dll so my unit tests could access the classes and methods in the web app. However, in VSTS, it seems as though VS doesn't allow for creating references to the .dll of a web project (not very easily it seems) When I go to add a reference to my test project for the web site .dll, I have to first publish the web site so there is a .dll somewhere and then manually find that .dll so I can add a reference. Am I doing something wrong I obviously don't want to have to publish my web site each tim ...Show All

• .NET Development ServicedComponent RegistrationException - Invalid Derived Classes

  I am having difficulty with code that used to work in 1.1 working in 2.0. I have an n-tier application that uses ServicedComponents for persisting database information within a single transaction. Because I want these classes to be able to participate in transactions, I derive them from System.EnterpriseServices.ServicedComponent. In 1.1, this worked just fine, however in 2.0, when remoting these components using .NET remoting over TCP, I recieve a RegistrationException stating that: Invalid ServicedComponent-derived classes were found in the assembly. (Classes must be public, concrete, have a public default constructor, and meet all other C ...Show All

• Visual Studio Team System TFS: Can't access to TFS Beta 3 Refresh from remote Team Client

  Hello, I have two machines in my test network - first is domain controller running under Windows Server 2003 R2 Build 2038, I have installed WSS SP2 that came with R2, SQL Server 2005 as the default instance (RTM). The second machine is running under Windows XP Media Center Edition 2005, it is joined to my domain (I know how to do that). I installed TFS B3 Refresh successful by using recommendations following to Installation Guide, created two accounts for TFS - TFSSERVICE and TFSREPORTS. But now firstly there're not any administration tools for configuring TFS. Ok, I tried to connect to TFS by using my Visual Studio 2005 RTM from my client ...Show All

• Smart Device Development [Using Visual Studio 2005] Using a Class defined outside any project

  My question is quite simple : I've got two C# projects in a solution. with that i create a C# class outside any project, it's only a log class I want to use my logger into my two projects, how can i do that I try tu put my class in "Solution Items" but i can't use my logger In C++ i could include my class passing it's path but how i do that in a C# project Hi, The recommended way of doing this is to use a classlibrary and hence there is no way to *link* the file. Now you could just copy across the same source file to both projects but you will need to update the source code in both places in case ...Show All

• Visual Basic Dragging the form without using the title bar

  I have a problem on my splash screen, i set the borderstyle to none. How can I drag the form without having the title bar. I am using Visual Basic Express You need to write your own code to catch a click on the form, and move the form as you move the mouse with the button down. ...Show All

• Windows Forms Smart Client & Web Service

  I am developing a smart client application that  uses Web Service to load data - a dataset containing 15 Tables. The data is subsequently loaded in about 15 forms where the user can amend them using textboxes, comboboxes,calendars etc. Once they decide to save their changes, the data should be sent back to server via Web Service. I would appreciate any help ...Show All

• SQL Server SSIS Script Component

  Dear all, Such a pain, I know. Yesterday I did a couple of questions regarding transformation rows and very kindly I obtained answer (Thanks Jamie and Michael) But now I face another stupid issue and is how to map source with destination columns inside Script Component Task. On my Flat File Source I’ve got defined thirteen columms (from Column0 till Column13); that’s fine. And then, I’ve got a sql table as destination with another names, of course… Inputs and Outputs option from Script Component Editor leaf has been commited both (Input 0 and Output 0) but I wonder how the hell I’m refer to them here: Public O ...Show All

• Visual Studio Team System How to spawn Team Explorer

  Is it possible to launch Team Explorer client from a web page Something like URL to link from Team Project Portal. Preferably pointing directly to the related project. obs.: I've tried to do that using a script with shell command, but my users have VS2003 installed in their machines too, and in some cases it gets launched instead of VS2005 (when running DevEnv.exe). Thanks, Max You could tweak "Content Type" to something IE does not understand, like "application/devenv" and it will open the file in devenv after the usual warning.  Nearly all of the VS registered content types are text/plain or ...Show All