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

Kamis, 23 Februari 2012

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

Dear Duane

Yes I has created Subreport

No, I am not remove detail section from report, actually I put subreport
there.

Link Master/Child is InvoiceID

On Fri, Feb 24, 2012 at 12:49 PM, Abdul Shakeel <maxccess@gmail.com> wrote:

> Dear Duane
>
> Yes I has created Subreport
>
> No, I am not remove detail section from report, actually I put subreport
> there.
>
> Link Master/Child is InvoiceID
>
> On Fri, Feb 24, 2012 at 12:21 PM, Duane Hookom <duanehookom@hotmail.com>wrote:
>
>> **
>>
>>
>>
>> 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]
>>
>>
>>
>
>