Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Create a custom letterhead template in Word
- Printing your own stationery can save you significant bucks -- you can print on an as-needed basis and make changes whenever you want without incurring any charges. Here's what you need to know about using Word to set up a letterhead template. by Susan Harkins
- Tags: Page, Margin, Template, AutoShape, Susan Sales Harkins, Document Management, Microsoft Word, Word Processors, Printers, Microsoft Office, Enterprise Software, Software, Finance, Managerial Accounting, Office Suites, Hardware, Peripherals, Susan Harkins
- Blog posts 2008-07-30
- How do I... Reseed a SQL Server identity column?
- Microsoft SQL Server’s identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works. by Susan Harkins
- Tags: Microsoft SQL Server, Server, Column, Value, Identity, Table, Identity Column, Seed Value, Term Seed, TRUNCATE TABLE, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-07-15
- 10 ways to prevent Access database corruption
- By Susan Sales Harkins and Gustav Brock Nothing frustrates the full spectrum of Access users -- from casual user to developer -- quite like a corrupted database. With a little know-how, you might get lucky enough to repair the database or at least recover the data. Sometimes,...
- Tags: Microsoft Access, Workstation, Network, Data, Susan Sales Harkins, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-04-01
- How do I... Display multiple values in an Access value list control?
- The title's a mouthful, but don't get too hung up on the terminology. The technique is simple, although not commonly implemented. You can populate a Microsoft Access list control with an explicit list of values and generally that list consists of one column, although you can display more. Creating a...
- Tags: Technique, Data Source, Microsoft Access, Property, Column, Difference, Form, Title, GetString Method, Susan Sales Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-01-23
- How do I... Reject alpha characters in a SQL Server character column?
- Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analysis and reports. It only takes one piece of bad data to throw everything off. Susan Sales...
- Tags: Microsoft SQL Server, Server, Susan Harkins, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management
- Download resources 2008-01-25
- Add a looping introduction to a PowerPoint presentation
- You can set up your slide shows to include a little preview presentation that will help prime your audience for the main event. Susan Harkins shows this simple but highly effective technique. by Susan Harkins
- Tags: Slide, Microsoft PowerPoint, Button, PowerPoint Presentation, Presentation, Susan Harkins, Susan Sales Harkins, Microsoft Office, Office Suites, Software
- Blog posts 2008-11-24
- How to log errors in Microsoft Access
- If you Google "error logging in Microsoft Access," you'll find a number of complex solutions. But the process doesn't have to be that difficult. Most of us need only a simple function to log specific information about the current error. by Susan Harkins
- Tags: Microsoft Access, Microsoft Corp., Error, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins, Function, Code, ErrDate, UsrName, ErrNumber, ErrDescription, ErrModule, ActiveX Data Object Recordset, Debug.Print, Susan Sales Harkins, Storage, Programming Languages, Hardware, Software Development, Software/Web Development
- Blog posts 2008-10-31
- How to list the primary key columns in an Access table
- You can get a list of the columns in a primary key manually, but depending on the task at hand, you may want to handle it programmatically instead. Susan Harkins shares a VBA function that uses ADOX objects to obtain the column information. by Susan Harkins
- Tags: Microsoft Access, Column, Susan Harkins, Scripting Languages, Microsoft Office, Databases, Software/Web Development, Web Development, Office Suites, Software, Enterprise Software, Data Management, Key, ADOX, Susan Sales Harkins, Storage, Hardware
- Blog posts 2008-10-28
- Quickly export Outlook e-mail items to Excel
- Exporting e-mail messages from Outlook to Excel is easier than you might think. This sample VBA code automates the process, allowing you to specify exactly which fields to copy. by Susan Harkins
- Tags: Outlook E-mail, Microsoft Outlook, Microsoft Excel, E-mail, Microsoft Office, Groupware, Office Suites, Software, Online Communications, Enterprise Software, Susan Harkins, MsgBox, Sample Code, Code, Error, vbOKOnly, Set, intColumnCounter, Susan Sales Harkins
- Blog posts 2008-10-20
- Generate a descending-order numbered list in Word
- Word can't automatically produce a numbered list that counts down instead of up. But with the help of a bookmark and some fields, you can work around that limitation. by Susan Harkins
- Tags: Item, Field, List, Value, Numbered List, SEQ, Insert, F9, Susan Sales Harkins, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-09-25
- Keep supporting details handy for your PowerPoint presentations
- When someone raises a question during your presentation, you can try to wing it -- or you can smoothly bring up an ancillary slide that clarifies the issue. Having a few extra slides up your sleeve can make all the difference in the success of your delivery. by Susan Harkins
- Tags: Slide, Microsoft PowerPoint, PowerPoint Presentation, Presentation, Hyperlink, Default Button, Susan Sales Harkins, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-08-29
- Return to the record you were working on when you reopen an Access form
- If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight to it when you reopen the form. by Susan Harkins
- Tags: Microsoft Access, Command Button, Record, Form, varID, OrderID, vbOKOnly, Sub, Susan Sales Harkins, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware, Susan Harkins
- Blog posts 2008-08-28
- 10+ tips for getting the best performance out of your SQL Server data types
- Using the right data type can go along way toward minimizing problems and optimizing performance. Susan Harkins offers these practical tips to help you avoid getting bogged down by inappropriate data types. by Susan Harkins
- Tags: Performance, Microsoft SQL Server, Server, Column, Data Type, Susan Harkins, NULL, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management
- Blog posts 2008-07-10
- How do I... Add music and narration to a PowerPoint presentation?
- The best presentations engage the audience using a number of creative tools. Sound effects, such as music and voice recordings can mean the difference between a good presentation and an outstanding presentation. PowerPoint supports media clips, which include sound and video files. Susan Sales Harkins explains how to use sound...
- Tags: Microsoft PowerPoint, PowerPoint Presentation, Music, Presentation, Susan Harkins, Susan Sales Harkins, Corporate Communications, Microsoft Office, Marketing, Office Suites, Software
- Download resources 2008-03-04
- Consultant encourages other women in IT to explore their options
- The number of women in IT is shrinking and some see that as a problem. Susan Sales Harkins sees something different -- she sees opportunity. by Susan Harkins
- Tags: Consultant, Women, Information Technology, Susan Sales Harkins, Gender And Diversity, Human Resources, Susan Harkins
- Blog posts 2009-03-09
Additional Resources
- How do I... Share a PowerPoint presentation for comments and changes?
- Most of us don't have the creative expertise to put together a professional presentation without a little help. In fact, many people within your organization may view your presentation before it gets a final stamp of approval. You could meet with colleagues in a conference room so everyone can comment...
- Tags: Author, Microsoft PowerPoint, PowerPoint Presentation, News, Presentation, Send, Review, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-02-27
- How do I... Fill a Word table with Access data?
- Almost effortless collaboration is a key selling point for Microsoft Office: If the data already exists in one format, why re-enter it in another. Usually Office delivers nicely on its promise. Word is troublesome, however, because it doesn't offer an import feature. Using the File Open feature, you can specify...
- Tags: Microsoft Access, Data, Table, Clipboard, Clipboard Method, Figure C, Figure D Use Word, Figure G, Figure H, Microsoft Word, Word Processors, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-03-31
- Remove field codes from Word documents with this handy macro
- This article is also available as a PDF download.By Susan SalesHarkins and Bryan CarbonnelleWord offers a number of useful features for managing largedocuments. For instance, you can mark specific words and phrases, which Wordthen uses to generate a table of contents, a table of authorities, a table offigures, and even...
- Tags: Word processors, Microsoft Word, table of content
- Technical articles 2007-03-27
- How do I... return a unique list in Excel?
- This information is also available as a PDF download.Lists work their way into just about everything we do. Ordinarily, you might not think of worksheet data as a list, but that data can quickly turn into one, depending on your needs. That need becomes a bit more complicated if you...
- Tags: Data, Microsoft Excel, List, Cell, Susan Harkins
- Blog posts 2007-08-06
- How do I... Export e-mail messages to Access using VBA?
- Exporting Outlook folders and their contents is a common and simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard is a one-time deal. You can't append records to an existing file using the...
- Tags: Folder, Data Source, Database, Microsoft Outlook, Microsoft Access, Microsoft VBA, E-mail Message, Wizard, Figure B, E-mail, Microsoft Office, Databases, Storage, Online Communications, Office Suites, Software, Enterprise Software, Data Management, Hardware, Susan Harkins
- Blog posts 2007-08-20
- << Previous
- page 1 of 1
- Next >>
Introducing SmartPlanet
-
-
Find thought-provoking progressive ideas on topics that intersect with technology, business and life.
Visit Today
-
-
Technology, perspective, and insights shaping the world
-
Learn innovative and practical skills for your business and your life. SmartPlanet offers 360 degree coverage that you need to feel connected to the information that matters to the world at large.
Go to SmartPlanet
