creat individual reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have created a simple database to track event checklists for my
office. i used a simple form for each category along with a seperate table
for each form. I need to be able to preview, print, email individual
checklist results. However when i create my reports i get all the records
from the table, how can i pull up just the most current perhaps from the
form as i imput it. any help would be great thanks Scott
 
You haven't described why you are using separate tables for each form or
what you mean by "most current" or lots of other specifications. Any reply
would most likely be a WAG.

Please try to be more descriptive about what you have and what you need.
Entering a few sample records would also help.
 
Sorry,
i am using the database for emergancy action checklists. Each form is a
diferent emergency checklist, and each table is exclusive to that checklist
form. the forms allow me to imput general information about the emergency
event such as who, what, when, where, and what steps where involved, who was
notified ect. A new checklist form must be ran for each emegency and each
time a checklist is completed for an event i need to be able to print that
information from that checklist or email it say as a snapshot file. Hope
that makes sence i aint had my coffee yet this AM
Scott
 
To print just a single record from a table, you can use a combo box on a
form to select the primary key value of your record to print. Use this value
in the where condition in the DoCmd.OpenReport. There is a sample of this
code at http://www.mvps.org/access/reports/rpt0002.htm.

Rather than use separate fields for each action, I would use a more
normalized structure similar to "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You
would be able to modify checklists without changing any table structures or
forms or reports.
 
thank you i will go review the above links. As a fairly entry level user i
am sure i will have many questions
Scott
 
ok i have found several aspects of your ATS example that would work great
for me however i am not able to understand how you built each section. do you
have a more detailed step by step talking papper on it ? IE how to build each
form, table, ect, ect ?
Scott
 
I only wanted to show you a more normalized method. At Your Survey allows
for any number of surveys which are similar to your check lists. There is a
Word document that explains some of AYS.
 
I think i worded that poorly, let me retry, is there anywhere i can find a
tutorial on how to creat such a database (with more how too's then the AYS
doc had) as you did for the AYS example. I do not wish to copy the example
simply learn how you did it
Thanks
Scott
 
Back
Top