Creating a Macro to Print Screen

Resolved · High Priority · Version 2003

Fri 22 May 2009, 10:54 Delegate Sandip said...

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

Fri 22 May 2009, 15:52 Delegate Sandip said...

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?

Mon 20 Jul 2009, 09:39 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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