Developer Support - Developer Help from Developer Experts

Create a Win7 Gadget DanRollins11/20/2009, 12:00 AM This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, or to act as a gateway to a website or a larger pr Topic: Windows ProgrammingTags: tutorial, sample, Windows 7, gadget.xml, sidebar, Hello World, localappdata, debugging, ZIP file, Dan Rollins Views: 70666Comments: 20
C++ Q & A / Interview Practice Questions evilrix08/27/2009, 12:00 AM How good is your C++? Below is a collection of questions that I have built up over time that test how well someone who claims to know C++ actually does. Knowing the answers to these questions will probably help you avoid making a lot of the mistakes Topic: C++ Programming LanguageTags: c++ interview questions Views: 34167Comments: 47
How do I enlarge my image without losing quality? lherrou07/15/2009, 12:00 AM by Todd L'Herrou As you might guess, this is a common problem, and a common type of question. Unfortunately, small images or highly compressed images (including JPG format images in particular) provide very little to work with when trying to enla Topic: Images & Photo SoftwareTags: enlarge image jpeg jpg gif quality photoshop irfanview resize Views: 29817Comments: 22
jQuery AJAX-Enabled Forms in Modal Dialog anoyes12/13/2009, 12:00 AM It's a problem I'm sure many of you have faced in developing web applications. You've got a form to add a new something - perhaps a customer or an item in a to-do list. When the user clicks that link to add a new item, a new page loads, they fill Topic: JqueryTags: jquery, ui, dialog Views: 26600Comments: 20
How Oracle Stores Passwords sdstuber06/09/2009, 12:00 AM How Oracle Stores Passwords Sean D. Stuber 2009-06-09 Up to date through Oracle version 11g Overview: Many times a DBA may want to replicate a user from one system to another and migrate that same password,such as refreshing a production syste Topic: Oracle DatabaseTags: Oracle, 10g, 11g, DBA_USERS, SYS.USER$, password, hash Views: 22957Comments: 36
Pie Chart Techniques ValentinoV10/29/2009, 12:00 AM Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips. This article explained how to optimize a Column Chart. Today I have returned to show you some Pie Chart implementation techniques. As usual, I will Topic: MS SQL ReportingTags: SSRS, SQL Server Reporting Services 2008, pie chart, reporting services, charting Views: 21668Comments: 12
Simple Multithreading in Visual C++ DanRollins09/23/2009, 12:00 AM Here's a summary of how to use multithreading, with short, easy-to-follow example code in C++. Before you embark on this journey, I suggest that you read Multithreading -- When and Why because odds are, you really don't need to create additiona Topic: Windows ProgrammingTags: multi-threading with C++, Create Thread, AfxBeginThread, TerminateThread, killing a thread Views: 19568Comments: 4
Flash - Collision Detection using ActionScript 3.0 Crackpack05/09/2009, 12:00 AM This is intended to introduce all collision detection principles in flash, their strengths, weaknesses and workarounds. The main method for Collision Detection in flash is using hitTestObject. But unless you'll be pushing rectangular shapes without Topic: Adobe FlashTags: Flash, ActionScript, hitTest, collision, detection Views: 16554Comments: 7
Convert string to number / Convert number to string in JavaScript DanRollins09/25/2009, 12:00 AM This EE article provides JavaScript examples of conversion from string to integer, string to floating-point, and number to string. We'll also look at some related topics, including how to format numeric output with two decimal places, and one way t Topic: JavaScriptTags: javascript, JScript, convert to string, convert to integer, convert to floating point, format currency, toFixed, parseInt, toString Views: 16532Comments: 3
Execute a Program with C++ DanRollins09/19/2009, 12:00 AM This article describes several ways to launch a program using C++, including one that will launch a DOS (console-style) program and capture the console output (the standard output) for programmatic processing. We are going to focus on the task of Topic: Windows ProgrammingTags: Execute a DOS program, ShellExecute, launch a program, C++, show web browser, print PDF file, CreateProcess, unzip, runas, Dan Rollins Views: 15900Comments: 10
How To Resolve "An attempt was made to reference a token that does not exist" on an IIS 5 server Tray89606/21/2009, 12:00 AM Here are the symptoms: You start receiving calls from users that one of your legacy web apps isn't coming up, so you log into your IIS 5 server to check it out. When you pull up the services, you notice that the WWW Publishing service isn't runn Topic: Microsoft IIS Web ServerTags: IIS Views: 15686Comments: 2
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: 15626Comments: 23
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: 15515Comments: 18
Your First OLAP Report ValentinoV01/24/2010, 12:00 AM This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Topic: MS SQL ReportingTags: SSRS, SQL Server, Reporting Services, mdx, olap, SSAS, Analysis Services, cube Views: 15402Comments: 12
Retrieving Data From Excel Using OPENROWSET() ValentinoV05/04/2010, 12:00 AM The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a significant amount of time has probably come into contact Topic: MS SQL ServerTags: import Excel, openrowset, SQL Server, SQL Views: 15259Comments: 6
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: 15055Comments: 2
MFC Feature Pack for VS 2008 and 2010 DanRollins12/19/2009, 12:00 AM In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008. These same feature are in the MFC libraries that come with Visual Topic: Windows MFC ProgrammingTags: VC++, Visual Studio, MFC Feature Pack, Win7, CMFCMaskedEdit, CMFCMenubar, CMFCButton, CMFCFontComboBox, Tear-off menus, Dan Rollins Views: 14955Comments: 7
3 Ways to Speed Up MySQL gr8gonzo07/27/2009, 12:00 AM There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these 3 ways. Here they are, in order of importance: 1. Optimize queries 2. Tune the MySQL configuration 3. Add more hardware ... Topic: MySQL ServerTags: mysql, database, performance, optimization, indexes, queries, slow, caching Views: 14392Comments: 59
AjaxControlToolkit’ TabContainer control’ Javascript functions. sand198002/25/2010, 12:00 AM In this blog we will start with a common requirement for the tab container control i.e. setting focus to a tab using javascript and later at the end of this blog we will also see some important javascript functions available with ASP.NET AJAX Tab Co Topic: Programming for ASP.NETTags: ASP.NET AJAX, TabConainer, ASP.NET Views: 14324Comments: 0
Function pointers vs. Functors evilrix06/07/2009, 12:00 AM Often, when implementing a feature, you won't know how certain events should be handled at the point where they occur and you'd rather defer to the user of your function or class. For example, a XML parser will extract a tag from the source code, wh Topic: C++ Programming LanguageTags: C++ Views: 14296Comments: 8
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: 13873Comments: 26
Using Regular Expressions in Visual Basic for Applications and Visual Basic 6 matthewspatrick08/17/2009, 12:00 AM Using Regular Expressions in VBA and VB6 Projects By Patrick Matthews (matthewspatrick, ... Topic: Visual Basic ProgrammingTags: Regular Expressions, RegExp, Visual Basic, VB6, VBA, RegExpFind, RegExpReplace, Excel, Access, Office Views: 13660Comments: 51
Getting Flex Builder for Linux working with Eclipse 3.5 Galileo danyul_c07/08/2009, 12:00 AM First things first - Preparation We need all the part for this install and it's much nicer to have them all on hand when you need them so here's what's required. Download Eclipse 3.5 32 bit (I like the Classic flavour) from here. Download Fle Topic: Adobe FlexTags: Flex Builder, Linux, Ubuntu, Eclipse, Jaunty Views: 13381Comments: 1
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: 13304Comments: 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: 12774Comments: 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: 12733Comments: 19
Add a Custom Command Button to the Windows 7 Explorer Toolbar DanRollins12/30/2009, 12:00 AM This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar. In the previous article, we saw how to put the Delete button back there where it belongs. "Delete" is a predefined action, but today, we're going to Topic: Windows ProgrammingTags: Win7, Explorer toolbar, FolderTypes, command bar, custom button, RegEdit, registry, jscript, Dan Rollins Views: 12702Comments: 12
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: 12489Comments: 35
ASP.NET : Mobile Device Detection and Redirection amimpat01/19/2010, 12:00 AM This article explains approaches for ASP.NET mobile development to determine if an HTTP request is coming from a mobile phone and then redirecting the request to a page optimized for a mobile browser. Examples in below article are in c#.net Me Topic: Programming for ASP.NETTags: ASP.NET, Device Detection, Browser Detection, ASP.NET Mobile, Mobile Web Views: 11780Comments: 34
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: 11779Comments: 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: 11770Comments: 34
Use AJAX ModalPopupExtender in GridView or other data controls prairiedog04/08/2009, 12:00 AM AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays, Topic: Programming for ASP.NETTags: ASP.NET, AJAX ModalPopupExtender Views: 11622Comments: 2
Connect by prior ivostoykov02/12/2010, 12:00 AM by Ivo Stoykov One of challenges in data digging is hierarchical data representation. Usually manipulating trees in relational database raises lots of questions and confusions. In following lines I’ll try to scatter the fog around this topic. For Topic: Oracle DatabaseTags: oracle hierarchy query select data parent child Views: 11514Comments: 8
Create a Win7 Maze! Gadget DanRollins11/20/2009, 12:00 AM This article shows a few slightly more advanced techniques for Windows 7 gadget programming, including how to save and restore user settings for your gadget and how to populate the "details" panel that is displayed in the Windows 7 gadget gallery. Topic: Windows ProgrammingTags: Tutorial, sample, Windows 7, sidebar, wrench, settingsUI, onShowSettings, onSettingsClosed, System.Gadget, Dan Rollins Views: 11088Comments: 11
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: 10363Comments: 7
How to make your own Joomla template V4nP3rs1301/07/2010, 12:00 AM Here is a tutorial for making your own Joomla templates. Note before reading, you should have some existing knowledge of web development using HTML and CSS. Design your template in a graphics program like Adobe PhotoShop or Corel Draw for examp Topic: JoomlaTags: joomla, joomla 1.5, template, html, css Views: 10271Comments: 8
Adding an Else to your Switch ValentinoV01/16/2010, 12:00 AM In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack. Those functions are IIF() and Switch(). And I'll be showing you how easy it is to add an Else part to the Switch function. T Topic: MS SQL ReportingTags: Reporting Services, SSRS, IIF, Switch, if, switch else, sql server Views: 10196Comments: 7
Oracle Backup and Recovery: Best Practice #1: RMAN Autobackup mrjoltcola05/24/2009, 12:00 AM If you are an Oracle DBA, and you don't know RMAN, don't bet on being taken seriously in a competitive job market. More importantly, you are making your job more difficult by sheer laziness of learning. Many years have passed since Oracle 8 introduc Topic: Oracle DatabaseTags: rman oracle backup recovery best practices autobackup controlfile parameter mrjoltcola Views: 10056Comments: 5
Create a Win7 Gadget with a Flyout Panel DanRollins11/22/2009, 12:00 AM This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget. The example gadget shows several additional techniques: How to automatically resize a gadget or flyout panel t Topic: Windows ProgrammingTags: Tutorial, Windows 7, gadget, sidebar, flyout, System.Shell, size to content, ActiveX, JavaScript, action verbs, FolderItem, Dan Rollins Views: 9986Comments: 3
Spring Jersey Integration rajkumar_pb04/21/2010, 12:00 AM Hi, I've been learning Spring and Jersey for the past few months and to say in simple, i am pretty much impressed with these frameworks. Many developers feel it awkward to implement a RESTful Web Services with such a popular Web Application Fr Topic: Web FrameworksTags: Spring 3, Jersey Views: 9882Comments: 2
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: 9696Comments: 28
Checking for valid IP addresses using JavaScript Regular Expressions HonorGod06/28/2009, 12:00 AM There are times when an Internet Protocol (IP) address needs to be verified/validated. What are examples of valid IP addresses? 127.0.0.1 1.2.3.4 192.168.1.100 The pattern is that we have 4 integer values (from 0 to 255) separated by period Topic: JavaScriptTags: JavaScript, RegExp, Regular Expression, IP Address Views: 9652Comments: 11
Hide/Show Validator Callout Control Using Javascript sand198004/06/2010, 12:00 AM In this article we will see how to show and hide a ASP.NET AJAX’ (AJAXControlToolkit) ValidatorCalloutExtender control using Javascript. Below is an .aspx page with a validator callout control. <%@ Page Language="C#" AutoEventWireup="true" CodeF Topic: Programming for ASP.NETTags: ASP.NET AJAX, ValidatorCalloutExtender, ASP.NET Views: 9641Comments: 16
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: 9621Comments: 55
Dynamic Pivot Procedure for SQL Server mark_wills05/15/2009, 12:00 AM by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively Topic: SQL Server 2005Tags: SQL2005 sql2008 PIVOT Views: 9543Comments: 16
Create a Win7 DropTarget Gadget DanRollins11/21/2009, 12:00 AM This article shows how to make a Windows 7 gadget that accepts files dropped from the Windows Explorer. It also illustrates how to give your gadget a non-rectangular shape and how to add some nifty visual effects to text displayed in a your gadget. Topic: Windows ProgrammingTags: Windows 7, transparent, drag and drop, target, sidebar, sample, g:background, g:text, System.Shell, ondrop, Dan Rollins Views: 9493Comments: 3
How to FTP with Oracle PL/SQL sdstuber05/09/2010, 12:00 AM Sometimes you need to get data from a server into your database, or from your database into a remote server. There are many ways this can be done such as SOAP or REST web service calls, database links, pipes, or external tools. Another option, Topic: Oracle DatabaseTags: Oracle, FTP, PL/SQL Views: 9409Comments: 33
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: 8990Comments: 20
POSIX Threads Programming in C++ w00te03/05/2010, 12:00 AM Written by John Humphreys C++ Threading and the POSIX Library This article will cover the basic information that you need to know in order to make use of the POSIX threading library available for C and C++ on UNIX and most Linux systems. Be Topic: C++ Programming LanguageTags: C++, C, POSIX, Threads, Linux, pthread_create, pthread.h Views: 8947Comments: 12
PHP - Prevent SQL Injection abolinhas05/26/2009, 12:00 AM SQL injection vulnerabilities have been described as one of the most serious threats for Web applications. Web applications that are vulnerable to SQL injection may allow an attacker to gain complete access to their underlying databases. Because Topic: PHP and DatabasesTags: php, mysql Views: 8940Comments: 14
ERROR: "Acrobat Failed to connect to a DDE server" bhwithun01/07/2011, 12:00 AM Can Be Caused By Disabled Services I have encountered a problem viewing PDF files using Adobe Acrobat Reader. For the longest time, PDFs might launch or might not. Sometimes they took about 15 minutes to appear after launching them. After som Topic: Adobe AcrobatTags: adobe acrobat, acrobat, DDE, error Views: 8884Comments: 2
PHP Client Registration, Login, Logout and Easy Access Control Ray_Paseur02/03/2010, 12:00 AM Introduction A frequent design pattern question for new PHP developers goes something like this, "How do I handle client registration and login?" It's done in every framework and CMS, and all of them use a similar pattern. This article builds the Topic: PHP Scripting LanguageTags: login, client validation, session, cookie, password Views: 8720Comments: 47
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: 8584Comments: 42
Chart Optimization Tips ValentinoV09/26/2009, 12:00 AM Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services. These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to Topic: MS SQL ReportingTags: SQL Server Reporting Services 2008, chart, SSRS, Reporting Services Views: 8557Comments: 14
Building Android app with NDK - integrated in Eclipse with CDT alexcohn11/16/2010, 12:00 AM Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project automates most of the tasks discussed in this article. You can even find instructions for debugging your n Topic: EclipseTags: Android NDK, Eclipse Views: 8500Comments: 5
Mouse Wheel Programming in JavaScript DanRollins01/16/2010, 12:00 AM In this article I'll describe cross-browser techniques for using the mouse wheel (or "scroll wheel") in your JavaScript programming for HTML pages. I'll show example Javascript for option selection and image zooming. The mouse wheel is generally Topic: JavaScriptTags: mousewheel, scroll wheel, DOMMouseScroll, onmousewheel, pentominos, wheelDelta, Dan Rollins Views: 8236Comments: 9
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: 8115Comments: 7
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: 8111Comments: 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: 8086Comments: 56
Convert String to int / Convert int to String in C++ DanRollins09/17/2009, 12:00 AM This EE article provides examples of conversion techniques for various types of string variables: classic C-style strings, MFC/ATL CStrings, and STL's std::string data type. Convert Integer to String int to C-style (NULL-terminated char) string Topic: C++ Programming LanguageTags: atoi, sprintf, itoa, convert integer to string, convert string to integer, std::string, ostreamstring, atoi_s, sprintf_s, Dan Rollins Views: 8077Comments: 12
Building a Formless WinForms Application with a NotifyIcon in VB.Net 2008 Idle_Mind03/24/2010, 12:00 AM This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru Topic: Microsoft Visual Basic.NetTags: ApplicationContext, NotifyIcon, WinForms, Visual Basic.Net Views: 8028Comments: 20
Working with Modal Popup extender control. sand198008/08/2010, 12:00 AM This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal Topic: Programming for ASP.NETTags: ASP.NET, ASP.NET AJAX, Modal Popup Extender Views: 8025Comments: 24
Adding Split MySQL database read/write capibilities to Drupal 5 mwecomputers11/20/2008, 12:00 AM Drupal 5.x currently does not have a production-ready patch bundle to allow for split read & writes for a MySQL master/slave replication setup. After reading a open discussion/thread on the Drupal site (http://drupal.org/node/147160) and a doing a b Topic: Web-Based CMSTags: drupal, mysql, replication Views: 8015Comments: 1
Trimming strings in Javascript quincydude11/20/2008, 12:00 AM User input plays a big role on webpages. It acts as an interface between users and the server. Handling user inputs is important as we need to ensure what data can be sent to the server and we cannot expect what the user will send. One of the most c Topic: JavaScriptTags: Trimming, trim, strings, Javascript Views: 7972Comments: 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: 7907Comments: 21
Custom File Filtering Using Java File Choosers mwvisa112/16/2008, 12:00 AM INTRODUCTION Working with files is a moderately common task in Java. For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient. However, when your application has vi Topic: Java Programming LanguageTags: Java, javax.swing.JFileChooser, javax.swing.filechooser.FileFilter, Nested Anonymous Class, Inheritance, Custom File Filtering, Open File Dialog, Save File Dialog, File Choosers Views: 7874Comments: 8
Decoding the Oracle ROWID (and some Base64 for fun) mrjoltcola06/13/2009, 12:00 AM Most Oracle programmers have heard of ROWIDs. Many have even used ROWIDs at some point. A few even have an idea of what the ROWID is, logically, but only a very select few actually know the details. It is sufficient to know that the ROWID exists and Topic: Oracle DatabaseTags: oracle dba rowid base64 dbms_rowid utl_encode base64_decode block mrjoltcola Views: 7831Comments: 22
Client side input validation with Javascript quincydude11/20/2008, 12:00 AM Html Form is the main way for users to interact with server side. It can bring a lot of functionalities to web sites such as searching, data storing and different kinds of calculations. However, page involving user inputs also implies users can do s Topic: JavaScriptTags: Client side, validation, Javascript, form Views: 7738Comments: 2
Setting up IIS7.5 in Windows 7 to run Classic ASP Web Sites carrzkiss09/21/2010, 12:00 AM Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t Topic: Active Server Pages (ASP)Tags: IIS, Windows 7, Classic ASP, IIS7.5, Windows 7 Classic ASP, IIS7 Classic ASP Views: 7705Comments: 19
Radio Buttons in MFC Dialogs DanRollins09/12/2009, 12:00 AM Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms. Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go. MFC has a very cool system for handli Topic: Windows MFC ProgrammingTags: MFC, DDX_Radio, C++, DoDataExchange, RadioButton group, enabling dilaog items, Dan Rollins Views: 7680Comments: 1
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: 7662Comments: 22
HTA - Hypertext Application tutorial DanRollins06/27/2009, 12:00 AM Use HTAs for rapid testing, early development, and in-house deployment. This article describes how to create an HTA (Hypertext Application). To illustrate a common scenario, we will open an ADO recordset and display some of it in an HTML table - Topic: Miscellaneous Web DevelopmentTags: HTA, ActiveXObject, ADO, WScript, WshShell, MSHTA, SQL, script, JavaScript Views: 7624Comments: 9
How to make the Lotus Notes 8.x Standard client run faster. jvutechnc01/11/2010, 12:00 AM For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster. I've had to exercise t Topic: Lotus NotesTags: lotus notes, notes eclipse Views: 7606Comments: 10
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: 7531Comments: 100
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error aelliso307/07/2010, 12:00 AM Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t Topic: MS SQL ReportingTags: SSRS 2008 SQL Server R2 User Access Control UAC Permission Error Views: 7503Comments: 6
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: 7482Comments: 34
Handling Date and Time in PHP and MySQL Ray_Paseur11/20/2008, 12:00 AM The DATETIME Tower of Babel Human beings can read dates and times in a variety of ways. We readily understand such things as September 5th, 2010, and we know that it comes before November 11th, 2010,and after May 9th, 2010. We have shorthand conv Topic: PHP Scripting LanguageTags: PHP, MySQL, date, time, mktime, strtotime Views: 7361Comments: 49
Output an XML type attribute using DataContract williamcampbell08/31/2009, 12:00 AM This tutorial will show you how to add an attribute to an XML stream returned from a Windows Communication Foundation (WCF) Web Service. Some knowledge of WCF and XML is required; the code is in C#. Below is an XML sample of an attributed XML stre Topic: Web Services and WCFTags: DataContract Attribute, XML, C#, WCF Views: 7340Comments: 39
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: 6989Comments: 8
20 Tips to Optimize your ActionScript moagrius12/15/2009, 12:00 AM Introduction This article is primarily concerned with ActionScript 3 and generally specific to AVM2. Most suggestions would apply to ActionScript 2 as well, and I've noted those tips that differ between AS2 and AS3. With the advent of ActionS Topic: ActionScriptTags: AS, ActionScript, AS3, Optimization, Performance Views: 6976Comments: 18
Advanced Object-Oriented Programming in PHP gr8gonzo03/08/2010, 12:00 AM This article is intended to cover some of the more advanced topics of object-oriented programming (OOP) in PHP, and is intended to follow up on my previous article covering the basics of OOP in PHP. Specifically, this article will teach you all abou Topic: PHP Scripting LanguageTags: object-oriented programming, OOP, PHP, get, set, accessors, mutators, interface, extending, classes Views: 6917Comments: 10
Subquery Factoring WITH Oracle ivostoykov02/02/2010, 12:00 AM WITH Clause OR Subquery Factoring WITH Oracle by Ivo Stoykov Digging information from a database sometimes requires creating complicated queries. Often a simple select * from . . . is nested into another one and both into another one and so Topic: Oracle DatabaseTags: WITH Clause Factoring Oracle Views: 6874Comments: 2
PIVOT Transformation - SSIS - Complete Tutorial reza_rad02/15/2010, 12:00 AM Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft : Mi Topic: SSISTags: PIVOT, PIVOT Transformation, SSIS, Tutorial Views: 6844Comments: 9
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: 6827Comments: 27
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: 6813Comments: 29
Scrollable fixed size table cell with CSS quincydude11/20/2008, 12:00 AM Table is a very common element used in web design. It can bring neat and tidy designs to web pages. As dynamic web pages(php, jsp, etc) are now very popular for web building, a lot of web designs involves filling up dynamic content into table cells Topic: Cascading Style Sheets (CSS)Tags: Scrollable, fixed size, table cell, CSS, html Views: 6803Comments: 1
Delimited String Parsing in SQL Server 2005 and later BrandonGalderisi11/20/2008, 12:00 AM This article will describe one method to parse a delimited string into a table of data. Why would I do that you ask? Let's say that you need to pass multiple parameters into a stored procedure to search for. For our sake, we'll say that we wa Topic: SQL Server 2005Tags: parse, string parsing, delimited string, user defined function, sql server 2005, sql server 2008 Views: 6744Comments: 8
Closures in Java 7 - does a new era start for the language? Venabili03/18/2010, 12:00 AM Java had always been an easily readable and understandable language. Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde Topic: Java Programming LanguageTags: java 7, closures Views: 6723Comments: 20
File permissions with Java Venabili09/10/2009, 12:00 AM Java has always been considered a multi-platform language - you write your code once and then you use it on almost any Operating System. Unfortunately for most Java developers, this is often taken quite literally from anyone that had no knowledge of Topic: Java Programming LanguageTags: Java, Permissions, Unix Views: 6718Comments: 10
How to Succeed in ... Anything ericpete10/07/2009, 12:00 AM This article originally appeared in the Experts Exchange Newsletter, and is republished here by request. It never ceases to amaze me the lengths to which people will go. I've been a member of the workforce since I was about 12. I didn't have t Topic: Project ManagementTags: management, personnel Views: 6587Comments: 37
How to use Access Control Lists in Oracle sdstuber10/28/2011, 12:00 AM Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth Topic: Oracle DatabaseTags: Oracle, ORA-24247, ACL DBMS_NETWORK_ACL_ADMIN Views: 6565Comments: 9
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: 6501Comments: 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: 6437Comments: 6
Advanced DOS batch pitfalls Qlemo05/21/2009, 12:00 AM The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some Topic: Windows Batch ScriptingTags: DOS, batch, inconsistency, file redirection, delayed expansion Views: 6365Comments: 20
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: 6365Comments: 23
DNS Troubleshooting made easy ChiefIT11/30/2008, 12:00 AM Most DNS problems are VERY easily troubleshot and identifiable if you can follow the steps a DNS query takes. I would like to share the step-by-step a DNS query takes from the origin to the destination. ... Topic: Domain Name Service (DNS)Tags: DNS troubleshooting Views: 6344Comments: 10
SARGable functions in SQL Server rob_farley02/24/2010, 12:00 AM This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou Topic: SQL Server 2008Tags: SQL Server, Indexing Views: 6340Comments: 6
Encryption - Decryption in SQL Server 2008 and backup database with encrypted data and restore it somewhere else. RiteshShah02/04/2010, 12:00 AM Long way back, we had to take help from third party tools in order to encrypt and decrypt data. Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, Topic: SQL Server 2008Tags: Encryption, decryption, backup database, restore database, certificate, symmetric key Views: 6319Comments: 13
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: 6302Comments: 10
Separating C++ template declaration and implementation evilrix07/18/2009, 12:00 AM The following question was the inspiration for this short article:"Splitting a template and class into definition and declaration.". In this question the asker asks, "I have the code below, which is all well and good but I'd like to move the definit Topic: C++ Programming LanguageTags: c++ templates Views: 6300Comments: 8

Top Articles

Top Developer Experts