Access - Total Beginner Question

[ladyck3]

I apologize in advance for my lack of knowledge when it comes to Access, but I'm wondering if what I am seeking might have a simple solution.

I have created a database by importing a table, I then .. using the wizard, created a form, however I know how to customize that. I know the very basics as described but when we get into "functionality" .. well I am lost.

I have a table with 2 columns. The first are file extensions and the second is their description. There are duplicates, IE: ABC may have 5 or 6 different explanations, so I am dealing with multiple entries of the same in column 1 but no duplicates in column 2.

HOW.. do I create a search in a database?
How.. do I get it to return any/all of the explanations related to one value from Column 1?

Please be gentle, I'm so totally ignorant about programming and scripting and just what I need to do...

If this is to fundamental for this forum to assist with, please let me know... I will not post again. I will fully understand.

I'm just one that learns by doing, when I have practical application... to read books about how to, on things that are not of interest to me, do not help... I just don't grasp it... (my brain is too old to wrap around some of that is all).

Thanks in advance.

 

[RoCoPe]

Create a query using the Query Wizard. Keep it simple, use the help to understand.

Step at a time.

RoCoPe
"You need it to do what?"

 

[tledwards]

The most basic way to sort filter records is to use the filter/sort capabilities when you open a table. Go to the Tables section. Open your table. Then under records you will find the filter/sort capabilities or find the icons.

The second way is to use queries. Go the the Query section. Select new query. Select design view in the window that appears. High light your table name form the window that appears. Then click on Add then Close. Explore how to add fields and set up criteria.

Good luck

 

[ladyck3]

Thank you very much for responding...
I had created a query and deleted it because once created, I was unsure what to do from there. I know this sounds really stupid... argh...

I'm more than willing to use the help file but I'm not even sure what I should be asking it ... just do a search for search?

I told you I was ignorant about this....

If you told me to put a VB script in, I would have no idea where or how to do this....

Again, if this is too elementary for this forum, I will not be offended if you tell me so.... I just thought I'd try here and see what help I might obtain.

Thanks again... I mean it!

 

[joebloeonthego]

you want to search by extension and get a list of explanations?
I'm fairly new to access, but I could do this if I had too (i'm sure there's better ways... but)

if you want an example to work by, I can email you something I just whipped up.

 

[jfgambit]

There are a couple of ways to do a search on a form, here are a couple of examples:

1. Add a Combobox to your form. The wizard will guide you through the process of retrieving data based on your selection from the combobox.
2. Add an unbound Textbox to your Form and call it txtExtension. Add a query to your database that pulls all of the information for the form. In the Criteria field of the Extension field add [Forms]![NameofForm]![txtExtension] (Nmae of Form being the name of the form that you have created. Change the Record Source of the Form to the Query. Finally, go to the Properties of the Textbox you created (Right mouse click the textbox and select properties) on the Event tab put your curser in the After Update Event and click the 3 “…” to the right side of the box. Select Code Builder and add the following after the line: Private Sub txtEtension_AfterUpdate() line and before the End Sub Line:
Me.Requery

Should look something like:
Private Sub txtExtension_AfterUpdate()
Me.Requery
End sub

What the above does is filter the query based on the text you enter into the textbox on the form. After you enter data and hit “Enter” the After Update event run the query attached to the form and pulls the data based on your parameters.

Let me know if you need more help.


"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[CMooreJr]

Go to the Query Tab and select "New Query"/ "Simple Query Wizard" When you do this, it will open a box listing all tables and queries you have. Select the table you want to "filter" information from.

This will put the table at the top of the interface. Close the table box. Select the fields you want to have appear. Say for instance, You have a table called "people" and have put that in your query. There are fields in that table named "first_Name" and "Last_name". Double click on these fields from the box at the top. It will put it down in the columns at the bottom. Now you just need to filter what you want. Say you just want to pull just names whos last name is "Jones" See the Criteria field? Put the following in the last name field

Like "Jones"

If you want them to input the name they want to search for, you put the following in the criteria field

[Enter last name to search]

The text they type in will look in the "people" table" and will only pull what matches.

Hope this helps!

 

[ladyck3]

I would like to thank those who have replied to my query... we found a way through using a pivot table in Excel. This is not quite a nice little database window but its functional...

jfgambit... your technical expertise is <whew> above my head.... I&quot;m going to save your info however and see what I can find.. or see if I can implement this in some way but its more than I have knowledge of....

I haven't tried importing the pivot table, that's my next venture.... not sure if can do that....