How to change the string value in the registry?
How to change the "string value" in the registry from the code? As
there is a functionality in my application that the user can change
the "string value" with some GUI. But I m not able to change it as
there is a function RegReplaceKey but its only to take the backup of
old file and to replace it with new one and even i dont know how to
use this functin to suit my case.
RegSetValue/Ex() should do it I think.
Look at the Registry APIs. Also, take a look at my Registry class on my MVP Tips site.
On Sun, 26 Aug 2007 23:59:33 -0700, HItz <hitesh_im...Name change due to marriage...
I have a user who recently got married and would like to have her new married
name for her emails, but also wants external users to be able to send emails
to her old address until she has adequate time to inform everyone. Her new
email would be something like lastname-newname, firstname instead of
Should I create a new account with her new name and forward all her emails
from the old account to the new one and can I copy her current pst into the
THanks for everyone's help.
No. Just highlight her account in ADUC, and choose re-name. Make the
neede...Excel Formulae #4
I've been trying hard to find a formula which would
enable me (from one cell) to Add several cells and
Subtract the answer from another cell (subtracting items
of expenditure from a starting total). I could manage
this with Lotus - but Excel does not seem to behave the
same. Advice would be much appreciated. Thanks,
Say you wanted to subtract A1, A2, A3, J4 and N5 from L6:
In article <firstname.lastname@example.org>,
"KenS." <email@example.com> wrote:
> I've been trying hard ...Unable to Open received PO (change to "change order")
Great Plains will not allow me to change this Purchase Order from Received to
Here is the message I get:
However, if I try to enter a quantity cancelled, I get:
How can I re-open this Purchase Order so I can change the price???
Unfortunately, the pasted messages did not come through.
Once a line item is received, you can change its cost only during invoice
matching. The process would be to return the item; add a new row with the
correct cost; and receive and invoice the new item. Not an elegant solution,
Charles Allen, MVP
&quo...Tracked changes function misbehaving
I have a simple workbook (2002) in which the Track Changes
feature is enabled. End users have reported periodic
problems with the contents of cells "mysteriously"
changing. In process of investigating these, have found
that when tracked changes are highlighted, the comments
that describe changes are not always associated with the
correct cell. Example, comment on cell B114
states "Changed cell B114 from '<blank>' to '12345'". In
fact, contents of cell B114 is "67890" and contents of
cell B104 is actually "12345". Has anyone...Changing font size in data validation drop-down lists
In Excel 2003, I created the value list on a separate worksheet and labled
the range so I could use it in the data validation wizard on a different
The list is working fine; however, the font size in the drop-down list is
too small to comfortably read.
So far, I have tried:
Making the font in the list larger.
Formatting larger font size in the active cell with the drop-down button
And, creating the list on the same worksheet.
All three remedies have not increased the size of the font in the drop-down
Suggestions are welcome.
There is n...Shorter Formula
Can anyone shorten this formula please. Basically all it
does is gives me an average of the figures in Column "W"
depending on the number of times that product appears
in "R" column
I didn't try too hard to analyze your formula, just noted that your ranges
and sum_ ranges...Formula counts incorrectly
Column K contains dates and blank cells. I would like to count how many
of these dates fall within a given date range. For example, in the
first week in May. Column K contains these dates. 5/2/2005, 5/3/2005,
5/5/2005, 5/5/2005. I would like to count this as 4 dates within the
first week of May. I created this formula but the output is 3.
I assume that it is only counting 5/5/2005 one time?
I changed the dates in the formula to check a second 2nd date range
(5/9 to ...Excel date changes
I have created a spreadsheet using excel which requires the use dates
on a monthly basis (similar to a calendar). The problem I have is that
every month I have to go in and change the dates on the spreadsheet to
reflect those of the current month before printing. Is there a way I
can make it so that excel does that for me every month.
Thanks, I'd really appreciate the input.
Please elaborate on what the spreadsheet looks like.
> I have created a spreadsheet using excel which requires the use dates
> on a monthly basis (similar to a cal...Change order of A/R Statements
How can I change the order in which customer statements print out of RMS? I
would like to print statements sorted by company name. Currently, the
statements print in some random order....I think based on CustomerID.
I just had a customer tell me the same thing. They need the statements in
Alphabetical order. The current order appears to be straight out of the
customer table in the order they were entered.
It has been posted as a suggestion - vote for it and push it higher on the
"Paul Arenson" wrote:
> How can I chang...Changing URL from Ticker Symbol
Many of partners in Japan want to changing URL from Ticker Symbol in order to
jump to a web site in Japan instead of http://moneycentral.msn.com/ .
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowse...Protect formatting & formula
I need to protect the formatting & formula in each cell to avoid accidental
changes during update by different users. However, if I protect them, any
new row creation and deletion are disable. Is there any way resolve it?
Especially, when create a row, how can all formatting and formula to create
automatically for the new row?
What version of Excel?
"Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message
>I need to protect the formatting & formula in each cell to avoid accidental
>changes d...Is there a way to automatically put the $ sign into the formula?
I want to turn this =A1 into =$A$1.
How is the best way of doing this. Is there a shortcut....keyboard stroke to
Hit [F4] several times and watch the results.
> I want to turn this =A1 into =$A$1.
> How is the best way of doing this. Is there a shortcut....keyboard stroke to
> do this??
Enter =A1 then tap F4
Repeated taps of F4 scroll through the referencing options
When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently an...can i see the date the last time a cell was changed?
I am trying to figure out a formulla to make the date appear in one cell
everytime anouther cell's data is chaged.
Use a worksheet_change event to copy the cell address and put in a date
"JohnNuTek" <JohnNuTek@discussions.microsoft.com> wrote in message
>I am trying to figure out a formulla to make the date appear in one cell
> everytime anouther cell's data is chaged.
There really isn't a worksheet formula to do that. Typicall...Unhandled database exception: A get/change operation on table 'Bat
During Edit Checks, we get the following message:
Unhandled database exception: A get/change operation on table
'Batch_Headers' could not find a record.
Then we get this message:
This transaction was recovered during normal processing. You may continue
processing this transaction.
You might want to run Check Links on payables. Before doing this, make sure
you have a backup of your dynamics and company databases.
> During Edit Checks, we get the following message:
> Unhandled databas...Help writing a formula
I have a huge database that I need to create numbering for each line like
this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the
number doesn't change each line - sometimes the number will be duplicated on
multiple lines because those lines have the same title, I also need to create
another cell extending that letter/number combo that will differentiate the
So the first cell stays the same if the title is the same. The second cell
adds another layer of numbering to differentiate the first cell.
(Row1, Col 1-4) AK-1, AK-1-1, Title1...trouble changing data type
I am running MS Access 2007 on Windows XP Professional 2002 (SP2).
I need to change the data type of a single field in a table containing just
over 1.4M records in order to link it with another table and run a Make-Table
Query, but Access is telling me I do not have enough memory to change the
data type. I have 1GB of RAM and a Pentium 4, 2.79 GHz processor. Am I out
of luck based on the equiptment I am working with, or is there a way around
First backup your database. Next Compact and Repair.
Third add the new field datatype. C...Changing size and placement of maximized dialog
I want to have maximized window not on all screen.
how to change maximized size and placement of dialog ?
I red doc for SetWindowPlacement(&wPlac) and I have tried
wPLac.length = sizeof(WINDOWPLACEMENT);
wPlac.ptMaxPosition.x = 200;
wPlac.ptMaxPosition.y = 200;
But after dialog is maximized it is on all screen.
What is wrong ?
> I want to have maximized window not on all screen.
> how to change maximized size and placement of dialog ?
> I red doc for SetWindowPlaceme...keeping messages in inbox
I've been using Outlook for about a month to pull in my
emails from a different mail services I have - AOL and
SBC/Yahoo. The problem I'm having is that while my
messages are coming in from AOL correctly (or they seem to
be), Outlook only retains them for a week or so then they
disappear. It does not happen with the SBC mail (which is
the first/default mail account). I've looked everywhere
for something to adjust the length of time messages stay
in the Inbox folder for the AOL messages, but no success.
Anyone with ideas that might help would be greatly
appreciated, be...How do i keep the colors applied to the specific rows when sortin.
I have applied specific colors to specifc rows, but when i sort the colored
rows follow the sorting format.
...Keeping Custom Properties When Forwarding or Replying to a Message #2
We have emails saved on the file system, that is kept track of by
another program. These emails have custom properties attached to
them. There is no custom form, just custom properties. These fields
were originally added using objPost.UserProperties.Add. We need it
so that when someone opens up one of these emails through the file
system, and then replies or fowards the message, these custom
properties are kept in the reply. This is so the external program can
track these emails. Is there a way this can be done? We could have
these emails opened up using an Outlook command line that i...Re: Could someone please help me with formulas
"No" <firstname.lastname@example.org> wrote in message news:...
> I created a workbook and tried to explain the best I could how everything
> should be. you can download the workbook at,
> I really appreciate everyones help on this.....
> "CLR" <email@example.com> wrote in message
> > Maybe in cell J2 you could put the formula =H2+I2, which would give you
> > sum of the C...HELP! Outlook Keeps Receiving Same E-Mail Messages
I keep getting the same 6 e-mail messages. This is after calling Norton and
Comcast re receiving the same 3 e-mail messages (538 of them since midnight
Dec 3!). Of course, it was not their problem, so it must be Outlook.
It sounds like you have an email message with a large
attachment that is bogging down your account. What
happens with the email is once you have connected to your
ISP and clicked on the send/receive button if the
connection is lost it will start over again until it can
pull all of your messages in 1 sweep. You will need to
log on to your accou...LINQ related query
I have a question regarding joining xml files on a key which is present in
all file, following is my code
docFTR is of type XDocument
xdList is List(Of XDocument)
Dim doc = From x In docFTR.Descendants("Data") From i In xdList.GetRange(0,
1) Join d In xdList(0).Descendants("Data") On x.Descendants("Guid").Value
i need to programmatically replace xdList(0) with the current XDcoument
which comes from "From i in xdList.getRange(0,2)"
GetRange(0, could be 2 to 10)
Any help is welcome...SFO error message "write protected change are not synchronized" 07-28-05
When I am changing (closing) an kalender activity from my CRM SFO
recieve an message that "The item is write protected in Microsoft CRM.
Changes are not synchronized to the Microsoft CRM system" (translatet
Do you have any ide what i wrong?