Steven P.'s Q&A profile

• Visual Studio Tools for Office Question about VSTO Install Items

  Hi there! This is a non-programming question ... I installed VSTO earlier in the year and am only now getting around to notice that I don't have the VS2005 Image Library zip file installed anywhere on my system. Was it not included with VSTO (as opposed to other versions of Visual Studio) or am I missing something Thanks for your help, Richard As far as I know it's shipped with VS.NET 2005 and it should have the following location: C:\Program Files\Microsoft Visual Studio 8\Common7 Kind regards, Dennis       ...Show All

• Windows Forms VB.NET Windows apps with EXCEL - Deployment Pbm

  Hi, I developed an VB.NET Application that make use of microsoft EXCEL PIAs. (VS2003) It works fine in the development environment which has MS EXCEL. But actually target machine don't have MS EXCEL. When i try deploy the project it prompts me an error like "COM Object with CLSID {...} is either not valid or not registered" Can anyone clarify the following doubts. Can we deploy this kind of application in the system which donot have MS office If so, How I tried my best. but couldn't reach the solution. Kindly guide me in this aspect. Note : I never Used "New " for workbook. Thank You! I create a program that would open text delimited file to excel. The pro ...Show All

• Visual C# Many a C# Question

  Hi, I've got a few questions relating to C# (Forms & Code) and am hoping that someone could please help. If you do, it'll be much appreciated. Is it possible to add tabs (like MS VS does) when I want to make a new thing If so, what do I do Is is possible, to add non-existant programs to a menu after they have been installed on a computer (like MS Windows Start Menu etc. or Internet Explorer) If so, what do I do When printing with web browsers, is it possible to NOT use the image document user (like when using IE) If so, what do I do Is it posssible to ban websites using web browsers If so, what do I do Is it possible to have a loading bar when a web browser is loading or if something is printing If so, what do I do ...Show All

• Commerce Server MSCS_CatalogScratch why does it get do full?

  Recently, when performing a catalog search for subcategories, I got the following message: Could not allocate new page for database 'MSCS_CatalogScratch'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth. Upon looking in the database, I saw literally hundreds of tables with results for this search, or results for this SPID. Since uor App has a treeview representing catalogs, and population on demand, we use the catalog search to retrieve each categorie's child categories and products, sometimes variants, etc.. How can I keep this database clean so that 2 months into production I don't get this error why doesn't the database keep it ...Show All

• Visual Basic SplitContainer without the splitter

  How do I remove the horrible dotted line that the SplitContainer has when it is selected If I'm not completely mistaken, the dotted line is the focus rectangle. If you don't give any visual clues as to when the splitter is selected, it makes it very hard to use the keyboard to change its position (the user wouldn't get any feedback that the splitter is the currently selected item) The focus rectangle shows up for pretty much every control that can currently has the focus. Best regards, Johan Stenberg ...Show All

• Visual Studio Express Editions Textbox Display web browser's URL

  I would like to know how to make my ToolStripTextBox1 display the URL of WebBrowser1. I want it to display the URL of each new page WebBrowser1 loads. Thank You. Private Sub WebBrowser1_Navigated( ByVal sender As Object , ByVal e As System.Windows.Forms.WebBrowserNavigatedEventArgs) Handles WebBrowser1.Navigated ToolStripTextBox1.Text = (WebBrowser1.Url.ToString) End Sub ...Show All

• SQL Server Parent Child Dimension

  Hi I have a little problem. I build a Parent - Child dimension an I need to change the default listing of this kind of dimensions to display some information from another column than ID and ParentID. Is there eny way to solve that Tanks in advance for your help. (AS 2005; Excel 2007) You can change this in the name column for the the parent child primary key. Check the attribute pane in the dimension editor. Regards Thomas Ivarsson ...Show All

• SQL Server SQL Query Help....

  Hi All, As part of a one time migration activity, we are running into a situation wherein in the old database, there are some records in the transaction tables that don't have a valid reference in the master table. This was because the OLD database was not having any proper constraints in place, and it is suspected that the records in the Master table would somehow got deleted. I now what to write a query which will pick only the valid data and the other non matching records should be marked as not valid or so. Bringing a new status called as Not valid in each n every master table is also fine. Ideally this will be a left join with the master and the transaction tables, but the issue am facing is that the left join is giving only ...Show All

• Windows Forms How to place one more Datagrid in Nested Datagrid

  hi all I succeeded in placing a Data grid in another data grid(Nested Data Grid).Also i can perform add,edit,delete operation on both grids.But i got synchrinization error when i tried to place another data grid in this nested grid. Error i got: Type 'System.Web.UI.WebControls.DataGrid' in Assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' is not marked as serializable Exception Details: System.Runtime.Serialization.SerializationException: Type 'System.Web.UI.WebControls.DataGrid' in Assembly 'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' is not marked as serializable. Stack Trace: [SerializationException: Type 'System.Web.UI.WebControls.DataGrid' in A ...Show All

• Visual Studio Detect change to project properties

  Hi all, Hopefully a quick and easy question. I have a little add-in that I use to detect certain events in Visual Studio 2005. I now want to be able to detect when a project's properties have been changed (ie build path, application type, references). Does anyone know of such an event and how to hook into it. Thanks, Mark. You can detect reference changes casting EnvDTE.Project.Object to VSLangProj.VSProject and then using VSProject.Events.ReferencesEvents, but AFAIK there is no way to detect property changed events, maybe using some service from the SDK ...Show All

• Visual Basic DAODBEngine

  G'day After a VB6 to VB.NET 2.0 upgrade I am left with an IBM DB connection problem. The original version works. The upgrade doesn't. They are both running on the same PC and are configured the same. Original Code: Public dbIBMHost As Database Set dbIBMHost = Workspaces(0).OpenDatabase("", False, False, _ "ODBC;DSN=ValidDSN;UID=ValidUserID;PWD=ValidPassword;") New Code Public dbIBMHost As dao.Database dbIBMHost = DAODBEngine_definst.Workspaces(0).OpenDatabase("", False, False, _ "ODBC;DSN=ValidDSN;UID=ValidUserID;PWD=ValidPassword;") and the upgrade kindly supplied the following Module to define DAODBEngine_definst Module UpgradeSupport Friend DAODBEngine_definst As New dao. ...Show All

• Visual Studio Express Editions How can I create a SIMPLE Report in VB Express?

  Hello, How can I create/design a report in VB express Does VB Express have any Reporting functionality at all Are we NOT supposed to learn how to do reports Is this catch 22 Please help me, please. Kind Regards, Kajani VB Express as such does not come supplied with specific reporting tools. If you buy certain versions of VB/Visual Studio then 3rd party tool Crystal Reports is bundled into the product which does enable simple report development. http://msdn2.microsoft.com/en-us/library/b4z62wxz.aspx There are numerous 3rd party reporting tools available Crystal Reports - http://www.businessobjects.com/products/crystal/default.asp intcmp=hp_products_crystal ActiveReports - ...Show All

• SQL Server FTS Catalogs won't populate

  Hi After creating a full text catalog in SQL Server 2000 and performing the initial population, the catalog say has an index count of 1 (should be several thousand) and all "contains" queries return no results. The gather log contains the following error message: Error Fetching URL, (80070002 - The system can not find the file specified) . Any catalog I try to make has the same problem. All catalogs were working fine last week. Any help would be very appreciated. Thanks! Hey, we fixed our problem by re-registering tquery.dll on SQL Server. See http://support.microsoft.com/kb/817301/en-us . Hope this helps. ...Show All

• Visual Basic O'kay so I now have a working application. How do I port it to other computers?

  I can install VB 8 onto other computers along with my application, but that seems unusual. The other PCs never will be programming in VB. They want to just use my application. Question: Please explain to me in a step-by-step button clicking and dragging fashion how to do this. More Simple To Vb menu click build. Then outside the vb open the folder of Yr app. You'll find there a folder bin and there You have the exe file. Just run it and everything is ok ...Show All

• Visual Basic Is there a IF…AND…THEN operator?

  An IF…AND…THEN… is exactly what I need and I can’t imagine that VB would not have such and operator. In other words, if two conditions are true then do something. What I wanted to write was: IF Cells(x, 4) = “Large” AND Cells(y, 4) = “Small” THEN LtoS = LtoS + 1 ElseIF Cells(x, 4) = “Large” AND Cells(y, 4) = “Medium” THEN LtoM = LtoM + 1 ElseIF… I’m new to VB so I appreciate your help. Cheers There are logical operators AND OR ANDALSO ORELSE which you can use. Some useful article. http://www.startvbdotnet.com/language/operators.aspx http://www.informit.com/articles/article.asp p=31092&seqNum=15&rl=1 http://visualbasic.about.com/od/usingvbnet/l/ ...Show All