ACCESS FEED: RE: [MS_AccessPros] Re: Help with report

Rabu, 02 Januari 2013

RE: [MS_AccessPros] Re: Help with report

Duane-

I agree. And I'm not sure why you're using a RunMacro, Katrina. Why not
just use DoCmd.OpenReport directly in your VBA code?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, January 02, 2013 4:31 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Re: Help with report

Katrina,

I rarely save any report with something in the Filter property. Try change
the SQL view of qry_cargo to include the where condition:

SELECT tblPlanes.EDA, tblPlanes.Formal, tblPlanes.[Informal Entries
Release], tblPlanes.[Enforcement Exams], tblPlanes.[Stratified Compliance
Exams], tblPlanes.[ATS Compliance Exams], tblPlanes.[Intensive Exams],
tblPlanes.[Agriculture Exams], tblPlanes.[Negative Exams],
tblPlanes.[Positive Exams], tblPlanes.[SSPL/SIPL], tblPlanes.SSAC,
tblPlanes.DOS, tblPlanes.[ATF 6A], tblPlanes.OGA, tblPlanes.Quotas,
tblPlanes.[Duty Collected], tblPlanes.TIB, tblPlanes.[Inbond Arrivals],
tblPlanes.[Inbond Closures], tblPlanes.[Inbond Departures], tblPlanes.[INS
Issues], tblPlanes.[ATA Carnets], tblPlanes.[HS-7], tblPlanes.[CF
4455/4457], tblPlanes.[CF 214], tblPlanes.[CF 3299], tblPlanes.[CF 3311],
tblPlanes.[CF 4647] FROM tblPlanes WHERE [EDA] Between
[Forms]![frm_cargo_rng]![bdate] And [Forms]![frm_cargo_rng]![edate] ORDER BY
tblPlanes.EDA;

Then delete anything from the filter properties of the main and subreports.

Duane Hookom MVP
MS Access

----------------------------------------
> From: no_reply@yahoogroups.com
>
> I uploaded the same database (Austin Tracker - new working3) with more
records in the tblPlanes. When I select different dates for example 04/01/12
through 04/30/12, the first page of the report shows the records I've
selected; however, the second page shows other dates instead of only those
between April 1st and April 30th. I've looked over the report and can't seem
to find what it is I'm doing wrong that doesn't allow the subreport to also
filter only those records between those dates.
>
> Thanks!
>
> Katrina
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom
<duanehookom@...> wrote:
> >
> > The records displayed for me. Are you using the Print Preview mode?
> >
> > Duane Hookom MVP
> > MS Access
> >
> > ----------------------------------------
> > > From: no_reply@yahoogroups.com
> > >
> > > Duane,
> > >
> > > I took out the EDA field in the Link Master/Child, and it still
doesn't display the records. The main reports displays the records based on
the date selection I made on the frm_cargo; however, the same records should
be displayed for those same dates in the subreport, and the subreport comes
back blank. I'm not sure what else to do.
> > >
> > > Your help is greatly appreciated!
> > >
> > > Thanks!
> > >
> > > Katrina
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom
<duanehookom@> wrote:
> > > >
> > > > I think your issue is that you have the Link Master/Child properties
of the subreport set to the EDA field. I expect you want these blank.
> > > >
> > > > Duane Hookom MVP
> > > > MS Access
> > > > ----------------------------------------
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > From: no_reply@yahoogroups.com
> > > > > Date: Mon, 31 Dec 2012 17:51:43 +0000
> > > > > Subject: [MS_AccessPros] Help with report
> > > > >
> > > > > Hello all!
> > > > >
> > > > > I have a database I'm working on, and have run into a problem. I
have a report that displays certain fields based on a query. In that report
I have a subreport that I want displayed at the bottom of the report. The
top portion of the report is filtered based on the date selection made on
the frm_cargo. What I would like is to also have the fields in the subreport
filtered based on that same selection. I entered the filter in the
subreport; however, it does not display the information once the dates are
selected. If someone could please look at my report and tell me what it
might be I'm missing I would greatly appreciate it. I have uploaded the
database into the Assistance Needed folder under Austin Tracker - New
Working2.
> > > > >
> > > > > Thanks so much for your help!
> > > > >
> > > > > Katrina

------------------------------------

Yahoo! Groups Links