Re: Dialog box - paramater query

From: Francisco F. (FranciscoF_at_discussions.microsoft.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 07:29:08 -0800

Jeff,

To your questions: the dialog box is a form, with a combo box and two text
boxes. Thanks for the hints, they are valueble for the future, but I found
the problem, it was just a misspelling of the parameters. Now it's working
correctly as planned. Thank you.

"Jeff Boyce" wrote:

> Francisco
>
> I am somewhat confused, and am not visualizing your situation well.
>
> What happens if you only consider your "first-in-the-chain" query? Does it
> work properly with the values in your dialog box?
>
> Is your "dialog box" actually a form, or something else?
>
> How does your first query get it's parameters? Does it work properly?
>
> Then I'd step to the "next-in-the-chain" and test it the same way.
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "Francisco F." <FranciscoF@discussions.microsoft.com> wrote in message
> news:516F5E1E-4B66-4747-9F1A-4CCEFB69347E@microsoft.com...
> > Hello all.
> >
> > I have a Dialog Box to set parameters for two fields: one is "supplier"
> and
> > the other is «between [StartDate] and [EndDate]. The "supplier" parameter
> is
> > working OK, but the dates parameter NOT.
> >
> > The query is base on two other queries which are based on two and one
> > queries, respectively. I have set the criteria parameter entries in the
> > "base" queries, i.e., in these last two+one queries, because they're the
> ones
> > that contain the fields "StartDate" and "EndDate". It's not working.
> >
> > Two questions:
> > 1) Must the criteria parameter entries be set in the "last" query?
> > 2) I have three dates, three different fields, in the "base" queries, and
> I
> > want to entry only one parameter to set the (same) date for these three
> > fields. Is that possible like this?
> >
> > Thank you.
>
>

Relevant Pages

  • Re: Same Parameters in all sub reports
    ... something wrong between the form and the query. ... It didn't for my regular queries. ... "Jeff Boyce" wrote: ... Build a query that will be used to provide data to your report. ...
    (microsoft.public.access.reports)
  • Re: split fields
    ... you get to build UNION queries to find all possible names. ... Access is a relational database. ... >> If the topics of normalization and relational design are unfamiliar, ... >> Jeff Boyce ...
    (microsoft.public.access.queries)
  • Re: Displaying Query Results on a Form
    ... Please describe your data structure (what fields do you have in which ... built a form with several tab to make it easy for a user to populate the ... Many of them however are queries built of ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: How to pass parameter between parameter queries
    ... Jeff Boyce wrote: ... the queries and/or reports. ... the value' functionality into a VBA function, ... possibility in plain SQL. ...
    (microsoft.public.access.queries)
  • Re: Running queries one after the other
    ... > event code as follows to run two Queries, ... > changed something and forgot to retest it at the time. ... > The first query is called Append School Offers to Archive ... The form that calls the queries? ...
    (microsoft.public.access.queries)
Loading