<div>
Hello david_88,<br />
<br />
DoCmd.printout<br />
<br />
What do you mean by the convert macro?<br />
<br />
Regards,<br />
<br />
Jupiler78
</div>


Hello david_88,

DoCmd.printout

What do you mean by the convert macro?

Regards,

Jupiler78

<div>
sometimes its easier to create a macro and then convert to vba which you could do in 2003
</div>


sometimes its easier to create a macro and then convert to vba which you could do in 2003

<div>
Glad I could help.<br />
Good luck and thanks for the points &amp;&nbsp;grade.<br />
<br />
Jupiler78
</div>


Glad I could help.
Good luck and thanks for the points & grade.

Jupiler78

<div>
<div class="content wysiwyg-content">
I have a report which i want to create 2 buttons 1 to preview the report and the other to print the report in 1 click ie print to deafult printer and based on page ranges saved in table.<br />
<br />
i have the below code to preview but don't know how to get that to print. &nbsp;In 2007 how do you convert a macro to vba code<br />
<br />
DoCmd.OpenReport &quot;rpt_printorders&quot;, acViewPreview<br />
<br />
dave
</div>
</div>


I have a report which i want to create 2 buttons 1 to preview the report and the other to print the report in 1 click ie print to deafult printer and based on page ranges saved in table.

i have the below code to preview but don't know how to get that to print.  In 2007 how do you convert a macro to vba code

DoCmd.OpenReport "rpt_printorders", acViewPreview

dave

Access VBA Preview / Printing Report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.