Ms Access Reports Letters and Envelopes

Hi Everybody

I have an Access 2000 database full of names and address, the usual
thing.

I am able to print out an A4 (UK paper size) letter that lines up
with a window envelope and shows the address just great. Keeps the
mailman happy.

However The problem is that there are so many different envelope
manufactures, and they all have different standards as to where to put
the window.

Add to that, they feed through printers in different ways, so that it
is difficult to predefine the positions of the address in a way that
will suit all users.

What I need is a way for the end user to be able to adjust all of the
reports/letters at runtime from some "Setting" area in the DB.

Has anyone else come up against this problem

Regards to all Smiley Bob

re: Ms Access Reports Letters and Envelopes

I have never done it, but I would think you would have to build some code
behind your report with variables for the margins. You'd then have to
prompt the user to determine which margins to use.

There may be other methods out there.

Rick B


"Bob" <smileyBob@hotmail.com> wrote in message
news:q51vb05n1vcllrcdijbmd6uc1o3493c829@4ax.com...
Hi Everybody

I have an Access 2000 database full of names and address, the usual
thing.

I am able to print out an A4 (UK paper size) letter that lines up
with a window envelope and shows the address just great. Keeps the
mailman happy.

However The problem is that there are so many different envelope
manufactures, and they all have different standards as to where to put
the window.

Add to that, they feed through printers in different ways, so that it
is difficult to predefine the positions of the address in a way that
will suit all users.

What I need is a way for the end user to be able to adjust all of the
reports/letters at runtime from some "Setting" area in the DB.

Has anyone else come up against this problem

Regards to all Smiley Bob

re: Ms Access Reports Letters and Envelopes

How about using envelopes without windows and printing mailing labels?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"Bob" <smileyBob@hotmail.com> wrote in message
news:q51vb05n1vcllrcdijbmd6uc1o3493c829@4ax.com...[color=blue]
> Hi Everybody
>
> I have an Access 2000 database full of names and address, the usual
> thing.
>
> I am able to print out an A4 (UK paper size) letter that lines up
> with a window envelope and shows the address just great. Keeps the
> mailman happy.
>
> However The problem is that there are so many different envelope
> manufactures, and they all have different standards as to where to put
> the window.
>
> Add to that, they feed through printers in different ways, so that it
> is difficult to predefine the positions of the address in a way that
> will suit all users.
>
> What I need is a way for the end user to be able to adjust all of the
> reports/letters at runtime from some "Setting" area in the DB.
>
> Has anyone else come up against this problem
>
> Regards to all Smiley Bob
>[/color]

re: Ms Access Reports Letters and Envelopes

don't bother to try to change the actual report margins --
just move the position of the controls on the report.
(in the open/load event)

(david)

"Rick B" <anonymous@discussions.microsoft.com> wrote in message
news:eC9WOlaSEHA.4028@TK2MSFTNGP09.phx.gbl...[color=blue]
> I have never done it, but I would think you would have to build some code
> behind your report with variables for the margins. You'd then have to
> prompt the user to determine which margins to use.
>
> There may be other methods out there.
>
> Rick B
>
>
> "Bob" <smileyBob@hotmail.com> wrote in message
> news:q51vb05n1vcllrcdijbmd6uc1o3493c829@4ax.com...
> Hi Everybody
>
> I have an Access 2000 database full of names and address, the usual
> thing.
>
> I am able to print out an A4 (UK paper size) letter that lines up
> with a window envelope and shows the address just great. Keeps the
> mailman happy.
>
> However The problem is that there are so many different envelope
> manufactures, and they all have different standards as to where to put
> the window.
>
> Add to that, they feed through printers in different ways, so that it
> is difficult to predefine the positions of the address in a way that
> will suit all users.
>
> What I need is a way for the end user to be able to adjust all of the
> reports/letters at runtime from some "Setting" area in the DB.
>
> Has anyone else come up against this problem
>
> Regards to all Smiley Bob
>
>[/color]

re: Ms Access Reports Letters and Envelopes

Easiest way (perhaps) is to produce several selectable standard reports.

You DON'T have to code the actual report multiple times - you can stick it as
a sub-report in various "holder" reports with different margins.

Basically altering printer settings requires design mode (and an mdb) and
some pretty fancy footwork for things to "stick".

You could also look at Attac Consulting demos for what can be done with
printers.
http://ourworld.compuserve.com/homep...cg/acgsoft.htm
(look for "on-the-fly printing")

Chris

"Bob" <smileyBob@hotmail.com> wrote in message
news:q51vb05n1vcllrcdijbmd6uc1o3493c829@4ax.com...[color=blue]
> Hi Everybody
>
> I have an Access 2000 database full of names and address, the usual
> thing.
>
> I am able to print out an A4 (UK paper size) letter that lines up
> with a window envelope and shows the address just great. Keeps the
> mailman happy.
>
> However The problem is that there are so many different envelope
> manufactures, and they all have different standards as to where to put
> the window.
>
> Add to that, they feed through printers in different ways, so that it
> is difficult to predefine the positions of the address in a way that
> will suit all users.
>
> What I need is a way for the end user to be able to adjust all of the
> reports/letters at runtime from some "Setting" area in the DB.
>
> Has anyone else come up against this problem
>
> Regards to all Smiley Bob
>[/color]