Simple access search

[midnightrunner]

Hi, i realise i say simple access search, yet ask for help, what i mean is, it sounds to me it is simple for somebody who is experienced within using access.

I want to create something in access, so i can enter information, for example the information in my database...

Names:
Michael Hallam
Liz Raczynski
Natasha Hallam

Then use a search to search for specific records. For example, searching for Hallam would produce my the results, Michael Hallam, Natasha Hallam, But not Liz Raczynski. I need to update the informaiton on the database too daily, so maybe a command button which lets me add a new record.

Any help to get the above running would be greatly appreciated. Its just an example which i can try to implement into the program i am trying to make, which is that simple.

I would rather learn it myself for educational purposes, but am new to using access, so if if sounds too complicated for a beginner to acheive within a couple of days, would i be able to pay somebody to do this for me.

thankyou

 

[GingerR]

Hi--well, this is a little question with what could be a huge answer. Basically what you want to do is make a table; then make a form with the table as it's recordsource (where you can add and edit data). Then for searching, you'd want another form (unbound, meaning it has no recordsource) where you have a text box where the user enters something to search for; if it's always just searching on the last name, then write a QUERY that has in the criteria

Like "*" & Forms!FormName!txtSearchBox

where "FormName" is the name of your searching form, and txtSearchBox is the name of the text box where people enter what they are searching for. The user enters some text into the box, then clicks a button which opens the Query.

This is a basic scenerio. There are a ton of different ways you can go about this. So, essentially, you need to learn all the basics of MS Access database design, Normalization, Queries, and Form development. You can look at the sample Northwind database that comes with MS Access for some ideas. Let us know how it goes.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html