Wednesday, May 20, 2009

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

May 20, 2009
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.

Sponsored
Business 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




Cashing the check on Green IT
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!


TechRepublic Today

10 ways developers can meet user expectations and ease frustrations
10 ThingsSome 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.RSS

Get more from TechRepublic


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.

No comments:

Post a Comment

Thanks for understanding that we need to prevent the nasties.

Terms of Use

Personal & Educational Use Only This blog consists mainly of FREE newsletters from computer web gurus that I receive. I thought you might like to see them all in one place than try to discover them on your own. A moderate amount of editing may be done to eliminate unrelated repetitious ads or unnecessary text which bloat the post. However I have given the authors full credit and will not remove their site links because you deserve to see where it comes from and they deserve to get credit for what they have written. Your use of this site is simply for educational purposes. For more computer-related help go to: CPEDLEY.COM for free software, advice and tips on low cost products which are very helpful. If you want to contact the editor, please go CPEDLEY.COM and check the Contact page for email address.