Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Printing Forms

Printing Forms

ResolvedVersion 2003

Fri 8 May 2009, 15:51 Delegate Charlotte said...

Charlotte has attended:
Access VBA course

Printing Forms

Is there a way of printing just the first record from a form instead of all?

Mon 11 May 2009, 11:22 Trainer Stephen said...

RE: Printing Forms

Hi Charlotte

Thank you for your question

You can use the printout method of the DoCmd object. This method allows you to specify a start and finish page of the form or report in question.

For example

DoCmd.PrintOut acPages, 1,1

prints the first page of the active form

Hope this is useful

Regards

Stephen

Mon 18 May 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:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

Printing Forms

Printing Forms

RE: Printing Forms

Access articles

Access tip:

Using the Quick Access Toolbar in Access 2010