Template Trouble w/ Access 2007

[Newbie Non-Profit]

I'm a VERY new user to Access and thought I'd make my learning easier by
using a template. Well.

I've input all my data onto a Charitable Contributions template from the
Office website, and now am attempting to print statements for each
contributor for tax purposes. I'm following the instructions I'm finding
(I've tried to join the contibutors table to the donations table, etc.) but
some of the instructions don't seem to apply to what I'm using -- Access 2007.

For instance, when I pull up a specific contributor, I can click on the
"donations" tab on their record and SEE all the donations they've made
through the year, I just can get it to print.

I've tried a query, which has seemed to foul things up even more and I can't
find the ForceNewPage property that I was hoping would solve my problems and
make the reports print like a charm.

Any ideas?

 

[John W. Vinson]

On Mon, 21 Jan 2008 09:37:04 -0800, Newbie Non-Profit <Newbie

I'm a VERY new user to Access and thought I'd make my learning easier by
using a template. Well.

I've input all my data onto a Charitable Contributions template from the
Office website, and now am attempting to print statements for each
contributor for tax purposes. I'm following the instructions I'm finding
(I've tried to join the contibutors table to the donations table, etc.) but
some of the instructions don't seem to apply to what I'm using -- Access 2007.

For instance, when I pull up a specific contributor, I can click on the
"donations" tab on their record and SEE all the donations they've made
through the year, I just can get it to print.

I've tried a query, which has seemed to foul things up even more and I can't
find the ForceNewPage property that I was hoping would solve my problems and
make the reports print like a charm.

Any ideas?

It helps to get clear what the different aspects of Access do.

Data is stored in Tables. Data storage is (or should be, Microsoft is trying
to muddy this up with Lookup Fields and Subdatasheets) a table's only purpose,
not data display, printing, or editing.

Data is selected, sorted, and calculated in Queries. Query datasheets should
also not be routinely used for display or printing.

Data is displayed onscreen and edited using Forms; these are the users'
primary means of interacting with Access.

Data is printed using Reports.

Only a Report has "Force New Page". The report will use a Query as its
recordsource; in this case, you want to use a query which selects just one
donor's data in a criterion. But you don't need to "open" or see the query to
do this (except while you're developing it of course); just use a query with a
criterion such as

=[Forms]![YourFormName]![DonorID]

on the DonorID field in the query, referencing an open form to select which
donor, and Access will display only that donor's data on the report.

John W. Vinson [MVP]

 

[Jeff Conrad [MSFT]]

How about a new FAQ page just for you?
http://accessjunkie.com/faq_52.aspx



--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com