I'm working with an Access database and I need to concatenate different related rows into 1 row. I found a solution here and used it with great success. However I need to add extra conditions to it, it should only be done if certain other columns are equal too. For example: 1 X Alpha 2 Y Beta 1 X Gamma 1 Z Delta should become 1 X A...
Sometimes, for what ever reason, I copy source code into either a word document, or an email ... which in Outlook, I believe, is using Word. Anyway, it would be nice if I could spell check the english part of my document without having to manually ignore each and every source code token. Is there an option, or some type of style format...
Microsoft Word uses PROPFIND method and asks for property save-profile-form-location in urn:schemas-microsoft-com:office:office namespace. What is this property? What am I supposed to return for it? Update: I found urn:schemas-microsoft-com:office:office Namespace documentation, but they don't mention this property. ...
Is it possible to insert a button into a word document and call as macro on click of this button. Please let me know if you have any similar ideas and also the procedure to do it. ...
You know the one I mean: Is there a way to disable this? I'm writing an application to automatically test a large number of Excel spreadsheets which are used in a critical environment. Many of these sheets do crazy things which crash Excel. When Excel crashes I want it to terminate ASAP and without user-intervention. I definitely ...
I'm working on a regression-testing tool that will validate a very large number of Excel spreadsheets. At the moment I control them via COM from a Python script using the latest version of the pywin32 product. Unfortunately COM seems to have a number of annoying drawbacks: For example, the slightest upset seems to be able to break the c...
We have a third party application that ends up generating and opening an InfoPath 2003 form from a Web page. This is NOT a SharePoint forms issue - it is a plain old Web app that upon a button click generates some InfoPath XML with the appropriate mso-infoPathSolution and mso-application elements in it and sets the appropriate content ty...
I need to know whether Microsoft Word, Excel, Outlook, Project, etc are installed in a Windows Forms .net 2.0 C# application. The first attempt was by simply trying to create the application objects and catching any exception, but this is too time consuming. Is there any faster way to detect this? Like checking registry values, or anothe...
Some of the queries I have written inside MS-Access are getting deleted automatically. And while I run the queries through code, I get this error 'Query should have one destination field' What can be the possible reason Explanation: I created a query in MS-access. Ran it from the code. Closed the database. Started it again, and now fo...
I want to deploy a VSTO 3 Application Level Word 2007 addin that I've written with Visual Studio 2008. I see that WiX has an extension named WixOfficeExtension that looks like it might have this functionality, but I can't find any documentation for it, and I can't discern it's purpose from the source code. Has anyone attempted this befo...
I have cross posted on access-programmers.co.uk Please post responses on that forum is possible.. I have compiled a dll in c# 3.5.. where I set the solution properties to register the build for COM interop. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.InteropServices; name...
Hi, I'm really struggling with something here. I have a class module, let's call it FormMan which has a bunch of methods relating to the large number of userforms I have in my project. One particular method is to be called from a lot of different places and is pretty simple - it simply adds a user defined number of controls to a form and...
I would like to generate an Open XML document containing a Chart using the Open Xml SDK 2. I found an SpreadsheetML example, but I can't work out how to add the chart in a .docx... Is there a good source for documentation/examples for the Open Xml SDK 2? ...
Wrote a small app that accesses a bunch of search websites and puts the results in a word document, which gets run a few hundred times a day. It saves individual search results in a number of local folders so the next time those words are searched, it grabs them locally instead of loading the website again. This works fine - even thoug...
I want to set up a template document along the lines of this: ================ Doc content ---------------- Merge Field1 Merge Field2 Merge Field3 ---------------- More doc content ================ I then want to be able to open the document, load a DataTable from the database in C# and merge the fields in the template section in ...
Is it possible to create a two-column Word document, where each column shows a different file? I would like to print out a text in different languages, original and translation, side by side to learn a foreign language, but I cannot figure out how to do it. ...
This is something I ran into last year, and SO seems like a good place to document it :) Q: When automating Excel (/Word/...) from Delphi, how can I check if an Excel function returned the variant Nothing (as it's called in VBA)? ...
I have a customer using the Access 97 runtime to support part of their product. Ideally, given the budget to do so, I would have replaced that dinosaur by this point, but that isn't an option today. I am not the system's original author, but am attempting to provide ongoing support. To distribute this to their customers, they bought the...
I have a use case that seems pretty simple, but after Googling around I can't find a solution. I have some Word documents on an FTP server and I'd like to be able to create a link that would download them into Word and then allow the saved changes to be sent back to the FTP server. The problem is that I can only get Word to either open ...
I'm embedding some Word documents into our web page using iframe like this: <iframe src="ftp://ftp.example.com/www/uploads/Image/test.doc" width="100%" height="400"> Alternative </iframe> The problem is that the embedded Word control allows the user to edit the documents and shows an icon to save them, but doesn't actually save ...