Ask Experts Questions for FREE Help !
Ask

MS Access DB 2010

Asked Mar 29, 2012, 08:50 AM — 1 Answer
I created a simple access db, with 1 table and 3 columns.

Table Name: Machining_Fixtures
Column 1 Name: ID
Column 2 Name: Location
Column 3 Name: Fixture

There are 500 records in this table. I just want to be able to enter the location and have it bring me back the fixture, or enter the fixture and have it bring me back the location

How do I go about doing this?

Search this Thread
Share |
1 Answer
ScottGem's Avatar
ScottGem Posts: 58,072, Reputation: 28135
Computer Expert and Renaissance Man
  
#2

Mar 30, 2012, 04:42 AM


There are several ways. The easiest is to create a form based on the table using the Form Wizard.

At the bottom of the form will be a search box. Just start typing in either the location or the fixture and it will find the record.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Bishop Co. Began operations on January 1, 2010. Financial statements for 2010 and 201 [ 1 Answers ]

Bishop Co. Began operations on January 1, 2010. Financial statements for 2010 and 2011 con- tained the following errors: Dec. 31, 2010 Dec. 31, 2011 Ending inventory $132,000 too high $156,000 too low Depreciation expense 84,000 too high Insurance expense 60,000 too low 60,000 too...

Issues creating a one to many relationtionship in Access 2010 [ 9 Answers ]

I have two tables (Clients / Quotes) and I want to create a report for each client displaying a list of quotes that has been sent to them. The 'Quotes Form' can have up to 6 clients being priced the same project with a 7th client field for the winning client. So the relationship view looks like...

Need help creating a relationship in Access 2010 [ 4 Answers ]

Hi all, I'm trying to build an access db (I don't know access very well) to keep track of my rechargeable batteries (geeky I know). Here are my tables: BatteryType: Just contains the different types of batteries available Inventory: contains batterytype, serial number, purchase date, etc...

Bishop Co. Began operations on January 1, 2010. Financial statements for 2010 and 201 [ 1 Answers ]

Bishop Co. Began operations on January 1, 2010. Financial statements for 2010 and 2011 con- tained the following errors: Dec. 31, 2010 Dec. 31, 2011 Ending inventory $132,000 too high $156,000 too low Depreciation expense 84,000 too high Insurance expense 60,000 too low 60,000 too...

View more Access questions Search