The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Find particular records

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Find particular records

Resolved · Medium Priority · Version 2003

ReplyFri 11 Dec 2009, 13:44Delegate Sue said...

Find particular records

We have a contacts-based database. If I wanted to find a particular individual (not knowing what company he worked at) how could I do it? The Find and Replace worked only for finding companies, not an individual.

Thanks

For upcoming training course dates see: Pricing & availability

ReplyFri 11 Dec 2009, 13:52Trainer Stephen said...

RE: Find particular records

Hi Sue

Thanks for your question

I am assuming that you have listed multiple individuals per company. If this is the case then it all depends on the structure of your database

If the individuals are stored in their own table you could build a form based on that table and use find and replace there. Alternatively, you could build a parameter query that does the same thing.

If however they are stored in multiple fields within the company table, then the problem is more complex as you would have to build a query that looks at these multiple fields

Regards

Stephen

Fri 18 Dec 2009: Automatically marked as resolved.

Access articles

· User-Proofing Your Access Database: Part 1
· Find Out All About Microsoft Access Report Sections
· Help Business To Go Global With Shared Databases
· How To Change The Data Displayed In A Linked Field In An Access Table
· Microsoft Access Training Opens Doors

Please browse our web site to find out more about
access.training and other Microsoft training courses.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

I have added a picture as a background but want to fade this so the text can be seen clearer. How do I do this?

» Forum post: Background

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions