appler's Q&A profile

• Visual Basic Deleting Columns from spreadsheet before importing to Access

  Hello, I have a spreadsheet I want to import into an Access table. Problem is two of the columns in the spreadsheet don't exist in the Access table. I don't want to add the columns to my table, so I need to delete the columns before importing the spreadsheet. Does anyone know how to do this How are you planning on importing the data between the Spreadsheet (which I'll assume is Excel) and Access. ...Show All

• Visual C++ Port in use!

  Hello, I am working with a database program(client-server) developed using visual studio.When i install the program and open the database, i get the error message "Port in use".But this is not the case when i run the program from the visual studio.In my code     m_server.ConnectTemplate(clsid, pDocTemplate, FALSE); Can anybody explain me, whether setting the parameter to TRUE could help in anyway I have very less experience wi ...Show All

• Visual Studio Express Editions Intellectual Question??

  Hi There Below Is a Is a Generated VB Simple Program. - A Windows Form with a Rich Text Editor Control loaded with the Text - "Hello World Without A Printer"....... < Global .Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Partial Class Form1 Inherits System.Windows.Forms.Form 'Form overrides dispose to clean up the component list. <System.Diagnostics.DebuggerNonUserCode()> _ Protec ...Show All

• Visual C# Using OS to open files

  I am currently writing an app that extracts files from a database and attempts to open them using Process.Start(); It works fine as long as the file type has an association, but if there is no association, I get an exception.  What we are looking to have is for the OS to handle it just as if you tried to open a file from Windows Explorer and the file type is unassociated, you get a Windows Dialog (Windows cannot open this file) What d ...Show All

• Visual Basic Trying to write an Excel Formula using a VB.Net variable

  I am trying to add a formula that will subtract Column C from B through code, but I don't know how to format the formula using a variable in my code to move to another cell. I more then likley going about this wrong, so any help would be appreciated. The following works with the exception of the formula. Please Help. Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlBook As Microsoft.Office.Interop.Excel.Workbook ...Show All

• Windows Search Technologies Desktop search does not think Outlook is installed

  I recently installed windows desktop search on my XP SP1 machine running Exchange 2003 in cached mode connecting to an Exchange 2003 server. Windows desktop search won't let me select Outlook because it doesn't think I have it installed. I checked from IE and Outlook is set to my default mail client. Any suggestions of other things to check is appreciated, searching through my mailbox and .PST files would be great! Thanks. ...Show All

• Visual C++ How to add print support in CformView

    Hi, I just create a MDI MFC application using CFormView as the base class for the application view.  It becomes a disaster when I want to print this form to printer.  According to the MSDN document: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vccore/html/vcconcreatingforms-basedapplication.asp No printing support for a form-based application! I tried to add ON_COMMAND(ID_FILE_PRINT, OnFilePrint) ...Show All

• Smart Device Development Split Screen

  Is it possible to split the PPC screen so that an application can be running on 3/4 of the screen, while a custom tool bar remains visible either above or below it I need this badly; I hope it's possible... Thanks, Pete M Unfortunately, I really don't see how we can do this today. I've seen that you have already been answered at the native forums http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=288 ...Show All

• Visual Studio Express Editions Blue Rectangle in Breakpoint Margin

  What does the Blue Rectangle in Breakpoint Margin indicate Ok... I've discovered that the blue rectangles are bookmarks. Only thing is I did not put them there... they are only on lines with TabControl code on them... and only in the code of one form (ie, I have TabControl on other forms but those lines are not bookmarked) Could Visual Basic have marked these lines for me for some reason ...Show All

• SQL Server using filters to full text search inside pdf & word documents

  how can pdf, word filters be used to full text search inside pdf, word documents using SQl Server 2005 and how to find what filters are loaded. please give a step by step instruction or direct to a comprehensive tutorial. thanks for reading. how accurately FTS works. recently Oracle released a search technology that compares to Google but will FTS be upto my expectations when i perform a search through the documents using FTS. is there ...Show All

• SQL Server RS 2005 connecting to Clustered sql 2000 server

  We have a configured environment where we have sql 2000 in an active passive cluster.  I have a seperate machine where I installed RS2005 and store the RS database on the SQL 2000 Server.  When doing this, I get errors with WMI. Although saving the database connection succeeded, the report server cannot access internal information about this deployment to determine whether the current configuration is valid for this edition.  If y ...Show All

• .NET Development That assembly does not allow partially trusted callers.

  Why am I getting this I am trying to debug a C# application on my own machine, so, as I understand it, my program should have full trust. Might you be willing to provide the full exception details (including call stack listing) as returned by the exception's ToString method ...Show All

• SQL Server How do i add my database to "data sources"?

  I n Lesson 9 as you can see here (at 16:50), a connection is created against his .mdf database, and the dataset is shown in the "Data Source" window/panel. He can then simply drag the data source onto the form, and controls are created and bound automaticly - or drag them as a datagridview to the form. That is what i want to do, but i have some problems... I have set up a connection to my SQL Express database, and a dataset is c ...Show All

• Visual C++ Accessing textbox's Text from outside Form class? Possible?

  Hi, I have a function within my namespace, but outside the Form1 class. Inside the function, I am trying to access the Text property of the textbox (called "txtData"), and add new text into the box. However, I'm getting the following errors: error C2653: 'Form1' : is not a class or namespace name error C2065: 'txtData' : undeclared identifier error C2228: left of '.Text' must have class/struct/union type is ''unknown-type'' Here ...Show All

• .NET Development .NET Application crashes

  In the sample code , show below, we are merging many binary file to a single mp3 file. This process works fine for 4 times , but on the 5th time, the application crashes on br.Read without throwing any .net error. We have implemented try catch blocks also.It gives the system error &H80131315&  Dim fsInput As System.IO.FileStream Dim fsOutput As System.IO.FileStream Dim bw As BinaryWriter Dim br As Bi ...Show All