PrtMip

[Andy Levy]

Hi

I am using Access2K. I am tryingto programatically set a Report's margins
on Open. I have read about PrtMip, and hav tried implementing that without
success so far. I have alose read that MDE files cannot handlle PrtMip. Is
this so, and what can i do about it. I want to send out the app as an MDE
and not just a secured database as microsoft suggests.

Thanks

AL

 

[SA]

Andy:

In MDE databases you can not change objects like reports or programatically
modify margins or use the prtmip property, there is no work around it just
can not be done via code. If you need prtMip code look on our site in the
code and design tips area under reports; you'll find code for mainipulating
prtMip and margins. You could of course send out an un-MDE'd reports db
while the rest of your db is secured. You'd need to have a general function
that you could call in the reports db to spaun a report contained there.
All report queries would need to be in the reports db and the main db would
need to reference the reports db to "see" its report launch function.

All that said, in 99.9% of the cases you shouldn't be modifying things like
prtMip programatically anyhow once the report is created.