Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Creating a Macro to Print Screen

Resolved · High Priority · Version 2003

Reply Fri 22 May 2009, 10:54Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Fri 22 May 2009, 15:52Delegate 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?

Reply Mon 20 Jul 2009, 09:39Trainer 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.

Access articles

· Microsoft Access 2007: New Features
· Access Corruption Avoidance Tip #1: Split Your Database
· Getting to grips with Access 2007's Opening Screen and User Interface
· How To Take Control Of Your Data And Save Money In The Process
· Record, Find And View Data Easily Thanks To Microsoft Access

Please browse our web site to find out more about
access+vba+courses+london and other Microsoft training courses.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips