Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Make data entry in Access easier by changing text boxes to combo boxes
- Lookup WizardAlthough the solution presented is serviceable, it would force you to do those same steps on each foreign key you place on each form you build.A more elegant solution would be to open the table in Design View, and use the Lookup Wizard on each foreign key field (RepID...
- Tags: combo box, Lookup Wizard, Microsoft Access, ttrollen@..., data entry, RepID, foreign key, software, database, msaccess
- Discussion threads 2007-03-07
Additional Resources
- What's your favorite free newsletter?
- The Web can provide plenty of free information, but it's often difficult to weed through all of the advertising and junk offerings. Three members have weighed in with their favorite free newsletters. Now it's your turn.When our IT Consultant community shared theirideas for keeping skills current, one of the most...
- Tags: Corporate communications, Strategy, Beth Blakely, newsletter
- Technical articles 2001-11-12
- I made a bad hire and lived to tell about it
- In our IT Manager Republic Net Note, I recently asked whether any IT managers had experienced any hiring nightmares when staffing their IT organizations.As a former manager myself, I knew the question would strike a nerve. Even after you extricate yourself from the mess caused by a poor hire, the...
- Tags: job, programming, Toni Bowers
- Technical articles 2003-03-19
- An unconventional way to comment your Excel formulas
- Excel provides a number of ways to add special comments or notes to your spreadsheets. Here's a trick that lets you add comments at the formula level.When you distribute “soft” or electronic copies of your Excel spreadsheets, you can’t assume everyone who reviews your data will understand how you arrived...
- Tags: Microsoft Office, Jeff Davis, Microsoft Excel, cell
- Technical articles 2001-03-21
- Add watermarks to your Excel printouts
- How do you underscore the private nature of your Excel printouts? Try adding your company's name or a phrase like Company Confidential as a watermark in the background.Have you ever needed to print a watermark graphic behind the data in your Excel printouts? One way to underscore the private nature...
- Tags: Microsoft Office, Figure C Here, Jeff Davis, watermark, Insert WordArt, Drawing, Microsoft Excel
- Technical articles 2001-02-14
- Enhance your Excel charts with custom backgrounds
- You don't have to settle for those boring default chart styles. Use this tip to make your graphs stand out.Excel’s Chart Wizard makes it easy to create and format charts and graphs. By default, however, those charts aren’t too visually exciting. Fortunately, Excel’s Drawing toolbar makes it easy to customize...
- Tags: Figure D Here, Jeff Davis, Drawing, toolbar, Drawing toolbar, Microsoft Excel
- Technical articles 2001-02-21
- Breaking Excel's three-column sort barrier
- Who says Excel can't sort on more than three columns at a time? Here's a tip that lets you sort data on as many columns as you need.Excel’s built-in sorting options let you sort rows of data based on the values in as many as three columns. You just go...
- Tags: Microsoft Office, Jeff Davis, Figure B Here, barrier, Microsoft Excel, custom
- Technical articles 2001-03-07
- Debugging Excel formulas one cell at a time
- If a formula refers to cells throughout your spreadsheet, double-checking each cell can be a slow, tedious process—unless you know this trick.In his article “Use these handy tips to debug your Excel formulas,” Bob Johnson presents some invaluable lessons on using [F9] to troubleshoot spreadsheet problems, in addition to some...
- Tags: Jeff Davis, cell, Microsoft Excel, Ctrl
- Technical articles 2001-03-28
- Assessing the almighty ASP
- Are you considering contracting with an application service provider? The industry changes daily, it seems, so how do you keep up? Check out our ASP Informer TechMail. It tells you all you need to know, and it's delivered right to your inbox.The application service provider ASP industry is going through...
- Tags: Application service providers (ASPs), Web hosting, Business services, TechRepublic Staff, application service provider, service provider, Microsoft ASP
- Technical articles 2001-02-22
- Two tips for filling in holes in your Excel data
- Are you or your users wasting time manually filling in blanks in your Excel sheets? If so, here's a shortcut that's guaranteed to save time.How do you deal with blank cells in the middle of your Excel data? If your first thought is, “I manually copy or type something into...
- Tags: Figure C Here, Jeff Davis, blank cell, cell, Microsoft Excel
- Technical articles 2001-03-14
- Offer your expertise through EXP.com
- Looking for a place to prove your IT expertise and solicit new clients at the same time? Try EXP.com, an online service where you can do everything from answer simple questions to lead complex projects.Drew Connelley has a five-star rating. He’s a networking expert for a major consulting firm based...
- Tags: Channel management, Thomas Pack, Exp.com
- Technical articles 2001-02-19
- Put your Excel data on the map
- Does your company do business in more than one state or country? If so, here's an Excel tip that makes it easy to display important data organized by location.Every self-respecting Excel user knows how to create graphs and charts. You enter some data, click the Chart Wizard icon, and you...
- Tags: Microsoft Office, Jeff Davis, Microsoft Excel, Figure C Here, Microsoft Map, abbreviation
- Technical articles 2001-01-30
- Enter Excel functions visually
- If you support Excel users who suffer from function-phobia, here's a lesson that's guaranteed to provide a cure.If you support or teach Excel users, you know that one of the most difficult skills for a beginner to master is how to use functions. Of course, the Standard toolbar’s AutoSum button...
- Tags: Microsoft Office, Jeff Davis, Microsoft Excel
- Technical articles 2001-02-07
- Teen techies chuck college for jobs
- While most IT experts agree that a college degree is important, some teens are choosing higher salaries over higher education. In this week's Tech Watch, Bob Weinstein shares the success story of one IT whiz who skipped college and didn't regret it.Kit Mobley is only 20 years old, and he’s...
- Tags: Web site development, Channel management, Web technology, PRODUCTIVITY, Strategy, Scripting languages, job, Bob Weinstein, Kit Mobley, Web, information technology, Web site
- Technical articles 2001-02-21
- Members provide recommendations for secure OSs
- The results of a recent poll showed that many of our members recommend Microsoft Windows to security-conscious clients, but a flurry of e-mails suggests that others have very different opinions. Find out what they recommend and why.No matter which operating system OS you recommend, your top criterion is likely to...
- Tags: Operating systems, OPEN SOURCE, UNIX, Beth Blakely, Debian, Murray Webber, operating system, security, Linux, Microsoft Corp., Microsoft Windows
- Technical articles 2002-06-14
- Get answers to several Excel questions from the Help Desk Advisor inbox
- TechRepublic contributor Jeff Davis answers Excel questions sent to the Help Desk Advisor inbox. He provides tips on such areas as mail merging and data validation.One of the most enjoyable fringe benefits of writing a column for TechRepublic is receiving e-mail from Help Desk Advisor readers and subscribers to the...
- Tags: Microsoft Office, Word processors, Jeff Davis, Microsoft Excel, B14, Microsoft Word, data source, C14, help desk, mail merge, merge
- Technical articles 2002-10-08
- << Previous
- page 1 of 1
- Next >>
