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

microsoft access

Forum home » Delegate support and help forum » Microsoft Access Training and help » Microsoft Access 2007

Microsoft Access 2007

ResolvedVersion Standard

Matthew has attended:
Access Introduction course
Access Intermediate course

Microsoft Access 2007

Is there anyway of saving a template that you have created for a report or a form so that this can be used and then imported on the future?

Thanks

Matt

RE: Microsoft Access 2007

Hi Matt, Thank you for the post, in answer to your question; because the report is dependant upon an underlying query or table, you are restricted in how much you can pre-create, but there is no reason why you could not create a template ie a (blank report) with the appropriate formatting and design labels in particular areas which you can then populate with the appropriate fields when you need to use it.
In order to point your 'template' at the right table or query you will need to change its Source in the Report Properties though.
I hope that helps, best regards Pete.

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.