Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Connecting Text Box in Query Criteria

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  printing  
Author Message
Ms-Exl-Learner

External


Since: Feb 2, 2010
Posts: 3



(Msg. 1) Posted: Tue Feb 02, 2010 9:06 am
Post subject: Connecting Text Box in Query Criteria
Archived from groups: microsoft>public>access (more info?)

I have created a Select query for retrieving some particular Date Records
from a table using the BETWEEN expression in query criteria bymentioning the
From Date and To Date and it’s working fine.

Each time I don’t want to open the query and enter the From Date and To
Date, so I want to create TWO Unbound text box in Forms for entering the From
Date and To Date and nearby the text box I am having a command button to run
the query.

Now I want to know how I can connect the Two Unbound Text Boxes that is From
Date and TO_DATE which is created in Forms in the Select Query (BETWEEN). I
want the select query to pick the From date and To Date from the form text
boxes and run the query.

Hope someone will give your valuable suggestion.

--------------------
(Ms-Exl-Learner)
--------------------

 >> Stay informed about: Connecting Text Box in Query Criteria 
Back to top
Login to vote
Jerry Whittle

External


Since: Jan 9, 2009
Posts: 12



(Msg. 2) Posted: Tue Feb 02, 2010 9:18 am
Post subject: RE: Connecting Text Box in Query Criteria
Archived from groups: per prev. post (more info?)

Between [Forms]![frmParameter2]![From Date] AND [Forms]![frmParameter2]![To
Date] + .99999

The form must remain open, but can be invisible for this to work. Also there
might be a problem if your date field includes time. The + .99999 part is a
cheat to work around it. Test.

 >> Stay informed about: Connecting Text Box in Query Criteria 
Back to top
Login to vote
Douglas J. Steele

External


Since: Nov 27, 2008
Posts: 61



(Msg. 3) Posted: Tue Feb 02, 2010 12:09 pm
Post subject: Re: Connecting Text Box in Query Criteria
Archived from groups: per prev. post (more info?)

Use Forms![NameOfForm]![From_Date] and Forms![NameOfForm]![To_Date] as the
parameters in your query.
 >> Stay informed about: Connecting Text Box in Query Criteria 
Back to top
Login to vote
Ms-Exl-Learner

External


Since: Feb 2, 2010
Posts: 3



(Msg. 4) Posted: Thu Feb 04, 2010 6:06 pm
Post subject: Re: Connecting Text Box in Query Criteria
Archived from groups: per prev. post (more info?)

Thank you, Its worked like a charm.

--------------------
(Ms-Exl-Learner)
--------------------


"Douglas J. Steele" wrote:

> Use Forms![NameOfForm]![From_Date] and Forms![NameOfForm]![To_Date] as the
> parameters in your query.
>
> --
> Doug Steele, Microsoft Access MVP
> [URL="http://www.AccessMVP.com/DJSteele"]http://www.AccessMVP.com/DJSteele[/URL]
> (no e-mails, please!)
>
> "Ms-Exl-Learner" wrote in message
>
> >I have created a Select query for retrieving some particular Date Records
> > from a table using the BETWEEN expression in query criteria bymentioning
> > the
> > From Date and To Date and it's working fine.
> >
> > Each time I don't want to open the query and enter the From Date and To
> > Date, so I want to create TWO Unbound text box in Forms for entering the
> > From
> > Date and To Date and nearby the text box I am having a command button to
> > run
> > the query.
> >
> > Now I want to know how I can connect the Two Unbound Text Boxes that is
> > From
> > Date and TO_DATE which is created in Forms in the Select Query (BETWEEN).
> > I
> > want the select query to pick the From date and To Date from the form text
> > boxes and run the query.
> >
> > Hope someone will give your valuable suggestion.
> >
> > --------------------
> > (Ms-Exl-Learner)
> > --------------------
>
>
> .
>
 >> Stay informed about: Connecting Text Box in Query Criteria 
Back to top
Login to vote
Ms-Exl-Learner

External


Since: Feb 2, 2010
Posts: 3



(Msg. 5) Posted: Thu Feb 04, 2010 6:06 pm
Post subject: RE: Connecting Text Box in Query Criteria
Archived from groups: per prev. post (more info?)

Thank you, Its worked like a charm...

--------------------
(Ms-Exl-Learner)
--------------------


"Jerry Whittle" wrote:

> Between [Forms]![frmParameter2]![From Date] AND [Forms]![frmParameter2]![To
> Date] + .99999
>
> The form must remain open, but can be invisible for this to work. Also there
> might be a problem if your date field includes time. The + .99999 part is a
> cheat to work around it. Test.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Ms-Exl-Learner" wrote:
>
> > I have created a Select query for retrieving some particular Date Records
> > from a table using the BETWEEN expression in query criteria bymentioning the
> > From Date and To Date and it’s working fine.
> >
> > Each time I don’t want to open the query and enter the From Date and To
> > Date, so I want to create TWO Unbound text box in Forms for entering the From
> > Date and To Date and nearby the text box I am having a command button to run
> > the query.
> >
> > Now I want to know how I can connect the Two Unbound Text Boxes that is From
> > Date and TO_DATE which is created in Forms in the Select Query (BETWEEN). I
> > want the select query to pick the From date and To Date from the form text
> > boxes and run the query.
> >
> > Hope someone will give your valuable suggestion.
> >
> > --------------------
> > (Ms-Exl-Learner)
> > --------------------
 >> Stay informed about: Connecting Text Box in Query Criteria 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
filter by criteria - I have a query that is extracting an inventory list, but the first field called Part_Nbr, I need to exclude items that start with "ENG", "PS", "CS", I could only get it for 1 criteria with NOT LIKE "ENG*", but I ...

Can not change data once i bases a query on a query - I have a despatch System that shows a customers orders with the products to be despatched Its on a Contious form based on a query. On the form i also want to show the Quantity that need to be despatched as the order might be despated in parts Th I hav...

Alpha Query - Records in my Emp fields is as follows Emp 01-2-06ABC 1-1-09CDA 01/04/09BVE In my query, i want to select alpha and i can get Emp1 ABC CDA BVE Thanks

Query from 3 tables - I have three tables that I want to put in query. But this is what I need: Articles Stores MinimumQTY ----------- ---------- --------------------- ArticleID StoreID ArticleID..

Query Parameter - Is there a way to use a query parameter with an expression. Or reference a textbox value within an expression. In the expression below I would like to replace the 9/1/2010 date with a reference to a textbox or parameter message box: MeasurementDays:...
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]