how can I fix the size of frame? once I fixed ,the user cannot changed its size
"msnews.microsoft.com" <email@example.com> д���ʼ�
Handle CFrameWnd::OnGetMinMaxInfo and specify whatever size you want for
your frame to be.
Ajay Kalra [MVP - VC++]
"msnews.microsoft.com" <firstname.lastname@example.org> wrote in message
When I file an epay payment, I put in the due date. For
some reason, the program puts in the current date.
For example, if I pay a bill today that is due on July
15, I put in 7/15. When the payment is submitted, the
program changes the date to 7/1 (today).
The problem is, when the program tracks my balance, it
looks like the 7/15 bill has already been paid. That
makes my balance look lower--and often overdrawn.
I want the date of an epay to stay the date the payment
will be made. I cannot find any setting to make the
program do this and the help is no help.
...A Template or a Macro with the current date
Can i add the current date to a new template of a new macro? That is,
i want to have a template where the current date is already
mentioned.(or a macro that added the current date together with other
When i tried to replay a macro of the add current date shortcut
(ctrl+;) it added the same date that was recorded already and not the
Thanks a lot,
Range("A1") = Date
"iris" <email@example.com> wrote in message
> Can i add the ...Change font size based on value of a cell
If the value of A1>0, I need the font size in a merged cell to change
from the default 10 to 16. It needs to return to the default size
when A1 returns to a value of 0. Can someone help with this? Thanks.
Here's a little macro that will do it.......
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("a1").Value = 0 Then
Range("B1:E3").Font.Size = 10
Range("B1:E3").Font.Size = 16
Vaya con Dios,
> ...Chart Value Changes in VBA
When you have say a bar chart and drag the bar downwards this will change
the value in the reference source cell. Is there a way through VBA to
identify the source and the cell changed by when dragging the bar. That is,
when you drag the bar in the chart let me know the cell that ahs changed!
Any help would be appreciated. Thanks in advance.
If your objective is to prevent the cell changes via the chart, you can
protect the worksheet (Tools - Protection). The cells should be locked
(Format - Cells - Protection).
Or you can use the Chart_SeriesChange event macro for the cha...Changing password problem
my users are not able to change their outlook passwords from their
computers. I am running Exchange 2000, the clients are running Outlook 2000
and XP, on Windows NT/2000/and XP. Any ideas
Are your clients use exchange version of outlook or POP version of outlook?
"Eric Graham" <firstname.lastname@example.org> wrote in message
> my users are not able to change their outlook passwords from their
> computers. I am running Exchange 2000, the clients are running Outlook
> and XP, on Windows NT/2000/and XP. Any ideas
>...Outlook Error after URL change
We have already configured our internal DNS records to support
crm.domain.com to point to the proper machine, and created the host
headers on the web server. How do we get CRM to switch from "server1"
In a nutshell, we renamed the server from an internal name to a FQDN.
Internally the CRM server still believes it is on http://server1
We are trying to access it now on http;//crm.domain.com.
Our outlook worked properly before we made this change. After the
change, only the web works and the outlook after a uninstall and
reinstall, switching the server name whil...Calculate As of Date Check Book Opening Balance
Is there any way to calculate as of opening and closing balance of a given
check for Payments and Deposits Listing report
Module = Banak Management
...Change base language
Hi I need to change the base language of CRM 4.0
I think I have to uninstall CRM and delete the CRM databases and then
install again in the other language, it's not a big problem because there is
no data in CRM but what about the registration would there be any problems
registering the same server again ?
There will be no problem in registeration .Never seen it .
Blog = http://mscrmsupport.wordpress.com/
No it all went well, uninstalled and deleted the databases and a new
registration with same information and we are up running the right base
/J...Pocket PC Money security ?
The PPC version of Money has password option.
However, does anybody know if the database is actually encrypted ?
I am using Money for PPC v4
I'm not sure, but I doubt it's encrypted.
"Amamba" <email@example.com> wrote in message
> The PPC version of Money has password option.
> However, does anybody know if the database is actually encrypted ?
> I am using Money for PPC v4
> Thanks !
...Change color for each serie?
Is it possible to to change the color in a chart where 3 dataseries is
Eg. one color representing one region
I have tried to create 3 series in the chart unsuccesfully. It seems
that excel dosent allow it although I only have about +60 data in each
The data is also sorted (by size and not by region), so it is not
possible just to select the data and assign them a specific value
representing one color..
Hope that my question is clear. :)
...How do I retrieve changes to an unsaved excel document
I closed a excel document without saving changes. Is there a way to retrieve
my old worksheet which would have the changes I made. I'm using excel 2000
is part of my Microsoft Office 2000 program.
No it's not possible
Northwest Excel Solutions
(remove ^^ from email address)
"Jim" <Jim@discussions.microsoft.com> wrote in message
>I closed a excel document without saving changes. Is there a way to
> my ...Thanks for all the help on Year-to-date query!
It's so great to know that there are folks out there that can take the
time to help someone whose 78 year old brain is slowly turning to
Francisco 9 @ ATT N E T
...Date in an Edit Control
Hi i would like to enter a Date value into an edit box
To get very spcific...
i have an edit box when selected ,the user must be able to just select the date he requires
such as 11 02 04 ,.....only the numbers are required and this has to be stored into a fil
See this link
"NoviceJohn" <firstname.lastname@example.org> wrote in message
> Hi i would like to enter a Date value into an edit box.
> To get very spcific....
> i have an edit box when...Excel, Quicken and MS Money
My online banking service allows me to download my account data as
QIF, Quicken or MS Money format. Unfortunately I don't use any o
Does anyone here know of a way to get data from any of those formats
Thanks in advance
Message posted from http://www.ExcelForum.com
"djlong3000 >" <<email@example.com> wrote in message
> My online banking service allows me to download my account data as
> QIF, Quicken or ...Woks 2002 Money
I archived my records from 2005 to a CD. Money won't open the CD and I may
have lost all my 2005 info. In trying to open the archived CD file, I picked
"Restore from Backup." Now, My 2006 file is missing my records from most of
September and all of October! What have I done? Is there any way to fix this?
In microsoft.public.money, Jeannine wrote:
>I archived my records from 2005 to a CD. Money won't open the CD and I may
>have lost all my 2005 info. In trying to open the archived CD file, I picked
>"Restore from Backup." Now, My 2006 fil...match dates in two columns get value from third
I have a data set on daily basis and another data set on weekly basis. i want
to put the weekly data in daily data set by putting a formula which picks
values from col c for relevant dates in daily set. example - let us say this
is the data set
ColA Col B Col C
jan1 jan1 8
jan2 jan7 7
I want the data from colC against dates in ColA as in ColD below. it should
leave other cells blank (colA and ColB are dates format)
ColA Col B Col C ColD
jan1 jan1 ...Change Chart Size
I was wondering if anyone knows how I can change the sizes of charts in
excel. But i dont want to just resize by dragging the corners, i want to
lock the aspect ratio, and change the width to 3.5 inches. So basically, i
want to change the width of each chart to 3.5 inches exactly.
Another problem I am having is when I copy and paste a chart from excel into
powerpoint, all the changes to the size and text I made get changed so its
not the copy I wanted. Is there any way to change this.
1) Resize using aspect ratio only after the chart is sucessfully in
2) You get charts...worksheet_calculate event changes worksheets, but shouldn't
The code below is in the Sheet1 (Budget) Module: The user is entering
data into the "Budget" worksheet. When this fires, it should hide some
rows on the Categories worksheet. It does work ok, however, everytime a
user enters a new figure on the Budget worksheet, it fires and
momentarily flashes over to the Categories worksheet. It is quite
distractive, especially when one has hundreds of figures to enter.
I set a trap to stop it on the top line of this code - the Private Sub
Then, when I enter a new number on the Budget page, it fi...Microsoft Money 2005 not picking up data
I have recently bought a new computer (still with XP) and a) loaded my copy
of MM 2005 Standard to it and b) loaded the data files for MM which I copied
from the old computer. But I cannot get the program to pick up the data -
and of course, support from Microsoft ended last month! Can anyone suggest
what I should do to get the data to connect with the software program?
In microsoft.public.money, patsy <firstname.lastname@example.org(donotspam)>
>I have recently bought a new computer (still with XP) and a) loaded my copy
>of MM 2005 Standard to it and b) loaded th...Retrieving records between dates
Here is my table:
CREATE TABLE [dbo].[FD__PROGRAM_CLIENT](
[ClientKey] [int] NULL,
[PgmKey] [int] NULL,
[Date_Admit_Program] [datetime] NULL,
[Date_Discharged_Program] [datetime] NULL,
CONSTRAINT [PK_SYS_FD__PROGRAM_CLIENT] PRIMARY KEY CLUSTERED
609 6 2008-05-27 00:00:00.000 2008-06-02 00:00:00.000
459 4 2008-07-30 00:00:00.000 2008-08-12 00:00:00.000
605 6 2008-06-17 00:00:00.000 2008-06-30 00:00:00.000
607 6 2008-04-23 00:00:00.000 NULL
1671 4 2008-07-15 00:00:00.000 2008-07-16 00:00:00.000
1757 6 2008-05-17 00:00:00.000 NULL...Upgrading from Money 2003 Deluxe & Business
I am considering upgrading from Money 2003 Deluxe & Business to 2005. I
don't see a Money 2005 Deluxe & Business. It's either Deluxe or Small
Business. I liked having both in one software. What should I upgrade to, or
should I not?
Thank you in advance for any help on this.
In microsoft.public.money, tracallahan wrote:
>I am considering upgrading from Money 2003 Deluxe & Business to 2005. I
>don't see a Money 2005 Deluxe & Business. It's either Deluxe or Small
>Business. I liked having both in one software. What ...Preventing "save changes" dialog box???
My spreadsheet data is stored in the range A1:J20. Therefore, I do not
care if a user plays with or modifies cells that are outside of this range.
Can I somehow program Excel to prevent the "Do you want to save
changes?" dialog box if a user changes cells that are out of range and
then s/he closes the workbook??
I basically only want the "save changes" dialog box to be prompted
when cells within the A1:J20 range are modified.
Right click the worksheet tab that your concerned with and paste this
Priv...Changing Entity Name
We need to change the wording from "Account" to "Customer". can we do that?
On Wed, 27 Jul 2005 02:15:03 -0700, Shawki
>We need to change the wording from "Account" to "Customer". can we do that?
Not possible in CRM I'm afraid!
You will be able to do this in the next version of CRM, 3.0.
> We need to change the wording from "Account" to "Customer". can we do that?
This is possible. Unsupported t...Cannot change order state
Can anybody tell me why i cannot change order state?
I create order, its state is Active
Then i create invoice, and close it with Paid is full
but state of my order does not change
(i use test version of MS CRM)