Wil Burton's Q&A profile

• Microsoft ISV Community Center Forums what is wrong with this formula? *9 Views & no one knows?*

  =IF((Weeks!D(B1+6))="",1,2)   whats the error with this D(B1+6) is ment to respresent a cell with D    = the value of B1+6   what am i getting wrong its oki have resolved the problem with his VB code instead of formula more script but works fine.   Sub NamesDropDown_Change() ' check for already inputted data Dim B1Value As Integer B1Value = Cells(1, "B").Value For x = 1 To 7 i = i + 3 If Sheets("Weeks").Cells(B1Value + 6, i).Value = "" Then     Sheets("Add Details").Cells(x + 2, "G").Value = 1     Else     Sheets("Add Details").Cells(x + 2, "G").Value = 2     End If Next x     End Sub ...Show All

• SQL Server passing multivalue parameter in a URL action

  How can I pass a multivalue parameter via a URL action on a report item I've tried using Split and Join but it doesnt work. Any ideas Multivalue paramters are accessed in URL within the following schema: Report_Param_Name=A&Report_Param_Name=B&Report_Param_Name=C so AFAIK you would have to write some own sophisticated code to do this. HTH; Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Software Development for Windows Vista how to change the text shown when dragging activities from the toolbox

  Can someone please explain, how I can programmatically change the text, that is shown, when I drag activities onto the designer surface By default, the class name is shown (for example in the designer rehosting example). HI. Mario as default action, the activity designer will display the QualifiedName ,but text property. if you want to change the display text during drag-and-drop from the tool box in designer. you need to override the OnPaint there is a sample code like below. protected override void OnPaint(System.Workflow.ComponentModel.Design.ActivityDesignerPaintEventArgs e) { if(!this.IsRootDesigner && this.ParentDesigner == null) // it is important. at dragdrop from toolbox mode. ...Show All

• Visual Studio Execute target when (core)compile will execute

  Hello, there must be a simple solution for this silly question, yet I cannot find it. I want to execute a target before compilation only when compilation will occur, i e when corecompile has been determined to execute (ie dependencies have been updated) then I want my target to execute before compilation. If corecompile does not run, I do not want my target to run either. So, is there a hook before corecompile is run after it has been determined that it will run Or is there a simple property that expresses the inputs / outputs used so that I can use the same dependencies /mawi As you say, that will in many situations be a problem, since the build process will then involve editing files in the framework. ...Show All

• SQL Server No. of User Accounts in SQL SERVER 2000 and SQL SERVER 2005 ..plz

  I want to know the maximum number of users that can be created in SQL SERVER 2005 and the previous version... Yorker: I am going to assume that you will hit the limitations of the "uid" field. This field is a SMALLINT datatype; however, it appears that groups begin @ 16384 and that this field must be non-negative. Therefore, it appears that a user database MIGHT be limited to 16384 distinct users. However, on a serverwide database you can have many databases therefore leading to at least N x 16384 distinct users. There does not look to be any "variable size" limitation on the LOGIN side because this is based now on SIDs whereas in much older versions of sql server it was formerly ba ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Textures don't show up when using Basiceffect

  Hi, I'm just trying to create a couple of walls and apply a texture to them. Unfortunately, when running the program the walls just come out as a grey sort of colour (depending on the texture, the shade of grey seems to change). I'm assuming there's something obvious I'm missing, so I'm hoping someone can help me out. Here's snippets of code handling the basiceffect: //In loadgraphicscontent: Texture2D wallTexture = content.Load<Texture2D>("Content\\Textures\\em2"); theWalls = new Walls(wallTexture); wallEffect = new BasicEffect(graphics.GraphicsDevice, null); //wallEffect.DiffuseColor = theWalls.TheColor.ToVector3(); wallEffect.TextureEnabled = true; wallEffect.Texture = theWalls.WallTexture; w ...Show All

• .NET Development how to deserialize a list object in an xml?

  Hi all, I have managed to serialized objects into an xml including an arrayList object but upon trying to deserialize, all I get is only MySerializer.Animal where MySerializer is the namespace and Animal is the class, instead of a string. Previously, before I add an arrayList object, the deserialize function works fine. I had only put [ XmlRootAttribute (ElementName = "WildAnimal" , IsNullable = false )] above the class Animal (which I want to serialize). Part of my code is shown below: namespace MySerializer { /// <summary> /// Base class for the animal object hierarchy /// </summary> [ XmlRootAttribute (ElementName = "WildAnimal" , IsNullable = false ...Show All

• SQL Server Multiple queries within a single MDX command

  Is there a way to return a single cell set from multiple MDX queries I'd like to perform something like the following: SELECT MEMBER {[SalesRegion_TotalRev] AS [Measures].[Value Usd Actual] + [Measures].[Value Usd Scheduled], [Time Period].[Year Quarter].[Year Quarter]} ON 0, [Sales Region].[Sales Region]. CHILDREN ON 1 FROM [cubDashboard] along with.... SELECT MEMBER {[BusSector_TotalRev] AS [Measures].[Value Usd Actual] + [Measures].[Value Usd Scheduled], [Time Period].[Year Quarter].[Year Quarter]} ON 0, [Business Sector].[Business Sector]. CHILDREN ON 1 FROM [cubDashboard] Thanks, Marilyn WITH   MEMBER [Measures].[SalesRegion_TotalR ...Show All

• Visual C# How easy is this in C#?

  Sorry for the very general subject line. I've been working on a problem for some time right now that will have two separate applications passing information back and forth and preferably sharing objects. To date, I've been working on this problem using C++ and the WinAPI. However, the WinAPI and Visual Studio c++ 2005 don't really integrate very well. I've been taking a look at C# lately, and it seems like the language would support this effort pretty well through the use of marshalling (a new concept to me), and multi-threading. I would like to hear from some experienced C# programmers their opinion on how easy this would be to implement in C#. There is an example in "Programming C#" that seems like it would accomplish the type ...Show All

• Internet Explorer Development IE6 and FTP protocol issue

  I am attempting to create a website that lists documents that can be downloaded from a password protected ftp site. I was hoping I could link the documents to the ftp site like this: <a href='ftp://webuser@ftpsite.ourdomain.org/webdocs/test.doc'>test doc</a> I've read some sites that suggest this should work, but for some reason I get a page can't be displayed error. I CAN do the following: <a href='ftp://webuser:webuserpassword@ftpsite.ourdomain.org/webdocs/test.doc'>test doc</a> This will download the document but this is no good as including the password in the url defeats the whole prupose of putting the document on a password protected ftp site <a href='ftp://webuser@ftpsite.ourdomain.or ...Show All

• Visual Studio 2008 (Pre-release) Where is system.windows.dll

  What do I need to install to get system.windows.dll I need it for System::Windows::Media. Searched the disk and it's not there. I Installed the SDK and .Net3.0 and 2005 Extensions on Vista Ultimate. Thanks Doc Thanks for your reply... In my header I have using namespace System::Windows::Interop; what do I need to import in my stdafx.h #using <system.windowsbase.dll> Says could no find that assembly Doc ...Show All

• Visual Studio 2008 (Pre-release) FlowDocument ColumnRuleBrush problem

  Hello may be you can help me with this. I have a Flowdocument with paragraphs and I have set the ColumnGap, the ColumnRuleWidth and the ColumnRuleBrush. Now I've a Figure that has a size of two columns. The problem is that the Column Rule goes in the background of the figure. It's any way to make the rule hide in some parts of the flowdocumnt or set a background in the Figure to hide the rule Thanks a lot !!!! You may find that the cleanest solution for you is to set the background on the Figure itself. Also, use the Figure Padding property to provide the spacing around your Figure's content instead of Margin (make Margin 0). ...Show All

• Visual Studio Tools for Office Cypress and task panes accross multiple documents / addin support

  I have recently made a post earlier on today regarding a problem I have had with Action panes and task panes. In a VSTO 2005/ Excel project, I have created a very powerful action pane for an application we are developing. Problem is that this action pane is only available for the workbook in which it was created. Its important that this action pane is available for other workbooks including those that are not created by VSTO (i.e. existing Excel workbooks with at most VBA in them). For example if a user creates a new workbook, this action pane should be available to them. Cindy has pointed out that action pane is document specific and not application specific which is a disaster for me. She also pointed out that add-ins do not suppor ...Show All

• Software Development for Windows Vista Stange text encoding in the Registry for RC1

  I've got an application that provides similar functionality to the Device Manager. It displays the devices by "category" similar to the list view in the Device Manager. It gets the category string from the registry... specifically the "default" string value at each one of the keys like: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318} These string value at these locations used to be just normal unicode text, but with build 5600, the text is a bizarre unicode-wanna be "[xufkY][ VD/ D-ΓO ιν !!! ]" instead of "DVD/CDROM drives" It's almost readable as english, so that leads me to believe that the change was deliberate (I can't imagin ...Show All

• Visual Studio Visual Studio SP1 for Vista Beta

  Hi, I have Visual Studio Team Edition for Developers installed on a Vista machine. When I tried to apply the Vista Beta version of SP1 it told me that the patch could not be applied because the required product was not installed. Does SP1 beta not work for any of the team editions Thanks I had a similar experience when I tried. I did a fresh install of VS2005 Pro on Vista Ultimate. No other versions of VS existed. Next I tried to install VS 2005 SP1 for Vista Beta and received the same error that you did. I then thought I might need to install the generic VS2005 SP1 but I received the same error still. So, basically, after a fresh install of VS2005 Pro I cannot install the VS2005 service pac ...Show All