Prev: Back-up Bob Larson
Next: New member, can any one help?
From: Emmy on 5 Jul 2008 14:40
I want to bring up all records for a certain client. For instance, all
clients named "Smith". I'm used to working with Microsoft Works database.
That allowed me to bring up a group of records, and then choose "all records"
to get back where I started. Can anyone help do that with Access?
From: Arvin Meyer [MVP] on 5 Jul 2008 15:31
Exactly how depend upon your version, but generally, you can:

1. Write a query which prompts for the name.
2. Use QueryBySelection which allows you to right-click in a text box and
type in criteria.
3. Use QueryByForm, from the menu which allows you to turn your form into a
criteria engine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Emmy" <Emmy(a)discussions.microsoft.com> wrote in message
news:E9F0F63E-57F5-44C7-9640-5C1A7F10E745(a)microsoft.com...
>I want to bring up all records for a certain client. For instance, all
> clients named "Smith". I'm used to working with Microsoft Works database.
> That allowed me to bring up a group of records, and then choose "all
> records"
> to get back where I started. Can anyone help do that with Access?


From: Emmy on 5 Jul 2008 16:29
Thank you. I did realized I didn't include that I'm working with 2007, but
too late.
after reading your reply, I was able to get what I wanted.
Emmy
Office 2007


"Arvin Meyer [MVP]" wrote:

> Exactly how depend upon your version, but generally, you can:
>
> 1. Write a query which prompts for the name.
> 2. Use QueryBySelection which allows you to right-click in a text box and
> type in criteria.
> 3. Use QueryByForm, from the menu which allows you to turn your form into a
> criteria engine.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Emmy" <Emmy(a)discussions.microsoft.com> wrote in message
> news:E9F0F63E-57F5-44C7-9640-5C1A7F10E745(a)microsoft.com...
> >I want to bring up all records for a certain client. For instance, all
> > clients named "Smith". I'm used to working with Microsoft Works database.
> > That allowed me to bring up a group of records, and then choose "all
> > records"
> > to get back where I started. Can anyone help do that with Access?
>
>
>
 | 
Pages: 1
Prev: Back-up Bob Larson
Next: New member, can any one help?