98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Printing Forms
Printing Forms
Resolved · Medium Priority · Version 2003
Fri 8 May 2009, 15:51Delegate 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:22Trainer 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,1prints the first page of the active form
Hope this is useful
Regards
Stephen
Mon 18 May 2009: Automatically marked as resolved.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
