Prompt User for Input to Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the Criteria section type in [Student name]

The query will pop up a box the asks for the name, but you
have to match it exactly.
-----Original Message-----
Hello, I am trying to create a Database for a small adult
school that wants to track their students. We need the
ability to do transcripts; keep attendance; etc. I have
most of that already in place. What I would like to do
however, is to find the student's information on demand. I
can easily do that in a query. but let's say the student's
name is Charlie Brown. It is getting close to Charlie's
Graduation. He needs to see if there is any make up work
that he has to do. He goes to the school's administrator.
She click's on "Transcripts". I want Access to prompt the
administrator for the student's name. Can this be done
easily? Any help would be appreciated.
 
Put this in the Criteria section and the match doesn't have to be exact.

Like "*" & [Student Name] & "*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


In the Criteria section type in [Student name]

The query will pop up a box the asks for the name, but you
have to match it exactly.
-----Original Message-----
Hello, I am trying to create a Database for a small adult
school that wants to track their students. We need the
ability to do transcripts; keep attendance; etc. I have
most of that already in place. What I would like to do
however, is to find the student's information on demand. I
can easily do that in a query. but let's say the student's
name is Charlie Brown. It is getting close to Charlie's
Graduation. He needs to see if there is any make up work
that he has to do. He goes to the school's administrator.
She click's on "Transcripts". I want Access to prompt the
administrator for the student's name. Can this be done
easily? Any help would be appreciated.
 
Back
Top