• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

How do print by selecting field in access 2007 ?

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
HawzhenJR
Asked:
HawzhenJR
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
satishmpCommented:
HI ,

Check this link

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

Regards
Satish
0
 
Jeffrey CoachmanCommented:
Will this "Print Field" always be the same?
Or are you truly wanting to "Select" a field to print?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
HawzhenJRAuthor Commented:
Its not the same filed , befor printing i wana to select defrent field
0
 
Jeffrey CoachmanCommented:
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
 
Helen FeddemaCommented:
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
 
Patrick MatthewsCommented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now