Excel 2002 (XP)
I have data in cells and I'm using inner and outer borders. There are times
I like to move or cut a few cell and paste else where. When I do that, the
original location where the data was, the borders are gone. Is there a way
to move/cut data and keep the format/borders intact?
Note: When I do the above using copy, the original format stays intact.
But this means I have to go back and delete the data. I prefer to move/cut
just the data, and leave the borders as is.
When you cut or move a cell, both the data and the cell formatting it
If you co...Outlook XP sp3 and IPAQ
I have 2 users on our network that have been getting
warning messages from Outlook saying that a program is
trying to access e-mail addresses in their Outlook address
book. It appears to happen everytime they go to sync
their IPAQ handhelds.
Does anyone know the solution to this problem. I have
seen the reference to Palm OS on the slipstick site, but
haven't seen anything about Windows PC.
Thanks in advance,
What version of Active Sync are you using?
Tips of the month:
-Setting Permissions on a Mailbox
-Create an Office XP ...Data Validation
How can you get an audio sound when the error alert message displays in Excel
By default, Excel will make a sound when the error alert is shown. Turn
up/on your volume :)
"Help" <firstname.lastname@example.org> wrote in message
> How can you get an audio sound when the error alert message displays in
...Custom entity errors
When I try to create a new entity I get the following message upon saving..
An error has occured please contact your system administrator.
Everything else seems to be working.
Most likely a rights issue. DO you have proper rights to make changes to the
MS SQL database?
Anne Stanton, MVP-CRM, MBA/ACC
The Norwich Group
"Dave" <Dave@discussions.microsoft.com> wrote in message
> When I try to create a new entity I get the foll...Error while connecting the Database
during the installation of MS-CRM 1.2 I have to create a connection to the
(existing) database. This database is stored on another server. While trying
to connect the database I get the following error: On the computer with SQL
server full text indexing must be implemented. The indexing service is
installed. The SQL service "Microsoft search" also.
...Ecel (XP) formatting
I use Excel (XP) to create tables for web pages - i.e. 'save as we
page...' and then open them in dream weaver to format them. The proble
I'm having is that saving as web page keeps all the column values an
row heights etc. which creates a v.largge html page.
Is there a way to strip out all the values when saving?
Many thanks in advance
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...Excel opening with Visual Basiic File not Found Error?? Help!!!
When I open up Excel I am receiving an error message "Microsoft Visual Basic
File not Found" when I hit help it tells me it is file not found error 53.
Can anyone provide me some information on how I need to fix this problem.
See responses to similar questions from Tom Ogilvy
and Dave Peterson:
"jbsand1001" <email@example.com> wrote in message
> When I open up Exce...Outlook Window Resizing in RegEdit
I have had a problem with some software which appears to
have sized the Outlook window to a size which makes it
disappear from the screen. If I Alt Tab to it and hit
Alt and the Down Arrow, I can see the menu's, but no
window. If I Maximise it from the Task Bar then it runs
full screen, but I want to run it at the original half-
screen sized window. I know that there is a way of
editing the size of the window in the System Registry.
Does anyone know where this can be done? I am fairly
competent with Reg Edit.
...Change Appearance of Font in Email Window
I would like to change the appearance of screen fonts in the email pane in
Outlook 2003. When I open an email, there is a button on the toolbar which
allows me to increase the appearance of the font size, but is there a way to
make the larger size the default?
...Outlook XP (2002) cannot find reply address
When I reply to an email, Outlook does not find the
address of the person I am replying to and instead asks me
to tell it using that fun little dialog that creates a new
address book entry. I don't need or want everyone that
sends me an email in my address book, and want it to stop
checking for an entry there and just use the one on the
email I am replying to - like all previous versions of
Outlook (97 & 2000) did.
...TransferSpreadsheet Access 2003 to Excel 2007 Error
I've had Excel 2007 installed and still run Access 2003 on my PC. The
following code ran fine when Excel 2003 was on my PC, but since using
2007 it generates an error.
'Transfer the recordset data to the workbook.
DoCmd.TransferSpreadsheet acExport, , QueryName, strNewWorkbookPath
, , NamedFormula
The error details are:
External table is not in the expected format.
Any ideas as to possible fixes for this problem?
I have problems on one client that they don't recieve all emails from people
sending to them. I guess something is wrong in the configuration. When I do a
nslookup -type=mx domain.com I just get unautharized answer. Also the ttl
time is just 1800 when I do a dns report. Do the guys that handle the dns
The people that doesn't get their mail throw get the 4.4.7 error in return.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"Surfer&q..."Error has occurred" message when Outlook left idle
Whenever I walk away from my computer for a few minutes,
when I come back, I have received this message regarding
Outlook: "An error has occurred in this program. To keep
working anyway, click Ignore and save in a new file. To
quit, click Close. You will lose information since your
...Exporting to Windows Live Mail
How do I export messages from OE6 to Windows Live Mail?
If WLMail is on the same machine, it will import automatically. To go to
Transferring data from Outlook Express to Windows Live Mail:
Copy the *ENTIRE* OE message store folder to a flash drive. (Folders.dbx
must be included). Place this on the Desktop or other location on the
machine using WLMail. Open WLMail and: File | Import | Messages |
Microsoft Outlook Express 6 and point to where you saved it.
OE Message Store Location:
In OE: Tools | Options | Maintenance | S...error 2424 message
My database includes a form for rentals of the department-owned car by
employees. This form has a combobox to select the hirer. The NotInList event
procedure calls to open in Dialog mode the form to enter a new employee's
master data, while the rental form goes invisible. The master data form's
cmdSave_Click event procedure hides the form.
While the rental form is still invisible, its hirer combo NotInList
procedure is then to read from the master data form's key field. That's when
error 2424 comes in.
The direct window provides this:
? Forms(1).Name, Forms(conNew...adding multiple error bars to bar chart
i need some help!! i need to add error bars to a bar chart, and each value in
the series has a different standard error which has to be added. any ideas
how i can do this?? each time i try and change the error bar they all change
in the series!
Help me please!
On the Error bar dialog is the option to use a range as the values.
This can be used for both positive and negative values.
See Jon Peltier's page,
> i need some help!! i need to add error bars to a bar chart, and each value in
> ...Error on opening
When I attempt to open "Outlook" I always get the
following error message:
OUTLOOK caused an invalid page fault in
module <unknown> at 0000:13722a04.
EAX=00110162 CS=015f EIP=13722a04 EFLGS=00010246
EBX=00000000 SS=0167 ESP=0056f114 EBP=0056f338
ECX=0056f340 DS=0167 ESI=01a1105c FS=3797
EDX=0056f364 ES=0167 EDI=01a1093c GS=0000
Bytes at CS:EIP:
3a45beaa 01a1105c 0056f340 01a1093c 0069112c 00691cf0
81400000 04572d96 01440000 01672da7 16a71624 5270814e
076e1787 16a7077a 815c3797 17874e04
I cannot open 'outlook' to retrieve my id number.
Any s...Exchange 2003 Admin tools on XP x64
I need to load the Exchange 2003 Admin Tools on an XP x64 bit box. I am
getting an error saying the tools are not compatible with x64. Do you have a
work around? Will SP-2 for Exchange include x64 admin tools?
As for the work around: There is always the alternative of loading up a VM
(VMWare, Virtual PC) for the time being and installing the tools on the VM
session. Granted, it's a bit easier just to terminal into a server and
administer it from there.
"sc0rpi0n" <firstname.lastname@example.org> wrote in message
news:2EA037DB-77C4-49E3-A0DD...SBS 2003 R2 and Windows 7
I know there were issues with Vista Business
Is there anything special required to connect Windows 7 Pro to SBS 2003?
Any gotchas ?
Should be the same as Vista...
Installing Windows 7 in a SBS 2003 Environment
Merv Porter [SBS-MVP]
"sam" <email@example.com> wrote in message
> I know there were issues with Vista Business
> Is there anything special required to ...Slight change now macro error
Active Cell being A1, Date D15, Payment Received E15 , H14 Value which is
subtracted by its value to get Zero in H15
But I am getting a error now on the last line!
..Offset(14, 3) = (Date)
..Offset(14, 4).Value = "PAYMENT RECIEVED"
..Offset(14, 7).Formula = "=-" & ActiveCell.Offset(13, 6)
This was the original but wanted to change the active cell to A1 instead of
..Value = (Date)
..Offset(0, 1).Value = "PAYMENT RECIEVED"
..Offset(0, 4).Formula = "=-" & Act...Unknown error message
What does this mean please and how do I fix it?
An unknown error has occurred.
Windows Live Mail Error ID: 0x800C0148
When does it occur ?
Is your account really using Port 0 for smtp ?
"whatlink" wrote in message news:F6BDF51C-3C13-47BF-9051-C7DEB9E3DA77@microsoft.com...
What does this mean please and how do I fix it?
An unknown error has occurred.
Windows Live Mail Error ID: 0x800C0148
That symptom is usually caused by interference from ...Runtime Error #19
When I try to start outlook it comes up with runtime
error in visual c + + library error. I have tried to
uninstall and reinstall. Same problem. Can somebody
perhaps help. The os is XP home.
...Batch Recovery error...missing script message?
A user is posting a batch to the RM series (she does this all the time so
this is nothing new). Receives a "posting interrupted" message on the master
We went to batch recovery and marked it and did a continue, but it still did
not post. It returns the message: Script
'RM_Post_Validate_GL_Dist_DocType_0_Ex' not found.
I checked the SY00500 table for the company and the entry is there. It
looks "normal" as far as I can tell. There is no batch entry for it in the
Dynamics SY00800 table. I don't know if that's an issue or not.
I t...Check out the internet update for Windows
Content-Type: multipart/related; boundary="svmwdypqsmo";
Content-Type: multipart/alternative; boundary="wrdjrfadlwqwsclrk"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now ...Error Message #22
Every time I enter any information in a cell I get this
"The macros in this project are disabled..."
How do I fix it - I don't understand the instructions.
basically it seems that the workbook contains some VBA code (macros) which
has been writen to run when you enter information into a cell, as the macros
have been disabled (default setting in Excel) then they can't run as the
author of the workbook designed them to.
IF you know who created the workbook and you are sure that the macro code in
it is something you want to run then if you...