A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with printing from Access!



 
 
Thread Tools Display Modes
  #1  
Old February 26th, 2009, 11:21 PM posted to microsoft.public.access.gettingstarted
Carra
external usenet poster
 
Posts: 5
Default Need help with printing from Access!

I am VERY new to Access; the previous person at my office set up Access to
print out end of year donation letters. I was able to edit the donation
letter but cannot print all of them out.
When I print out a periodic summary (in reports) and use the dates 01-01-08
to 12-31-08 all of the people who donated during 2008 (approx 400) are
listed. However when I try to print out the actual letters (in reports)
using the same dates only 38 letters come up.
I have no idea what to do - I have never worked in Access before and am
"learning while doing."
Can anyone please help? It is very much appreciated
  #2  
Old February 27th, 2009, 06:09 PM posted to microsoft.public.access.gettingstarted
Fred
external usenet poster
 
Posts: 1,451
Default Need help with printing from Access!

It sounds like you are using an application that was developed by somebody.
If so, you might try fishing around for any instructions, notes, etc. (in the
screens, on paper etc.) that relate to what you are trying to do.

Otherwise I think that you are missing too many things to come up with a
quick answer...on this forum or otherwise. You'l probalby need to get
several hours of help from somebody who knows Access well to figure out what
you have and how it works.
  #3  
Old February 28th, 2009, 06:09 PM posted to microsoft.public.access.gettingstarted
Damon Heron[_3_]
external usenet poster
 
Posts: 257
Default Need help with printing from Access!

Without knowing how the db was set up, it is very difficult to diagnose -
but, I would first try to reduce your
date range to months (1/1/08 - 1/31/08) and see how many letters are
printing.

Damon

"Carra" wrote in message
...
I am VERY new to Access; the previous person at my office set up Access to
print out end of year donation letters. I was able to edit the donation
letter but cannot print all of them out.
When I print out a periodic summary (in reports) and use the dates
01-01-08
to 12-31-08 all of the people who donated during 2008 (approx 400) are
listed. However when I try to print out the actual letters (in reports)
using the same dates only 38 letters come up.
I have no idea what to do - I have never worked in Access before and am
"learning while doing."
Can anyone please help? It is very much appreciated



  #4  
Old February 28th, 2009, 07:06 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Need help with printing from Access!

On Thu, 26 Feb 2009 15:21:01 -0800, Carra
wrote:

I am VERY new to Access; the previous person at my office set up Access to
print out end of year donation letters. I was able to edit the donation
letter but cannot print all of them out.
When I print out a periodic summary (in reports) and use the dates 01-01-08
to 12-31-08 all of the people who donated during 2008 (approx 400) are
listed. However when I try to print out the actual letters (in reports)
using the same dates only 38 letters come up.
I have no idea what to do - I have never worked in Access before and am
"learning while doing."
Can anyone please help? It is very much appreciated


Well... we cannot see your database from here and have no way to know what
might be wrong. It would seem that there is an error in the report, or in the
query upon which the letter report is based. You'll need to fix this error to
get the reports.

Are the "actual letters" printed from an Access Report? If so, open the Report
in design view; view its Properties; find the "Record Source" property on the
data tab. It should be a query (again, I can't see it so I don't know what
this person did!). If it's a query, click the ... icon by the property to open
the query design window; select View... SQL; and post the cryptic SQL text to
a message here.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.