How do you change the background color of a picture?
I have a image that I have copy and pasted, however I want to fill behind the
image. I know how to fill and all that, my problem is that it recognizes the
entire image as a picture, I was wondering if there is a way to change the
background while the image lays on top?
> I have a image that I have copy and pasted, however I want to fill
> behind the image. I know how to fill and all that, my problem is that
> it recognizes the entire image as a picture, I was wondering if there
> is a way to change the background while the image lays on top?
=============...Sort ascending, make changes, restore previous order
I've got an AutoFilter in a spreadsheet. I want to sort ascending, mak
some changes to some cells, then restore the previous order. Can thi
be done easily or will this require some programming??
Thanks in advane!
BVHis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=859
View this thread: http://www.excelforum.com/showthread.php?threadid=47508
I'd use a helper column.
Put =row() and drag down.
Convert it to values (edit|copy, edit|paste special|values)
Do all y...Error: Invalid byte was found at byte index 63.
Does anyone know what this means:
"Invalid byte was found at byte index 63. "
If yes, please help.
> Does anyone know what this means:
> "Invalid byte was found at byte index 63. "
That means exactly what it says: At index 63 XML parser found a byte, which is
invalid either according document's encoding or is forbidden in XML documents
at all (see list of allowed in XML characters at
Multiconn Technologies, Israel
...Outlook 2003 and "Check Names"
We are testing Outlook 2003 at our office now and there is
one very frustrating "feature" that is bugging all of us.
When we create a new e-mail message and type in the first
name of a person from the global address book and hit ctrl-
k to check the name...we get a response that Outlook
doesn't recognize the name and there are "no suggestions".
The only way Check Name will successfully resolve the name
is if we type it last name first (ie, Gates, Bill). This
was not the case in Office XP or Outlook 2000. You could
search by first name (or partial first name)...multiple Domain name delivery problem
hi, I currently have Exchange Server 2003 Build 7638:2 SP2,. We have multiple
domain names being delivered to the exchange store. I have nothad any
problems, but i currently have one user that is not receiving emails with
attachments from one certain "internet" sender to one of her email addresses,
but the other address works fine & if they send emails without attachments,
everything works fine from either address. I have had the user send them
message with attachments to me & the user with the problem & i get the
message, but not the other user! I even use message..."The connection to the Exchange server is unavailable. Outlook must be online or connected to complete this action"
I have setup a number of user accounts and the relative mailboxes without
However, since this afternoon, if I try and connect to a newly mailbox
through the email accounts wizard I get the following error message: "The
connection to the Exchange server is unavailable. Outlook must be online or
connected to complete this action".
This also occurs when I go to File>Open>Other User's Folder... and I try and
lookup an existing account/mailbox that I know I have permission to.
I know Outlook is connected to the Exchange server (I can ping, send and
receive emails) ...XCH Error 3092, OAB replication
I am getting error 3092 for OAB in Exchnage 2003 (migrated from 5.5)
"Error 1129 occurred while processing a replication event.
Folder: (3-8) NON_IPM_SUBTREE\OFFLINE ADDRESS BOOK\EX:/o"
Tried to delete offilne addressbook and recreate but error has not stopped.
Any help will be a great help on where to look to get rid of this issue.
...New Disk storage
I'm planning on adding a new SAN to our Exchange system (Active/Passive 2
node cluster) and this has been connected to the Exchange cluster nodes and
is accessible as shared disk storage.
But that isn't the question I've got, basically the mail stores are
currently located on a Powervault (Drive S:) and I need to present a plan for
moving this data (14 databases) onto the SAN storage, I can see two options
Option1) Use the ESM to migrate databases to new drive letter
1. Use exmerge to export all email to PST files (and ensure backup)
2. use the ESM utility to change the...Error Generating the Offlice Address Book
I have a mixed site with 3 5.5 server and 4 2003 servers. I installed
2003 SP1 a few weeks back and since then I'm having an issue
generating my Offline Address Book.
Here the event log messages I'm getting.
Event ID 9331:
OALGen encountered error 80040107 (internal ID 501023d) accessing the
public folder store while generating the offline address list for
address list '/'.
- Default Offline Address List
For more information, click
Event ID 9335:
OALGen encountered error 80040107 while cleaning the offline address
list public ...Unexpected error message on closing an Excel file
Suddenly I am getting the following message when I try to close a workbook:
"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are
correct, and try again"
The mysterious thing is that it does not happen consistently and that, after
I click OK after the above message, I can still save the file.
What might be the cause of this error message and can the "invalid
reference" be tracked down using one of the utility add-ins such as J.
If it only happens when you close ...Linker Error after upgrade from VC7.1
After upgrading a VC7.1 project to visual studio 2005, it failed to build in
the release configuration with the follwoing error :
1>nafxcw.lib(winocc.obj) : error LNK2005: "public: class CWnd * __thiscall
CWnd::GetDlgItem(int)const " (?GetDlgItem@CWnd@@QBEPAV1@H@Z) already defined
The debug build works fine.
The project uses MFC in a static library.
Well, after doing some research, it seems that this one is tied to the fact
that in a release configuration, _AFX_ENABLE_INLINES is defined, so inline
functions are embedded in the .obj file.
Sure there...Change File Locations to Private Drive (not Folder)
I know that I can use "File Locations" in "Options" so that whenever I use
the "Open..." command in Word, it will open to a specific folder. I'm
wondering if there is a way that this can be applied not to a folder but to a
specific drive on a network.
Our company has a main public drive and has also assigned each of the Staff
their own private drive. Is there a way to access the "main page" (for lack
of a better term) of my private drive each time I use "Open..." in Word?
Right now it goes to "My Computer" or ...How to change font size on formula bar in Excell 2007
I don't find Tools>Options>General (as suggested in other post answers) in
Excel 2007. On the Office button there is an Excel Options but it doesn't
provide a method of changing font size on the office but. My font is so
small I can barely see it.
Office button>ExcelOptions>Popular tab>in the "When creating new workbooks"
section, choose font and font size
Microsoft MVP - Excel
"jimwillie" <firstname.lastname@example.org> wrote in message
news:588AAC05-0F52-404E-AA01-128E70E02D0B@microso...Invalid XML error when I open customization setting
I have a problem when I try to open customization setting after I import an
entity. The system errored "Invalid XML" "The XML passed to the platform is
not well-formed XML". Please recommend how to resolve this problem. Thanks.
...How to restore entire server?
This is a long post.
Its that time of year again where I practise some disaster recovery skills.
I set up a completely seperate physical network from the production network.
Its got one Win2000 server (DC + all the Operations Master roles, DNS, WINS,
etc) with SP4 (different AD/DNS root forest) and running Exchange 2000
with SP3 (same org name as production server, admin group, storage group,
logical and physical database names, legacyexchangeDN, etc). As a result, I
can successfully restore our production Exchange 2000 w/SP3 Storage
Group/Information Store database without problems. Outlook...How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...Drag and Drop file/directory names on Tree Control.
I am writing an application in which i have one Tree control.
Now i want that , when user drag & drop any file/folder on tree
control the file name/folder name should be add in the tree control
User may drag and drop file from desktop or may be from
I just want the path of that file/foder name nothing else.
so plz tell me will it be possible ...
Plz Help me.............
> I am writing an application in which i have one Tree control.
>Now i want that , when user drag & drop any file/folder on tree
>control the file nam...owa not resolving names properly
Exchange 5.5 sp4 - just recently OWA is not resolving addresses properly -
the administrator at this site states:
> There is a strange situation happening when using OWA to send emails. If
> we try to send an email to an account out of our domain (i.e.
> email@example.com) the recipient name and domain get wrongly resolved
> to our own domain thus generating a message undeliverable.
> For example using OWA a test email was sent to "firstname.lastname@example.org" the
> address gets resolved to email@example.com
The admin is going to give me an account to test with, but...adding name /creating field/query?
I can create an invoice_number field in a query using the primary
field ID from the main table as
but if ID say is 100, I cannot work out how to create
We aren't there. We can't see what you're looking at.
Where did "renewal_invoice_100" come from and what does it mean?
Please post the SQL statement of the query you are trying to use.
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://micro...Install Exchange 2003 Server on new Hardware with same name
I got a new server to move my Exchange Server Installation. I want to
keep the name I'm using now for my Server. Already read TechNet Article
"How to Move Exchange Server 2003 to New Hardware and Keep the Same
Server Name". Is there anything else that I should be aware of that is
not on this TechNet article? I'm using a different Disk Configuration,
does this matters? Should this be a smooth process?
Thanks for any help you can give.
The drive letters MUST match, because the paths of the databases are at the
Active Directory. The disks can have different sizes than the or...Mails not appearing in Inbox although on Server and viewable by colleague
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...error 0x800cc0f
i installed windows xp, and i set up all my email
accounts. they are all working , except one: i receive
0x800cc0f message, which states that the service has been
interrupted, contact your ISP...., but this is not the
case, since my internet conneciton is working fine
all the account settings are correct
I am having the same problem. I have to close outlook and reopen to retrieve
all of my messages.
Have you found a resolution yet?
> i installed windows xp, and i set up all my email
> accounts. they are all working , except one: i receive
> 0x800c...how do i change colour of scroll bar in worksheet
I find it very difficult to see the scroll bar in my excel workshhet as they
are white, can they be changed to a colour and if so how ?
Are the scrollbars white in other applications?
In win98, I could change some display settings, but I couldn't change the
But if the scrollbars aren't white in other applications, then this can't be the
> I find it very difficult to see the scroll bar in my excel workshhet as they
> are white, can they be changed to a colour and if so how ?
In word they are, but not on a...error on upgrade: ID 4386
I am upgrading from DPM 2010 RC to DPM 2010 RTM, 64 bit version, on Win 2008
The RC is working without any issues. The upgrade scenario is supported.
At the very end of the process the upgrade fails giving me the following.
The SQL Server installation failed because a restart was pending on this
computer. Restart the computer and then start DPM Setup again.
ID: 4386. Details: Unknown error (0x84be0bc2)
Restarting the server does not correct the issue. On the next attempt I am
getting the same error message.
Where to look for the pending rest...DNS Error on Exchange
I am getting the following error on my Exchange server. What is my problem?
Event Type: Warning
Event Source: smtpsvc
Event Category: None
Event ID: 2012
Time: 12:01:53 PM
SMTP could not connect to the DNS server '188.8.131.52'. The protocol used
was 'UDP'. It may be down or inaccessible.
For more information, see Help and Support Center at
0000: d5 04 00 00 Õ...
Is that a DNS server that's configured on your Exchange box? It shoul...