John Ellis
asked on
Access 2010: How to Have a Form Only Generate Data for One Record
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
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
PatHartman
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.
ASKER
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
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
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.
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.
ASKER
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
That final comment was not very professional.
Incidentally, you would use a crystal ball to look into the future--not the present.
John
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.
ASKER
The thought of "trolling for work" did not even enter my mind.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.