MacDonaldC's Q&A profile

• Microsoft ISV Community Center Forums Memory issue with variable declaration in a macro to write from excel to text file

  I have a macro to write data from excel spreadsheet to text file. The macro is actually creating a DMS script with the insert statement. Everything works fine till the cell(i, 104). Beyond that I am getting 'Compile Error- Too many local, non static variables. ' When I look up in the help it says that 'The sum of the memory requirements for this procedure's local, nonstatic variables and compiler-generated temporary variables exceeds 32K'. How do I fix this problem Here is the code- Sub exportWOinserts2() Dim lFile As Long Dim i As Long Dim lEnd As Long Dim x lFile = FreeFile Open "C:\WOInserts.dms" For ...Show All

• Visual Studio Team System Team Foundation Version Control Command Line capabilities

  Can TFVC have command line capabilities If so, where can I find a TFVC command line listing and guide TFVC command line reference ...Show All

• Visual Studio Team System Moving TFS servers

  Folks, There have been a number of postings requesting instructions on how to move servers (covering some of the following scenarios): Moving TFS from a workgroup to a domain Moving TFS from a Test domain to a Production domain Moving TFS (single server) from one machine to another (disaster recovery for single server) Moving TFS from single server configuration to dual server configuration. These instructions are not currently available as part of the latest MSDN documentation, but I'm happy to announce that they are avaialable here: http://blogs.msdn.com/vstsue/archive/2006/03/22/558178.aspx . As the blog article says ...Show All

• Visual Studio Logon Failed for runtime oracle connection for Crystal Report - VS 2003.

  I'm getting a Logon Failed message when trying to view a web page with a crystal report embedded..   The error is: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. I'm connected to an Oracle 9.x database to design the report using MSDAORA provider, Data Source U50DAMC_LINDA (as defined in my tnsnames file) I've attempted to add the login details to the report as shown below. ReportDocument rpmWorkloadDoc = new ReportDocument(); string reportPath = Server.MapPath("tctoRPMWorkloadReport.rpt"); rpmWorkloadDoc.Load(reportPath); rpmReportViewer.ReportSource = rpmWorkloadDoc; // Declare required variab ...Show All

• Visual Studio Team System On the Destination Folder and Database Server page, type the following information

  I am following the Installation guide for TFS. I'm performing a dual install. I am up to step #5 of "To install the Team Foundation Server (services)". Step #5 says to type the installation path of the TFS services or accept the default. It also says in the Database Server box, type the name of the computer on which you installed the TFS Databases. The problem that I have is that this box is disabled/greyed out. I have tried to solve this problem by uninstalling and reinstalling about 3 times and I get the same problem everytime. I thought the problem was at the point where I am installing Sharepoint and asked to select Server Farm ...Show All

• Visual Studio Reuse class designer?

  This is a longshot...but here goes. I have to provide a "class designer-like" UI for a project (the designer creates an xsd that represents the design of a business object). The timescales are really tight. Is there any way I can reuse any of VS 2005 class designer classes to help deliver this functionality Thanks in advance Stuart Hi Stuart, Unfortunately the answer is no. We are developing a Domain Specific Language toolkit scheduled to release later this year. The key goal of this toolkit is to enable developers like you to create custom designers in a short period of time. An early ...Show All

• Visual Basic It's slow!!!

  Hello After I turn on my computer and when I launch first program (which programed by VB2005), it's take a long time to show main form. VB6 was faster.   CPU speed: 2600 MHz Memory: 1024 MB  Is there a solution for that   Thanks & Regards What do you mean by 'long time' It's possible that, even though windows appears to have finished booting up, it hasn't - it's still loading and starting various services (e.g.SQLServer). Additionally, it may be that the .NET framework needs to load prior to your application loading. Did you try using a splash screen to see if t ...Show All

• Windows Forms fast loading datagrid and combo

  Hi When there are are 10000s of records it takes lot of time to load datagrid. Is there any control that loads only records that will be seen on the screen at a time, then fetches records when we move below of datagrid using scroll. Regards Abhilash c b ...Show All

• Windows Forms Detecting mouse click location for a DataGridViewCell

  I have a ContextMenuStrip in which different options are shown depending on which cell of a DataGridView the user clicks on. My problem is that I am unable to get the x & y co-ordinates of cells. I get the mouse position by using : Point mouse = MousePosition; I tried getting the cell's location by saying: Rectangle cell = dataGridView.Rows[r].Cells[idx].ContentBounds; cell.Offset( this .Left + dataGridView.Left, this .Top + dataGridView.Top); However, the cell co-ordinates I get are completely wrong. Any ideas Thanks for the help in advance guys! Private Sub MyDataGr ...Show All

• Visual C# using ExecCommand to copy in MSHTML

  I am working on an editor using mshtml. I just cannot get cut / copy / paste to work with ExecCommand. All other command identifiers seem to be working well. Here is my code: public partial class Form1 : Form { private static HtmlDocument htmldoc; private bool fireonce = false; // fire previewkeydown only once public Form1( ) { InitializeComponent( ); } private void Form1_Load(object sender, EventArgs e) { webBrowser1.Navigate("about:blank"); webBrowser1.Select( ); } private void webBrowser1_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e) { ...Show All

• Microsoft ISV Community Center Forums Excel, Forms, and Charts

  I am pretty much a beginner when it comes to VB. I need help with a project I am working on that has me ready to rip my hair out. Here is the what I need to do: When I open a workbook (excel) I want it to display a form where I can enter in the date and various data. I need that form to add that data that I entered to the worksheet in the coloumn that corrisponds with that particular information. It also needs to copy that row's formulas and drop it down one row. Last I need it to automaticaly update 3 diffrent charts that have more than one data line. I am at a loss. PLEASE HELP!!! T ...Show All

• Smart Device Development memory to memory transfer rate...

  Hi! We have just discovered one very interesting thing: using memcpy() function we observe data transfer rate ~4.5 Mbytes on our Qtek s100 device and ~9.0 Mbytes on our iPAQ 2210 do not discussing difference of rates for these devices I wanna ask - is such extremely low internel data transfer rate normal for nowadays PDA and communicators It's really disappointing. Any advice I'd say it's normal. If you find a device with dual channel DDR2 64 bit memory at 533MHz, that would be a lot faster than with cheap high-latency 100MHz SDR 16 bit memory most ARM devices have. Tiny single level ...Show All

• Visual C# Tablet PC Ink Overlay Question

  I was struggling to find a good forum to post this in, hopefully c# general will do.  I am using an inkoverlay object on top of a Leadtools RasterImageViewer, but for all intents and purposes let's pretend it is a picturebox control. Everything works very well, I can accept ink, erase, etc, the problem is that if I am not displaying the image in normal 1:1 mode then my strokes don't go to the correct area of the graphics object (the image).  I know the answer probably lies with some form of transform but I still haven't quite understood the concept.  Also when the image is not 1:1 like if it is set to fit or fit width when I d ...Show All

• Visual C++ How can I sign ActiveX controls/references in VS2005?

  In VS2003 C++, I can configure strong names for ActiveX control references so I can sign and build my main assembly. This is done from the Project Managed Wrapper Properties. But I cannot find an equivalent for this in VS2005 C++. I see properties for references in Project References, but they are grayed out. Is there a way to sign ActiveX controls/references in VS2005 Thanks Hi, I am not sure what dialogs you are looking for. Strong name signing is described in this topics, http://msdn2.microsoft.com/en-us/library/xc31ft41(VS.80).aspx . However I am not sure what you mean abou ActiveX control signing ...Show All

• SQL Server Remote Error Problem

  Hi all, I created a report that uses resultset generated from integration service. I managed to run the report on BIDS and also by command prompt on both server pc and remote pc. (I created the report from remote pc and deploy the report from remote pc also). When I try to run the report from report server, the following error came up (I already enable remote errors): An error has occurred during report processing. Cannot create a connection to data source 'SSIS'. 5 Anyone have any idea how to solve it or anywhere that I can find the meaning of the 5 below the error message Thanks in advance. Daren ...Show All