http://www.songhaysystem.com/kb/subject/office The Funky Knowledge Base at songhaysystem.com. The subject of this channel is Office Applications. Thu, 23 Oct 2008 21:00:34 GMT http://www.songhaysystem.com/kb/number/2076072055/subject/office Article Excerpt: SharePoint uses the BLOB data type in SQL Server to store files. SharePoint is the primordial ancestor of WinFS. It is tempting to see it as a full replacement for a traditional file system like NTFS. But there are limitations explored in “SharePoint vs… Thu, 23 Oct 2008 21:00:34 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072057/subject/office Article Excerpt: “Custom Document Properties are metadata. Being able to manipulate file listings based on their metadata is one of the core pieces of functionality in SharePoint. My opinion? —don’t use folders in the file system OR SharePoint. In a SharePoint docu… Sat, 18 Oct 2008 01:41:17 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072030/subject/office Article Excerpt: RSS feed support in Outlook 2007 is not satisfactory. It sucks. There is an article from tech-recipes.com, “Outlook 2007: Remove or Disable RSS Feed Support,” here: http://www.tech-recipes.com/rx/ 2031/outlook_2007_remove_or_disable_rss_f… Wed, 03 Sep 2008 20:00:04 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072026/subject/office Article Excerpt: To change the default view to Draft view when a Word 2007 document is opened, follow these steps: 1. Click the Microsoft Office Button, and then click Word Options. 2. Click Advanced. 3. Under General, click to select the Allow opening a document in Dr… Tue, 02 Sep 2008 04:01:32 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072027/subject/office Article Excerpt: From the Word team: “As mentioned in my first post, building blocks are essentially parts of a document that can be reused. All building blocks are contained in galleries in the UI for easy use. Where are these building blocks stored? The simple answer … Tue, 02 Sep 2008 04:08:51 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072028/subject/office Article Excerpt: Public Sub RefreshCustomQuickParts() Dim objRow As Word.Row Dim objCell As Word.Cell Dim strEntryName As String, strCategoryName As String, objEntryRange As Word.Range Dim strMsg As String Dim objNode As Word.XMLNode Dim objContent… Tue, 02 Sep 2008 04:10:11 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076072025/subject/office Article Excerpt: Office Word 2007 handles AutoText entries differently than in previous versions of Word. In previous versions of Word, AutoText entries are stored in the Normal.dot template or in user templates. Office Word 2007 replaces the Normal.dot template with the … Tue, 02 Sep 2008 03:38:34 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071991/subject/office Article Excerpt: 1: Use the Custom UI Editor Tool to generate the proper OpenXML parts in the Normal.dotm template to get me started writing raw XML against the Word 2007 application. I could have done this by hand using the tool mentioned in step 2 but was too “lazy.�… Tue, 19 Aug 2008 23:19:46 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071976/subject/office Article Excerpt: Moving items to and from the Spike 1. Select the text or graphic you want to move, and then press Ctrl-F3 (in Windows) or Cmd-F3 (on a Mac). 2. Repeat this step for each additional item you want to move to the Spike. 3. Click in the document where you … Wed, 02 Jul 2008 03:25:21 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071975/subject/office Article Excerpt: 1. On the Tools menu, click AutoCorrect Options, and then click the Smart Tags tab. Note In Word 2007, click the Microsoft Office Button, click Word Options, click Proofing, and then click AutoCorrect Options under AutoCorrect options. In the AutoCorrect… Wed, 02 Jul 2008 03:22:41 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071895/subject/office Article Excerpt: Junk mail filtering does not work by design when Outlook is not running in cached exchange mode. To turn on cached exchange mode: 1. On the Tools menu, click E-Mail Accounts, click View or change existing e-mail accounts, and then click Next. 2. In the … Mon, 08 Oct 2007 22:56:07 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071732/subject/office Article Excerpt: Ken Laws of Microsoft writes the following: "Once Visual Studio 2005 is installed you may encounter problems debugging your VSTO 2003 project from within Visual Studio 2003. This is again a result of Microsoft Office loading the project in the 2.0 Framewo… Wed, 25 Jan 2006 18:59:07 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071725/subject/office Article Excerpt: I will never build an XML Expansion Pack. This sacred vow is based on the description of them in "XML Expansion Packs [Word 2003 XML Reference]": http://msdn.microsoft.com/library/en-us/ WordXMLCDK/html/cdkAdvancedExpansion_HV01112412.asp Th… Wed, 11 Jan 2006 07:16:17 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071690/subject/office Article Excerpt: Read "How to debug a script for a Microsoft Office InfoPath 2003 form" (MSKB Article 827002; http://support.microsoft.com/kb/827002/EN-US/) to see, "To debug a script for an InfoPath form, you must first attach Microsoft Script Debugger to your InfoPath f… Mon, 11 Jul 2005 01:34:13 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071676/subject/office Article Excerpt: By making your form fully trusted, you can avoid the annoying "ADO Security Warning" messages that suggest a communication problem among development teams at Microsoft. You can make your form Fully Trusted by selecting Tools > Form Options > Security. You… Thu, 19 May 2005 22:37:03 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071671/subject/office Article Excerpt: Mon, 02 May 2005 07:08:00 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071664/subject/office Article Excerpt: The error message "The custom dictionary is full. The word was not added." is not always due to custom dictionary "corruption" problems covered in MSKB article 224035 here: http://support.microsoft.com/kb/224035 This error message can appear when yo… Sun, 10 Apr 2005 05:48:59 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071616/subject/office Article Excerpt: "This article describes how to bind a Rich Text Box control on a Microsoft Office InfoPath 2003 form to an XML element that is returned from a Web service." For more information please see: http://support.microsoft.com/default.aspx? kbid=826… Thu, 17 Feb 2005 23:02:04 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071646/subject/office Article Excerpt: When opening a SQL Server table in DataSheet View from an ADP file, the following error message might appear: "The stored procedure executed successfully but did not return records." This problem is likely to be caused by an invalid SQL statement st… Mon, 14 Feb 2005 21:55:42 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071640/subject/office Article Excerpt: You may have noticed that you can resize the Open and Save As... dialogs in all Office System applications. You probably have seen the strip of icons on the left side of these dialogs. This strip is called the My Places bar and it is customizable. The det… Sat, 29 Jan 2005 07:53:58 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071639/subject/office Article Excerpt: * The Table > Autofit commands were seriously overlooked. * Enhanced metafile is the graphics format that Word "likes" (won't bloat file size). * Keyboard shortcuts for Office Word that have lasted over the years: Ctrl + c (Copy) Ctrl + v (Past… Fri, 28 Jan 2005 09:21:30 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071631/subject/office Article Excerpt: I am a Microsoft guy for historical and practical reasons---not for ideological reasons. When some Oracle guy has a smart remark, I say, Hey, smarty slacks, back in the early 1990s when I was learning SQL I could not walk into an Office Depot and pick up … Thu, 13 Jan 2005 02:03:43 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071615/subject/office Article Excerpt: "When you save a Microsoft Word document that contains an EMF, PNG, GIF, or JPEG graphic as a different file format (for example, Word 6.0/95 (*.doc) or Rich Text Format (*.rtf)), the file size of the document may dramatically increase." For more informa… Tue, 02 Nov 2004 01:12:23 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071604/subject/office Article Excerpt: Sub SaveFolder() Dim FSO As New FileSystemObject Dim Folder As Folder Dim File As File Set Folder = FSO.GetFolder("C:\MyDocs\") For Each File In Folder.Files If InStr(1, File.Name, ".wps") Then _ Call FileSaveAs(Fol… Thu, 26 Aug 2004 20:37:45 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071600/subject/office Article Excerpt: Outlook power users know that the F11 key sends focus to the Find a Contact drop-down list in the Toolbar. The names shown in this are stored in the registry and, for Office 11, can be cleared by deleting this key from the registry: HKEY_CURRENT_USER… Wed, 14 Jul 2004 18:29:25 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071595/subject/office Article Excerpt: Under the Tools > Options... > Calendar Options... > Calendar options section you clearly see the Add Holidays... button. You might have the idea that there is a "remove holidays" button as well. There isn't. And what's worse is when somehow, someway holi… Thu, 01 Jul 2004 18:36:47 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071588/subject/office Article Excerpt: * To avoid Internet Explorer security prompts, namely those popping up because of Web Parts, add the SharePoint portal to the Trusted Sites zone. * The fastest way to expose the portal to an intranet domain (and all of the domains that trust this domain)… Wed, 26 May 2004 02:46:34 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071559/subject/office Article Excerpt: Dim objRange As Range Set objRange = Application.ActiveDocument.Range With objRange.Find Call .ClearFormatting .Font.Bold = True .Format = True .Forward = True .Highlight = False .MatchAllWordForms = False .MatchCase = False … Sun, 11 Apr 2004 08:32:01 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071535/subject/office Article Excerpt: The Microsoft KB article "Text in Drawing Does Not Appear Correctly When You Print to Adobe PDF Writer" covers this problem in detail at: http://support.microsoft.com/default.aspx?scid=kb;en-us;318324 It appears that Microsoft blames Adobe for this … Sat, 13 Sep 2003 07:27:43 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071534/subject/office Article Excerpt: Turning Off AutoCorrect Per Field AutoCorrect can hurt more than it can help in Access forms. To turn it off at the application level (via Options... > Spelling) may not be the way to go as this could affect other Office applications---not to mention the… Fri, 12 Sep 2003 22:33:05 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071529/subject/office Article Excerpt: InfoPath is FrontPage for XML documents. It serves as a wrapper for BizTalk (thereby actually making BizTalk "necessary"). Sharepoint Server reads the properties of InfoPath documents, but these "properties" are actually the XML nodes of the document it… Tue, 26 Aug 2003 00:21:37 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071522/subject/office Article Excerpt: This was the error message that started it all: "The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source." I was getting this error when I set the RecordSource … Wed, 11 Jun 2003 00:18:41 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071520/subject/office Article Excerpt: This is an old problem that keeps popping up over the years: Say I enter a semi-colon or /cmd for my shortcut to my office application file as described by KB article 209207 ("ACC2000: How to Use Command-Line Switches in Microsoft Access"). I have consist… Sat, 07 Jun 2003 00:13:20 GMT Bryan Wilhite http://www.songhaysystem.com/kb/number/2076071496/subject/office Article Excerpt: In Word XP (or Word 2002) the Paste Options Button appears after you paste text into a Word document. Clicking on the Paste Options Button reveals the option Match Destination Formatting. This option is extremely useful when you are copying text (with bol… Thu, 07 Nov 2002 23:52:45 GMT Bryan Wilhite