Kamis, 23 Februari 2012

RE: [MS_AccessPros] Re: Word Like Table in MS Access Report

 


Abdul,
I'm not convinced you have this set up correctly.

Did you create a subreport?

Did you remove a level of detail out of the main report?

Can you tell us about your record sources and Link Master/Child properties?

Duane Hookom
MS Access MVP


> To: MS_Access_Professionals@yahoogroups.com
> From: maxccess@gmail.com
> Date: Fri, 24 Feb 2012 09:37:41 +0500
> Subject: Re: [MS_AccessPros] Re: Word Like Table in MS Access Report
>
> Clive-
>
> I have already Grouping on InvoiceID with "Keep whole group together on one
> page"
>
> On Thu, Feb 23, 2012 at 5:57 PM, Clive <zctek@aol.com> wrote:
>
> > **
> >
> >
> > Hi Abdul,
> >
> > You will need to change the Sorting_And_Grouping for
> > the Invoice.
> >
> > Open the report in Design_View and click on
> > View/Sorting_And_Grouping from the menu.
> > You will probably just need to group on an
> > Invoice Field.
> >
> > Regards, Clive.
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel <maxccess@...>
> > wrote:
> > >
> > > Dear Duane,
> > >
> > > thanks it works, but when an invoice have more than one record the it
> > > splits into to pages, and become even worse if invoice have more than 2
> > or
> > > more records, however I have set can grow/shrink property to no
> > >
> > > On Thu, Feb 23, 2012 at 10:44 AM, Duane <duanehookom@...> wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > I think you can do this with a subreport of fixed height. Make sure the
> > > > subreport can't grow or shrink.
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel
> > <maxccess@>
> > > > wrote:
> > > > >
> > > > > Dear All,
> > > > >
> > > > > I want insert a table in access report just like we do in word but
> > with
> > > > > some fixed height in width let say the table height 3 in" fixed even
> > if
> > > > it
> > > > > had only one record, I post these question previously in different
> > manner
> > > > > got some answer though which are not helpful, I also have tried line
> > > > method
> > > > > but no luck. I am trying to make an invoice. any suggestions.
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar