viperjason's Q&A profile

• SQL Server Drill down on table fields?

  I remember that one of the cool things you could do in SSRS 2005 was drill down. I have a summed field in my SSRS Report table which I'd like to see the records behind that sum. How do I enable this feature where I can double click that field ...Show All

• Visual Studio VSS 2005 can not show history.

  I'm using VSS 2005 and VS2005, both version are 8.0.50727.42. I'm using VSS Explorer. The "Show History..." does not work. No any results when I choose a long period. I tried to empty "From" and "To" fiels, the result is same. Any idea Thanks in advance. I'm experiencing the same problem. I've recently upgraded to the RTM version of VSS 2005 (was previously using the Beta version, and 6.0d before that). I've observed that any databases that I created with the 6.0d client work properly. I can view the history of files, see their dates and labels, etc. Any databases I created with the 2005 Beta or now with 2005 RTM, History functional ...Show All

• Visual Studio Team System Error 28703

  Hi, I have a problem during the installation of Team Foundation Server, the error is: Error 28703. Unable to connect to the SQL server. Please check that you have the necessary permissions and the SQL server process is running on the data tier. See the setup logs for more information. In spite of this I can connect from another pc to the SQL Server. I can conect to SQL Server using the user TFSERVICES During the installation I'm using the user TFSETUP. Somebody can help me, thanks. HI, More data about my installation of TFS. I’m installing TFS in a single-server and configur ...Show All

• Visual Basic Creating Zip Files

  Is there access in VB2005 that allows creation of compressed (Zip) files, or at least has access to the windows-based utility that puts files into a compressed folder You can download one from here: http://www.icsharpcode.net/OpenSource/SharpZipLib/Default.aspx . ...Show All

• Visual Basic How to update ID values in multiple tables

  Hi, I am in the process of developing an IT Asset Tracking System in VB.NET. I have come across a small problem though. A user is assigned to a Desktop PC and also assigned to other items such as a Printer, Monitor etc. The workstation details along with the user is stored in one table and other items associated with the user are stored in another table. If I then disassociate the user from the Desktop PC by removing the userID, I also want the userid disassociation to happen on the other table where there were other items assigned to the user. If I then assign a new user to the Desktop PC, how can I then assign this new user to the ...Show All

• Visual Studio Catching files added to a project/solution

  Howdy! I've been trying to figure out how to receive notice when a file is added to a project to no avail. My goal is to run an operation on all new files as they are added, no matter what type of file it might be. I thought AdviseSolutionEvents might have the info I want, but it sounds like it only passes on info about new projects. Does anyone have any advice Many thanks, Matt Hmmm, looks like it is time for me to learn C#. =) Thanks for the help! I'll let you know how it goes. ...Show All

• Microsoft ISV Community Center Forums Opening a Word file from a macro in Excel

  I have some code that will open a Word document from a macro in Excel, but for some reason it won't recognize the Word file if the folders in the filepath have any spaces in their names. Here is the code: Sub MergeToWord() ActiveWorkbook.Names.Add Name:="MyData", RefersTo:="=Sheet1!" _ & Range(Selection, Selection.End(xlDown)).Address Shell "C:\Program Files\Microsoft office\Office11\winword.exe F:\\Shared Files\wordfile.doc " End Sub The line in red is where the problem is. Since there is a space in "Shared Files" it doesn't recognize the word file. Does anyone know a w ...Show All

• Windows Live Developer Forums Client found response content of type '', but expected 'text/xml'

  I have a web service that uses the MSN search web service. When its called by a client using the SOAP toolkit, after about 10 calls, the try/catch block around the MSN search call within my web service starts to catch this error: Client found response content of type '', but expected 'text/xml', which is returned to the web service's client. That error is repeated on several calls, and then it eventually goes away, and then may come and go after that. I have a search page that uses the MSN search API that doesn't get this error. But that's only used by web browsers. Anyone know any reasons for this error I read somewhere that this m ...Show All

• SQL Server Previous Row Calculations

  Hi all  I am wondering if anyone know a way that you can look up a value from the previous row to do a calculation on. I have a field that I need to subtract the same field from the previous row to validate. Is this possible in a query Thanks Kenzie Slight simplification, you can use only the CTE in the self-join like: WITH t_seq AS ( select ROW_NUMBER() OVER(ORDER BY <column_list>) AS seq from <table> ) select ... from t_seq AS t1 left join t_seq AS t2 on t2.seq = t1.seq -1; ...Show All

• Visual Studio Can't find Class Designer on IDE

  Can't find Class Designer on IDE I have the most basic question of all.  I've installed the Feb CTP.  Nowhere in any of the menus can I find the class designer.  If I add a new class the designer doesn't show.  I just get the basic classX Where do I find the class designer dennist SKU is packaging form - e.g. C# Express, Visual Studio Standard, Visual Studio Team Suite etc. You can find out which one(s) you have installed by going to Control Panel | Add/Remove Programs and finding them listed there - e.g. I have the following product name on machine with Beta2 VSTS installed: "Microsof ...Show All

• Visual Basic trouble setting a max and min value

  I have the following code: Private Sub numericTextboxKeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress Dim tb As TextBox = CType(sender, TextBox) Dim chr As Char = e.KeyChar If IsNumeric(e.KeyChar) And Not e.KeyChar = "-" Then 'If adding the character to the end of the current TextBox value results in ' a numeric value, go on. Otherwise, set e.Handled to True, and don't let ' the character to be added. e.Handled = Not IsNumeric(tb.Text & e.KeyChar) ElseIf Not Char.IsControl(e.KeyChar) Then 'IsControl is ...Show All

• Smart Device Development Need a couple clarifications please

  My company is planning on doing some Pocket PC development in the near future and I have been asked to look into which version of Visual Studio we would need to get. Currently we have either VS 2003 or 2005 Standard in mind. We know 2003 will work for sure but I have a couple questions regarding 2005 that I have not been able to find clear answers on. 1. Does 2005 COMPLETELY with no issues support development for Pocket PC 2003 SE devices using the 1.0 .Net compact framework or do we have to use the 2.0 framework 2. Can the "streamlined" interface of the Standard edition be un-streamlined to make it work like the Pro edition (with obvi ...Show All

• SQL Server sys.conversation_endpoints

  Is there anyway to figure out which tables/objects this view uses In SQL Server 2000 one could see the actual script of the view but in Yukon this is only possible for user-created views, right What I am aiming for is to combine the speed of sp_spaceused with the information in sys.conversation_endpoints (and maybe other service broker views, like sys.transmission_queue) to tell me, quickly, how many conversations are in a particular state. The underlying tables a hidden so you can't access them in a SQL statement.  The view should be as fast as accessing the underlying tables after the query is ...Show All

• Software Development for Windows Vista Error Installing December CTP

  I have WinXP profesional with SP2 installed on my machine. I have 2 partitions C: and D:. I have selected to install Vista on D:. Free space available on D drive is more than 9GB. I am getting error as follows: "Setup was unable to locate a locally attached hard drive suitable for holding temporary Setup files." Please let me know, if there is any solution to overcome this problem. I even tried installing in VirtualPC with 10GB of HDD. I am getting same error. Which build of Vista are you trying to install If it's 5270, you will need at least 16GB of space. For previous builds, you will need ...Show All

• Visual Studio Express Editions Form Designer problem

  While using VB 2005 Express edition I periodically have a problem that occurs when I select View Designer for any one of my forms I get the following example error: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. The designer could not be shown for this file because none of the classes within it can be designed. The designer inspected the following classes in the file frmFunctions --- The base clase 'Pw_Barcode_Scanner_v4.frmBase' could not be loaded. Ensure the assembly has been referenced and that all pr ...Show All