Print Preview show my whole database

[sgiuffrida]

I am running access 97. I have 2,400 employees in the database. When i want to print the screen, i select print preview and print selected records and the whole database wants to print. I see the print progress go through all 2,400 screens and attempt to print every person in the system.

The other strange thing is that if i pull up a person named Hogen, John and attempt the print the screen my print preview shows the first screen in the database Adams, Sandy. Then, if i scroll to find Hogen, all the names are out of order. This is driving me insain, i have shrunk the screens and moved sub forms around with no help...



Is there a linking tool to see where the printing is attaching to the database? Has anyone seen this strange accurance?

Thanks steve

 

[WayneRyan]

Steve,

You don't want to produce reports that way.

First, go to the database window and design a new query
based on your table. Then experiment by putting things
in the criteria field like:

Like "Smit*"

in the name field.

Then run your query.

After doing this make a new report, using the wizard, based
on your query.

Experiment a little (with a copy of your database) and
let us know.

Wayne

 

[sgiuffrida]

how do i pull the report dynamiclly by name

Thanks that worked well, but i need the statement in the crieria field to pull the report of the person whose page i am viewing.

Here i am on Joe Blows page, he has all his information on the screen. How do i set up a button on the page that pops open a report with JUST his name and the information ONLY being viewed on the screen.

I just need a statement that points the report ONLY to that person. Do you have any thoughts on how to do this. you have been a big help thanks for your time.. Steve

 

[WayneRyan]

Steve,

Make a query based on your table.

In the name field enter this for criteria:

=Forms![YourFormName]![NameField]

Then use this query as the source of your report.

Wayne