Auto Filter problem
I am using the auto filter for a particular column to sort out differen
medical programs. When I click the drop down and click a program, i
doesnt show me ALL the lines that say this particular program. Why is
Message posted from http://www.ExcelForum.com
maybe some hidden characters in these lines 8e.g. additional space
"jkb724 >" <<email@example.com> schrieb im
> I am using the auto filter for a particular column to so...Auto-Editing
Word 2003 has a very annoying default. It assumes too much! If I reformat a
few words in a document, it changes the entire document to that formatting.
Grr-rrr-r! I have to constantly press undo to get what I want. I know
there's a feature that's causing this annoyance but I can't find it to turn
it off! Can anyone help, please?
Microsoft Word MVP
"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
I have a spreadsheet that utilize the stock quote add-in from MSN. On a daily basis I refresh the add-in functions for the Highs, Lows, Last, Volume, etc. On occasion the spreadsheet reverts to manual caculation settings, and I have to press the F9 even after I updated the quotes. I've always preferred the any spreadsheets I open, blank or otherwise, the automatic setting selected for calculations. I consider this an annoyance. Has anyone experienced this glitch? Is there a fix for it?
Excel takes the calculation mode from the first workbook that opens in a
Sub...Windows 2000 GP installation #2
Fully Patched/Updated Windows 2000NT console.
When installing the integration manager this error pops up when
" The windows installer service cannot update the system file C:
\WINNT\system 32\msscript.ocx because the file is protected by
windows. You may need to update your operating system for this program
to work properly. "
Clicking okay resumes the install and everything seems to proceed just
When running MS Dynamics GP a login and server can be selected but
when you attempt to login to a company we get "The databse setup has
not been co...auto copy self
How do I arrange for Outlook to automatically copy myself
on every new, reply or forward email?
If you mean keep a copy of all sent, see settings under Tools/Options/Email
Options and Advanced Options
"rich" <firstname.lastname@example.org> wrote in message
> How do I arrange for Outlook to automatically copy myself
> on every new, reply or forward email?
...Exchange Attributes missing from 2000 DC Controller
I have two questions that I am sure I shoudl know the answers to but thought
I would get a quicker response from newsgroups than my memory; We have a
windows 2000 domain that has been upgraded to windows 2003 schema but has no
2003 Domain Controlllers. There is one 2003 member server that is running
1: We can only modify/ view the Exchange attributes of active directory on
the 2003 member servers active directory. Is there anyway of upgrading the
active directory managers on the 2000 domain controllers to show the
2: Where can I get the re...Windows Live Video Chat
I have a laptop that has an integrated webcam and microphone.
Well I was trying to call a friend over Windows Live Messenger and the
webcam works just fine. What doesn't work is the microphone. And I don't know
Someone help please? Any suggestions? Answers?
"Wicked Sin" <WickedSin@discussions.microsoft.com> wrote in message
> I have a laptop that has an integrated webcam and microphone.
> Well I was trying to call a friend over Windows Live Messenger and the
> webcam wor...3rd Party DNS server
According to the Exch2000 resource kit I need to run the Win2000 DNS
service, if I run a 3rd-party DNS server (in this case Netware) that allows
SRV records and dynamic DNS will I be OK? At the moment my Win2000 AD domain
works fine with no DNS service of its own, but looking at the Netware DNS
server. I am looking at upgrading from Exch5.5 to Exch2000.
Depends on what you are trying to do.
Dynamic DNS is not required, but the use of SRV records is.
So you can use BIND or any other name server that has support for SRV
"PM" <pmunro@c...When opening MS Outlook 2002 a window opens asking for network server?
Office XP Professional
When I open MS Outlook a window opens up that is titled
Microsoft LDAP Directory It asks for a server name, user
This is a stand alone computer. Not on a network. Is
there anyway of stopping this window from opening up each
time I start Outlook?
Thank You for your time
Your Outlook is configured to use an LDAP server for some
To remove the settings for an LDAP server, goto:
Once in the Email-Accts window you will see four radio
buttons(2 for E-mail and 2 for Directory) Click on the
button next ...Auto Scale Chart Macro -- Any improvements please?
This is the best way I've found to correctly scale a chart -- the only way I
found to exclude a chart interpolating with #NA cells was to delete those
cells containing #NA, and run the chart. This takes a long time on my
computer. Wondering if there is a better way. This macro is directly taken
from 2 excel mvps and modified; i believe a mehta and ron bovarty, but could
be wrong. Thanks for taking a look.
Dim ValuesArray(), SeriesValues As Variant
Dim Ctr As Integer, TotCtr As Integer
Applic...Auto correct or Auto complete
We are all familiar witht he auto correct or auto complete functions found in
MS applications. Of course that means it is available in Access also. My
question is this ... can this function be replicated within the DB, so that
the set of auto correct items are part of the package rather than something
that would have to be set up on each individual desktop system?
It's use, for me, would primarily be within a memo field where medical
abreviations, used as a shortcut, would convert to the true meaning as the
user types them in. Ex: "prn" without quotes would change to. &qu...OWA auto login
I am trying to use the credentials from the forms authentication login to
automaticaly log in to Outlook Web. I redirect to a URL with this format:
I have seen this example in other posts but this does not work for me. I
still get the Outlook Windows Login prompt.
Perecli Manole wrote:
> I am trying to use the credentials from the forms authentication
> login to automaticaly log in to Outlook Web. I redirect to a URL with
> this format: http://UserName:Password@mailserver/exchange
> I have seen this example in other posts but t...2 X 2 Splitter Windows #2
What is wrong with the following code? I am trying to create a 2 X 2
splitter window. It should look like this.
CMyTreeView | CMyListView
CPictureView | CDetailView
It compiles correctly but when I run it I get an error in the WinSplit
routine of MFC.
if(!m_wndSplitterWnd2.CreateStatic(&m_wn...Any way to get rid of an auto-suggestion in the login dialog box, for Exchange/OL using RPC over HTTP?
A client was using RPC over HTTP to two different Exchange servers (OL
prompting for profile on startup). Both profiles were set up to prompt for
credentials upon connection to Exchange.
There's now only one Outlook profile needed; the other is gone and OL isn't
prompting for the profile selection any longer, which is fine.
However, Outlook is remembering domain1\user and domain2\user in the login
dialog box, and I'd love to be able to get rid of the no-longer-valid
credential dropdown suggestion.
(The computer is not a member of a domain and hence always needs to be
prom...Auto look through subfolders
I can write a macro that will extract data from all excel files in a
What I need to be able to do is write a macro that will automatically
extract data from excel files within folders and sub folders and sub
sub folders etc
For example the data is all held on the following directory:
H:\development forms\2006 cost sheets\
And within that directory by customer - for example Tesco, Boots, Asda
etc. These customers are then subdivided into product ranges - eg
1,2,3,4 etc and some futher subdivided by national or exclusive. All
the excel files are in exactly th...MOC Exchange 2000
Sabe Alguien donde puedo bajar los MOC de Exchang 2000
...Do I need DSClient to run Exchange 5.5 on an NT4.0 box in Windows 2003 Native Mode ADS?
I am in the process of migrating my WinNT4.0 domain and Exchange 5.5
Org to Windows 2003 ADS/Exchange 2003. I know best practice is to
change the domain to Native mode, but how does this affect my NT4.0
server running 5.5? Do I need to simply load the DSClient onto the
I should also note that we did an inplace upgrade from NT 4.0. This is
a single domain environment.
As long as you no longer have NT 4.0 BDCs you should be able to move to
native mode. Your NT 4.0 server running E55 will not be affected (unless of
course it is also a BDC).
It is a good idea to...Auto date
I am trying to create a field in a form that if anything is changed on it, it
will automatically update the date to current date. Is this possible?
>I am trying to create a field in a form that if anything is changed on it, it
>will automatically update the date to current date. Is this possible?
Make sure the last changed date/time field is in the form's
record source table/query. Then use the form's BeforeUpdate
Me.lastchanged = Now
MVP [MS Access]
You can do this in the On Dirty event of the form, which fires as soon as you
m...server setting don't activate
I was using outlook 2003 and I didn’t find any problem to activate my account,
But when I upgrade to the version 2007 wish is already activated , when I
tried to set my same email account it don’t work
Thanks a lot
> I was using outlook 2003 and I didn�t find any problem to activate my
> account, But when I upgrade to the version 2007 wish is already activated
> , when I tried to set my same email account it don�t work Thanks a lot
You cannot activate e-mail *accounts* at the mail server using Outlook. You
have to do that with whatever means the e-mai...DPM2010 and backing up Vm's on Hyper-V servers in a cluster
I have installed DPM Protection agent on a Hyper V server 2008-R2 and i
automatically see the VM (child snapshot....) on the Hyper-V in DPM2010 if i
want to backup the VM using DPM2010. And i can take a backup of the Hyper-V
volumes and of the child VM. So far, so good.
I have installed DPM Protection agent on 1 of the Hyper-V servers Win2008-R2
forming together a cluster. I can backup the Hyper-V volumes with DPM2010 but
i don't see in DPM2020 my VMs on that Hyper V server. And so i cannot select
it to back it up. No child snapshot line is there ... And i don't know why...exchange failover server (sorta)
I have an idea for a cheap(er) solution to providing a failover
exchange server (excuse me if this has already been thought of or shot
1) Back up Information Store of SERVER1 (using backup exec)
2) Immediately after backup of SERVER1, restore IS to SERVER2
(SERVER2 would be in a "same but different" site name and organization
name, using the method to restore IS backups to a new server described
by Veritas in their white papers).
If SERVER1 were to crash (and IS service fail to start) during the work
day, could you "failover" to SERVER2 by having the individual u...Windows 7
On a Windows 7 64 bits PC. Powerpoint viewer 2007 wouldn't open a file
because MSVCR80.dll was missing. I uninstalled PP viewer and re-installed it.
Presto it worked immediately after install. I turn the PC on the next day and
go to open a PP file and back to MSVCR80.dll is missing. What gives? And why
hasn't this been fixed? It's obviously a bug. There are so many posts
involving different issues relating to MSVCR80.
Are you running Norton?
Have you updated your viewer?
Glen Mi...An auto reply to an auto reply!
Had the funniest situation yesterday.
Somebody emailed a public folder we have set up.
On there we have a rule to send a reply saying thanks for your
email -someone will be with you shortly (we have to have this message on -
it is for some website that recently went live).
Now that auto reply went back to the guy who emailed - who must have sent it
from a public folder himself (as he forwarded the original email from a
The guy received our auto reply - and promptly his email system sent an auto
reply to us.
As is the way it is set up - our email system sent him an auto ...Window Placement After Installing Service Pack 3
A GP 10.0 client has shown that most, if not all, transaction entry windows
appear automatically on the far left-hand side of the screen instead of in
the middle--ever since the installation of service pack 3. Although this may
sound trivial, the client makes use of GP 10.0’s Navigation Pane. Having to
move the windows back over to the right, in order to click on helpful
shortcuts on the Navigation Pane, becomes a little cumbersome after a while.
...External Mail Wont Send Out From New Server
We are performing a swing migration to new hardware. The original server is
win2003 with exchange 2003 sp2. The new server is win2003 with exchange 2003
sp2 as well. I also have another temp server configured as a front-end with
win2003, exchange 2003 and sp2. I installed the new replacement server into
same org and it shows in the admin console. I am able to move mailboxes from
the original server to this new server and receive incoming mail both
internal and external after homing the mailboxes on the new server but when
I try and send email to an external address from an...