ShaulB's Q&A profile

• Microsoft ISV Community Center Forums Optimise VBA for Multi-Processors

  How do I tell my VBA it is allowed to do several things at once I am moving my project to the server, which has 4 CPUs. I know that sections of my code have no interaction with each other, and do not work with the same cell ranges. Imagine my code is as such: Main Routine Call Task 1 Call Task 2 Call Task 3 End This is programmed in linear code, so I know that it won't start Task 2 until it has finished Task 1. I need some way of telling it that tasks 1 and 2 can run concurrently. Does XL VBA have this ability Separate windows within a single instance of an application will not help. You wou ...Show All

• SQL Server Getting an error for drilled down reports.

  Hi, We are geting an error while generating an drilled down reports when the drilled field value contains a space. Please help us in what way we can resolve this issue. Thanks in advance ...Show All

• Visual Studio Express Editions Class Library can't access System.Windows

  I'm trying to create a new Class Library for a custom control. The base code is as follows: Imports System.ComponentModel Public Class DynamicCheckedListBox Inherits System.w... End Class When I try to type System.Windows.CheckedListBox, Intellisense shows no entry for Windows. The list displayed includes "WeakReference", "XML", but no Windows option. In my other projects, this works fine. Yesterday I had a similar problem wherein System.Windows was acceptable, but there was no entry for CheckedListBox. Somehow along the way, it showed up on the list, as I tried creating a new project. ...Show All

• SQL Server FTP Taks Fail

  Hi, sorry again, l've a package which call the FTP tasks. In design-time, it works fine. While l put it into SQLAgent to run in schedule. It fails. The package log file said, OnError,MAXIS-SYSOPT,NT AUTHORITY\SYSTEM,FTP Raw File Motorola,{b3b941f5-ebc2-4b38-b314-87ff4827c2a8},{E93D51C5-539E-4CEE-B616-BBCFF9FA813E},4/18/2006 3:18:23 PM,4/18/2006 3:18:23 PM,-1073573489,0x,Unable to connect to FTP server using "Metrica FTP". Does anyone know what's happening So this is occurring all on the same machine Success in designer and failure through agent When something works elsewhere but not under agen ...Show All

• Visual Studio 2008 (Pre-release) 3D performance problem when animating a mesh

  I am simulating the surface of a liquid with moving waves, let's say an ocean. I'm doing this by creating a rectangular mesh with 1000x1000 knots. So my MeshGeometry3D has 1.000.000 positions which I all added like this: mesh.Positions.Add(new Point3D(x, y, z)). Now I want to animate the mesh. All points of the surface will keep their x and y coordinate, only z will change. So instead of creating a complete new Point3DCollection for the mesh, I'd rather like to use the existing points and only change their z-value. So I try this: foreach (Point3D p in mesh.Positions) p.z = somethingNew; But the compiler won't let me do so: Er ...Show All

• Visual Studio Express Editions [C++ Express] Add Resource disabled?!

  I downloaded Visual C++ 2005 Express Beta 1 last friday, but it seems that adding and compiling resources wasn't enabled in this version! Haven't had the time yet to try Beta 2, but is this enabled in this version or will it be enabled in future ! MS's "plan" here seems to disregard its (claimed) intended audience for the Express editions.  MS uses language like "beginner", "get your feet wet", and similar indications that it views the Express editions as a tool for novices... yet who needs a resource editor more than a novice   Why not omit application templates too, or the debugger (don' ...Show All

• Windows Forms How to hide some properties?

  Hi, everybody, I want to write a control and a designer for it. The control and the designer will exist in "separated" assemblies, The control has some special proeries just for designer, I don't want user use it except for my designer. How to do that Any ideas would be great!  Thanks you are developing with .NET right  Well to create an  ...Show All

• Visual Studio Copy report data directly into word

  We have a tabular report that is generated and displayed in a report viewer control. Is it possible to select the table with the mouse and copy and paste it direct into a word document, or will we have to export it to excel and then import/export it into Word. Thanks Michael In webforms, you can use the standard copy-paste support from the web browser. At this time, there is no way to copy-paste report content with the winforms. This is a common feature request and we hope to add it in the future. ...Show All

• .NET Development Debug Complex SQL Query!

  I am trying to include the following query into my VB.net windows project. every time i run my project i get the System.OleDbException error and i know its something to do with my query. can anyone tell me where I'm going wrong or suggest a better solution : Public Class Form1 Inherits System.Windows.Forms.Form 'Create a new OLeDb connection, Assign it to the Access DB and specify the path of the DB Dim myAccessConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\XML\Blackberry XML\VB Code\drpdata.mdb") 'create the adapter that will later be used to hold the SQL query Dim myDa ...Show All

• Windows Forms searching items in dataset table

  i have to search the data in the dataset before inserting into its table to avoid duplicacy of items, can any body guide me in this context. thanx. Hi, Is your problem solved Thank you, Bhanu. ...Show All

• SQL Server Can you join datasets

  Hi I am using reporting services 2000 and I have two datasets which have a common link. Is it possible to create a new dataset based on these two datasets from within the report Many thanks No. If you need to do this, you can create a stored procedure that creates a single dataset from multiple data sets and call this procedure from your report. Or you can reference two datasets in your report but not combine into one data set. ...Show All

• Visual Studio Team System Clean single server install problem

  I'm having a problem when trying to create a new team project. I've installed using the latest install guide and have followed each step as described. Below is the error. Any ideas ---begin Exception entry--- Time: 05/12/2005 10:29:39.921 Module: Initializer Event Description: Initialization for plugin "Microsoft.Pcw.wss" failed with error: "Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html>    <head>       <title>Server Unavailable </title>    </head>    <body>    ...Show All

• Smart Device Development update error

  Friends, I get this error from C# generated code - it is not from my own code: Message="Update requires a valid UpdateCommand when passed DataRow collection with modified rows." It happens when I click save on a bindingNavigator (table) after making a modification to one of the rows. What gives Thanks !! This forum is for devices related questions only. Since there's no BindingNavgator on devices, please post to a relevant forum below. Thanks. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=45&SiteID=1 ...Show All

• Visual Studio Express Editions MDI Help Needed

  Hello everybody, I was playing around with the MDI form and was trying to figure out this. Upon loading of the MDI Parent form, I would like to have a form that is being auto loaded plus it is maximize. I have manage to make the MDI Parent to auto load the form but I can't manage to maximize is upon loading. I have changed the 'WindowState' of the form that I wish to maximize to 'Maximized' but when I run it, it still appears in its original size. Is it a bug or have I left out some adjustments that needs to be done Please help! hi This may help http://forums.microsoft.com/MSDN/ShowPost.aspx PostID ...Show All

• Windows Forms BindingSource.EndEdit() does not throw exception

  I've a business object, and it validate value when new value is assigned to its properties, exception will be thrown if value violate validation rules. Business object is bind to UI controls by a BindingSource object, when I input a invalud value in TextBox and call BindingSource.EndEdit() programmically on FormClosing, exception is eaten by somewhere, I do not allow user to close the form if error is detected, Thank you very much! public class Customer { private string _customerNo; private decimal _balance; public string CustomerNo { get { return _customerNo; } set { _customerNo = value; } } public decimal B ...Show All