Screen or print option while printing report
Allow a default for the company or the user that can set the report option (
Screen or Print )
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8c0c7c3b...in excel; page size is adjusing, not print size on page.
I apparently have done something that when I go to print, the area which is
printed on a page does not change, only the size of the page. ie; in the
print command, I scale the size to 75%, but it reduces the actual page, does
not reduce the printed text to print more on a page. So if I put in 10%, the
worksheet displayed on the screen is 10% of the actual size vs. putting more
data on a printed page. Help.
What did I change accidentally to cause this?
...Repeated Downloading of EMail Messages in Outlook 2003
This problem has only started happening in the past few weeks with no
apparent cause as nothing has changed here on this Windows XP Pro SP2
system. Outlook 2003 SP1 has all updates applied.
In my mail settings I have Outlook set to Leave Messages on Server from my
POP3 account. I use Outlook as the master message store but this way I can
read new or retrieve an older message from anywhere. These are not MSN
Can someone tell me why this has started occurring? We're at a few hundred
e-mails that are being repeatedly downloaded (then deleted, but they keep
re...Printing long formulas
On 2004-February-Friday - 14:22:01 wa
69-144-224-231.client.bresnan.net ( Mozilla/4.0 (compatible; MSI
6.0; Windows NT 5.1; .NET CLR 1.1.4322) ) with the following I
184.108.40.206 on your boar
...Multiple mailboxes per Outlook account for send as either mailbox user using Exchange mailboxes
Using Outlook 2003 and Exchange Standard 2003 SP2. I need to have a user
open their Outlook email and be able to see and send as another user
account. For instance user Bob opens Outlook. Bob needs to see emails from
salesinfo account and be able to reply to email sent to salesinfo and the
reply needs to show as from salesinfo and not a reply from Bob or sent on
behalf of sales info.
I think I know how to do this but am looking to see if I am correct or there
is a better/easier way. The way I am thinking to try is to give Bob full
mailbox rights to salesinfo via salesinfo user account ...Printing locally when connect via RWW
When I am connected to sbs 2003 server at the office via rww I am unable to
print to my local printer which is an HP Colour Laser Jet 3800n. Is there a
way to get is printer to work with rww?
With Windows 2003 and XP and prior, you must have exactly the identical printer
name and drivers at both ends.
Typically, you can install the remote printer driver on the SBS using LPT1
and it will redirect to USB or whatever on the remote, but some USB printers
require that the printer be installed on USB and worse, some require that
the printer be phy...Repeating Macro
Is there a way to have a macro repeat a specified number of times? For
example, I have a spreadsheet that comes from my accounting software that
has about 30,000 lines. Only the first, fourth, seventh etc line is needed.
From the beginning, I need to move down a row, delete two rows, move down a
row, delete two rows until the entire data is cleaned up. I can record the
macro to delete the two lines, but I don't know how to make it repeat.
Looping in this case would be very, very, very slow. Better to sort based on a helper column, and
do one deletio...F4 Repeat Action -- not fully functional in Office 2007
My employer recently installed Office 2007 on our computers.
With Office 2003 I was able to use the F4 key to Repeat An Action, like
re-sizing a picture/image in Word. I can no longer use the F4 function to
repeat the action of re-sizing multiple images.
What can I do to restore full F4 functionality?
Thanks, in advance, for your help.
This isn't a problem with the F4 key functionality. There is a new graphics
engine, only partially implemented, in Word 2007, (it is improved in 2010)
and the changes you see are related to the fact that different processing ...Print to PDF and specify location
I'm trying to eliminate the user from selecting the directory and file name
when printing to a file. Current I have the report to print to a PDF. Can I
create code to select the file name and save location? The database is used
in a large group and our IT department will not allow me to change or add
...Lookup value with multiple results
I have a 3 column list and need to pull the value from column 2
whenever there's a value in column 1 for that row. I've been using the
following formula to accomplish this:
This works just fine, but my list is actually 9999 rows and not 99.
When I change the array from just 99 rows up to 9999 rows, I get no
values returned. I think this is because it's too big to calculate.
Can ...Multiple Identity Problem in Outlook Express
We have successfully used multiple identities in Outlook
Express for some time. Suddenly all emails are going to
one identity. We've checked the setup of the identities
and all seems correct. We are running XP with log on for
two different people. What would cause all emails to go
to one identity and how can this be corrected? Thanks.
Hi, Tim -
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if y...reports wont print
I am unable to print reports from Access 2000. This started yesterday after
making changes to a parameters form and a report to enable filtering with a
multiselect list box. I closed this db and opened another unchanged one and
was unable to print from it also. I restarted my computer but that didn't
help. This morning I also could not print a Word document. I can print a
test page from the printer setup window. I can also print from another
application(Quickbooks). This appears to be Office related. I also noticed
when closing the form I was modifing that another for...Inventory Reconcile Needed Repeatedly
We have begun to experience situations where the quantity allocated for items
in the IV00102 table are getting just totally bogus values and we need to run
inventory reconcile almost daily. When you compare the actual quantities
allocated in SOP10200, they are are not even close. I cannot see any way to
compute the numbers that were written to the IV00102 table for that item.
Reconcile does correct them, but then it happens again to completely
There is no known issue in regards to why you would have to be consistently
running the Inventory Reconcile. This is ...Printing a pane of a splitter window
This is how I'm attempting to print the second column, first row, spitter
I call a function in CChildFrame that I call "OnPrintPane()" from a drop
It reads like this:
TRACE("Printing from pane\n");
COrthographicsView *pView =
This calls SetSwitch of my view. This works, and the function being called
TRACE("Trying to print...\n");
CPrintInfo *myPrintInfo = new CPrintInfo;
OnP...Print Address Labels from Columns??
Have an Excel spreadsheet with Name, Address, State, Zip in different
columns. Are there stored functions an easy method to print envelopes or at
least write that information to a text file for printing as address labels?
the following sites may help you using Word in combination with Excel
(mail merge for your labels):
Al Franz wrote:
> Have an Excel spreadsheet with Name, Address, State, Zip in different
> columns. Are there...printing chart in color
I used the chart wizard to put a chart on my excel spreadsheet. Print preview shows it in color but it prints black & white. I verified that the black & white box is NOT checked in page setup. I tried automatic color and custom color by selecting the colors I want each bar to be. What am I doing wrong?
I am trying to set up the print setup so that the 2 top rows are repeated at
the top of each page printed....help please!
Go to File > page setup
Choose the sheet tab
Rows to repeat at top
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http://www.excelforum.com/showthread.php?threadid=26337
Click File > Page Setup > Sheet tab
Under Print Titles, input* in box for:
Rows to repeat at the top: $1:$2 (rows1 and 2, for example)
Click OK...Multiple worksheet chart
How do I create one chart that shows data from several worksheets?
-- Two options that you can consider:
(1) Create the chart by first using data from the single sheet in which you
want the chart to reside. You can do this via the Chart Wizard. Then, add
the new series that refer to the other sheets as secondary steps.
(2) Create a summary range on the single sheet in which you want the chart
to reside. The summary range will consist of formulas referring to the data
on the other sheets. After the summary range is complated, create the chart
from the summary ...Print Group Permissions
Am wondering if there is a quick way to generate a report that will print
out group permissions for my database objects.
I can always write them down, but it would be very time-consuming to note
each level of permission for each and every database element.
Any advice would be greatly appreciated!
The built-in Documenter can do this:
Tools | Analyze | Documenter
I prefer to use my own tool for this:
My tool can document many areas of your database and usually with less pages than the Documenter.
...Re: Printing Double Sided
I have an excel workbook with 8 worksheets with one page of printable data on each sheet, I want to print out each of the 8 sheets in a report, but I want to do double sided printing so that the report only contains four A4 pages. I can do double side printing when all the printable data is on one worksheet but I can't seem to be able to do it when the printable data is on seperate sheets in the excel workbook.
Help would be greatly appreciated.
I don't know how to do this in excel but there is a program availabl
that will allow you to do this, the program is ca...Printing Multiple Worksheets as a single print job
My problem is as such:
I use Excel 2002 to maintain a list of refurbished endoscopic equipmen
offered for sale by our company. I have it broken down int
"sub-categories" so the workbook has 6 worksheets (or 6 tabs).
The way the document reads, it's supposed to come out as one continuou
document (print entire workbook). However, when it prints, it print
the first two tabs as one print document, then the third as a separat
document, then the fourth, fifth & sixth tabs as another - therefore
it's actually 3 separate documents being sent to the printer.
This isn't t...How can I add multiple source data data labels?
To be more exact, I require my original data labels (in an Area Chart in
Excel) to remain visible, ie £250,444; in addition I require to show on the
same drop line, either above or below this original figure, the Loan To Value
amount, ie 48%.
I am sure this is possible, however I am unable to discover the correct
process to enable this eventuality.
First you need to create a concatenated formula in the spreadsheet, then you
need to use a custom add-in to use those cells a data labels.
Assume you 250,444 is in column B and the 48% is in column C then in column
D enter thr...Duplicate emails appear then disappear repeatedly
This is what happens:
1. Outlook goes to check for new emails on the Exchange
2. A duplicate of all emails in the inbox appear on my
3. When the process if finished all the duplicates
disappear and I am left with only 1 copy of all emails in
This happens again and again every time my outlook checks
for new emails.
I need help to find out what is wrong and how to fix it.
The first thing I would try is to:
Search the hard drive for all OST files (*.ost)
(Be sure to search for hidden files if you need to)
Delete them from the Find window
Reope...Multiple eMail Domains & Shared Calendar
Windows SBS 2003 R2 w/Exchange
Windows XP Pro w/Outlook 2003
Server and workstations, respectively.
Situation: Family-run small businesses (plural) sharing an office and
resources. 4 different email domains in use/desired. Shared calendar
How do I setup Exchange on SBS 2K3 R2 to send/receive emails for
multiple email domains with only 1 SBS server (also PDC, etc.)? Using
off-site email hosting and am in the process of migrating on-site using
Exchange which came with SBS. Changed 1 set of MX records for 1 domain
name to point to server. Additional email domains a cri...class structure for repeating sequence of repeating elements?
I am trying to code a class for use with the XMLSerializer that can produce
XML valid for the following schema (fragment):
<xs:sequence minOccurs="1" maxOccurs="unbounded">
<xs:element name="SubElement1" />
<xs:element minOccurs="0" maxOccurs="1" name="SubElement2" />
<xs:element minOccurs="0" maxOccurs="1" name="SubElement3" />