?
Solved

How do print by selecting field in access 2007 ?

Posted on 2011-03-16
8
Medium Priority
?
301 Views
Last Modified: 2013-11-29
I have table in access 2007 i wana to make Reprot to this table , but i wana to be selecting field , i don't want to print all field just selecting the field that i want to printed it .
0
Comment
Question by:HawzhenJR
[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
8 Comments
 
LVL 58
ID: 35146584
<<I have table in access 2007 i wana to make Reprot to this table , but i wana to be selecting field , i don't want to print all field just selecting the field that i want to printed it . >>

  Create a query based on the table and include only the fields you need.  Then set the reports recordsource to that query.

JimD.
0
 

Expert Comment

by:satishmp
ID: 35146601
HI ,

Check this link

http://www.databasedev.co.uk/multi-column_report.html

Regards
Satish
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35148355
Will this "Print Field" always be the same?
Or are you truly wanting to "Select" a field to print?
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:HawzhenJR
ID: 35153950
Its not the same filed , befor printing i wana to select defrent field
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35154415
Quick and dirty sample (Modified from a previous Question)

You must be familiar with VBA coding

You will have to modify this to work in your database.

;-)

JeffCoachman
Access--EEQ26890196SelectHideSho.mdb
0
 
LVL 31

Expert Comment

by:Helen Feddema
ID: 35184747
Do you mean that you want to select a field to display on the report, or filter the report by a value in a selected field?  If you want to filter by a field value, see my Access Archon #129.  Here is a link for downloading it:

http://www.helenfeddema.com/Files/accarch129.zip

and here is a screen shot of the form:
Fancy-Filters-Form.jpg
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 35410246
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Industry Leaders: 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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…
Suggested Courses

770 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