Solved

customize reports

Posted on 2013-12-28
4
246 Views
Last Modified: 2013-12-30
Is there a way to create your own customized report template?
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 12

Expert Comment

by:pdebaets
ID: 39744203
Do you mean create a report layout in design view, only without any fields, then save it. Then copy it to a new name when you want to create a new report?
0
 

Author Comment

by:Connie Campbell-Pearson
ID: 39744227
I have always used the wizard and then had to change everything. I did experiment with a design as you said. I was wondering about customizing my own theme. Is that possible?
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39744229
You can define a single report as the Access default when you create a new report. This is not selectable at the time you want to create a new report however.
 
The only other way is to create a report and save it as a report and then copy and paste it into your project. It will immediately ask you to name it. This is how I do it anyway. I would be interested in finding a simpler way.
0
 
LVL 37

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39745308
Yes.  Once you create the template, you tell Access to use it by setting the FormTemplate and ReportTemplate properties under the Object Designers section of Access Options in A2007 and A2010.  You can also do it with earlier versions but you probably get to the setting though Tools/Options.

What you can define with the templates is limited.  Here is what the help entry says:
When you create a form or report without using a wizard, Microsoft Access uses a template to define the default characteristics of the form or report.

The template determines which sections a form or report will have and defines each section's dimensions. The template also contains all the default property settings for the form or report and its sections and controls. However, a template doesn't create controls on a new form or report.

The default templates for forms and reports are called Normal. However, you can use any existing form or report as a template. You can also create a form or report to use only as a template. Changing the template doesn't have any effect on existing forms or reports.

Microsoft Access saves the settings for the Form Template and Report Template options in your Microsoft Access workgroup information file, not in your Microsoft Access database (the .mdb file) or Microsoft Access project (the .adp file). When you change an option setting, the change applies to any Access database or Access project you open or create.

If your templates are not in an Access database or Access project, Microsoft Access uses the Normal template for any new forms and reports you create. However, the names of your templates appear in the Form Template and Report Template options in every Access database or Access project in your database system, even if the templates are not in every Access database or Access project.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question