Page Setup changes or resets

  • Thread starter Thread starter rueskov_palle
  • Start date Start date
R

rueskov_palle

Hi
Im having much the same problem as others have discribed in earlier
posts that the reports
(randomly!) resets to Windows Default printer and to default printer
settings.
Im using Access 2003 SP2 and there doesnt seem to be any improvement
from 2000 versions.

If I copy a database frontend from a user machine and opens it on my
development machine, I can be pretty much sure that several of the
reports forgets their specific printer and there by of course specific
margins. On my own development machine I always have the same printers
installed with the same name and settings as the users.

The same problem occurs when I am finished developing and want to
deploy the changes, so I have gotten use to only to deploy the objects
that have been changed, and then instruct the users to delete specific
objects and import them from the temporary database(or if it is reports
that have changed I do this my self through remote control on the users
machine.

This is a bit annoying and does not seem very professionel to the
users.

Does someone have an idea on how to dynamical set reports printer
settings either when the databases loads or perhaps when each report
loads which would make it possible always just to make a simple copy of
the whole database.

rueskov
 
Im having much the same problem as others have discribed in earlier
posts that the reports
(randomly!) resets to Windows Default printer and to default printer
settings.
Im using Access 2003 SP2 and there doesnt seem to be any improvement
from 2000 versions.

If I copy a database frontend from a user machine and opens it on my
development machine, I can be pretty much sure that several of the
reports forgets their specific printer and there by of course specific
margins. On my own development machine I always have the same printers
installed with the same name and settings as the users.

The same problem occurs when I am finished developing and want to
deploy the changes, so I have gotten use to only to deploy the objects
that have been changed, and then instruct the users to delete specific
objects and import them from the temporary database(or if it is reports
that have changed I do this my self through remote control on the users
machine.

This is a bit annoying and does not seem very professionel to the
users.

Does someone have an idea on how to dynamical set reports printer
settings either when the databases loads or perhaps when each report
loads which would make it possible always just to make a simple copy of
the whole database.
Click to expand...


I don't understand what you expect here. If a report is set
to use a specific printer and the printer is not available
on some machines, how can the report do what you want it to
do?

The usual approach to different printers on different
machines is to set the reports to use the default printer
and preselect margins that will work on all the machines.
In my experience, there are a fair number of printers that
require .6 in and even some .7 in on at least one edge.

If all else fails, check VBA Help for the Printers
collection and the Printer Object.
 
I don't understand what you expect here. ......>
Hi
Thanks for the reply.

Probably I havnt described it well enough, but the point was that
the specific printer is available on both machines with the same
printer name and same settings.

But even then the reports resets to Windows default printer when I copy
the database from one machine to the other machine.

I will look into the printer object i VBA and see if I can make some
workaround.

rueskov
 
Back
Top