MDE Reports

[David Sinclair]

One of the problems with Access 2000 is that when you build a mbe database and distribute it to others custom paper setting revert back to the default for that machine. Does any one have any experience of setting paper size in code for an mde database?

 

[David Sinclair]

Have done as suggested; currently have SP3 on both the development machine and on a second computer. Have turned off the Auto Correction facility under options, created an MDE file, copied it to the second machine and on opening the report the report opens as the default paper size A4.

What I am trying to do is open a report based on paper size, “Envelope DL”, without having the operator change Paper Size at print time.

As a passing comment on the development computer have both Access 2000 and Access 2003. Creating the MDE file under Access 2000 environment.

Am I missing something, any more thoughts?

Thanks

 

[David Sinclair]

There is quit a lot of correspondence about fixes relating to margin problems. Currently I don’t have an issue with margins, it using different paper sizes that I am trying to resolve. I have heard that it can be done using API calls at the time a report is loaded but have not yet come across any one who is able to advise on this. Any thoughts where I maybe able to explore this option?

Thanks

 

[David Sinclair]

Access 2003 does have the ability to change printer settings in code. Its all very simple, its just that everyone else is using Access 2000.

Thanks for looking into this.