SQLinSouthseaUK's Q&A profile

• Microsoft ISV Community Center Forums OWC10 Chart to print on a report

  I am trying to create a Stacked bar chart dynamically in Access VBA to include on a report.  I have to build it with VBA because I need to manipulate the color of the stacked bar slices based on the data values.  This graph gives me the exact results I need, however, I cannot get the graph to run when the form opens (loads) and cannot get it to function when dropping it onto a report as a subreport. Create a form called frmChart_5_Floor Drop a Microsoft Office Chart 10.0 component on the form Place a button on the form to call the following procedure: Public Sub BuildPivotChart()     Dim objPivotCha ...Show All

• Visual Basic Adding expandable Container/Panel Control like on 'My Computer' Form

  I am trying to find an expandable container/panel control like the one found on the left side of the 'my computer' form.  I am currently migrating from VB6 to VB2005.  Any thoughts on these controls would be helpful. Thanks Zach there is a panel control in VS05 and there are also splitter controls that work really well with docking and anchoring for a dynamically resizing forms ...Show All

• Visual Basic Pass any command line Argument?

  Hello sir, How, can i pass any command line arguments (Through Run Command) pass when my VB application execute and that's values are receive when form activate. Kindly Help me Thanks. What version of VB are you using You imply VB6. If it is VB6, then lookup the Command function. Please be aware that this is not the forum to post VB6 questions, and may be contributing to the confusing answers you are getting. ...Show All

• SQL Server Reference Documentation on VBA in relation to SSIS

  Hi, I have heard alot of people talk about using C# for scripting withing SSIS and the answer to that question is no apparently. You can only use VBA but there is no extensive or in my respect any documentation as reference for using VBA in SSIS. I am new to VBA because i used to use jscipt and vbscript in early version of sql server. But in order to learn using VBA, I need to learn it in which there seems to be no reference in relation to SSIS. All the VBA references you find are in relation to MS Office. Is there anything i am missing or can someone show me where to go as my reference for VBA in SSIS. Its bad enough to change the scripting ...Show All

• SQL Server sql statement from webform with dynamic join, how?

  In my application the user can enter form textfields and check checkboxes to dynamically generate the SQL SELECT. Most searched values com from one table but some come from other tables with a 1:n relation. So, if needed INNER JOIN them by writing the FROM statement in a variable, that I use in the query. Like this: " INNER JOIN tCmsElementCustomProdspecArtikelZusatzStoff ON tCmsElementCustomProdspecArtikel.artikel_ID = tCmsElementCustomProdspecArtikelZusatzStoff.art_zus_artikelid " This works fine for some cases but in some cases I need to select all articles with "art_zus_artikelid = id1 AND art_zus_artikelid = id2" and for both "art_zus_v ...Show All

• Visual Basic Another Question

  How do I create a grid of pictureboxes (25 x 25) on Visual Basic 2005 and auto-name them pbx(row)_(column) for the picture boxes It is to slow and hard to manually rename all 625 of them. Ok question answered, thanks. New question: OK, I ran into another problem. I want it be so that if I click the picture box with the person in it, you can move him by clicking on another tile. How do I do this (I tried (got from Dustin_H 's sample code) :     Private Sub PicBox_On_Click( ByVal sender As Object , ByVal e As EventArgs)         If PicBox(x, y).Image = Tiles.picPerson.Image Then &nb ...Show All

• Windows Forms SaveFileDialog actions wrong

  I have a strange issue. Seems like a few others have had it, but I couldn't find a post on msdn about it. SaveFileDialog either returns DialogResult.OK or DialogResult.Cancel. The problem is if the file name the user wants to save the file as already exists in the current directory, another dialog pops up and asks if the user wants to overwrite. Even if I click "Yes", the SaveFileDialog returns DialogResult.Cancel. Even if this is the correct action C# creators intended to have happen, it goes against all logic and doesn't allow me to know that the user wants to continue on with the save. On another site's forum, someone resp ...Show All

• Smart Device Development "Failed to start debugging"

  When I start VS2005 debugger (press F5) to debug a simple native app built for WCE5.0-based smart device, the debugger does not start and, after several seconds, displays error message "Failed to start debugging". This does not appear to be the issue in http://blogs.msdn.com/srini/archive/2006/01/05/509599.aspx , where the conflict is thought to be a co-install of Platform Builder and VS2005, as the recommended work-around does not work for me. I even tried creating a new user to ensure I was starting from scratch as much as possible. I am using the directions at http://msdn2.microsoft.com/en-us/library/ms228708.aspx to conne ...Show All

• Windows Forms MDI data structures

  I want to write a document editor which can handle a large number of documents simultaneously, any of which can ioncrease in length arbitrarily. A multidimensional byte array is not suitable because only the last dimension can be redimensioned. Does anyone know how standard editors like Word etc. manage their data files JOLinton   That will work. Collection classes are still better than arrays for any object grouping that needs to dynamically change in size. I would suggest taking a look at ArrayList (or List<> if you are using .NET 2.0). This would be a good opportunity to dive into ...Show All

• SQL Server OLEDB provider error.

  Hi: I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this. OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.". Msg 7373, Level 16, State 2, Line 1 Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)". Thanks, Pramod Xinwei: This is the query i am using... SELECT a .* FROM ...Show All

• Windows Forms SOAP Client error

  Hello, I have an application that calls a webservice that sends mails to specified users. This application runs fine on all the user machines. There is however a Win2000 box that acts like a terminal server where remote users can connect to, this box always errors out whenever the soap client is invocated. I use the oWS = CreateObject("MSSOAP.SoapClient")   ...Show All

• Visual Studio Team System Common Rule Set

  What I need to do is have all users in a group use the same set of rules. There are no custom rules, at least yet. But many rules have been turned off. We all want to easily share the same rule set. Do I need to use your procedure here to do that Seems like my scenario would be a very common thing to do and one which should be easily accomplished. Hi Andy, Right now there is no easy way to do this. There is some support if you have Team Foundation Server by creating a code analysis policy, set the rules you want enabled and migrate the policy to the solution. However this will only enable rules that ...Show All

• Visual Studio Team System Where can i get additional custom security rules that can be pulgged in to VS 2005 Statis Code Analysis

  Hi, I’m not sure if this is the right alias to ask this question, if not, I would greatly appreciate if you could point me where I can post this question. I’m looking for custom security rules which warn for codes which are vulnerable to Cross-Site Scripting, SQL injection. It would be great if I can reuse any plug-in that’s already written. I would greatly appreciate your valuable feedbacks. Thanks, Kumar. We don't have any additional Microsoft-provided security rules (though we are currently in the process of creating a plan to develop more analysis along these lines). Perhaps someone else on the for ...Show All

• Visual Basic Declaring Windows constants for VB.Net

  Hi, I was curious if there was an include file for VB.net that would enable you to use Windows Constants. I have found a few examples of where people declare their own Windows Constants (such as: Private Const WM_SYSCOMMAND As Integer = &H112 Private Const SC_CLOSE As Integer = &HF060 ) But I am curious if there is a file that already has this declared. I believe there was a .h file used for C++ in the past. I'm looking for soemthing similar to that. And if there is no file like this, is there someplace I can find these references How do I know that SC_CLOSE always = &HF060 Any help on this subject would be gr ...Show All

• Software Development for Windows Vista Activity 'workflow1' validation failed

  Hi,    I got a problem. I have a class which code like: [Serializable] public class Item {    string code;    string Name;    public string Code   { get{return code;}      set{ code = value; }     .... } And also I've another class which implements IDataHandler interface. There is only a UpdateData activity on the workflow. I've set DataSource and DataObject for the UpdateData activity, everything seems ok but it don't pass compilation. The error message is : Activity 'workflow1' validation failed: Propety 'DataObjectType' has invalid value. 'workflow1. ...Show All