qrli's Q&A profile

• Microsoft ISV Community Center Forums VBA script not accessing another workbook

  I have written a simple application for user that pulls information from another workbook. When my workbook is open, the source worksheet cannot be accessed, but when I shut my workbook down, the source workbook can be accessed. This was written using office 2003 but was saved in a 97 to 2003 format and the user is using windows xp. This is happening on the user's computer but not on my own which is on the same network. Sub populate() 'total reps in team a at cell 2,9 'total reps in team b at cell 2,10 Dim repsa As Integer Dim repsb As Integer Dim monthcaps As String Dim monthproper As String Dim monthint As Integer 'monthint = Workbooks("Team Competition").Worksheets("Main").Cells(2, 12) monthi ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX August 2006 SDK, installed now my keyboard has gone haywire!

  I just installed the latest SDK, and now my backspace, arrow, enter and return keys do not work, all other keys work OK!! This is just happening in VS2005, all other apps work OK Now I think this coincided with the install. I have uninstalled but still no luck, I am up the preverbal creek without a paddle If any one can offer some advice I would really appreciate this, I am on a deadline I could really do without this Thanks Julian OK sorted now: http://blogs.msdn.com/john_pollard/archive/2005/12/21/506433.aspx Julian ...Show All

• Visual Studio Team System CTP7 - VisualStudio requirements

  I've got a subscription to the Microsoft Downloads RSS feed, and saw CTP7 show up. So I downloaded, uninstalled CTP6 and went to install. However it complained that Team Suite wasn't installed. I've got VS-TE for Developers as my base install. Am I going to have to go back to CTP6 Thanks For additional information about why CTP7 requires Team Suite or Team Suite trial edition (the "trail" edition, sadly, never caught on [sorry, couldn't resist the opportunity for bad humor in the morning]), refer to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=887356&SiteID=1 . ...Show All

• Visual Studio Team System Error 1 The specified schema name "Sales" either does not exist or you do not have permission to use it.

  I'm playing with the AdventureWorks DB to test the DB Pro piece, however after importing the DB I get tons of errors like the above. Is this a known bug in this release or did I miss something ciao andreas Hello Steven, thank you for the feedback, good to know I didn't miss something. Don't mind to use CTP. The product overall looks very promising. :) ...Show All

• Software Development for Windows Vista State Machine Workflow doesnot persist with ManualWorkflowSchedulerService - RJ

  Hi, I have a statemachine workflow with web application, SqlWorkflowPersistenceService does not persist workflow to database if I use ManualWorkflowSchedulerService so last statement instance.Unload(); throws exception since it tries to look for the instance id into database but it was not saved. System.InvalidOperationException: Workflow with id "c3a32e79-89dc-4dad-9ba9-7850ca479f35" not found in state persistence store. at Humana.WebArch.TCW.WebServices.TCWService.GetTCWWorkflowInstance(Guid instanceGUID) in C:\DotNetRoot\Projects\TCW\TCW.V1.0\Humana.WebArch.TCW.WebServices\TCWService.asmx.cs:line 1004 at Humana.WebArch.TCW.WebServices.TCWService.SubmitToWorkflow(String requestId, String workFlowId, String ...Show All

• .NET Development Application using WebService

  Hi Have developed an application that is deployed using ClickOnce. Using WebService to access data on the server. All users tested running on the same machine, different logins and access rights, XP. When running from a user with administrator right everything works nicely. When running on a user with 'Limited account' right I get an exception: WebExceptionStatus.NameResolutionFailure. I have tried to change the users rights to 1) administrator and 2)added him to the group 'Power users' and my application runs fine. Setting the right back to 'Limited access' and the exception NameResolutinfailed is back. Is this problem due to some settings not properly set in ClickOnce Or, cannot users with 'Limited account' use Appl ...Show All

• Visual Basic Warning As Errors

  Is it possible to default this to on There is no switch in Visual Studio to let you set the default setting for this for new projects like you can do for option strict/explicit/compare (Tools->Options->Projects and solutions->VB Defaults) You could modify the new project templates to get the behavior you want. You may also want to add a suggestion to the product team to add this option to the tools/options pages. Best regards, Johan Stenberg ...Show All

• SQL Server options other than row_number() ?

  Hi all, Friends i m badly stuck...... i want the functionality like select row_number(), name,class,age from student but the PROBLE is 1) I dont have sql 2005. 2) I dont have write access to database, so that i could create any sp. Is there any other way to achieve what the above query gives without using row_number thanks King: Is this more-or-less the kind of thing you are looking for set nocount on declare @student table ( [name] varchar (30) not null, class varchar (30) not null, age tinyint not null, primary key (class, [name]) ) insert into @student values ('Herman Munster', 'English 325', 217) insert i ...Show All

• Visual Studio Failed to load viewstate

  Hello, When I stay at one report for some minutes and push "Back to parent report button" I receive " Failed to load viewstate" message: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Htt ...Show All

• Visual C++ assigning derived class from base class declaration

  Hello; For the following code, know that Poodle is a derived class of Dog, and that aPoodle is an instanciation of Poodle. In the code below, I would expect dogObject to become a pointer to aPoodle, but it doesn't seem to work for me. Instead, dogObject seems to only maintain the attributes of dog. Any idea what I may be doing wrong ____________________________________________________________ Dog *getDogObject() { Dog *dogObject; DogTypes dogType; // an enum of dog types (poodles, hounds, etc..) dogType = getDogName(); switch (dogType) { case DogTypes::poodle: dogObject = &aPoodle; // <======= PROBLEM HERE break ; } dogObject->jump(); // <===== CALLS DOG.JUMP, NOT POODLE.J ...Show All

• Visual Studio Express Editions declaring arraylist

  How do i declare a arraylist variable in c++/cli. and i need to initialise 10 elements in it. How is done and how am i to get the value and gcnew it to array In .NET, the List<T> class is the generic equivalent of the older, non-generic, ArrayList class. You can check out the MSDN documentation for more information about the class. The topic for List has a fairly comprehensive sample in it that will answer your questions regarding initialization and access. ...Show All

• Windows Forms swap two rows

  In Windows forms 2.0 How do I swap two rows in datagridviews and also how do i allow user to see only first 10 records or last 10 records E.g, you want swap row2 and row4, you may 1. remove row2 and row4 and store them in temporary variables 2. Insert row4 to second row 3. Insert row2 to the fouth ...Show All

• Visual Studio Team System Looking for a way to create a SelF eXtractor (SFX)

  I have a copy of wzipse32 (winzip se) but it doesn't seem to work over the TFS, seems like some sort of running as a service problem. Does anyone else know of any other ways to do this I had actually tried this , but it didn't work because the process was still running at a service TFSService, and there was presumably a popup window which caused it to hang ...Show All

• Software Development for Windows Vista In July CTP, using StateMachineWorkflowInstance to obtain CurrentState freezes workflows in that State

  Dear all, I have a working StateMachineWorkflow hosted under asp.net 2.0. I have written a simple routine (shown below) to interrogate the current state of a workflowinstance: public string WfCurrentStateDescription(string WorkflowInstanceId) { // Get the workflowRuntime which was started in global.asax WorkflowRuntime wfRuntime = (WorkflowRuntime)Application[WorkflowRuntimeKey]; StateMachineWorkflowInstance wfInst = new StateMachineWorkflowInstance(wfRuntime, new Guid(WorkflowInstanceId)); return wfInst.CurrentState.Description; } I find that, once I have called this on a workflowinstance, that instance gets "stuck" in the current state and never transitions to the next state, even though code appears to get c ...Show All

• Visual Studio 2008 (Pre-release) Converting Message between soap versions

  Hello, is there a simple way to convert a received Soap11 formatted Message object to Soap12 Looking at the Message.CreateMessage overloads its not clear to me if the MessageVersion I provide has to match what I read in (say, using XmlDictionaryReader), or if it just sets the message version of the created message. Any examples of using this would be great. This was very helpful but I am stumbling trying to copy the headers from a soap11 message to a soap11wsaddressing10 message. The error I get is this: The version of the header(s) (Soap11 ( http://schemas.xmlsoap.org/soap/envelope/ ) AddressingNone ( http://schemas.microsoft.com/ws/2005/05/addressing/none )) differs from the version of the message (So ...Show All