Search Button on Navation Form (1 Viewer)

[SarahBeth]

How can I put search button on the navigation form to search all form in my database? I have eight form I would like to be able to search to be able to pull all information for one student worker.

 

[Mihail]

Welcome to the forum !
Seems that you need a query not a search button.

 

[SarahBeth]

Welcome to the forum !
Seems that you need a query not a search button.

How can put together a query that will allow me to search all database for one student? I have nine tables to search throw. I am trying to get where from the navigation form my boss can search for any student worker by their Student ID number.

 

[Mihail]

Maybe I'll be able to help you if you post the database.
How can I help you with no information about what you have ?

 

[SarahBeth]

Maybe I'll be able to help you if you post the database.
How cannot I help you with no information about what you have ?

I can upload the database it is to big. Can I have your email address?

 

[Mihail]

alt.mihai@yahoo.com
No problem if you wish to email me your database.
But here, on the forum there are more brains, more skilled guys than me, that can help you better than me.
So, first COMPACT your database, then ZIP it, then try again to upload.

 

[SarahBeth]

How do you COMPACT a database?

 

[Mihail]

Office Button -> Manage -> Compact and Repair Database
This should reduce a lot the size.

Also you can:
Office Button -> Access Options -> Current Database -> check the Compact on Close check box

 

[SarahBeth]

I have done that and is still to big to upload.

 

[Mihail]

So email me. Hope I can help you.

 

[SarahBeth]

Here is the database I need help make a search from Navigation Form.

 

[SarahBeth]

This more update database I hope someone can help me.

 

[Mihail]

Unfortunately I can't open because I use Access 2007.
Can you save in this version ?

 

[michaeljryan78]

Looks like 2010. I can open it fine. I will look into it. what information are you trying to get?

 

[SarahBeth]

The information I am try to get is from the Navigation Form, my boss can search for student worker information by their student id number and get that student information.

 

[michaeljryan78]

WOW. there are definately some structure issues here. WHat is the point of the Naviagtion table. There is a composiet key consisting of 8 fields??!!

 

[SarahBeth]

To help the new student worker go to the right form to fill out from the Student Worker form that any new student worker fill out.

 

[SarahBeth]

What are the structure issues?

 

[michaeljryan78]

Right now, there are only 1 student with a stduentID in the StudentBasicInformation table. The contactInformation table has a primary key based on the student first name are there are no student ID's in that table. The CraftInformation table has more students listed but there are no student ID's.

I would create a Student table with a unique ID and start there.

 

[michaeljryan78]

Mihail: here is the structure. Looks like there may need to be a bit of an overhaul with normailization