1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Database

Discussion in 'Business Applications' started by CRMasters, Jun 2, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. CRMasters

    CRMasters Thread Starter

    Joined:
    Jun 2, 2007
    Messages:
    4
    Hi i created an access database for students that keeps track of their personal information as well as a monthly evaluation that they have to fill out, however i do not know how to create a button that i can place on the form that can allow the administrator to go to each student by either last name... sort of like a search engine. I don't know how to do this though, as well as just making a query that only gives me information for just 1 person and i don't have to manually put in the information in the criteria.. this i would also like to make a button or something of that sort..

    please help!!! I'm close but no cigar!
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    CRMaster, use the Toolbox Wizard to create a Combo Box, on the first question it asks select "Find a Record on my Form that matches my Combo selection".
     
  3. CRMasters

    CRMasters Thread Starter

    Joined:
    Jun 2, 2007
    Messages:
    4
    can you fully explain it.. because i did the wizard however it didn't redirect me exactly to another part of the form i don't know what i did wrong.
     
  4. CRMasters

    CRMasters Thread Starter

    Joined:
    Jun 2, 2007
    Messages:
    4
    okay it did work!! the only issue i have now is that there are repeated names for each evaluation form and i just want a single name to show up for each student.. is that possible?
     
  5. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    Foes that mean that you have Multiple records with Student Names in?
    If so then you should really have a separate table for Student Names.
     
  6. CRMasters

    CRMasters Thread Starter

    Joined:
    Jun 2, 2007
    Messages:
    4
    okay so then so how will i be able to connect it all with the information of the evaluations of the students?
     
  7. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    When you create the Student Table you also Create a Relationship between that table using the StudentID to the Table(s) holding the Student's other data.
    You should then create a Main Form for the Student and the other data is displayed on one or more Sub Forms. The Main and Sub forms are "Linked" by the StudentID.
    If you need help with this just attach a Zipped copy of the Database to this thread using the "Go Advanced" and "Manage Attachments" buttons.
    I will create the Table/Queries/Forms for you.
     
  8. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/579897

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice