 |
08-Nov-2005, 12:52 PM
|  | Guest | | | | | | | | | | Finding specific records
Hi everyone,
Like to say what a great group this is and thanks for all the help in the
past.
However moving on here is my dilema today, I have a form that is based on a
query from several tables, this query can have hundres/thousands of records,
what I would like to do is do a search on a specific field and jump to that
records form, what I am thinking is along the lines of the record navigation
button for find but when I press the command button on my form it defaults to Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6841-finding-specific-records.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
the required field and parameters leaving the user to enter the search text
criteria.
MTIA Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh! |
08-Nov-2005, 12:52 PM
| | Guest | | | | | | | | | | Re: Finding specific records
Have a look at Filter By Form (Records ... Filter ... Filter By Form). The
interface may be just what you are looking for. Once selected from the menu,
simply fill in any field and click on the Filter button (the funnel)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
"souchie40" wrote in message
news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
> Hi everyone,
>
> Like to say what a great group this is and thanks for all the help in the
> past.
>
> However moving on here is my dilema today, I have a form that is based on
a
> query from several tables, this query can have hundres/thousands of
records,
> what I would like to do is do a search on a specific field and jump to
that
> records form, what I am thinking is along the lines of the record
navigation
> button for find but when I press the command button on my form it defaults
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
to
> the required field and parameters leaving the user to enter the search
text
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
> criteria.
>
> MTIA
 |
08-Nov-2005, 12:52 PM
| | Guest | | | | | | | | | | Re: Finding specific records
Yes that would do what I want , but is there a way to run 'filter by form and
apply filter' from code and again to remove filter
TIA
"Arvin Meyer [MVP]" wrote:
> Have a look at Filter By Form (Records ... Filter ... Filter By Form). The
> interface may be just what you are looking for. Once selected from the menu,
> simply fill in any field and click on the Filter button (the funnel)
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "souchie40" wrote in message
> news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
> > Hi everyone,
> >
> > Like to say what a great group this is and thanks for all the help in the
> > past.
> >
> > However moving on here is my dilema today, I have a form that is based on
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
> a
> > query from several tables, this query can have hundres/thousands of
> records,
> > what I would like to do is do a search on a specific field and jump to
> that
> > records form, what I am thinking is along the lines of the record
> navigation
> > button for find but when I press the command button on my form it defaults
> to
> > the required field and parameters leaving the user to enter the search
> text
> > criteria.
> >
> > MTIA
>
>
> |
09-Nov-2005, 17:50 PM
| | Guest | | | | | | | | | | Re: Finding specific records
Sure:
DoCmd.RunCommand acCmdFilterByForm
DoCmd.RunCommand acCmdApplyFilterSort
Docmd.RunCommand acCmdRemoveFilterSort
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
"souchie40" wrote in message
news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
> Yes that would do what I want , but is there a way to run 'filter by form
and
> apply filter' from code and again to remove filter
>
> TIA
>
> "Arvin Meyer [MVP]" wrote:
>
> > Have a look at Filter By Form (Records ... Filter ... Filter By Form).
The
> > interface may be just what you are looking for. Once selected from the
menu,
> > simply fill in any field and click on the Filter button (the funnel)
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads
> > http://www.datastrat.com
> > http://www.mvps.org/access
> >
> > "souchie40" wrote in message
> > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
> > > Hi everyone,
> > >
> > > Like to say what a great group this is and thanks for all the help in
the
> > > past.
> > >
> > > However moving on here is my dilema today, I have a form that is based
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
on
> > a
> > > query from several tables, this query can have hundres/thousands of
> > records,
> > > what I would like to do is do a search on a specific field and jump to
> > that
> > > records form, what I am thinking is along the lines of the record
> > navigation
> > > button for find but when I press the command button on my form it
defaults
> > to
> > > the required field and parameters leaving the user to enter the search
> > text
> > > criteria.
> > >
> > > MTIA
> >
> >
> >
|
09-Nov-2005, 17:51 PM
| | Guest | | | | | | | | | | Re: Finding specific records
Hi,
But How would I get it to pause between 'filter by form' and 'apply filter'
so that the user can enter the required criteria
TIA
"Arvin Meyer [MVP]" wrote: Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
> Sure:
>
> DoCmd.RunCommand acCmdFilterByForm
> DoCmd.RunCommand acCmdApplyFilterSort
> Docmd.RunCommand acCmdRemoveFilterSort
>
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "souchie40" wrote in message
> news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
> > Yes that would do what I want , but is there a way to run 'filter by form
> and
> > apply filter' from code and again to remove filter
> >
> > TIA
> >
> > "Arvin Meyer [MVP]" wrote:
> >
> > > Have a look at Filter By Form (Records ... Filter ... Filter By Form).
> The
> > > interface may be just what you are looking for. Once selected from the
> menu,
> > > simply fill in any field and click on the Filter button (the funnel)
> > > --
> > > Arvin Meyer, MCP, MVP
> > > Microsoft Access
> > > Free Access downloads
> > > http://www.datastrat.com
> > > http://www.mvps.org/access
> > >
> > > "souchie40" wrote in message
> > > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
> > > > Hi everyone,
> > > >
> > > > Like to say what a great group this is and thanks for all the help in
> the
> > > > past.
> > > >
> > > > However moving on here is my dilema today, I have a form that is based
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
> on
> > > a
> > > > query from several tables, this query can have hundres/thousands of
> > > records,
> > > > what I would like to do is do a search on a specific field and jump to
> > > that
> > > > records form, what I am thinking is along the lines of the record
> > > navigation
> > > > button for find but when I press the command button on my form it
> defaults
> > > to
> > > > the required field and parameters leaving the user to enter the search
> > > text
> > > > criteria.
> > > >
> > > > MTIA
> > >
> > >
> > >
>
>
> |
10-Nov-2005, 21:08 PM
| | Guest | | | | | | | | | | Re: Finding specific records
Opening Filter By Form pauses by itself. You would then enter your criteria
and push another button to apply the filter.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
"souchie40" wrote in message
news:67110FE1-F76E-48FE-8A73-7F0B6D93A4A1@microsoft.com...
> Hi,
>
> But How would I get it to pause between 'filter by form' and 'apply
filter'
> so that the user can enter the required criteria
>
> TIA
>
> "Arvin Meyer [MVP]" wrote:
>
> > Sure:
> >
> > DoCmd.RunCommand acCmdFilterByForm
> > DoCmd.RunCommand acCmdApplyFilterSort
> > Docmd.RunCommand acCmdRemoveFilterSort
> >
> > --
> > Arvin Meyer, MCP, MVP
> > Microsoft Access
> > Free Access downloads
> > http://www.datastrat.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
> > http://www.mvps.org/access
> >
> > "souchie40" wrote in message
> > news:01B8E0E4-D9E2-418D-90DA-C8B8329A64E5@microsoft.com...
> > > Yes that would do what I want , but is there a way to run 'filter by
form
> > and
> > > apply filter' from code and again to remove filter
> > >
> > > TIA
> > >
> > > "Arvin Meyer [MVP]" wrote:
> > >
> > > > Have a look at Filter By Form (Records ... Filter ... Filter By
Form).
> > The
> > > > interface may be just what you are looking for. Once selected from
the
> > menu,
> > > > simply fill in any field and click on the Filter button (the funnel)
> > > > --
> > > > Arvin Meyer, MCP, MVP
> > > > Microsoft Access
> > > > Free Access downloads
> > > > http://www.datastrat.com
> > > > http://www.mvps.org/access
> > > >
> > > > "souchie40" wrote in message
> > > > news:1AC200E0-2944-4D17-A2A2-36CD0E34757D@microsoft.com...
> > > > > Hi everyone,
> > > > >
> > > > > Like to say what a great group this is and thanks for all the help
in
> > the
> > > > > past.
> > > > >
> > > > > However moving on here is my dilema today, I have a form that is
based
> > on
> > > > a
> > > > > query from several tables, this query can have hundres/thousands
of
> > > > records,
> > > > > what I would like to do is do a search on a specific field and
jump to
> > > > that
> > > > > records form, what I am thinking is along the lines of the record
> > > > navigation
> > > > > button for find but when I press the command button on my form it
> > defaults
> > > > to
> > > > > the required field and parameters leaving the user to enter the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6841
search
> > > > text
> > > > > criteria.
> > > > >
> > > > > MTIA
> > > >
> > > >
> > > >
> >
> >
> >
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Active Discussions | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
