Kamis, 04 April 2013

Re: [MS_AccessPros] Print fixed height vertical lines in detail section

Dear John

I have already use this method as follows:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Me.ScaleMode = 5
Me.ForeColor = 0
Me.Line (0.6042, 0)-(0.6146, 5)

End Sub

however I set line height to 5" but it print only for number of records in
the detail section, if I increase the height of detail section to 5" then
every record will be printed with equal space of 5"


On Thu, Apr 4, 2013 at 1:55 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> Abdul-
>
> If you want the lines to go to the bottom of the page regardless of the
> number of detail lines printed, you'll have to use the Line method. You can
> find details here:
>
> http://msdn.microsoft.com/en-us/library/office/bb237986(v=office.12).aspx
>
>
> 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 Abdul
> Shakeel
> Sent: Thursday, April 04, 2013 7:00 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Print fixed height vertical lines in detail
> section
>
> Dear Duane
>
> I have uploaded the file and my simple requirement is that I want my detail
> section looks like the attach file
>
> On Wed, Apr 3, 2013 at 5:35 PM, Duane Hookom <duanehookom@hotmail.com
> >wrote:
>
> > **
>
> >
> >
> > Abdul,
> >
> > You can post files in our group's Assistance Needed folder
> > http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/2_Ass
> > istanceNeeded/
> >
> > It also helps if you can describe your requirements more fully.
> >
> >
> > Duane Hookom MVP
> > MS Access
> >
> > ----------------------------------------
> > > From: maxccess@gmail.com
> >
> > >
> > > Dear Duane
> > >
> > > Yes this is I really want to do my report for more detail I am
> > > attaching here a pic this is what I would like my report detail section
> looks like.
> > >
> > >
> > > On Tue, Apr 2, 2013 at 7:34 PM, Duane Hookom
> > ><duanehookom@hotmail.com
> > >wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Abdul,
> > > > If I understand, you would like a fixed height of a number of
> > > > records
> > in
> > > > the detail section.
> > > >
> > > > For instance if the report was for Orders and Order Details where
> > > > the report is grouped by OrderID. You would like to have the order
> > > > details
> > take
> > > > up a fixed vertical space (like 3") regardless if there is one
> > > > order
> > detail
> > > > or five order details. In addition, you would like a vertical line
> > from top
> > > > to bottom of the "details" for each order.
> > > >
> > > > Is this what you actually would like? It really helps if you can
> > provide
> > > > some context to your question.
> > > >
> > > > Duane Hookom MVP
> > > > MS Access
> > > >
> > > > ----------------------------------------
> > > > > From: JohnV@msn.com
> > > >
> > > > >
> > > > > Abdul-
> > > > >
> > > > > Have you tried using the line control postitioned vertically?
> > > > >
> > > > > John Viescas, Author
> > > > >
> > > > > -----Original Message-----
> > > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > > > > Abdul
> > > > Shakeel
> > > > >
> > > > > Dear John
> > > > >
> > > > > I have control with can grow property set to No but I want to
> > > > > put a
> > > > vertical
> > > > > line with fixed height in detail section, let say vertical line
> > height
> > > > is 3
> > > > > in whether there is on line of record.
> > > > >
> > > > >
> > > > > On Tue, Apr 2, 2013 at 4:50 PM, John Viescas <JohnV@msn.com>
> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Abdul-
> > > > > >
> > > > > > If there are no Can Grow controls, simply add line controls
> > > > > > from Height = 0 to the height of the section. I you have
> > > > > > controls that
> > Can
> > > > > > Grow, you'll need to use the Line method.
> > > > > >
> > > > > > John Viescas, Author
> > > > > >
> > > > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > Abdul
> > > > > > Shakeel
> > > > > >
> > > > > > Dear All
> > > > > >
> > > > > > How can I print a fixed height detail section with vertical
> > > > > > lines
> > even
> > > > > > if there are only a few records?
> > > > > >
> > > > > > I asked these question in many forums but haven't got the
> > > > > > answer yet...plz help.
> > > > > >
> > > > > > --
> > > > > > Regards,
> > > > > > Abdul Shakeel
> >
> >
> >
>
> --
> Regards,
> Abdul Shakeel
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>



--
Regards,
Abdul Shakeel


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



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

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar