Access help needed

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Ref2335

Thread Starter
Joined
Jun 16, 2006
Messages
124
I'm hoping I can get some help here on an Access database I'm working on.

What I'm trying to do is build a form that has an area the user can type into, from there Access will look to a Query I have set up and return the results from the matching field. I'm sure its fairly simple to do but I am a novice Access user.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
Ref, yes it is fairly simple, do you want it search and match up data in just one field, or more than one field?
The next question is do you want an Exact Match or any Partial matches?
For instance Select a Name from current records and only that name or search a name field for "Jones" and it will find anybody with the name Jones.
 

Ref2335

Thread Starter
Joined
Jun 16, 2006
Messages
124
I'll see if I can explain it. It needs to be an exact match and what I need to match up is the user inputted field with a query that matches that data to 4 related cells.

Query will have "1234" lined up with cells that state red, bright, short, summer.

What I want is for the user to be able to key in 1234 and for Access to return all the instances of 1234 and all related fields from the query thats set up.

Does that make sense?
 

OBP

Joined
Mar 8, 2005
Messages
19,896
Ref, yes, although if the 1234 is some kind of "Item" number then you should have a Combo Box to select it to save typing errors.
But assume that your Form is called "Search" and your Field that you type in the number 1234 is called "Item" then you type in the Criteria Row for the field that has the 1234s in
forms![Search]![Item]

ie. Forms![Form Name]![Field Name]
 

Ref2335

Thread Starter
Joined
Jun 16, 2006
Messages
124
OBP, I believe we are quite close. A combo box is not what I want as I need the user to type in their data, an not match it to a drop down. If access autocompletes it as the user types in the data, thats great. Then the user needs to hit return to see all matches to the data they inputted. There may be up to 20 instances of their originating data which will show many different related fields tied to that original data.

I am not seeing the criteria row you are mentioning.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
In Design View the Criteria rows are those rows under the Field data, the heading "Criteria" is on the extreme left under Sort & Show, see the attached Excel sheet with a Screenshot.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top