comment and share: how to easily sum values by a cell's background color in excel by susan harkins susan sales harkins is an it consultant, specializing in desktop solutions.
which is best for you: datareader or dataset? an activex data object ado recordset was the option commonly used to hold query results and data contents. a dataset can contain one
more. security simplify admin tasks by exporting active directory data with csvde. csv is often a good file format to use when extracting seven trust data as a majority of applications
editor's note: in the video, brandon vigliarolo walks you through the steps of transferring data from word forms to an excel worksheet in microsoft office 365. disclosure: techrepublic
how to create a list of tables or queries from access. then you might as well use the database object and access its tabledef and querydef collections. one more reason that the
susan sales harkins shows you how to use a word form to collect data and then transfer that data to an access table. the technique requires an access database, a word form, and a bit of
five tips for writing better vba code. variants consume more storage than data types that are more specific. variants don't reject invalid data there is no such thing to a
here's how to use it to make data analysis easier. the model works behind the scenes and simplifies pivottable objects and other reporting features. or more sets of data
scott lowe shares a powershell script he wrote to extract a number of fields from active directory and write the extracted information into a csv file.
picking up the pieces: recovering corrupt access databases by luke mason in data management on april 3, 2002, 12:00 am pst learn how to salvage data from a corrupt access database
as more and more web sites begin using xml for their content, it's increasingly important for web developers to know how to parse xml data and convert it into different formats .
17 useful functions for manipulating arrays in php. this function selects one or more random elements from an array. use this function when you need to randomly select from a
see the example application for more detail on this type of usage. to have a basic understanding of how to use reflection on an object. use the advantages of custom attributes in
exporting access schema using xml. applications often act more like squabbling children than professional tools of the trade. sometimes the solution is to find a third application
when you need to see the last value in an excel table or data range, these formulas will get the job done. this walk through details the necessary formulas and some vba code that performs
important note: if you need to enter more than a handful of forms a day, you should consider using ado activex data object to create a code connection to the table that will automate the
to learn more about excel table objects, read 10 reasons to use excel's table object. comment and share: how to create two advanced dynamic lists in excel by susan harkins.
resize and reposition the list object figure j . let's try one more smartart list; this time, let's use a horizontal list with pictures. to create the slide shown in figure l,
hide objects. group objects you use more frequently than others. two creative ways to use word watermarks techrepublic editor's picks. the internet of wild things: technology and
obtaining user object information via active directory users and computers is fine for the one time use, but it falls short for batch tasks. two powershell scripts for retrieving user
effectively filter cisco router command output by david davis ccie in networking on august 25, 2005, 12:00 am pst locating the right piece of information from a cisco router can often be a
python vs. r is a common debate among data scientists, as both s are useful for data work and among the most frequently mentioned skills in job postings for data science positions .
understanding ram versus hard drive space via an analogy. the system will make more use of virtual memory to free up the work space and allow other applications to open and load more