[TechRepublic] Automatically fill in Access text boxes based on a combo box selection

May 20, 2009

TechRepublic Microsoft Office Suite Trouble viewing this mail? Read it online | Manage my newsletters Welcome: TechRepublic Member Update my profile | Unsubscribe from this mail Blogs | Photos | Downloads | Forums Automatically fill in Access text boxes based on a combo box selection You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user chooses that person's last name from a list. SponsoredBusiness Brief: Business Continuity - Are you Always Open for Business? This brief explains how Oracle solutions for mid-sized organizations can provide you with a secure, easily accessible, and always available information infrastructure that's also simple and cost-effective to manage. (Oracle) Hottest new tips Move text to the next column permanently Word may not be a full-featured layout program, but it does offer some tools that let you control the position of text on the page. See how to use a column setting to get that text where you want it (and keep it there). Always open Excel workbooks using a specific zoom factor Users working in a shared workbook save more than data. They save their personal druthers, such as the zoom factor. You can avoid this problem by standardizing the zoom factor using a macro. Quickly replace multiple space characters with a tab character Replacing multiple spaces with a tab can be a nightmare, unless you know this simple Find and Replace trick. New update to combat security vulnerability in PowerPoint Microsoft has released a new critical security update for PowerPoint. Free online PDF to Word conversion service Don't pay big bucks for a utility that converts PDF files to Microsoft Word text when you can convert for free! Office challenge: How can you force Excel to open a specific workbook? Here's the answer to last week's challenge on omitting 0 values from an averaging expression, along with a new question to test your Excel skills. Members' choice Flash your Outlook contacts Everything's mobile these days, including those Outlook contacts. Just download them to a flash drive and go! Popular power tips Build a quick training presentation using PowerPoint's Photo Album feature Easy tricks to make your Access forms run faster How to combine text and dates in the same cell 10+ lesser-known shortcuts for formatting Word text Two ways to return a unique list in Excel Cashing the check on Green IT The goals of Green IT include minimizing the use of hazardous materials and being smarter with their disposal, maximizing energy efficiency, and encouraging recycling and/or use of biodegradable products -- without negatively affecting productivity. In this TechRepublic Cover Story, we discuss some reasons to implement Green IT and some ways that you can do it in your organization. Download it today! TechRepublic Newsletters Get the latest community updates, product reviews, and need-to-know lists in the following TechRepublic newsletters. Automatically sign up today! Community Central Product Spotlight 10 Things White Papers from our partners SAP and Oracle: Who's ready for small and medium-sized businesses? (Oracle) Business Brief: Business Continuity - Are you Always Open for Business? (Oracle) Choosing the best CRM for your organization (Oracle) Downturn has you down in the dumps? Here are 10 strategies to help lift you out of it. (Oracle) Information Enables Compliance at Every Level - Oracle Compliance Architecture (Oracle) TechRepublic Today 10 ways developers can meet user expectations and ease frustrations Some users may make unrealistic demands, but most of the time, they just want software that's easy to use and that works the way it's supposed to. Justin James itemizes several basic user expectations and ways to address them. Subscribe to the 10 Things RSS feed. Get more from TechRepublic IT Dojo: Protect company assets during employee departures iPhone: Why I may be seduced by the dark side Career Management: Five mistakes managers make most often Video: Five prerequisites for successful IT projects Featured Training Courses Microsoft Exchange Server 2007 Managing and Maintaining a Microsoft Windows Server 2003 Environment Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 Managing and Maintaining Server 2008 Configuring Microsoft Office Communications Server 2007 Browse all Training Courses Presented by Global Knowledge Poll: How promptly is your IT department notified of employee departures? On average, how quickly is your IT department notified of employee departures? Take the poll and let us know. Sign up for more free newsletters from TechRepublic. To manage your account settings or to remove yourself from all TechRepublic communications, please visit our Subscription Center. The e-mail address for your subscription is cpedley@churchpower.com Unsubscribe from this e-mail | FAQ | Advertise | Privacy Policy   Copyright © 2009 CBS Interactive Inc. All rights reserved. TechRepublic, TechRepublic.com and the TechRepublic logo are registered trademarks of CBS Interactive Inc. Used by permission. CBS Interactive Inc. 235 Second Street San Francisco, CA 94105 U.S.A.