By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,423 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,423 IT Pros & Developers. It's quick & easy.

How to print a report from a command button click in Access 2003

P: 2

Iím having difficulty getting a report in ms access 2003 to print (physically print to printer) once Iíve clicked a command button in a form. Whatís the best way to do this?

I tried connecting to a printout macro however Iíve not installed the correct wizard. Iím 6,000 miles away from my home office so installing it is more difficult than it sounds.

Is there a simple way to do this using a simple sql statement?

Thanks in advance,
Hot ~:)
Oct 30 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
You can do all this using the Command Button Wizard!

Place the button on your form. When the Wizard comes up, click on Report Operations in the left hand box and then, from the right hand box, select either Print Report (to go straight to the printer) or Preview Report (to preview before printing.) The Wizard will then walk you thru selecting the actual report you want to print.

Welcome to TheScripts!

Linq ;0)>
Oct 30 '07 #2

P: 2
Thanks Linq, glad to have found this place.

I've have an additional question why i do as you you state, is there a way i can limit the pages printed to say page 1 only, or say a sequence of pages?

Oct 31 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.