Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

Posted on Sep 10, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

I created a drop down list in access to save time. Is there a way to print only what is selected in a drop down list when using reports

1 Answer

Tim Babcock

Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

  • Microsoft Master 2,794 Answers
  • Posted on Sep 17, 2008
Tim Babcock
Microsoft Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Joined: Jun 06, 2008
Answers
2794
Questions
13
Helped
1128433
Points
7249

If you build a query based on the drop down list in the report, you can do it that way.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How to read meter on mfx-3530?

You can print the machine's information and job report.
1. Press Menu on the control panel.
2. Press the up/down arrow to highlight System Setup and press OK.
3. Press the up/down arrow to highlight Reports and press OK.
4. Press the up/down arrow until the report or list you want to print appears.press OK.
To print all reports and lists, select All Reports.
5. Press the left/right arrow to highlight Yes at the Printing? prompt and press OK
tip

Excel - Drop Down List Ever wish that you didn't have to type...




Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

tip

How do I create custom Barcodes?

<p>Barcodes can be printed symbols with encoded data will be charged to the computer via a scanner. A bar code allows a company to maintain control of their actions to secure and instant access to information about each product. A bar code is created using software barcode generation software. Customizing a bar code is a simple process to enter your data into the software program, and print.<br /> <p> <br /> <p>1. Open your Web browser and visit Barcode Generator, barcode or Soft. See the program's interface is usually presented on the homepage of the website page. Look at the list of different types of bar codes available, and click the type of barcode you want to use. <br /> <p><br /> <p>2. Locate the area where you are allowed to present the information is converted into a bar in, and within the data type. Click "Generate Barcode" to create barcode images. View the image resulting bar code, right click on the image and click "Save image as" in the drop-down menu to save the resulting image on your computer. <br /> <p><br /> <p>3. Close the program bar code generation, and open the bar code image stored on your computer. Right click on the saved image and click "Print" from the output drop-down menu to print the bar code. Scan the bar code information printed to be loaded on your computer and check the data sent to make sure it is correct. <br />
on Jun 26, 2011 • Computers & Internet
0helpful
1answer

Please teach me how to use my HPF4185 to print envelopes. Thanks.

Hi

Use the product software, also known as the printer driver, to change the print settings for your envelope size and type. Then, use the Envelopes and Labels tool in Microsoft Word to select your envelope size.

Step one: Adjust the print settings

-In Microsoft Word, click File , and then click Print .
-Make sure that your product is in the Name drop-down list box, and then click Properties .
-Click the Features tab, or the Paper/Quality tab.
-Select an envelope size from the Size drop-down list.
-If the required paper size is not in the drop-down list, follow these steps to create a custom paper size.
-Select Custom from the drop-down list.
-In the Custom Paper Size dialog box, type a name for the new custom size.
-In the Width and Height boxes, type the dimensions.
-Select the unit of measurement, and then click Save .
-Click OK to close the Custom Paper Size dialog box, and then click OK again to close the Properties dialog box.
NOTE: You must exit the Properties dialog box to apply your changes.
Open the Properties dialog box again, and select the new custom size from the Size drop-down list.
-Select the paper type.
-In the Paper Type or Type is drop down list, click More .
-Click the desired paper type, and then click OK .
-Select the paper source from the Paper Source drop-down list.
-Change any other settings, and then click OK to close the Properties dialog box.

Step two: Set the correct envelope size

-Set the correct envelope size in the Envelopes and Labels dialog box before printing envelopes.
-In Microsoft Word, click Tools , click Letters and Mailings , and then click Envelopes and Labels .
-In the Envelopes and Labels dialog box, click the Envelopes tab.
-Click Options .
-From the Envelope size drop-down list, select the required paper size. If you created a custom paper size, select the new custom paper size from the drop-down list.
-Click OK , and then click Close to close the Envelopes and Labels dialog box.
-Click File , and then click Print to print the envelope.
NOTE: When you finish printing the envelopes, return the paper size and the paper type settings to the defaults.

Regards
Riztech
1helpful
1answer

I REPLACED MY INK CARTRIDGES. I WAS PROMPTED TO

Ignore the error and continue printing. The print job might still be acceptable even if the paper size and paper type settings are not an exact match.
  1. Press Enter on the control panel to clear the error message.
  2. Try the print job again.
  • If these steps resolved the issue , you do not need to continue troubleshooting.
  • If the issue persists , continue to the next solution.
    Use the HP product software, also known as the printer driver, to change the print settings for your paper size and type depending on your version of Microsoft Word.
    1. In Microsoft Word, click File , and then click Print .
    2. Make sure that your HP product is in the Name drop-down list box, and then clickProperties .
    3. Click the Features tab, or the Paper/Quality tab.
    4. Select a paper size from the Size drop-down list.If the required paper size is not in the drop-down list, follow these steps to create a custom paper size.
      1. Select Custom from the drop-down list.
      2. In the Custom Paper Size dialog box, type a name for the new custom size.
      3. In the Width and Height boxes, type the dimensions.
      4. Select the unit of measurement, and then click Save .
      5. Click OK to close the Custom Paper Size dialog box, and then click OKagain to close the Properties dialog box. NOTE: You must exit the Properties dialog box to apply your changes.
      6. Open the Properties dialog box again, and then select the new custom size from the Size drop-down list.
    5. Select the paper type.
      1. In the Paper Type or Type is drop-down list, click More .
      2. Click the desired paper type, and then click OK .
    6. Select the paper source from the Paper Source drop-down list.
    7. Change any other settings, and then click OK to close the Properties dialog box.
    8. Try the print job again.
      Paper mismatch errors occur because the printer scans the width of the paper before printing. If the paper size setting in the printer driver does not match the paper actually loaded in the printer, the printer reports a 'Paper Mismatch' or 'Paper too Narrow ' error.The error message might also display when you load the correct paper, just reinstall the printer driver if above procedure does not helps. Thanks. keep updated for any more query.you can rate this solution and show your appreciation.
2helpful
2answers

How do I backup the D880 phonebook list so that it can be printed easily? Thank you

try to do these steps..
1. run and install samsung pc suite on your computer.
2. after a successful installation, connect your phone through usb
3. on your pc suite, select tools, select phone book manager
4. synchronize your phone to the pc,
5. once sychronized, create a back up of your contacts,
6. select from the drop down list csv extension file. press okay and it will ask you where you wanted to save it.
7. select from your my document folder the appropriate storage, example, NPS folder and press save. it will create a back up for your contacts.
8. to print the contacts, go to your my documents folder, NPS folder, right click the file, select open with , select excel. you can now print your contacts.
0helpful
1answer

How can i generate incoming call report ?

To print a report:
  1. Press the [Menu] button on the Control Panel, until Reports is displayed on the top line of the Display Screen. The Phone Book menu item will be displayed on the bottom line.

    wcpe16-menu-but.jpg

  2. Press the right or left arrow button to scroll until the report or list you want to print is displayed on the bottom line.
    • Phone Book: Phonebook list
    • Sent Report: Sent fax report
    • RCV Report: Received fax report
    • System Data: System data list
    • Scheduled Jobs: Scheduled job information
    • MSG Confirm: Message confirmation
    • Junk Fax List: Junk fax number list
  3. Press [Enter] to print the selected information.
Your machine can print reports containing useful information. The following reports are available:
  • Phonebook List: This list shows all of the numbers currently stored in the machine's memory as Speed Dial and Group Dial numbers. You can print this phonebook list using the [Phonebook] button.
  • Sent Fax Repor: This report shows information of the faxes you recently sent.
  • Received Fax Report: This report shows information of the faxes you recently received.
  • System Data List: This list shows the status of the user-selectable options. You may print this list to confirm your changes after changing any settings.
  • Scheduled Job Information: This list shows the document currently stored for Delayed faxes or Toll Save faxes. The list shows the starting time and type of operation.
  • Message Confirmation: This report shows the fax number, the number of pages, the elapsed time of the job, the communication mode, and the communication results. You can set up your machine to automatically print the message confirmation report after each fax job.
  • Junk Fax Number List: This list shows up to 10 fax numbers specified as the junk fax numbers by using the Junk Fax Setup menu. When the Junk Fax Barrier feature is turned on, incoming faxes from those numbers will be blocked. This feature recognizes the last 6 digits of the fax number set as a remote fax machine’s ID.
  • Multi-Communication Report: This report is printed automatically after sending documents from more than one location.
  • Power Failure Report: This report is printed out automatically when power is restored after a power failure, if any data loss occurs due to the power failure.

NOTE: The lists you have set to automatically print out will not print out when there is no paper loaded or a paper jam has occurred.
0helpful
1answer

I have a Stylus photo printer R1900

There are two different ways to create a custom page size within the Epson printer driver on Windows 2000 or XP. The method you need to use will vary depending on what type of driver is installed.
CREATING A CUSTOM PAPER SIZE IN SERVER PROPERTIES
This method will create a new page size accessible by all printer drivers installed in Windows.
1. Open the PRINTERS (2000) or PRINTERS and FAXES (XP) window.
2. Click on FILE, then select SERVER PROPERTIES.
3. On the FORMS tab, place a check beside CREATE A NEW FORM.
4. Input a new name for the paper size. Enter the desired height and width, following the existing format (#.##in).
5. Click SAVE or SAVE FORM to add the new form size to the list, then close SERVER PROPERTIES.
6. Right click on the printer name and left click PRINTING PREFERENCES.
7. Look for PAPER SIZE. (Depending on the driver in use, this will be found on the MAIN tab, the PAPER tab, or under the ADVANCED button). Select your custom paper size from the list.
8. Click APPLY to save this setting, or OK in Windows XP.
NOTE: If your new custom size is not available on the list of preset paper sizes, it indicates that the new size is either too large or too small for the driver in use.
CREATING A CUSTOM PAPER SIZE WITHIN THE EPSON DRIVER
This method will create a custom size within the Epson printer driver only.
1. Open the PRINTERS (2000) or PRINTERS AND FAXES (XP) window.
2. Right click your Epson printer name and left click PRINTING PREFERENCES.
3. On the MAIN or PAPER tab, select USER DEFINED from the PAPER SIZE drop down box.
4. Enter the new custom size and give it a name. Click SAVE to save the new size and OK to return to MAIN.
5. Click APPLY to save the changes (OK in Windows XP).
NOTE: this method is not available when using printer drivers resident within Windows itself. If your printer driver name ends in "ESC/P2" you will need to use the first method to add the new size in SERVER PROPERTIES.
18helpful
3answers

Using drop-down form field in a word 2007 template

You need to protect the form (Protect Document, Editing Restrictions (Filling in Forms) then Start Enforcing Protection, the drop down menu will then work.
0helpful
1answer

Printing on 4x8 cards

There are two different ways to create a custom page size within the Epson printer driver on Windows 2000 or XP. The method you need to use will vary depending on what type of driver is installed.
CREATING A CUSTOM PAPER SIZE IN SERVER PROPERTIES
This method will create a new page size accessible by all printer drivers installed in Windows.
1. Open the PRINTERS (2000) or PRINTERS and FAXES (XP) window.
2. Click on FILE, then select SERVER PROPERTIES.
3. On the FORMS tab, place a check beside CREATE A NEW FORM.
4. Input a new name for the paper size. Enter the desired height and width, following the existing format (#.##in).
5. Click SAVE or SAVE FORM to add the new form size to the list, then close SERVER PROPERTIES.
6. Right click on the printer name and left click PRINTING PREFERENCES.
7. Look for PAPER SIZE. (Depending on the driver in use, this will be found on the MAIN tab, the PAPER tab, or under the ADVANCED button). Select your custom paper size from the list.
8. Click APPLY to save this setting, or OK in Windows XP.
NOTE: If your new custom size is not available on the list of preset paper sizes, it indicates that the new size is either too large or too small for the driver in use.
CREATING A CUSTOM PAPER SIZE WITHIN THE EPSON DRIVER
This method will create a custom size within the Epson printer driver only.
1. Open the PRINTERS (2000) or PRINTERS AND FAXES (XP) window.
2. Right click your Epson printer name and left click PRINTING PREFERENCES.
3. On the MAIN or PAPER tab, select USER DEFINED from the PAPER SIZE drop down box.
4. Enter the new custom size and give it a name. Click SAVE to save the new size and OK to return to MAIN.
5. Click APPLY to save the changes (OK in Windows XP).
Not finding what you are looking for?

46 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...