By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Ms Access Reports Letters and Envelopes

P: n/a
Bob
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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" <sm*******@hotmail.com> wrote in message
news:q5********************************@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
Nov 13 '05 #2

P: n/a
How about using envelopes without windows and printing mailing labels?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Bob" <sm*******@hotmail.com> wrote in message
news:q5********************************@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

Nov 13 '05 #3

P: n/a
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" <an*******@discussions.microsoft.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...
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" <sm*******@hotmail.com> wrote in message
news:q5********************************@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

Nov 13 '05 #4

P: n/a
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" <sm*******@hotmail.com> wrote in message
news:q5********************************@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


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.