Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Microsoft Access Help


  • Please log in to reply
2 replies to this topic

#1 Pookers27

Pookers27

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:06:33 AM

Posted 03 June 2005 - 09:11 AM

I have a database that I have created an Access form and report for. The problem is I would like to print out one report at a time for the current data on the screen in the Access form, not for the entire database as it keeps trying to do. When I try to even just view a report for the current information on the screen it gives me the report for the first client in the database, not the current client I am looking at on the screen. If anyone can help me solve this problem, I would appreciate it!!

BC AdBot (Login to Remove)

 


m

#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,568 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:06:33 AM

Posted 13 June 2005 - 10:19 PM

I don't know how you built your form and report, so can't be too specific at this time.
I gather from your post that the form displays all records in a continuous stream.
That can be changed.

Or, if you don't want to change, perhaps you can find on which page the record is and tell the printer to just print that page, but unless you have clear breaks between the records and specified in the properties to separate them, you might end up with pieces of surrounding records on the printed page.

You can try writing a query behind the form to display a record at a time.
That will definitely limit the printing to what you want.
Or do so in the query behind your report.

I think the bottom line is that you need to tweak the properties of the form and/or report. I don't recall the properties names at the moment, but can check in the office in a few days if your review gets you nowhere.

Did you check Access help? Look for stuff like record selection, print records, form design, etc.

#3 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,568 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:06:33 AM

Posted 14 June 2005 - 07:28 AM

I dug out few magic words that might help.
Relevant search items in Access help are: record source, parameter query.
Reportís Record Source property is a parameter query.
For parameter query, in design view enter, in the Criteria row, what question(s) to ask the user when the query/report runs or whatever constants you need to limit the query to.

General report and query design items are useful also if you havenít been there already.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users