Publisher file to PDF, image problems.
when I print a Publisher file to PDF, my logo comes out fuzzy.
Michelle1031 <Michelle1031@discussions.microsoft.com> was very recently
heard to utter:
> when I print a Publisher file to PDF, my logo comes out fuzzy.
If you zoom in on your document in Publisher, is your logo fuzzy?
What PDF quality settings are you using?
Ed Bennett - MVP Microsoft Publisher
I have tried that b4 and had no success. I even had a DTP
specialist try it, it still does not work. The only thing I can suggest
is to insert the photo from ur computer into the document after you
conve...Count If Formula #4
I need a formula that will figure the following:
If column C = 3, count all times < 00:45
If column C = 4, count all times < 00:45
If column C = 3, count all times > 00:46
Your description is a bit confused.You have different actions for the same
value (C=3). And where are the times, in a different column than C?
So, making many assumptions, perhaps
(remove nothere from the email address if mailing direct)
"Denise"...Autonumber created.. problems in the future?
I managed to create an autonumber in Microsoft CRM. I did this by
making a field "Number"(in the database "New_Number") and I published
it on the form.
Then I went To the SQL server and I changed the field in the table to
Identity Yes, Identity seed 1, Identity Increment 1.
I locked the field on the form.
I think that this is not supported by Microsoft. But has anybody got
any idea which troubles i could get with this configuration?
Do you know all add-ons for Microsoft CRM? Visit http://www.pimpmycrm.com
The biggest dange...Problem automating page in IE 8
I am using the following code to open a page to sign in to MyMsn and it
does not work in the same way as other secure sites do. I don't know if
Microsoft does something different(big grin here), but the code, which
I believe I got from Karl Peterson, shows 22 objects on the document,
but does not print anything for the obj type, obj name or obj value.
Passing the document to a timer to run HTML links does not show the
sign in boxes at all either. Is there another way to see the items on
this page and pass the email address and password to them?
Private Su...Problems with reallocations in the Advanced Budget
I am a using the Advanced Budget in Money and for years I have reallocated
money between categories and months. recently when I updated my transactions
all my real locations were wrong. Basically the money I allocated from March
to February was not only back in February it reversed it and made it look
like I sent Money from February to March so now any category that I have
reallocated money (an that is most) is wrong.
Does anyone know of a way to fix this, I have run the repair, but that did
Microsoft Money Plus Premium
I am so glad to see that I am...Banking Services Update Problem #2
I have successfully completed all of the steps as provided for in the update
instructions. Initially updates were received as usual. However, now all of
the accounts that were disabled and set-up again are failing to update.
Message received is "Update unsuccessful" and call summary message is
"Microsoft Money could not update your account. Please try to update your
Also after updating, the accounts that were updated never displayed a
password text box. I went through the disable and set-up process again and
still no password text box on the upd...New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...Display total value on subform
I have a job-costing page for our orders, which is a subform on a tab control
linked to all other parts of the database by Ref.
The aim is to show all costs, with total, then all revenue, with total, then
The incoming costs are entered here and then stored in a table, no problem.
Sales invoices are generated via other forms and I have a query that
displays just the basic details for each invoice filtered by Ref so that we
see only the invoices raised for that particular current order. These are
displayed on a nested subform based on the query.
When there are several sales invo...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Excel button problem
I have a macro that copies a worksheet in the active workbook and puts it
into a new workbook - then formats it and deletes any buttons on the
On the first click on the button the macro works ok.
On the second click, it fails because the all assigned macros on all buttons
in the active workbook changed from "mba" to "book1!mba". Book 1 doesn't
exists (wasn't opened, wasn't saved, doesn't have the macros).
I've never experienced this problem before??
Can anyone help to solve this problem?
The macro to do this is c...Vlookup return most recent date (value)
I have a set of data where Column A contains an personal ID# (001). Column
B contains a timestamp. My table has multiple entries for each ID# and
different timestamps for each entry. I want to use a vlookup to find the
MOST RECENT timestamp for EACH ID. Any help would be greatly appreciated.
With your data in ColA/B and the query ID in cell C1 try the below
Jacob (MVP - Excel)
> I have a set of data where Column A contains an personal I...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...how to convert lookup values to the "display text"
I'm using an sql code (below) which uses a few lookup fields. Unfortunately
in the datasheet view, I get the "bound values" instead of the "display
values". How can I change the properties for the these lookup fields so I
can see the "display values" from the datasheet view?
UNION ALL SELECT
UNION ALL SELECT
Has anybody ever seen an error message (0x800cccF6) message? I cannot
configure my Outlook to retrieve Hotmail. Works with other profiles on this
computer running winxp.
> Has anybody ever seen an error message (0x800cccF6) message? I cannot
> configure my Outlook to retrieve Hotmail. Works with other profiles
> on this computer running winxp.
If you have a free Hotmail account, note that it won't work anymore (even
your other profiles will eventually have problems) - see
...AD Sync problem
One of my DC was disconnected from the network for quite a long time and
cannot be synchronized with AD anymore.
I have been trying to apply the http://support.microsoft.com/kb/325850/en-us
procedure to reset the machine account password.
After launching the command "netdom resetpwd /S: ....." I've got the
following error message :
"The machine account password for the local machine could not be reset.
Echec d'ouverture de session : unknown user or incorrect password. The
command failed to complete successfully."
ANy idea to help me ?
Man...Change position ID in HR
We would like to change the position ID in human resources. Does anyone have
a suggestion on this.
You would need to do it behind the scenes using a tool like Query Analyzer.
Charles Allen, MVP
> We would like to change the position ID in human resources. Does anyone have
> a suggestion on this.
careful though when you change it on the background as you need to know all
the tables that use this position ID or Position Code and change it there too
otherwise all the link would be gone and you end up with orphan records that
its just the same as creatin...Problem with Range
Using Windows & Excel XP.
I have a worksheet that has times located in every other column, A1:A30,
C1:C30, E1:E30. I then name the range "times". I want to find the count of
times that are between 0:30:00 and 0:39:59 (30 and 39:59 minutes). I write
=COUNTIF(times,">=" & TIME(0,30,0)) - COUNTIF(times,">=" & TIME(0,39,59))
but get the error #VALUE!
I have tried writing a formula for times in one column and consecutive
columns and it gives the correct count, it is just when the times in every
other column that th...Having problem with spoofing email
Our users just received multiple email from different users outside the
company. In the To: line, it shows his user name correctly but when he print
those email, the To: line was showing somebody else name on the print out.
Is there a way to block this behavior? I'm using E2k3. For some reason our
spam (postini) didn't pick up these emails.
Could you please post the message in raw format (including the mail headers)
> Our users just received multiple email from different users outside the
> company. In the To: line, it shows his user name cor...unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.)
I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".
When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.
Thanks and regards,
...Setting a dynamic range in a formula
I have a column of numbers and I always want the following arra
formula to use the last 12 entries:
Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2419
View this thread: http://www.excelforum.com/showthread.php?threadid=37809
Assuming that Column D contains no blanks, try...
...confirmed with CONTROL+SHIFT+ENTER.
Hope th...random number generator
Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
Use the RAND() function. If 1-10 are in A1:A10, enter =RAND() in cell B1 and
copy it down through B10. Recalc (F9), then sort by column B.
Hope this helps,
> Hey is there a way to generate random numbers like you would for a
> draft. In other words, i have numbers 1 through 10 and generate a
> random order for those?
You would have to generate 10 random numbers ...Formula for Game Spreadsheet
I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute
the info for my character. I am having a probllem with the casting total for
spells related to a paticular character. The Formula is as follows :
I am trying to compute the casting total for the spells castable by this
character. The total for the ...WCF Client serialization problem
I posted the problem on another forum, and to prevent duplicate posts,
but get as many professionals as possible to look at it, I include the
url in this post. Please help!
...outlook 97 and express email problems
I am currently on an IBM X21 laptop and is running windows
98 se with office 97 pro. I recently experienced some
problems with outlook (illegal operations etc) and
reinstalled office to fix the problem but since then I
have not been able to send or recieve emails with outlook
97 and outlook express 6. I simply get an error message
saying the host can't be found (but does exist and I can
ping it successfully). Any suggestions on what I might do?
I have tried creating new accounts in windows mail and
outlook express, but I still get the same error.
Thankyou in advance!
D...message delivery problems
Hello! There are several email address that when I send them an e-mail,
they just sit in the Queue. I did message tracking and its telling me that
"Message Routed and Queued for Remote Delivery". Can anyone suggest
symptoms for this?
usually messages sitting in outgoing queue take time due to DNS related issues.
Do you have issues performing NSlookups on any domains from your workstation?
Can you perform the same NSlookups from the exchange server?
From the exchange server, can you perform smtp communication directly to the
mailserver that would receive the e...