Re: Questions on Control boxes, Parameter queries and calendars in

Well, I will have to read about a dialog form as I have never created one.
Thanks for the idea.

Andy

"Bob Howard" wrote:

> Why not develop a dialog form that you call (as a dialog) in the OnOpen
> event of the report?
>
>
> "Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:6F4492E7-6E47-4592-8084-C5AB4FFBA8EB@xxxxxxxxxxxxxxxx
> > Hi, I am having difficulty with control boxes and parameter queries. I
> have
> > created a report that is based on a parameter query. When executing the
> > report, the user gets prompted 3 different times so they can input an
> agency,
> > beginning date, and ending date. The report then brings back all
> > construction projects being worked by a specific agancy and between
> certain
> > dates. However, I would liek the agency box to be a drop down list so the
> > user can only choose from specific agancies and therefore cannot make a
> typo
> > and get no data back because the agency the typed does not match any
> agencies
> > in the construction project table, which is what the parameter query is
> based
> > on. In addition, I would like the parameter prompts for the beginning and
> > ending dates to be in a specifc format, such as dd-mmm-yyyy, so if the
> user
> > typed mmm dd, yyy they would get a message box stating to renter the date
> in
> > the proper format. Ideally, it would be nice for the user to be prompted
> > with a calendar, or to either be able to type the date or use the
> calendar.
> > I have a Dell Optiplex GX 270 with XP and Access 2003. Thanks in advance
> for
> > your help.
> >
>
>
>
.

Relevant Pages

  • Re: Reporting dates from 2 tables
    ... The Parameters declaration will bring up a message box that prompts the user ... If it is indeed a parameter query you're after, then in the SQL view you can ... Then you can base your report on the query, so that every time the user ...
    (microsoft.public.access.gettingstarted)
  • Re: parameter query prompting multiple times
    ... >I have a parameter query in a subreport that works fine. ... >this subreport to the main report and execute it the parameter query prompts ... >me four times before it finally returns the report. ...
    (microsoft.public.access.reports)
  • Re: Questions on Control boxes, Parameter queries and calendars in rep
    ... > created a report that is based on a parameter query. ... I would liek the agency box to be a drop down list so the ... I would like the parameter prompts for the beginning and ...
    (microsoft.public.access.reports)
  • RE: parameter query prompting multiple times
    ... Don't use parameter prompts in queries. ... setup in the report footer section. ... I have a parameter query in a subreport that works fine. ...
    (microsoft.public.access.queries)
  • Questions on Control boxes, Parameter queries and calendars in rep
    ... created a report that is based on a parameter query. ... I would liek the agency box to be a drop down list so the ... I would like the parameter prompts for the beginning and ...
    (microsoft.public.access.reports)
Loading