MS Applications Support - MS Applications Help from MS Applications Experts

Hyper-V Network Card not working dariusg05/14/2009, 12:00 AM Hyper-v Network Card not working There are two common mistakes that people make when they setup a Hyper-V VM. First problem is that they don't install the integration components before they start troubleshooting problems with the Hyper-V VM fu Topic: Hyper-VTags: Views: 18598Comments: 2
Using the Dictionary Class in VBA matthewspatrick07/13/2010, 12:00 AM Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful Topic: Microsoft Office SuiteTags: Dictionary, Scripting, Microsoft, Visual Basic, Visual Basic for Applications, VB, VBA, Scripting Runtime, Excel, Access, Word, Office Views: 15784Comments: 26
Median, Mode, Skewness, and Kurtosis in MS Access matthewspatrick02/24/2010, 12:00 AM by Patrick G. Matthews Introduction Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance Topic: Microsoft Access DatabaseTags: Microsoft, Access, Statistics, Mean, Median, Mode, Standard Deviation, Skewness, Kurtosis, Sampling, Visual Basic, Visual Basic for Applications, VBA Views: 15728Comments: 23
Extending Outlook Rules via Scripting BlueDevilFan01/18/2009, 12:00 AM Scenario. Outlook rules are a great way to automate message processing. Using rules you can organize your messages, forward or reply to messages automatically, display custom message alerts, set reminders, and more. Unfortunately, rules have two Topic: Outlook Groupware SoftwareTags: Microsoft, Office, Outlook, VBA, Macro, Rules Views: 15193Comments: 2
Outlook 2007 error in EMSMDB32.DLL when performing search BrainPicker01/13/2011, 12:00 AM Today I have discovered the solution to a problem that began yesterday. Some of our client computers running Office Outlook 2007 (connecting to Exchange 2007) started crashing, when performing a search on any folder. The error would crash Outl Topic: Outlook Groupware SoftwareTags: KB2412171 Outlook 2007 EMSMDB32.DLL error crash Windows XP Views: 13921Comments: 26
Calculating Distinct Counts in Access matthewspatrick02/08/2010, 12:00 AM by Patrick G. Matthews All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns t Topic: Microsoft Access DatabaseTags: Access, Query, Queries, SQL, Distinct, Count, Distinct Count, VBA, Visual Basic, Aggregate, Domain Aggregate Views: 13412Comments: 18
How to Split a String with Multiple Delimiters in VBA alainbryden09/08/2009, 12:00 AM This Article This Article discusses tips for extending the functionality of the VB 6.0 and VBA Split() function, described here. We will introduce a quick and easy enhancement function, as well as a more extensive function which provides some much Topic: Microsoft Office SuiteTags: VB, VBA, Split, Multiple, Consecutive, Delimiters, String, Array, Formula, Excel, Access, Word, Microsoft Views: 12973Comments: 35
A VBA Progress Bar for Excel and Other Microsoft Apps. alainbryden10/13/2009, 12:00 AM Keeping the user informed is important If you have written some VBA code for Excel (or Word, or Access), and it takes a long time to execute, it is important to keep the user informed that the code is progressing. Psychologically, it can also have Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, VBA, Automation, Progress Bar, Cancel Button, Time Elapsed Views: 12894Comments: 19
Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work matthewspatrick03/09/2010, 12:00 AM by Patrick G. Matthews Introduction VLOOKUP is a tremendously useful function that allows you to "fetch" data from a specified rectangular range (the "lookup table"); this range can be on the same worksheet, a different worksheet in the sa Topic: Microsoft Excel Spreadsheet SoftwareTags: Microsoft, Excel, VLOOKUP, HLOOKUP, function, formula, #N/A, N/A, error Views: 12724Comments: 35
Automatically Printing/Saving Emails/Attachments in Outlook BlueDevilFan04/22/2010, 12:00 AM Automatically Printing/Saving Emails/Attachments in Outlook Issue. One of the more frequent Outlook questions I see here on EE is "How can I automatically save or print an email and/or its attachments?" There are a number of variations to the b Topic: Outlook Groupware SoftwareTags: Outlook, macro, message, attachment, print, save Views: 11997Comments: 50
Importing and Exporting Outlook 2007 Categories BlueDevilFan05/31/2009, 12:00 AM Issue. "How do I copy my categories to another computer?" and "How can I share a set of categories with a group?" are two of the more frequent category related questions I see here on Experts-Exchange. The answer is that Microsoft, unfortunately, Topic: Outlook Groupware SoftwareTags: Outlook 2007, Categories, Import, Export, Share Views: 11850Comments: 34
Playing with Time Conversion in Excel saurabh72611/20/2008, 12:00 AM Lot of times in Excel we have to do quick time conversion that is...The time is given in Time format which is -->12:00:00 and we need to convert it into a number format that is -->12 A quick multipication of same by 24 will convert it to the Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Time Conversion Views: 10393Comments: 7
How to Mimic the T-SQL IsNumeric() Function in MySQL mwvisa111/21/2008, 12:00 AM In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number Topic: SQL Query SyntaxTags: MySQL, IsNumeric, RegExp, Regular Expression, Sorting Text and Numbers Separately, SQL, RegExp_Like Views: 9737Comments: 28
Excel Tips & Tricks: The Camera Tool harfang10/17/2009, 12:00 AM Introduction Back in the years when I was teaching Excel 4 (yes, version 4, when .xls meant "worksheet" and not "workbook"), I had a couple of recreational exercises to use when the class was getting tired, after the afternoon break. One of them Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel Camera Picture Link layout dashboard report traffic light semaphore Views: 9723Comments: 55
Internet Explorer 9 Crash Restart Loop PeteLong09/21/2010, 12:00 AM Problem I downloaded the Microsoft Internet Explorer 9 Beta, today, to give it a test drive and maybe write a review for the site, and it failed miserably and got stuck in a crash restart loop. The error message given is as illustrated below i Topic: Internet Explorer Web BrowserTags: IE9, Crash, Event ID 1000 Views: 9056Comments: 20
Expanding a Hierarchical Data Structure mbizup06/20/2008, 12:00 AM Introduction One of the earliest concepts learned by database developers is parent-child (one-to-many) relationships. These relationships are integral in countless database applications. A purchase request containing one or more items ordered i Topic: Microsoft Access DatabaseTags: Databases, MS Access, Bill of Materials, BOM, Parts Lists, heirarchical, recursion Views: 8701Comments: 42
Simple Linear Regression in MS Access matthewspatrick04/03/2010, 12:00 AM by Patrick G. Matthews Introduction Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables. While Microsoft Access does not Topic: Microsoft Access DatabaseTags: Access, Microsoft, regression, regression analysis, linear regression, statistics, VBA, VB, Visual Basic, coefficients, r squared, standard error Views: 8189Comments: 13
Never Again Forget to Add that Attachment to your Outlook Email BlueDevilFan04/25/2010, 12:00 AM Issue. Have you ever sent an email and forgotten to add the attachment? How embarrassing!!!! Here's a short Outlook macro to make sure this never happens again. As I’ve gotten older I’ve noticed that my memory and attention to detail have both Topic: Outlook Groupware SoftwareTags: outlook, attachment, vba, script, macro Views: 8136Comments: 56
Word 2010 Review: Improving Collaboration and Navigation BMilneSLO03/04/2010, 12:00 AM When I first made the jump from Microsoft Word 97 to Word 2007, it was just that … a giant leap. Going a decade between software updates is as dumb as it sounds, but when you’re used to a solid word processor like Word 97, you tend to stick with Topic: Microsoft Office SuiteTags: Microsoft Office 2010, Word 2010 Views: 8130Comments: 7
"Domain Aggregate" for Concatenating Values by Group in Microsoft Access matthewspatrick02/02/2010, 12:00 AM by Patrick G. Matthews A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query. For example Topic: Microsoft Access DatabaseTags: Access, VBA, SQL, query, domain aggregate, concatenate Views: 7941Comments: 21
Avoiding Blank Subject Lines in Outlook BlueDevilFan04/24/2010, 12:00 AM Issue. Have you ever received an email with a blank subject line? Have you ever clicked "Send" only to realize that you forgot to add a subject? It’s frustrating to receive a message with no subject. You’ve no idea what the message is about, how Topic: Outlook Groupware SoftwareTags: outlook, macro, script, blank, subject Views: 7725Comments: 22
Eliminating duplicate data with Duplicate Master V2 brettdj12/17/2009, 12:00 AM Introduction - The Problem Many people use or inherit spreadsheets built with database functionality. A frequent problem with such spreadsheets is duplicate data, either of entire records, or in specific fields. Duplicate data in your spreadshe Topic: Microsoft Excel Spreadsheet SoftwareTags: excel, duplicates, vba, regular expressions, fuzzy match, addin, unique, brettdj Views: 7573Comments: 100
Using Variant Arrays in Excel VBA for Large Scale Data Manipulation brettdj03/17/2010, 12:00 AM Introduction One of the most common VBA techniques is the use of a For .. Next loop to iterate through all the cells in a range. The syntax is straightforward and easily applied. Unfortunately, for large data sets it can also be the programming e Topic: Microsoft Excel Spreadsheet SoftwareTags: Variant Arrays VBA, For Next Loops, Code optimisation, leading zero replacement, regular expression Views: 7543Comments: 34
Option to open excel 2007 documents in a new instance alainbryden06/22/2009, 12:00 AM Problems we all know excel has Many people are tired of the way excel workbooks are affected by every other workbook you have opened. When you calculate one, they all calculate. Excel acts as though they are inter-dependent when they really aren't Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel, Excel 2007, Windows XP, Shell Views: 7041Comments: 8
Export or Strip Email Attachments in Outlook alainbryden08/12/2010, 12:00 AM Intro I've seen a few requests floating around for scripts that will export or strip attachments out of emails, and so far have never encountered any high quality implementations of this feature, so I created this method with a little flavor. Whe Topic: Outlook Groupware SoftwareTags: Outlook, Attachment, Strip, Archive, Save, Button, Manage, Email, VBA, Macro Views: 6897Comments: 29
Analytical SQL : Where do you rank? mwvisa109/16/2009, 12:00 AM "Top 10 customers by salesperson" sound familiar? Yes! I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind. So, how do you query this data in your SQL system? Topic: SQL Query SyntaxTags: Analytical Functions, Row_Number, Rank, NTile, Dense_Rank, Over, MySQL, Oracle, MS SQL, MS Access Views: 6882Comments: 27
How to dynamically control form List Box controls in Excel. alainbryden06/16/2009, 12:00 AM What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab Topic: Microsoft Excel Spreadsheet SoftwareTags: Excel VBA, Excel Controls, Excel 2007, Excel 2003, ListBox, ListBoxes Views: 6537Comments: 20
SharePoint permissions reporting tool dp_expert11/17/2009, 12:00 AM Recently Microsoft has released the Fourth Release of the Microsoft SharePoint Administration Toolkit. It was announced on the SharePoint team blog. A very interesting part of this toolkit is a permission reporting tool. I think that every admin Topic: MS SharePointTags: Effective permissions, reporting tool, permission inheritance, Sharepoint Views: 6474Comments: 6
Covariance and Correlation in MS Access matthewspatrick03/24/2010, 12:00 AM by Patrick G. Matthews Introduction Access provides functions for computing several common descriptive aggregate statistics for column data, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev, Topic: Microsoft Access DatabaseTags: correlation, correlated, covariance, MS, Microsoft, Access, domain aggregate, Visual Basic, Visual Basic for Applications, VB, VBA Views: 6419Comments: 23
Automating Out of Office in Outlook BlueDevilFan07/24/2010, 12:00 AM Outlook’s “Out of Office” (OOO) feature is a wonderful tool if your mailbox is hosted on Exchange. When it’s turned on, your Exchange server sends a reply to anyone who emails you, letting them know that you are out of the office. There’s th Topic: Outlook Groupware SoftwareTags: outlook, vba Views: 6375Comments: 10
Dlookup and the Domain Functions JDettman06/18/2008, 12:00 AM Applies to: All versions of Access Skill Level:Beginner One of the common questions we see in the Access zone is how to get a value from a table. One way to do that is with a set of built-in functions called Domain functions. These functio Topic: Microsoft Access DatabaseTags: "Microsoft Access" Access VBA Beginner Views: 6183Comments: 17
Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing harfang11/05/2009, 12:00 AM If you are on this page looking only for ways to handle Null values or Missing parameters, you can scroll down to the appropriate section, and skip the rest. Each section should be intelligible when read out of sequence. Introduction I hav Topic: Microsoft Office SuiteTags: VBA, Visual Basic, Access, Excel, Null, Empty, Blank, #N/A, ZLS, Nothing, Missing Views: 6094Comments: 17
Allowing Access to the Windows Clipboard DanRollins10/14/2009, 12:00 AM Do you ever get that "Do you want to allow this web page to access your clipboard?" pop-up message in Windows Explorer? This happens when a script on the page executes a sequence like: var s="new clipboard text!"; window.clipboardData.setData Topic: Internet Explorer Web BrowserTags: Internet Explorer, JavaScript, clipboardData, Trusted Site, webpage to access your clipboard Views: 6079Comments: 6
How to create and deploy a custom field type within Sharepoint gamesmeister11/25/2008, 12:00 AM This example will use a custom field type to create a drop down list populated from a Sharepoint List. There are four main components to building a custom field& " Field Class* This must inherit from an existing SPField class. e.g. SPFieldText Topic: MS SharePointTags: sharepoint, moss, custom field type Views: 5931Comments: 3
Fixed Rate Loan Amortization Schedule with Optional Extra Principal Payments matthewspatrick06/28/2010, 12:00 AM Introduction Using Microsoft Excel to create a fixed rate loan amortization schedule is a very common task: probably just about every skilled Excel user who has ever taken out a mortgage has either created such a schedule him/herself or downloade Topic: Microsoft Excel Spreadsheet SoftwareTags: mortgage amortization, loan amortization, amortization, loan, mortgage, Excel, VBA, VB6, interest, principal, PMT, PPMT, IPMT Views: 5921Comments: 28
Open multiple mailboxes on different Exchange Servers with Outlook 2010 demazter10/25/2010, 12:00 AM As an IT Consultant I have the need to have access to multiple mailboxes on different Exchange Servers remote from my working location. In previous versions of Outlook this meant I had to either use different outlook profiles or settle for using Topic: Outlook Groupware SoftwareTags: multiple mailbox, Outlook 2010 Views: 5798Comments: 8
Installing Ubuntu 10.04 on Windows 2008 R2 Hyper-V cshepfam09/21/2010, 12:00 AM The purpose of this article is to help people install Ubuntu 10.04 on Windows 2008 R2 Hyper-V. Some of the issues many people face in installing Ubuntu 10.0.4 on Hyper-V are the following: 1. No Network Connection 2. No Mouse functionality wh Topic: Hyper-VTags: Windows Server 2008, Ubuntu, Hyper-V, Ubuntu 10.04 Views: 5537Comments: 4

Top Articles

Hyper-V Network Card not working

Using the Dictionary Class in VBA

Median, Mode, Skewness, and Kurtosis in MS Access

Extending Outlook Rules via Scripting

Outlook 2007 error in EMSMDB32.DLL when performing search

Calculating Distinct Counts in Access

How to Split a String with Multiple Delimiters in VBA

A VBA Progress Bar for Excel and Other Microsoft Apps.

Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

Automatically Printing/Saving Emails/Attachments in Outlook

Importing and Exporting Outlook 2007 Categories

Playing with Time Conversion in Excel

How to Mimic the T-SQL IsNumeric() Function in MySQL

Excel Tips & Tricks: The Camera Tool

Internet Explorer 9 Crash Restart Loop

Expanding a Hierarchical Data Structure

Simple Linear Regression in MS Access

Never Again Forget to Add that Attachment to your Outlook Email

Word 2010 Review: Improving Collaboration and Navigation

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

Avoiding Blank Subject Lines in Outlook

Eliminating duplicate data with Duplicate Master V2

Using Variant Arrays in Excel VBA for Large Scale Data Manipulation

Option to open excel 2007 documents in a new instance

Export or Strip Email Attachments in Outlook

Analytical SQL : Where do you rank?

How to dynamically control form List Box controls in Excel.

SharePoint permissions reporting tool

Covariance and Correlation in MS Access

Automating Out of Office in Outlook

Dlookup and the Domain Functions

Understanding Null, Empty, Blank, #N/A, ZLS, Nothing, Missing

Allowing Access to the Windows Clipboard

How to create and deploy a custom field type within Sharepoint

Fixed Rate Loan Amortization Schedule with Optional Extra Principal Payments

Open multiple mailboxes on different Exchange Servers with Outlook 2010

Installing Ubuntu 10.04 on Windows 2008 R2 Hyper-V

Top MS Applications Experts