GlipNBA's Q&A profile

• Visual Basic How do I loop code through several, but not all worksheets within a workbook?

  I am trying to loop code (that works on one worksheet) through several (but not all) similar sheets within a workbook.     Here is my structure, and it is not working.   Note that the items in the Array parenthetical are worksheet names.         Dim my_sheet as worksheet     For Each my_sheet in Array("first", "second", "fourth", "sixth") *****Execute repeating code her ...Show All

• Software Development for Windows Vista Link error PlayWndASF MicroSoft Sample

  Hi all: I can't complie the sample for this error. LINK : fatal error LNK1104: cannot open file "D:\Program.obj" Error executing link.exe. D:\ is the directory which include DX90SDK and VS,VC6.0. Why Program.obj is needed Thank you. It looks like you are missing quote marks somewhere. That's probably supposed to be "c:\program files\something" ...Show All

• Visual Basic Graphics.DrawString Text with multi-line

  Hello everyone, I have a textbox with multiple lines. I can draw a string from a textbox only if the text is in single line. Can you help me find a way how to draw if the textbox has a value of multiple lines Thanks in advance. Michael Hi all, Please disregard this question. I already solved my problem. I split the text to string array and loop to it then draw each word from loop using drawstring method. Thanx, M ...Show All

• Visual Studio Working with a DTE.Project and an MSBuild Project

  I'm working on an automation project that does a bunch of work with a DTE Project, and for the most part, the DTE Project exposes everything I need.... Except for the "internal" settings of the project file itself, ie - the info contained within: <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> .... blah blah blah... </PropertyGroup> On the other hand, instantiating an MSBuil ...Show All

• SQL Server Identify/parse content within binary documents?

  I've got a full-text index on a table in which I've got word docs and pdfs (in an image field). I want to parse out certain types of content from these documents, and include the parsed content in the info I give back to the client. In this case, I want to collect the e-mail address(es) from each document yielded by a query. In other words, the client would input a term like 'indexing', I query the database to yield those docs which contain ...Show All

• SQL Server Flat Files Containing Dates

  Hi everyone. I'm trying to use a Flat File Connector to read in a fixed field width file that contains some date columns. The problem is that the date column is in a CCYYMMDD format (with no delimiters) so that todays date, as an example, would be 20050711. When it attempts to import the file it fails due to a "Data Conversion Failed" error. I can't find any way to specify the format of the column in the FFC dialog so my only option appears ...Show All

• SQL Server Error: "no report servers were found on the specified machine"

  Error: "no report servers were found on the specified machine" I get this error when launching the Reporting Services Configuration Manager...I've never seen this error, usually it can talk to my local servername but unfortunately it's not. This is a new test server and the first time I've come across this message after setting up Reporting services on 2 machines sucessfully in the past. NoEgo wrote: ...Show All

• .NET Development Can't Find MSSQL Instance when creating New Connection

  I have recently installed MSSQL Develper Edition on my PC with VS 2005. I can log into the database using the SQL Server Management Studio without any problems. When i try to add a New Connection in VS2005 it can't find my Server or the named instance i created. I installed the named instance under a Local System login. I haven't changed any other default settings yet. I have also tried restarting both the SQL Server Agent and the SQL Server ...Show All

• SQL Server Chart Labels at an angle??

  Hi, I have created a report with bar chart but the labels are too long and often go into next line. Is there any way to specify text orientation for labels of a bar chart I would like to show the chart labels at an angle. Is it possible Any help will be appreciated! This depends on which labels you are referring to. If you are referring to data point labels, then yes, it is possible to specifiy an angle. However, if you are ref ...Show All

• Visual C++ Problem loading dll created by VisC 2005

  Hi, I converted a C++ project from VS .NET 7.1 to VS .NET 8. The project uses old fopen methods and similar. Under 7.1 the project compiles and runs, but under 8, I am unable to run. First, when running the application, it complains about missing msvcr80.dll. Then, when I locate it (somewhere) on the computer, I get the error that the application tried to load the dll in an illegal manner. When searching for info on this, I stumble int ...Show All

• Windows Forms Component with DataTables. How to impliment?

  I'm creating a business object as a component that sits in the tray of a winform or ASP.Net page. This component will have functions that fill data tables. I would like to expose these data tables to binding similar to how the DataSet works. I& ...Show All

• Windows Forms ClickOnce installing in Documents and Settings\{user}\Local Settings\Apps\...

  How do I get this to install in programs/{appname} with ClickOnce You can't. Or at least the application can't. This FAQ says the administrator can change the location of the ClickOnce store. I've never looked into how to do that. http://www.windowsforms.net/FAQs/default.aspx PageID=1&CategoryID=24&tabindex=2 Mike ...Show All

• .NET Development SQL strings and distributed applications

  I am building a solution in VB 2005 which uses SQL strings to determin varoius totals etc. It works fine on my machine - but when I deploy the solution and install it on another machine, it fails to show the totals at all. I am in no way an expert so i assume that I have overlooked something simple. I would be most grateful if anyone could point me in the right direction. I don't get any error message, when you ...Show All

• Visual C# Extending functionality

  I would appreciate some guidance as I am reasonably new to C#. I need to implement a function to turn a string into its capitalized equivalent. I am not having any issue with the implementation of a function to take a parameter and convert the first letter of each word to uppercase, and the rest to lowercase, however is that really the "right" way to do it in C#. It would seem that the appropriate action would be to extend the St ...Show All

• SQL Server cannot convert between unicode and non-unicode with SQL Server

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All