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.



×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Why does Xerox 7335 truncates output from Oracle PDF?


It may not be the printer and I did some research on Oracle and this seems to be a common issue.
I pulled this information off an Oracle knowledgebase it may not resolve your issue and there is more info on the following site if you want to investigate further:
http://docs.oracle.com/cd/E23943_01/bi.1111/b32121/pbr_uxprt009.htm#RSPUB75727
NOTE:
If you're printing to the Xerox MFD with a PS (postscript printer driver) you could try installing and printing using the Xerox PCL driver for your computers operating system. If you printing reports from a mainframe this may be an issue at the mainframe level in which case I would engage your companies IT department for assistance.
Any one of a number of possible causes may account for the truncation of fields.
  • Check the field and determine if it is allowed to expand.
    1. In Oracle Reports Builder, double-click the field in the Paper Design or Paper Layout view to display the Property Inspector.
    2. Find the Horizontal Elasticity property.
    3. If it is set to Fixed, you should change it to Variable or Expand.
    4. Run the report to the printer.
    5. If it still truncates, it could be that the field requires multiple lines.
    6. Return to the Property Inspector for the field and check its Vertical Elasticity.
    7. If it is set to Fixed, you should change it to Variable or Expand.
    8. Run the report to the printer again.
  • If the right most fields on the page are always the ones truncating, it could be an issue with the printable area of the printer. If you are using a PCL printer, then you will have to estimate the size of the printable area and resize your margins accordingly:
    1. Open the report in Oracle Reports Builder.
    2. Go to the Paper Layout view.
    3. Click the Margin tool on the top tool bar. A thick black line appears indicating where the body of your report ends and the margin begins.
    4. Click and drag the black line to the left approximately 0.5 inches.
    5. Save and run the report to the printer again.
    6. If necessary, repeat steps 4 and 5 to determine approximately where the printable area boundary is located and then ensure that your report body fits within that area.
  • If you are using a PostScript printer, you can get the printable area boundary to appear in the Paper Layout view as follows:
    1. Open the report in Oracle Reports Builder.
    2. Choose File > Page Setup.
    3. Verify that the margins are small and that the orientation is correct.
    4. Click OK. The Paper Layout view should now be able to read the boundary.
    5. Go to the Paper Layout view.
    6. Click the Margin tool on the top tool bar. A thick black line appears indicating where the body of your report ends and the margin begins. A black hashed line also appears indicating the boundary of the printable area.
    7. Ensure that the thick black line is inside of the black hashed line. If it is not, click and drag the black line inside the printable area.
    8. Click the Margin tool to leave margin mode.
    9. If necessary, reposition your fields to fit within the new body boundaries.
    10. Save and run the report to the printer.
  • For PCL, if it is still truncating, try using a fixed space font instead of a proportional font. Sometimes PCL printers have problems interpreting proportional space fonts and it leads to truncation. You should try using a fixed space font, such as Courier, and possibly font aliasing.


    Note:
    Default layouts are built against a generic printer. Each printer has its own printable area. As a result, you may have to reset the report to fit the printer. Ideally, if you know the various printers you will be using, you can design the report from the start to fit the printer with the smallest printable area.

Mar 10, 2015 | Xerox Office Equipment & Supplies

1 Answer

How to print database in vb


To Print a Database you would require to create a Report. There were many ways of creating reports in Visual Basic 6.0. Hereby I am giving you an example of Data Report.
Printing a Data Report
Printing a data report can be accomplished in one of two ways. The user can click the Print button that appears on the data report in Print Preview mode (using the Show method), or you can programmatically enable printing using the PrintReport method. If an error occurs during printing, trap it in the Error event.
Choosing to Display a Print Dialog Box
When printing a report programmatically, you have two choices: to print by displaying the Print dialog box, or by printing without displaying the dialog box.
To display the Print dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code.
DataReport1.PrintReport True The Print dialog box allows the user to select a printer, print to file, select a range of pages to print, and specify the number of copies to print.
Note Printers must be installed on the computer in order to present a choice of printers.

Printing Without a Dialog Box
In some cases, you may wish to print the report without user intervention. The PrintReport method also gives you the option of selecting a range of pages to print, either all, or a specified range.
To print without displaying the dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code:
DataReport1.PrintReport False
Or, to specify a range of pages to print, use the code below:
DataReport1.PrintReport False, rptRangeFromTo, 1, 2

Mar 11, 2014 | Microsoft Visual Basic 6.0 for PC

1 Answer

How do I print a single call report for a FAX previously sent


Printing a fax call report
A fax call report is a brief report that indicates the status of the last fax that was sent or received.
To print a fax call report
1. On the all-in-one control panel, press Menu.
2. Use the < or the > button to select Reports, and then press .
3. Use the < or the > button to select Fax Call report, and then press .
4. Press to select Print report now. The all-in-one exits the menu settings and prints the report.
NOTE To set the fax call report to print automatically, see Setting print times for the fax call
report.


Setting print times for the fax call report

You can set the all-in-one to print a fax call report after any of the following events:
? Every fax error (the factory-set default)
? Send fax error
? Receive fax error
? Every fax
? Send fax only
? Never
NOTE If you select Never, you will have no indication that a fax failed to be transmitted
unless you print a fax activity log.

To set the print times for the fax call report
Use the following steps to set when the fax call report is printed:
1. On the all-in-one control panel, press Menu.
2. Use the < or the > button to select Reports, and then press .
3. Use the < or the > button to select Fax Call report, and then press .
4. Press the > button once to select Print report, and then press .
5. Use the < or the > button to select the option for when you want the fax call reports to be printed.
6. Press to save your selection.
The following print-time options are available:

Including the first page of each fax on the fax call report
If this option is turned on and the page image still exists in the all-in-one memory, the fax call report
includes a thumbnail (50% reduction) of the first page of the most recent fax that was sent or
received. The factory-set default for this option is On.
To include the first page of each fax on the fax call report
Use the following steps to include the first page of each fax on the fax call report:
1. On the all-in-one control panel, press Menu.
2. Use the < or the > button to select Reports, and then press .
3. Use the < or the > button to select Fax Call report, and then press .
4. Use the < or the > button to select Include 1st page, and then press .
5. Use the < or the > button to select On or Off, and then press to confirm your selection.

Jul 06, 2011 | HP LaserJet 3050 All-In-One Printer

1 Answer

How to stop to print the journal after send fax everytime?


Sending Confirmation
This report shows the fax number, the number of pages, elapsed time of
the operation, the communication mode, and the communication results.
You can set up your machine to print the message confirmation report in
one of the following ways (see page 5.3):
• Automatically after each transmission (ON)
• Automatically only if an error occurs during transmission (ERR)
• No report printed at all (OFF). You can print this report manually at
any time you want.
SENDING CONFIRM - A confirmation report shows whether the
transmission was successful or not, how many pages were sent, etc.
Select ON to print a confirmation report automatically each time you
send a fax.
Select OFF to turn this feature off.
Select ERROR to print only when an error occurs and the transmission
was not successful.

Nov 27, 2010 | Samsung SF-5100 Plain Paper Laser Fax

1 Answer

How to send mail from tally


E-mail a Invoice
To send a Invoice to a customer by email:
1. Gateway of Tally > Display > Accounts Books> Sales Register >
2. Select the required Invoice from the sales Vouchers
3. Click on Email from the button bar or press Alt+M

1. The fields on the Mailing Invoice form are automatically completed if you have given the required information during creation of the master records. Select No or press Backspace to change/modify the entries. Select Yes to accept.
2. The E-mail Server field is highlighted next. This is a mandatory field. The first time you use this feature in Tally, enter the name of your SMTP server, example: mail.btinternet.com. Subsequently, Tally will automatically display the SMTP server name. Refer to your Internet Service Provider (ISP) or network administrator for further queries.
3. The From field displays the name of your company entered in the Company Creation screen and stored in the Company Information Master records. You can also modify the default information. Press Enter.
4. The From E-mail Address field displays the e-mail address entered in the Company Information Master data. Enter your email address, if you have not done so while creating a company, or if you want to change the id.
• Enter the user name and password in Authentication User Name (Only if required) and Password field respectively if the mail server requires authentication.
• In the Format field a pop-up screen lists the three formats in which you can generate your email:
o ASCII (Comma delimited)
o HTML (web-publishing)
o XML (data interchange)
Select the type that suits your recipient.
1. To E-mail Address field is a mandatory field.

It displays the recipient's email address as entered in the Mailing and Related details during ledger creation. Enter the address if you have not done so while creating the ledger or if you want to modify the information.
1. Type the email address of another recipient to whom you want to send a carbon copy of the email in the CC (if any) field.

1. The Subject field is filled by default and displays the subject of your mail. You can change it to a subject of your choice.
• Any text you enter in the Additional Text field precedes the report in the recipient's mail program. You can use this field to type a message to the recipient.
• Additional Options provided in the form are:
o Include Post-Dated Transactions?- Set this option to Yes to include post-dated transactions.

Note: Additional Options may vary depending upon the type of report you want to email.

Print Preview: Use the Print Preview screen to view the document before emailing. This shows how the document appears in the recipient's email

Oct 31, 2010 | Tally Computers & Internet

1 Answer

Quicken will not print. Program aborts after error message: Problems communicating to printer: "Dell Photo Printer 944" The specified resource name cannot be found in the image file.


Hi,

Ensure that your printer is online and all cables are securely attached.

(i) If your printer is on a network, ensure that your network allows you permission to access the printer.

(ii) If you are printing to paper, ensure that the Quicken PDF Printer is not selected.
(iii) If you have more than one printer:

(iv) Ensure that you have selected the correct printer in Quicken. (Select the QuickenFile menu, select Printer Setup, and select the item you want to print. Be sure the correct printer shown in the Printer field. For example, if you are printing a report, select File > Printer Setup > For Reports/Graphs.)

(v)Try making another printer the default printer.
Microsoft Windows Vista:
Click the Microsoft Windows Vista logo (Start button) and select Control Panel.
Under Hardware and Sound, click Printer.

Select the printer and click the Set as default command button.

Microsoft Windows XP:

Click the Microsoft Windows Start button and select Printers and Faxes.

Right-click a printer and select Set as Default Printer.

(vi) Try printing from WordPad or Notepad to be sure Windows is communicating with your printer.

Click the Microsoft Windows Start button, select All Programs or Programs, select Accessories and select WordPad or Notepad.
Enter some text. Select the File menu and select Print.

(vii) If your file does print from WordPad or Notepad, try reinstalling the printer or printer driver.
(viii) If your file does not print from WordPad or Notepad, it probably means that Windows is not communicating with the printer. Check your Windows printer settings.
Thanks for using Fixya.
Good Luck and have a nice day.

May 25, 2010 | Computers & Internet

2 Answers

Need to print a report of past print jobs


If you have CentreWare IS you can do the following (taken from the manual):
You can find the manual link here: http://www.office.xerox.com/userdoc/P6250/6250_Web/pdfs/reference_guide.pdf

On page 97 of the manual it states:

Using Printer Management Features


Job Accounting

The printer stores information about print jobs in a log file. The log file is stored either in the
printer’s memory or on an optional hard disk if one is installed in the printer. If the log file is
stored in the printer’s memory, it is lost when the printer is reset. It is recommended that a hard
disk be used for job accounting.

The log file lists job records. Each record contains fields such as user name, job name, pages
printed, job times, and toner and ink used. Not all fields are supported by all printers. For
information go to CentreWare IS online help or CentreWare Web online help.

The job accounting values reported vary depending on the protocol and print command used
when each job was printed. For example, using NPRINT over NetWare provides the printer
with the most information about the job being printed. When using Windows and NetWare, the
job name is often LST: or LST:BANNER. Other jobs from other ports may provide less
information about the job.

Job accounting is available through CentreWare IS and CentreWare Web.
Using CentreWare IS

1. Launch your web browser.
2. Enter your printer's IP address in the browser’s Address field (http://xxx.xxx.xxx.xxx).
3. On the right side of the main CentreWare IS page, click Jobs.

The “Job Accounting Links” page provides links that enable you to browse, download, and
clear job accounting records.

For complete information on CentreWare IS job accounting, including clearing job
information, downloading job information to a file, and job accounting file formats, go to
CentreWare IS Online Help.


Hope this helps!

WizardRepair

Jul 17, 2009 | Xerox Phaser 6250DP Laser Printer

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

How to print picture wiht crystal report 8.5 using ms access ?


I am not sure if I understand your question correctly but here goes..

if you want to click on a link within crystal report and them show the picture you can use OLE..
in the tools menu click on OLE, select "Create From File" ,
select the object type eg: MS bitmap.
Select Link
Browse to folder where the image exists. and select it
you can now select a Icon or leave as is and it will display the image name..
Clikc OK

now when you run CR if you click on that link it will open and display the image..

if you just want to add a Image to CR
in the Tools Meni select Insert, Picture browse to the folder where the image is stored and select it then click OK and it will be displayed

I hope this helps



Jan 17, 2009 | Computers & Internet

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 Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...