Solved

Access 2010:  How to Have a Form Only Generate Data for One Record

Posted on 2016-08-30
8
39 Views
Last Modified: 2016-09-01
Hello:

Someone built a Microsoft Access 2010 .accdb file for us.  Unfortunately, the form that we use to generate reports per salesperson from this file contains a filter but only by document date.

I need to have this form--just this one time--generate reports for only one salesperson, in particular.  I'm not Access savvy, at all!

Anyway, I do see an object of some sort on the left-hand side of the window called "salespeople".  When I open it, I can filter it by the one salesperson.  But, how do I know that the form is going to generate a report for only that one salesperson?  In other words, how do I apply this filter to that form?

This is not going to be permanent.  Again, I want to apply this filter, just this one time.

Thanks!

John
0
Comment
Question by:John Ellis
[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
  • 4
  • 4
8 Comments
 
LVL 36

Expert Comment

by:PatHartman
ID: 41776964
Without seeing the database, I can't tell you how the developer is passing in the variable.  I suggest that you go to Gigs and find someone who can log on to your system with you and make the change in a temporary copy of the database.  Unless the developer did something obscure, it should take less than a half hour.
0
 

Author Comment

by:John Ellis
ID: 41776977
No, someone should just be able to tell me how to get a form to generate a report for only one salesperson for goodness sakes.  

If I knew Access, I'm sure that even I could do it.  It's a simple question.

Unfortunately, the person who created this file is no longer with our company.

John
0
 
LVL 36

Expert Comment

by:PatHartman
ID: 41776997
Generating the report doesn't happen by magic.  There is code behind the form that is opening the report.  It might be an OpenReport method where the salesman argument is passed in.  Perhaps the query the report is based on is getting the the salesman from the open form.  Perhaps there is a table that is used to hold the criteria.

You could always open the report and just print the relevant pages.

I lost my crystal ball so I don't think I can help you.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:John Ellis
ID: 41777004
Mr. Hartman:

That final comment was not very professional.

Incidentally, you would use a crystal ball to look into the future--not the present.  

John
0
 
LVL 36

Expert Comment

by:PatHartman
ID: 41777007
For someone who knows nothing about a topic you're pretty snotty yourself.  I don't take gigs so I wasn't trolling for work.
0
 

Author Comment

by:John Ellis
ID: 41777181
The thought of "trolling for work" did not even enter my mind.
0
 

Author Comment

by:John Ellis
ID: 41778200
Hello Mr. Hartman:

I apologize, for my comment.  I was simply taken aback by the use of the phrase "crystal ball".  :)

I simply re-ran all of the reports from the Access database to PDFs saved on a network directory.  I would like to have generated reports for only the three salespeople that I had in mind.  But, the Access form does not specify criteria for "Salesperson ID"--only a Document Date range.  So, I was "stuck" and decided to ask the question here and just get some "general tips".

Again, though, I do apologize.

Thank you!

John
0
 
LVL 36

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41778260
No problem.  I'm glad you took my advice to print the reports and just send the relevant pages.  There is no way short of modifying the application to do what you are asking and that was what I was trying to tell you.  It would have been easy enough for the developer to have given you the option to print one salesman or all when he created the app.  I do it all the time.  But, with you having no knowledge of Access, I could not even give you specific directions without knowing how the developer had done the programming to begin with.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Query Top 20 from subquery 11 43
Runtime Error -2147467259 (80004005) 7 50
Open A Form without Loading All the Records of Its Recordsource 6 46
Error 438 6 16
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

733 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