How to Change Value of Active Control
I'm writing a routine to change the value of any Active Control to null. I
can get the name of the control using ActiveControl.Name but I can't figure
out the syntax to change the value of this control. I've tried assigning it
to variables but variables aren't working in a:
Forms![variable]![variable] = ""
"Sondreli" <Sondreli@discussions.microsoft.com> wrote in message
> I'm writing a routine to change the value of any Active Control to null.
> can g...Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".
Is it possible to switch it? If so, how?
Thanks, Anna Marie
> Hi - I have never used pivot tables in Excel before so hopefully what I am
&...How to filter to show only one message from a specific sender/subject
I would like to filter out all but one email with the same subject
line from a specific sender.
I subscribe to a message board that sends an email every time a
posting is made to a thread, instead of just the first posting after I
have read the thread. Is there a way for filter out the duplicate
messages and just keep the oldest email?
...how to edit my x-axis data on a line graph
Operating System: Mac OS X 10.5 (Leopard)
my x axis data on my graph is just showing numbers 1 2 3 4 5 6 7 8 9 10 11.... and it is suppose to show the years. I can't figure out how to change these values
...Microsoft Money Deluxe 2004 #2
How do I install on a drive other than C? I am running Windows XP Home
In microsoft.public.money, Don wrote:
>How do I install on a drive other than C? I am running Windows XP Home
Early in the install process, Money has a place to click to change
where the installation is to take place.
If you install in a drive other than the system drive, there could
be an issue. I was thinking there might be, but I don't find a
reference. http://support.microsoft.com/kb/79917/en-us implies that
There is no problem. I have always installed Money (from M...Outlook startup #2
All of a sudden all our outlook client
(Outlook2002/Exchange 2000) are getting the following
"Your microsoft exchange server is unavailable"
with the retry and cancel options. We hit the retry
option it connects to the exchange.
Sounds like name resolution problems. Can you ping the Exchange server, by
name, from the affected workstations?
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup....How do I get deleted items that stay in inbox with line thru them.
I inherited a computer at work. Outlook is setup so that when I delete a
message it stays in the inbox, with a line thru it. How do I get the deleted
items to go automatically to the deleted item folder?
"rwwhit" <firstname.lastname@example.org> wrote in message
>I inherited a computer at work. Outlook is setup so that when I delete a
> message it stays in the inbox, with a line thru it. How do I get the deleted
> items to go automatically to the deleted item folder?
That's normal behavior...How to change default printing parameters on Excel & ......
How to change the default printing parameters on Excel & keep them changed
for future workbooks.
Example: Normally I use Printing margins 0.25 on all directions, but
default printing margins are 0.75. I want to change them to set 0.25 as
If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt.
Excel will use that as the basis for new workbooks.
You can change a lot of settings that way--including orientation,
> How to change the default printing parameters ...NO #2
Seriously Microsoft, what the fuck?
I'm not saying this as some sort of mac fan or money zealot or
whatever. Hell, I even worked for you once... but..
YOU ARE DEAD TO ME!
Fine, stop selling Money, I don't care. BUT LEAVE YOUR GOD DAMNED
SERVERS UP SO WE CAN GET ONLINE UPDATES INDEFINITELY. How much could
that cost you a month? A couple thou? You throw more than that away
every second repairing peoples broken Xbox 360s.
This is a new freakin low. Seriously.
...Change color of multiple autoshapes
I need to change the color of several autoshape based on different cells
I know how to change one autoshape using a worksheet_change event
but i can't just copy and paste this and change the object name + cell name.
is it possible to have multiple worksheet_change events in the same
You have only one worksheet_change event, but in it you can test to see which cell was
changed with something like
If not Intersect(Target, Range("A1") is nothing then
' do range A1 stuff here
If not Intersect(Target, Range("A2") is nothing then
...Moving Email Domain off of Exchange #2
I am in the process of moving one of our clients off of our Exchange
server and on to a third party email host. I have removed there domain
from the default recepient policy, and also disabled and unattached or
deleted their mailboxes. I have repointed there MX record to point to
the new host etc.
The problem is when I try to email them from our network my exchange
server still thinks it is responsible for handling the mail for the
domain and does not try to send it out of the domain. I get a 5.1.1
e-mail account does not exist in this organization.
How do I let Exchange ...Combine 2 rows if name is same in Column B & C on both
Combine 2 rows if name is same in Column B & C on both
2 spreadsheets - Sheet 1 is bigger with extra names in column B & C
Both - Column B & C Lastname Firstname - both sheets
Sheet 1 has data in Col. D & E
Sheet 2 has data in Col. F & G
Sheet 1 has extra names not in Sheet 2
If Sheet 1 B&C = Sheet 2 B&C ,
then add F&G columns from sheet 2 ,
behind D& E columns on sheet 1 , for the match of names in Column B &
On Nov 13, 12:50 pm, wk <kerns.wal...@epa.gov> wrote:
> Combine 2 rows if name...SDK for Microsoft POS 2.0
Does anyone know of an SDK for MS POS 2.0?
I have noticed several companies making add-ons for modules for MS POS, are
they standalone products that integrate with the POS database or are they
actually integrated into the MS POS itself?
Thanks for your comments.
On Nov 22, 4:46=A0am, NetKnight <NetKni...@discussions.microsoft.com>
> Does anyone know of an SDK for MS POS 2.0?
> Thanks for your comments.
they are standalone products integrated with the database, and also
add-on integrated with SO POS/SO Manager via COM
...View both incoming/outgoing messages by Thread or Conversation ? #2
Is it possible to view messages in outlook 2003 by Thread or Conversation,
both incoming and outgoing, in a single folder, or Inbox, just like Outlook
Express News Reader.
+ Sent Message
+ Received Reply
+Sent Message or Replied
+ Received Reply
I tried using Arrange by Conversation Option in outlook 2003 Inbox Folder,
but its just showing Inbox Messages, not Sent Items Messages.
...Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a
worksheet (file) that i'd been working on (I thought a
different file was highlighted). As it turns out I had
not saved the original file in over a day, though the
autosave is set up.
is there any way to get my file back, or at least an
intermediate version, instead of one with a day's less of
Thanks very much for your help!
Sorry to say, but your day's work is gone.
Greeting from the Gulf Coast!
"Mayukh" <email@example.com> wrote in...Compile Error in hidden module: Autoexec #2
I need help when ever I opepen or close any office
product ( excel , word etc...) I get the message shown
above.... How do I fix it please help
Take a look at this:
"Ash" <firstname.lastname@example.org> skrev i meddelandet
> I need help when ever I opepen or close any office
> product ( excel , word etc...) I get the message shown
> above.... How do I fix it please help
...Scrpit when trying to change CRM option in Outlook client
I get the attached script error when i try to change the MSCRM Option in
MSCRM Outlook client and it does not accept my changes.
An error has occoured in the script on this page.
Error: Type Mismatch
URL:http://localhost2525/tools/personalsettings/dialogs/personalsettings.aspx?clientid= etc etc
Please let me know if any one knows how to fix this issue, thanks.
...Publisher 2003 files try to open in Publisher 97 #2
Back again, but with a different Pub 2003/Pub97 issue
Have Office 2003 with Publisher 2003 and Publisher 97 both on my XP Pro system
Recently I find that files created in Pub 2003 are being saved as files with
the Pub 97 Logo, and when you try to open them from the file listing, they
open Pub 97, which correctly posts a box telling me that it cant open the
If I use Publisher 2003 to open the same files from within the application
the work fine.
When I select a 2003 Pub file which contains the Pub 97 icon, the file list
does not contain Publisher 2003, but when I browse and locat...Won't Remember Password #2
My email account calls for the password everytime I use
it. Even when I check the box to remember my password,
it won't retain it.
I run XP. Anyone else having problems with this?
If you are still having problems after applying both the SP 1 & 2 =
patches, then see if this article addresses your problemL
OL2002: The Save Password Setting Is Not Saved When You Connect to a =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups...uploading 2 or more mailboxes on 1 user account
I was able to reconnect 1 mailbox to 1 user account, but what i'
looking is the way wherein i can reconnect 2 or more mailboxes into
user account because instead of giving a 1:1 user account to eac
person we will be replacing it and giving them an account per area
Hence they already have their own personal account we will b
deleting it; How can i put all their messages from their persona
account into the single account that we wil be giving to them
More than one mailbox per account is not possible in Exchange 200x. You can
do that with Exchange 5.x
Menko den Ouden
...inverting data #2
Please help, I'm stuck! I conducted a survey where respondants each gave
answers to 30 questions using a Likert scale i.e. they answered either
1,2,3,4 or 5 to each question. The data is in the following form:
q1 q2 q3 q4 q5
1 2 4 2 1 2
2 4 1 2 1 4
3 4 4 2 1 4
4 2 3 2 2 5
5 2 3 4 5 3
My problem is that half of the questions were asked in a negative direction
to avoid possible response bias. For the answers to these questions, I need
to reverse the answers. If the repondant answered 1, I want to record 5, if 2
then 4, if 3 then 3, if 4 then 2, if 5 then 1. Is there an...Changing a username/address
I work with someone who just changed her name, and I'm trying to figure out
how to change it on the Exchange (2000) server.
I changed the username in Active Directory (also 2000), but messages from
the user still have the old name in the Sender field. Also, when I point to
the mailbox for saving messages, it has the new name (Mailbox - New Name)
until restarting Outlook, and then it has the old name.
Do I have to Exmerge out the mail, delete the account, re-create the
account, change the name of the .pst file and import the mail?
Thanks in advance!
Follow these steps:
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...Carriage Return/Line Feed Problem
I wrote some code that gets the HTML from a Web page and stores it in a
buffer, then I display the buffer in a big multiline CEdit box. The problem
is that on many pages I don't get new lines, I just get a thick solid
verticle line kinda like this: || where it should return.
Also, if I view the pages (view source) in Notepad they look fine.
Most pages do that, but interestingly Microsoft pages do the proper new line
and look great in my edit box.
Maybe I have to replace all the \r with \r\n or something like that ? Does a
\r\n still only take up 1 char ? I download the page in...Don't know where else to put q's. 2 questions. 11g Dongle and wire
What is and Acer WLAN 11g USB Dongle?
It is some program that is on my computer and pops-up at start-up. I'v
double clicked it, and nothing happens. I went on Acers site, and I can find
nothing. Even some freeware mentions it, but they only talked about the
freeware, not this WLAN 11g itself.
And how can I tell if I have wireless or not. This seems like a nobrainer,
you have it or not. But some documents on my computer mention wireless
internet surfing in programs that are there. I use a high speed connection
through an external modem that connects to my comuter and the w...