S
Steve'o
SQL Server 2000 SP3a
Access 2000 SP3 (.ADP)
I have a report and would like to do one of the following:
1. Choose Page Setup and OK (but so nothing pops up to the user, as we are
using the docmd.outputto command and need for page setup ok to occur
"silently")
2. Set the page margins from vba
I've googled, but not found anything, does anyone know how to do EITHER of
these, could someone point me to a link or help or.
Im stuck as I have a report which does not format properly, and my simply
clicking Page Setup then OK (not changing anything) it sorts the formatting.
I've tried compact+repair, import to new database, re-create report from
scratch. etc
I would luv to have a vba command to silently go Page Setup then OK.
Many thanks for any info!
Access 2000 SP3 (.ADP)
I have a report and would like to do one of the following:
1. Choose Page Setup and OK (but so nothing pops up to the user, as we are
using the docmd.outputto command and need for page setup ok to occur
"silently")
2. Set the page margins from vba
I've googled, but not found anything, does anyone know how to do EITHER of
these, could someone point me to a link or help or.
Im stuck as I have a report which does not format properly, and my simply
clicking Page Setup then OK (not changing anything) it sorts the formatting.
I've tried compact+repair, import to new database, re-create report from
scratch. etc
I would luv to have a vba command to silently go Page Setup then OK.
Many thanks for any info!