Question about Microsoft Access 2002 for PC

1 Answer

Selected fileds to print

I want to print only selected fields in reports during run time of reports.

Posted by on

  • shailajam Oct 21, 2008

    I am unable to view the solution.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 52 Answers

Start by looking under FILE, PRINT AREA, SET PRINT AREA

Posted on Oct 19, 2008

  • Dennis Gladieux
    Dennis Gladieux Oct 21, 2008

    Dear Shailajam,
    I will try to copy my actions as I do the requested task.
    I have opened the spreadsheet that I want to print only the selected data from.
    I left click and hold to drag and highlight the area that I want to print.
    I select "FILE" from the upper row of menu items.
    I select "PRINT AREA" from the drop down list
    I select "SET PRINT AREA" from a choice of two from a list of options.
    A very slightly visible dashed boarder appears around the selection of the click and draged area that I want to print.
    To change the selection I can go to edit at the top of the menu of the spread sheet and select "UNDO SET PRINT AREA" from the options presented in a drop down list.

    THE TRICK is to select what you want to print BEFORE you go to File, Print area, Set print area.

    You can select what you want to print by "Click and Drag" for an area or "Select" a cell and then "Shift+Select" for a range of cells or "Select and "Cntrl+Select" for random cells.

    Happy to be of assistance.
    Please evaluate my assistance even if bad, I can learn from any evaluation.



×

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

End of Day report is not printing correctly on the Epson printer. The output seems to be too wide for the printer and the right half of the report is not showing up. What should parameters be set to?


Start by checking the obvious. In FRIENDLY PRINTER SETUP, highlight report and select the proper printer on the right. It must be a full size printer. SAVE AND EXIT.
If those settings were OK, close RPE and open the windows PRINTER screen. Right click on the EPSON printer for reports and click on printer properties. In the properties dialog box, click on PRINT TEST PAGE. If the test page look fine, the printer should work with RPE.
Try other reports under the ADMINISTRATOR setting in RPE. If they are all printing OK, you may have a corrupt END of DAY report file. Reloading RPE should correct this, but all you really need to do is replace the bad file. If you have more than one PC running RPE, you can get this file from them. It is usually under C:\program files\cre.net\reports.

B Mattern
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.

Jan 13, 2011 | Pc America Restaurant Pro Express

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Business & Productivity Software

2 Answers

I would like one-time access to iWork (dont want to buy it)


Copy the document to a USB memory-stick, and take it to any friend (or to a computer-store) who has installed the software, and "save as Word Document".

Sep 11, 2009 | Apple iWork '06 for Mac

1 Answer

Trouble inserting a different picture for each record. Want to link to file on another drive, and want the pictures to show up in a report.


A bound object is an object displayed within a field of a record in a table. Access can display the object in a form or print it on a report. A Bound object is bound to an OLE object data type field in a table. If you use a bound object in a form, you can add and edit pictures record by record.
An Unbound object is not stored in a table, it is placed on the form or report. An Unbound object control is the equivalent of a label control. To display the object for each record, you must place that field in the Details section of the form or report. Does this help?

May 30, 2009 | Microsoft Access 2002 for PC

1 Answer

Income from some accounts not reported in profit/loss report


Go into the report and select "Customize" and be sure these new accounts are turned on (checked) to be added to your report results.

Apr 09, 2009 | Intuit QuickBooks Premier 2009 Full...

1 Answer

Printing previous reports in MYOB


save file into a .ZIP file then un Zip the file and it should help to change things or print reports. BUT, ALWAYS BACK UP A COPY OF YOUR FILE FIRST.

Mar 08, 2009 | Myob Accounting Plus (BPJUBC00) for PC,...

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Business & Productivity Software

1 Answer

How to print only selected fields in ms access.


open your table in query, follow steps to do this...

1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.

hope this will help you....

Oct 22, 2008 | Microsoft Access 2002 for PC

1 Answer

Conditional Formatting doesn't work until I select the item


the mouser is equip with shortcut of any of program by using right click pointing to item.

Oct 15, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Access 2002 for PC Logo

Related Topics:

64 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...