RE: Using forms to print reports based off of queries

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes, you can choose it in your toolbar.
right click on the tool bar, choose customise, commands, choose tools
there youll see few commands, one of them is anlayse with excel, or word and
more
"Keith Meier, MCSA" wrote:

> Thank you,
>
> Is there a way to create a control that would export the results of a query
> into Excel?
>
> Thanks again in advance,
> Keith
>
> "Ofer" wrote:
>
> > Rick gave you one way, another way will be
> > when you give the command to print you can add the filter
> > ' incase the field is number type
> > docmd.OpenReport "ReportName",acViewPreview,,"[MyFieldInQuery]= " &
> > me.[MyFieldOnform]
> >
> > ' incase the field is text type
> > docmd.OpenReport "ReportName",acViewPreview,,"[MyFieldInQuery]= '" &
> > me.[MyFieldOnform] & "'"
> >
> > "Keith Meier, MCSA" wrote:
> >
> > > I have a couple of reports that pull their information off of a single query
> > > and want to know if a form can add a filter to the query results for the
> > > reports.
> > >
> > > i.e. I have a sales query and I have a form that the user selects the month
> > > and it will print out the sales report for January.
.

Relevant Pages

  • RE: Using forms to print reports based off of queries
    ... the query... ... > right click on the tool bar, choose customise, commands, choose tools ... >> into Excel? ...
    (microsoft.public.access.forms)
  • Re: Updating - let me count the ways
    ... Is that code reuse so important that you are willing to ... >>> clicks on Add Query. ... >>> 3) Commands and Access Query ... running it should be the same at the Dymanic SQL. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Perl Performance Help.
    ... commands to read from / dump to a file. ... you should start by running the equivalent query from ... Subject: Perl Performance Help. ... take less time to fetch the data and assign to an array. ...
    (perl.dbi.users)
  • Organizing commands and UI matters
    ... If I even right click on the node a context ... commands somewhere and I have the graphical representation of those. ... tool bar items or context menu items. ...
    (comp.object)
  • Re: Multi-line "Srchfor" Utility?
    ... The immediate need is to list out all EXEC CICS QUERY ... the programs we have that issue the QUERY ... SECURITY commands may have the various keywords one-per-source-line or ...
    (bit.listserv.ibm-main)