Angie-
Are you building the filter as a string in code behind the form and then
applying the filter when you open the report? Or are you simply using
Parameters in the Record Source of the report that point to controls on the
form?
Please explain what you mean by "select close." Do you mean the Windows close
(X) button, or is this your command button? If it's your button, then you're in
control of what closes. If it's the Windows button, that should close only the
one window, not both.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
--------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Angie
Sent: Friday, June 22, 2012 10:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Use a command button on a report to filter--changed
to a form to filter :)
Thanks Duane. I had it envisioned in my mind but wasn't sure if it would work
that way. I have set up a form that will filter by Employee, Shift, Job worked.
How do I get that form to pop up when they open the report? I have command
buttons on the form that allow the user to set the filter, clear the form and
close the form. However, when I select close, it closes both the form and the
report. I would also like to have the report set back to the original
un-filtered version when it first opens. My report is named JobWorked and my
form is named frmFilter.
--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> I have never placed "a command button on the report". I typically create an
unbound form for the user to select filtering criteria such as date range, job
worked, shift, etc. Then I have some method of selecting and opening a report.
The report uses the criteria to filter the report.
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com, "Angie" <paankadu@> wrote:
> >
> > I have a form which the user selects the employee and then selects the job
worked, enters hours scheduled, hours worked, hours refused etc. I have created
a report that will pull the employee, shift, job worked and work date. As this
will become quite large I would like to do one of the following:
> >
> > 1) create a command button on the report that when clicked would filter the
report by employee and then a second button that would filter by job worked
depending on what the user was looking for. this would give the user the choice
of the full report or a filterd version based on either employee or job worked.
> >
> > 2) another option would be to provide only the most recent dates worked for
each employee (last 10 days)thus creating only a portion of the report at all
times.
> >
> > The report is grouped by Shift with each employee, job worked and date
worked falling under each Shift group.
> >
> > Any advice would be appreciated.
> >
> > Thanks in advance
> > Angie
> >
>
Tidak ada komentar:
Posting Komentar