Query Print Preview - Save Page Settings??? 1

[vivasuzi]

Hi

I have a macro set to open up my query in print preview and then print it out. However, I can't figure out how to get the print preview to retain the settings I want (ie .25 margins, landscape, specific printer) I tried to set this info, but it forgets this it all evertime it runs. I'm used to reports where you just hit save and it remembers your page settings.

Is there any way to save or use some code to change the print preview so it uses the margins and printer I want??

Just so you know, the reason I didn't make a report is because it is a crosstab query in which the columns change depending on user entry. Also they prefer to see it as a spreadsheet, which the print preview does very well.

I would like to make this all happen at the touch of a button, but if there is no easy solution I'll just teach my users how to change the page settings to print it.

Thanks! You got til monday to think about it :-D Have a good weekend!

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[dhookom]

I don't think this can be done. I have seen this same question asked in other public news groups and the consensus was it can't be done so use a report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

they prefer to see it as a spreadsheet
Why not using the DoCmd.TransferSpreadsheet method and the formatting the Excel sheet with OLE Automation ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[vivasuzi]

Why not using the DoCmd.TransferSpreadsheet method and the formatting the Excel sheet with OLE Automation ?

B/c i have no idea how to do that

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[vivasuzi]

Ok, update since I noticed I never updated. I made a macro to transfer the spreadsheet. It's not as nice as a report would have been, but do to the constantly changing information, they'll deal. Luckily I found out they only need this spreadsheet 4 times a year (once every quarter) so they don't mind having to edit it in excel to make it look nice.

Thanks!

*Suzanne*

http://www.vivasuzi.com