creating macro print screen

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Creating a Macro to Print Screen

Creating a Macro to Print Screen

resolvedResolved · High Priority · Version 2003

Sandip has attended:
Excel VBA Intro Intermediate course

Creating a Macro to Print Screen

Hi,

I am wondering if it is possible to record/set a VBA macro that will enable the user to take a print screen of the Access form and print the page?

Thanks

RE: Creating a Macro to Print Screen

Further to the above,

I have just added a button with the command Print to the form. (Through the wizard). The only problem is it prints over 4 pages.

Is there any piece of coding I can add that will enable the user to print on one A4 page?

RE: Creating a Macro to Print Screen

Hi Sandip

Thank you for your question

I apologise for the delay in replying. I have been away from work for some time due to illness. I realise that you may have already solved this problem, if this is not the case could you please advise me so that I can give it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.