Andrew Sims's Q&A profile

• Microsoft ISV Community Center Forums Convert worksheet to DOC

  Hi everyone, i working on a project for my workplace at the moment and I'm finding it very difficult to do a few things using vba, its the first time i am using it and so many things make no sense to me. So far i have been able to create a in excel a login with password system using a database of Access and this was hard enough to do. now my next problem is exporting a range from an excel sheet to a word documents, it is very important how the document will look like as it will be emailed to other companies for payments and time processing, so I'm trying to give it a look as professional as possible.(see picture below) http://i35.photobucket.com/albums/d187/moobz/untitled-1.jpg (this is the look i would like it to have.) To produce the pi ...Show All

• SQL Server Blank fields in Excel file

  I am trying to validate and import a Excel file into the database table using script component. The file contains some blank columns in the sheet. How can I handle the blank spaces while validating the file in the Script Component The code is as follows: Dim excelcmd As OleDbCommand = New OleDbCommand("SELECT Item,TaxCode,ItemDescription FROM [Input$]WHERE LEN(Item)>=0 AND LEN(ItemDescription)>=0 AND LEN(TaxCode)>=0", excelConn) Dim excelreader As OleDbDataReader = excelcmd.ExecuteReader() Dim row As Integer = 0 While excelreader.Read() NameValsBuffer.AddRow() NameValsBuffer.ItemCode = CStr(IIf(excelreader.GetString(0).Length = 0, "#", excelreader.GetString(0))) ...Show All

• Visual Studio Express Editions Visual C# Express Edition hangs on exit

  Unhandled Mystery After doing normal development work and saved files, I closed the Visual C# 2005 Express Edition with the close button on the caption row. Then it happens about one time of ten sessions – the post mortem message: Unhandled exception at 0x776c555c in VCSExpress.exe: 0xC0000005: Access violation reading location 0x585db268. Next the bigger nuisanse happens: System relaunch C# IDE and I need to close the application, but now it closes without exception. Post mortem debugger shows that exception occurred in the ntddl.dll library at address 0x776C555C. By reference, I should say, when using the Windows XP SP2 I never got that error. It shows after I switched in June to Windows Vista U ...Show All

• SQL Server BACKUP RESTORE with no data

  Hi champs, Is there a way in SQL2k5 to backup and restore a database, without the data that is stored in the tables I know I can script the whole database, but is there do this with a backup restore /Many thanks Is there any way of scripting the database out automatically I mean, is it possible to make a scripting backup of the database as a "Maintenance plan" /Many thanks ...Show All

• Visual C# generics: T Create<T>() where T : MyClass, new(...)

  Is there a way to enforce a non default constructor And if not, why not ! I wrote a class that implements a constructor that is in need of an XmlDocument as a parameter. Several other classes inherit from this base class. Now I would like to write a generic create method that instantiates one of the child classes and sets some base properties: class MyClass { public MyClass(XmlDocument xmlDoc) { ... } public ElementName { get { .. } set{ ... } } } class ChildClass1 : MyClass { ... } class ChildClass2 : MyClass { ... } class MyClassFactory { ... public T Create<T>(XmlDocument xmlDoc) where T : MyClass, new() { T myClass = new T(xmlDoc); ... } ... } Obviously that does not work because the generic all ...Show All

• Microsoft ISV Community Center Forums Listing the attributes of a graph

  I would like, by means of vba code, to list all the attributes and their values for a particular excel graph that I have. I want these values in order to be able to "mass produce", by means of vba, graphs with the same set of attributes and atrribute values). Anyone have code for that This would be a HUGE amount of code. It would be easier to create a user-defined chart type and apply it to your charts: http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html ...Show All

• Visual Studio Team System ReportProcessingException: The Language expression for the report ‘body’ has a user profile dependency.

  Hi, We are trying to configure a subscription to e-mail the "Remaining Work" report daily to a specified email account. We are running the RTM version of TFS and have not modified the RDL's in any way. The Remaining Work report displays fine when accessed via the URL. http://server/Reports/Pages/Report.aspx ItemPath=%2fTFS+Management%2fRemaining+Work The Reporting Service Log (\Program Files\Microsoft SQL Server\MSSQL.3\LogFiles) file shows the following exception when the subscription's scheduled time comes: ReportingServicesService!library!a!08/11/2006-12:02:05:: i INFO: Call to RenderFirst( '/TFS Management/Remaining Work' ) ReportingServicesService!processing!a!08/11/2006-12:02:05:: e ERROR: Throwing Microsoft.Repor ...Show All

• Visual Studio Express Editions Assigning special keyboard keys to buttons

  hi there guys. Im currently designing an app that enables disabled users to put data into controls through the use of an onscreen key board I have created. I have figured out how to assign the values of letters, numbers and special characters onto my onscreen keyboard but i cannot get around assigning values of keyboard keys such as 'Tab', 'Up arrow','Home' etc. Does anyone have any ideas on how to achieve this thanks in advance Matt Still dont get it Dman1. this is what i did Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Keys.Tab() End Sub All i get is a build error. Can you just clarify this a bit more. ...Show All

• Smart Device Development what is needed in voice streaming among pocketpc

  platform:mobile2k3 i want to build app that transit/stream voice amoung ppc. how to record sound in wav tcp/ip..... how to send wav file through tcp/ip or udp how to convert wav to bytes what is the best way to transit This is a very broad question. You need to educate yourself on audio streaming, MMS, RTSP, audio file formats, multimedia. Generic WIndows CE 4.2 and newer (not Pocket PC) has a standard VoIP implementation . Take a look at Vovida WinRTP project. It gives you an idea of how this is done. I believe some people were successful in porting it to WinCE ...Show All

• Visual Studio 2008 (Pre-release) Can i debug the service developed using WCF.

  hi, I want to debug the service that has been developed using WCF. When i inovke a method exposed thru a service i need to debug from the client to the service. Both me client and service are on the same machine. Is it possible to debug Thanks in advance. Regards, Rajesh. //Following articles may help Debugging ASP.NET with the CLR Debugger http://support.microsoft.com/kb/893657/en-us Troubleshooting ASP.NET using WinDbg and the SOS extension http://support.microsoft.com/kb/892277/en-us ...Show All

• Windows Forms Unable to cast COM object of type 'mshtml.HTMLDocumentClass' to interface type 'ICustomDoc'

  This operation failed because the QueryInterface call on the COM component for the interface with IID '{3050F3F0-98B5-11CF-BB82-00AA00BDCE0B}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). public virtual void DWebBrowserEvents2_DocumentComplete( object pDisp, ref object URL) { try { do { IWebBrowser2 pWB = ( IWebBrowser2 )pDisp; if (pWB == null ) break ; object oDoc = pWB.Document; if (oDoc == null ) break ; IHTMLDocument2 pHTMLDoc = ( IHTMLDocument2 )oDoc; if (pHTMLDoc == null ) break ; UnsafeNativeMethods . ICustomDoc pCustomDoc = ( UnsafeNativeMethods . ICustomDoc )pHTMLDoc; if (pCustomD ...Show All

• Smart Device Development Problem - connect to Crossbow PPC emulator

  Hello, During building emulator image with Crossbow AK(BSP 'deviceemulator') The problem is: 1. I cannot build PPC emulator with default config.bib & memory.cfg.xml because PPC emulator image exceeds the default NK size(around 32MB). 2. I modified above 2 files to accommodate bigger emulator image. And it worked. 3. But I cannot download bigger emulator image with visual studio 2005. 4. I can download only default size of emulator image(32MB) Can I download PPC image exceeding 32MB How Thanks a lot in advance, Mohit, Thank you very much for the reply and help. From your posting, I got a hint what had made me confused a lot. Exactly as you said, I was using wince6.0 plug-in to connect to wm6.0 emulator image. I cl ...Show All

• Visual C# Why? WSE910: An error happened during the processing of a response message.

  Hi, I am using Saml token for web service authentication. I have a problem it runs fine when server and client is my own machine but it i get error when server and client are seprate machines. --------------------------- --------------------------- Microsoft.Web.Services3.ResponseProcessingException: WSE910: An error happened during the processing of a response message, and you can find the error in the inner exception. You can also find the response message in the Response property. ---> System.InvalidOperationException: Security requirements are not satisfied because the security header is not present in the incoming message. at Microsoft.Web.Services3.Security.SecureConversationClientReceiveSecurityFilter.ValidateMessageSec ...Show All

• Windows Forms Dynamic control docking

  Hi, can anyone tell me if VS 2005 Beta 2 contains a control that will allow me to dock a user control / form I'm interested in getting the sliding docking feature found in VS 2003 / 2005; the one where you can pin a panel if required (ala Toolbox, Server Explorer etc). Thanks for your help Graham Thanks Mike, I look forward to see the article ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Invisible Skybox

  Hi i have used some of the code from the SkyBoxDemo tutorial to make a skybox in my game. I adapted the code to run with my game but when i debug the game i cannot see the skybox and my model following camera flips round to face the front of the model insted of the back and The Ship model turns weird colors!   You wouldn't necessarily have to scale the sky box. You could just move it towards the player a bit as you pour on the speed (and maybe move the camera back a bit as it tries to catch up), then move it back in place as you let off the gas. I originally made the sky sphere thinking space is big, really really big, and you won't see much movement. But it's a game, not reality... have to remind ...Show All