New Know-How for Subscribers
Top 15 for 2009 Week 27
ADVISOR TIPSUse FOXOBJECT to avoid problems with collections.By Mike Lewis, contributing editorMICROSOFT SHAREPOINT ADMINISTRATIONHere’s a script that will ensure that all the collections on your SharePoint site are backed up.REPORTINGHelp business users find report items quickly by displaying a guide to the items at the top or bottom of each page.By Susan Sales HarkinsADVISOR ANSWERSFind out why Access won't execute a statement attached to a button on a form.By Mike Groh, technical editorADVISOR TIPSVFP’s BETWEEN() function is useful for checking to see if a date lies within a given range, but it doesn't handle empty dates very well.Martin GriffinMICROSOFT ACCESS DEVELOPMENTYou can use Access' inline functions to manipulate and extract pieces of data from text fields in order to perform operations (such as sorting) on a part of the data instead of the entire field.By Joe StockmanADVISOR TIPSHere's how to make sure the build number is always up to date.By Rick SchummerADVISOR ANSWERSHere's how to add code to flip an image.By Ken Getz, technical editorADVISOR ANSWERSIn this tip, and the following series of tips, you'll learn how to create your own application that lets users rotate and flip images. The first step? Creating an application that displays images.By Ken Getz, technical editorADVISOR ANSWERSThis task isn't hard to figure out in VB6, but what if you need code for use in both Visual Basic 2005 and in C#?By Ken Getz, technical editorWEB DEVELOPMENTFlexibly store configuration settings for ASP.NET applications.By Mike Groh, VB.NET Advisor Journal, technical editorSECURITYGuarantee the authenticity of a file with digital signatures.By Mike Groh, Advisor technical editorWEB DEVELOPMENTIf you're not happy with the way an ASP.NET WebForm control works, write your own! Here's how.By Peter VogelMICROSOFT ACCESS DEVELOPMENTHave you ever wished VBA had a good way to do a quick byte array from a string with no delimiter?By Ken Getz, technical editorADVISOR ANSWERSHere's how to display the list of enumerated values, let the user choose one, and then apply the value to the corresponding property.By Ken Getz, technical editor
ADVISOR ANSWERSHere's how to single step through a service’s OnStart method, so you can see what’s going on as the service starts up.ADVISOR TIPSExplore content types, a new construct in WSS 3.0 and MOSS 2007.By Dana McCarthy, Brookhill, KansasVERSION CONTROLWhen your program stops working, you need to know what you've changed. Here's a utility that will let you quickly compare the old and new versions of your code—or any text file—to find out what's different.By Tom AnselmoMICROSOFT ACCESS DEVELOPMENTHere's how to put all the information you need into a single string -- and still be able to retrieve a single piece of data from that string.OBJECT-ORIENTED PROGRAMMINGUnderstand the implications of using inheritance when designing classes.By Andy Kramek and Marcia AkinsADVISOR ANSWERSIf you work with controls for long, sooner or later, you'll want to create a new property for a control. Unfortunately, in VBA, you're limited to exactly the control behavior that the original programmers provided.By Ken Getz, technical editor
QUERIESHere's a technique to get it done right.By Michel BrunetADVISOR ANSWERSWhen you need to have several forms appear together, is it better to use individual forms or a formset?By Tamar E. Granor, technical editorADVISOR ANSWERSHave you ever tried to retrieve just the list of Internet Cookies from your Temporary Internet Files folder? Do you know you cando this from .NET?VBA PROGRAMMINGYou can take full control of your user's keyboard settings with these API calls.By Ken Getz, technical editorADVISOR ANSWERSGet help with editing those grids when it comes to data entryBy Pamela ThalackerADVISOR ANSWERSHow can you change the spacing between rows on a report? Find out here.By Mike Groh, technical editorADVISOR ANSWERSIn this tip, and the following series of tips, you'll learn how to create your own application that lets users rotate and flip images. The first step? Creating an application that displays images.By Ken Getz, technical editor |
ADVISOR TIPSHere's how to create a custom exception class that inherits from System.ApplicationException (or System.Exception), and add custom properties as necessary.ADVISOR TIPSHere's how to earmark specific slides that you want to hide.By Ken Getz, technical editorPROGRAMMINGIf you aren't ready for for Microsoft Windows Communication Foundation (WCF) or aren’t upgrading to Visual Studio 2008, you can still write applications which are transport neutral -- where the same code will work across local, Web service, and remoting calls -- using Visual Studio 2005 and ASP.NET 2.0.By Kevin RattanMICROSOFT VISUAL FOXPROIs it poor coding practice to use DECLARE commands to call Windows API functions?By Mike Lewis, contributing editorWEB DEVELOPMENTSee how the DOM model makes it very easy to work with images and hyperlinks on Web pages.By Doug SteeleMICROSOFT SHAREPOINTSee how to use SharePoint to build a Web site that will let you share project documents, schedules, and communications.By Gord MaricADVISOR EXPERIENCEIf you're looking for a licensing solution for your own app, this article helps guide the way.By Doug Den HoedADVISOR TIPSHere's how to display a list of colors on an ASP.NET page, without having to loop through all the members manually.By Ken Getz, technical editorDATABASE DEVELOPMENTMake sure that your users know which row is the current row in a continuous form by highlighting it—and use practically no code.By Christopher WeberADVISOR ANSWERSLike everything else, there are a number of ways to accomplish this task.By Richard Campbell and Mike Groh, technical editorsMICROSOFT ACCESS DEVELOPMENTHere's an easy way to hide or show a checkbox's controls.By Ken Getz, technical editorINTEGRATIONLearn how to get and show Excel data using Web services and VSTO.By Marc Gusmano, IMG director of emerging technologiesADVISOR TIPSHere's how to set up an Access database in a multi-user environment and have a front end on each client.By Ken Getz, technical editorCOLLABORATIONIf you think wikis and blogs are just for fun, think again.By Robert BoguePROGRAMMINGHere's how to make sure your sorts are speedy.By Ken Getz, technical editorPROGRAMMINGBuild on what you've learned about the QuickSort algorithm to sort more complex arrays.By Ken Getz, technical editorADVISOR ANSWERSGet a solution to this common problem that's built right into Windows.By Christof Wollenhaupt, contributing editorUSER INTERFACEWhen the field description isn’t adequate, usurp it with a query.By Susan Sales HarkinsPROGRAMMINGGet to know the Quicksort algorithm.By Ken Getz, technical editorDEVELOPMENTLearn the different techniques for activating Features when you're upgrading, creating a new site, and toggling Features on existing sites.By Chris Fields |
= free access
= subscriber-only
= not online (on CD or in print)
= has download
RSS FEEDS
