Ask Experts Questions for FREE Help !
Ask
    ashley velez's Avatar
    ashley velez Posts: 67, Reputation: 1
    Junior Member
    		  
    #1

    Mar 29, 2012, 08:50 AM
    MS Access DB 2010
    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?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


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 high...

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 high...

View more questions Search