Access

[chris lovett]

Hi all,

I am just playing around with access 2007. But i am struggling now. I am looking to add a very simple search box to my form. All i want it to do

is to search an Auto number Field. This Field is my Primary Key aswell. I am very new to Access so as basic instruction as possible would be nice.

 

Thanks in advance

[DirtyPolo]

Hello chris,

 

For just basic querying [searching] try this link, as I don't have Access 2007 and would be able to explain in 2005 terms, but I'm not sure if they are the same :P

 

Create queries for a new Access 2007 database

 

you should also check out this link, as it is the whole list of Microsoft's Official Tutorials for Access 2007

 

Access 2007 - Training - Microsoft Office Online

 

Hope this helps!

 

Apologies for not being able to answer your question directly.

[chris lovett]

Thanks for this information. And the Office Training site is sure to help me in the future.

 

However i'm not sure using Queries is what i'm looking to do. Either that or i'm doing it wrong.

 

If i give some information on what my database is trying to do.

Basically i have created a database to help me manage my money.

 

I add a new entry on my form everytime i owe someone money.

This then adds it to my main table.

Each time i add a new payment it gives that payment an ID number. Which is displayed in a subform on my main Form.

I can then see who i still need to pay. no matter what ID i'm on.

But what i would like is so when i'm looking at my Form i can say go to ID ??. And my form will then display this ID with all the details.

 

Hope this makes sense. It doesn't too me. Access make me cry. :confused:

 

The search box on the navigation bar at the bottom worked originally. I could type in go to Record ?? and it would jump to that record. But now i have deleted some records it's not in synch and therefore doesn't work.

[DirtyPolo]

Oh, I do not completly understand what you mean, but to explain how to use a query in Access 2007, as I have it infront of me now.

 

- Open your database in Access

- Click on "Create" at the top.

- Click on "Query Design" in the "Other" section along the top

- In the box that appears, select which table you want to search in

- Click "Add" then "Close"

- At the bottom click on the drop down box beside "Field" and select which to display.

(i.e. if you wanted to see all the information for a certain ID, you would put in all of the fields)

- Select what table they are in, with the drop down box by "Table", below "Field".

- Where you've selected the ID as the field, click on the box that says "Criteria"

- Enter the ID that you wish to search for.

- Click the big red ! that says "Run" in the top left.

 

 

It seems a long winded way... another shorter way that I found is,

 

- When you are viewing your database in the "datasheet" view, click on "Find" on the top right

- In the "Find What" box, put in the ID you wish to find

- Where it says "Look In" select where you want it to look, it will normally give you 2 choices, a single field or the whole table, if you are currently selected on the "ID" column on your database then it will show the "ID" as the single field option.

- Click "Find Next"

 

Hope this helps :)

[chris lovett]

Ok so i'm nearly there, is it Possible to embed this into my form so i have a text box Which will Edit my criteria and a button to press to run the query. This will mean i don't have to do the query manually everytime. something like i have done below.

 

_________

[_Criteria_] [!]

[DirtyPolo]

There must be a way but I'm afraid my knowledge stops here as I haven't ever used a form on Access, just the database aspect of it I'm afraid :(

 

Hopefully someone with more knowledge can help and take over from here.