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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing Access Report
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 |
#2
|
|||
|
|||
Printing Access Report
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/O...p#Hookom,Duane -- Duane Hookom Microsoft Access MVP " wrote: 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 |
#3
|
|||
|
|||
Printing Access Report
On Aug 14, 5:16 am, Duane Hookom
wrote: 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 -- Duane Hookom Microsoft Access MVP " wrote: 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 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 |
Thread Tools | |
Display Modes | |
|
|