ACCESS FEED: Re: [MS_AccessPros] Two sided reports in Access 2003

Kamis, 20 Juni 2013

Re: [MS_AccessPros] Two sided reports in Access 2003

Daniel

I bet several members would appreciate your sample. Please feel free to upload it to our Files/Samples folder.

Bill Mosca, group founder

--- In MS_Access_Professionals@yahoogroups.com, "Daniel Combs" <drc0369@...> wrote:
>
> Bingo, I figured out what I did before. Actually, I didn't need code on this one as it is less complex than before. When generating tent cards from reports, depending on the size, for this instance 3in by 4in for print, arrange the page set up as landscape, set to 3 columns, 0 row and column spacing, with .25in margins. I will post a sample DB for anyone to use and feel free to modify.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Daniel Combs" <drc0369@> wrote:
> >
> > The tent cards are 3in x 2in folded and will be printed on 8.5 x 11 cardstock then cut to size. There was a trick to doing it I used before, but trying to recreate it, didn't have the opportunity to save my coding at the time. I just remembered last night it involves using subforms.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Glenn Lloyd <argeedblu@> wrote:
> > >
> > > Since you want to produce a folded card, wouldn't you want to print on the same side,just have half rotated 180 degrees?Â
> > >
> > > Glenn
> > >
> > >
> > > Sent from Samsung Galaxy Note ll Mobile Â
> > >
> > > -------- Original message --------
> > > From: Daniel Combs <drc0369@>
> > > Date: 2013-06-19 7:02 PM (GMT-05:00)
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: [MS_AccessPros] Two sided reports in Access 2003
> > >
> > > Ok, I haven't had to deal with this in a while and I'm rusty in this area. I'm working in Access 2003 and trying to print two different sides of reports. I'm making tent cards with info on the front facing only and inside with an image on the inside top and image and text on the inside bottom. I have two different reports and the layout size is 3in wide by 4in tall for a 3x2 folded tent card. Because I'm using data for each person (name and table number) I can't use a static image for all the cards that would be the same and I could just rotate the image.
> > >
> > > The issue is that I don't have a duplex printer and therefore I can't rotate the paper any way to be able to correctly match the name on the front (rptPlacementCards) to the table number on the inside (rptPlacementCardsInside)
> > >
> > > Any suggestions? Even any third party add-ins or unique coding?
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>