Solved

How do print by selecting field in access 2007 ?

Posted on 2011-03-16
8
295 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 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