Solved

new to access: How to limit data in reports

Posted on 2004-08-01
3
289 Views
Last Modified: 2008-03-06
i want to create a report that will be limited on a value I pass in to it. I've never used access before so i want to see which options are available for that and which you would recommend (and how to use them :).  I need a walk through like even how to pass the value to the report.

Thanks
David
0
Comment
Question by:NHBFighter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
flavo earned 100 total points
ID: 11689583
To open a report say from a button use,

Private sub cmdMyButton_Click()
    Docmd.openReport "rptMyReport", acViewpreview, , "ID = " & Me.id.Value
   '                              report name,   view                , where condistion (without where key word)
End sub

this example will open the report name rptMyReport and only show records where the id = the value ID from the form.

idea??  more help???  

Dave
0
 
LVL 4

Author Comment

by:NHBFighter
ID: 11689780
Thanks That did what I wanted!!
0
 
LVL 34

Expert Comment

by:flavo
ID: 11689799
Cheers mate!
Good luck!

Dave
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question