Printing Access Report

[clemay]

PLEASE HELP ! I am really, really new at this Access thing. I have
gotten through many roadblocks while learing how to use Acces with
posted help from this group. However, I can't seem to find any
"detailed" step-by-step information to help be overcome my latest
challenge.

I'm using OFFICE XP at work and OFFICE 2003 at home. I have a very
simple db. Two tables, tblEmpInfo and tblLabProdInfo. I have a report
that is bases on a query that prompt the user for EmpNum and starting
and ending ShftDate. My boss wants the ability to print out a copy of
this report for each employee without having to process the report
100+ times each week....she wants an "ALL" option.

I've seen and tried a few examples of setting up a multi selection
list box, even tried one exampe using the Northwind db but have had no
luck.

If anyone out there can help me out I sure would appreciate it.
Thx
NW

 

[Duane Hookom]

We don't know which solutions you have tried and why you didn't have success.
Allen Browne has a solution at http://www.allenbrowne.com/ser-50.html. There
is a generic function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[clemay]

We don't know which solutions you have tried and why you didn't have success.
Allen Browne has a solution athttp://www.allenbrowne.com/ser-50.html. There
is a generic function athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

WOW...thx for getting back to me on this so quickly. I was able to get
the code and instructions that you suggested me to, that Allan Brown
designed and posted, to work. However, the results weren't exactly
what I need. Long story short, I went with plan "B". I redesigned my
report, a summary report, grouped it by EmpNum this time as well as
LstDayWk. I then placed the totals I need in the LstDayWk footer,
placed my report header info in the Pg Hrd section with the actual
page header info, placed a page break in the EmpNum footer and then
deleted any info I don't need to display and closed the remaining
sections (except page footer). I then added a Between[ ]AND[ ] user
prompt to my EmpNum and ShftDate field in the query that drives my
report. The results, though maybe not the most elegant db design, is
that I am able to print out a page of the needed information for each
employee, with only their labor information on that page and with the
appropriate header information.

Again, thx for your help. This web sight and the folks the contribute
have been a real help.

BW