AdeptBlue's Q&A profile

• Microsoft ISV Community Center Forums ERROR RUNNING MARCO

  hi can anyone help me with this problem Hi can anyone help me with this problem I have this dos script to pass down a parameter upon opening the excel @echo off start excel "\\136.121.2.1\its helpdesk\ConRisk\RSP Concentration Risk Calculation.xls" /e/8212305557 Is there any code to capture the parameter "8212305557" on the excel macro upon opening here is my code Option Base 1 Private Declare Function GetCommandLineA Lib "Kernel32" () As String Dim CmdLine As String 'command-line string Dim Args As Variant Dim ArgCount As Integer 'number of parameters Dim Pos1 As Integer, Pos2 As Integer Dim sMsg As String Dim Customercode As String CmdLine = GetCommandLineA 'get the cmd-line string Cm ...Show All

• Visual Basic Change system time using vb.net

  Does anyone know how to change the system clock using code. I want to be able to set the date and time in my code. Any thoughts Thanks!!! when i do the global declare of Public theCustomDateTime As DateTime = New DateTime(Year, Month, Day, Hour, Minute, Second) like you suggested it gives me this message. Argument not specified for parameter 'DateValue' of 'Public Function year (DateValue as Date) as integer' ...Show All

• SQL Server Need help using GROUP BY clause

  I have two tables A. TEST_SUBJECTS_TBL with the following columns . This table contains the subjects in a test 1. TEST_SUBJECT_ID PK 2. SUBJECT_ID FK 3. TEST_ID FK 4. PM // This is the passing marks for the subject B. TEST_MARKS_TBL with the following columns This table stores the marks scored by students for each subject 1. TEST_SUBJECT_ID FK 2. STUDENT_ID FK 3. MARKS_OBTAINED I need a query which gives me the max, min,avg marks obtained in each subject for a test and the total number of students who have passed in the subject The query output should be something like this ___________________________________________________________________ SubjectID MaxMarks MinMarks AvgMarks TotalStudentsPassed _______ ...Show All

• Visual Studio Generating diagrams with Sandcastle?

  Is there any way to create diagrams with Sandcastle I mean like Doxygen generates DOT language and using GraphViz creates diagrams that are embedded to the generated help file. Of course I could use Doxygen, but I kind of like Sandcastles VS2005 layout better. Wrth, Sandcastle does not generate diagrams. Intenally we use graphic packages to generate diagrams and embed them during build. If you can provide deatils on DOxygen process or provide pointers I willbe happy to take a look to see what we can do to provide a similar functionality if we can. Anand.. ...Show All

• Visual Studio Can not install Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005

  I am trying to install Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 SP1, but I keep getting the following error, then the installer closes: The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program I have Visual Studio 2005 SP1, MS SQL Compact Edition runtime, and MS SQL Compact Edition SDK all installed. Any ideas why this wont install Make sure that the .msp file is in the c:\temp\ folder. I just tried it again and this should work, wat error do you get exactly On the dialog box that popups you can do a Ctrl + C that will copy the contents of the messagebox to the clipboard and ...Show All

• Visual Studio Team System Check-in from different directory

  Is there any way I can check in a file from a different directory from the one it was checked out, e.g. check-out dir = c:\project, check-in dir d:\equipment In VSS there was a edit box that allowed the directory to be overridden. Thanks, Jeff Not really. Even if you change your workspace mappings, running Get will move most of your files to the new location, but TFS won't touch files that are checked out. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do you draw text?

  Since the XNA documentation is lousy, I'm gonna ask here. How do you create text in XNA I want to use it for debugging purposes :( Where did you put the image and XML files Are they in a sub-folder in the project If so, did you include the sub-folder in your path in referencing them Can you post the relevant code ...Show All

• Windows Forms pictureBox1_Paint() doesn't draw

  Hi, I am making a scrolling text with transparent background. However, the  pictureBox1_Paint() seem to draw nothing! Any idea       public partial class Form1 : Form     {         private String drawString = "Sample Text";         private Font drawFont = new Font("Arial", 31);         private SolidBrush drawBrush = new SolidBrush(Color.White);         private int textX = 0;         public Form1()         {           & ...Show All

• Visual Studio Team System TFS VPCs

  I am unable to find the current VPCs for TFS on the MSDN subscriber downloads. Is this no longer available as a VPC The Orcas VPC is out there, but when I downloaded it, it didn't seem to have TFS on it. (Just the client Visual Studio stuff.) Am I wrong on this Jason, The Orcas Team Suite and the Orcas TFS are two seperate vpc images that you can download. if you wnt to do a single Orcas box, you can download the self-installing versions of each and do an actual install on a single VPC. This is the approach I am taking. -paul ...Show All

• Visual Studio 2008 (Pre-release) WCF, MTOM & File Chunking

  Hi, I have a WSE3.0 Web Service and a WCF Client. I'm trying to upload and download files using the WebService and MTOM. All works perfectly. I should now implement a progress bar showing the progress of the upload and download process. I have resolved this problem dividing the file in chunk of x bytes and sending with a cycle on another thread (using BackgroundWorker). Now I'm wondering: can I avoid the chunking stuff, send every file with a single call to the web service and still be able to monitor the progress of the upload process Thanks Marco have you looked the chunking channel sample at http://wcf.netfx3.com/files/folders/protocol_channels/entry3545.aspx , it's a channel layer ...Show All

• Visual C++ extern "C" with a struct

  Good Morning I'm trying to compile a project that is a mix of C/C++ code. It compiles fine but fails on linking as one of the C++ file can't resolve the global variables from the C code. So I ' extern "C" ' all of the global variables and that works, except I have a question: how do you extern a pointer to a struct I tried: extern "C" struct myStruct *struct; and I get about 80 errors, saying I'm missing semicolons and brackets and stuff. Any ideas Thanks, Philski extern "C" in this form can only be used with functions. For example: extern "C" void my_C_function(); You need to use the block form: extern "C" { struct MyStruct *struct; } ...Show All

• Visual Studio Express Editions Major new discovery: the Platform SDK's MFC source code can be built and used with VC++ Express

  As you all may know, MFC is not included with Visual C++ Express 2005.   You'd have to purchase VC++ Standard edition to get MFC. But the MFC source code (no binaries) happens to be included with the Platform SDK, in the folders: <installed Platform SDK folder>\SRC\MFC and <installed Platform SDK folder>\INCLUDE\MFC There are some make files in there (mfcdll.mak etc), but the main MAKEFILE and export DEF files are missing.  If you have a copy of Visual C++ 6.0 you can get these missing files.  I have sucessfully built this version of MFC (both debug and release) and run a test app using this rebuilt version (I named it MFC42E.DLL) with very minor changes to the source cod ...Show All

• Visual Studio 2008 (Pre-release) WPF Grid - Cell background color

  Is it possible to obtain access to a cell on a Grid and change it's background color I can create a panel manualy, but can't to add it to "cell". Can you say, how to insert (assign) a panel into a "cell" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game-install question?

  im starting to write a simple game.A tetris-like game.But i have a problem.My game will be about 1 or 2 MB.And written in C#.But if the users dont have .NET framework 2.0,wont they be able to play my game Or what should i do except making them installing Framework 2.0 Because it is huge and 20 mb . i need your advises,dear programer friends! Thanks a lot... If your program uses .NET 2.0 then anyone who installs it will have to have .NET 2.0 installed. Also if your program uses Managed DirectX 1.1, then users will need to install .NET 1.1 as well, if they don't already have it. I don't know of any ways around this, but one way to simplify your program's installation is to use ClickOnce deployment, which automatically ...Show All

• .NET Development Converting Excel Table to XML file

  Hi, I have been looking all over the web how to convert an Excel table to a XML file. I have such table: cityName Population Growth New York 10,000,000 1.3 Miami 5,000,000 2.4 with much more cities and mouch more columns, and I would like an XML such as: <cityName name="New York"> <Population>10,000,000</Population> <Growth>1.3</Growth> </cityName> <cityName name="Miami"> <Population>5,000,000</Population> <Growth>2.4</Growth> </cityName> Can anyone help figure out how to make such XML map/scheme Thanks, Yoni Sergey Dubinets - MSFT wrote: ...Show All