Solved

How do print by selecting field in access 2007 ?

Posted on 2011-03-16
8
294 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
8 Comments
 
LVL 57
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 500 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 92

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
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 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…

861 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now