Combobox height increasing on ownerdraw property
In my MFC application , I set the property of the combobox control as
onwnerdraw to override some drawing features. but the height of the
control( not the height of the dropdown) is getting increased when I
selected ownerdraw. I can see this difference when preview(Test) the
dialog at the design time itself.
Can you please suggest a method bring the combobox height to normal.
"Francis Abraham" <email@example.com> wrote in message
> In my MFC application , I set the property of the combobox con..."From:" Line Change
Before in Exchange 2000, the "From:" line for all
incoming msgs will use the "Display Name" entry if the
sender's e-mail address exist in the Global Address List.
After upgrading to Exchange 2003, that funtionality does
not exist anymore. Even if the sender's e-mail address
exists in the Global Address List, this is ignored and
the "From:" now line appears as per sender's own from
How do I revert back to before?
This change is for the better, because spammers and others would often spoof
a valid address in your domain as the From addres...changing shape of picture
I want to change an image from rectangular to oval or
round. How do I do that in Publisher? I can't seem to
find a straightforward way to accomplish this. I'm using
Using Microsoft Publisher 2002:
1. Draw an Autoshape that matches your prefered shaped
(from the object toolbar on the left side of your
2. Right click on this shape and choose Format Autoshape
3. Under the Colors and Lines Tab, go to the Color Fill
and choose Fill Effects
4. Now choose the Picture tab. Browse to your picture and
Brian Kvalhe...Total from SubReport Data But Not in SubReport
This is probably pretty simple, but I have created a report where the main
display is a subreport of items ordered by the customer order and price. I
would like to total the prices in the main report, but not from a total on
the subreport. The price field is called Expr5.
I have tried =Sum([Expr5]), but this gives and #Error
I can't figure out what you are asking. If you don't want the total from the
subreport, what do you want? Values displayed in a report must come from
somewhere. "Expr5" means nothing to any of us other than you haven't taken
the time ...Changing the order of names...
Ron and Pete...
What you had suggested for my earlier question "worked" for a file I
created, but I wasn't able to change it in the file I received...I'm guessing
Secondly..the names came across as (eg) Smith,Jane...is there a way to
change that order also for 2100 names??
> Ron and Pete...
> What you had suggested for my earlier question "worked" for a file I
> created, but I wasn't able to change it in the file I received...I'm guessing
> its protected??
> Secondly..the names came across as (...Page break before subreport if subreport has data
How can I create a page break before the subreport if and only if the
subreport has data?
Some records will have no data in the subreport, and I don't want an
unnecessary page break in those instances.
Add a page break control and some code like:
Me.PgBrkName.Visible = Me.subrptName.Report.HasData
Microsoft Access MVP
"Kathy Webster" wrote:
> How can I create a page break before the subreport if and only if the
> subreport has data?
> Some records will have no data in the subreport, and I don't want an
> unnecessary pag...CFO want me RMS Certified to support our growing operation
My company has been growing 20% each year and my CFO want me to get certified
like our System Admin as with MCSA. Why can't customer get RMS Certified?
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/...Mistake of changing decimal into whole numbers
Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30,
1.05 etc. to make it simpler, someone change it to 230, 105 and the
decimals was assumed after the 1st digit. Now the customer wants it back to
2.30 vs 230 but the format has been permanently changed. Is there any hope
here of changing it back?
Put 0.01 in a blank cell
Copy that cell
Select the range of number you want to move the decimal point on.
Check: Multiply and Values
(If that doesn't do what you want....Edit>Undo)
Does that help?
Reg...Change Folder List Font Type
Anyone know who to customize and change the Folder List
Font Type in Outlook XP?
I believe it's tied to your Windows font settings -- you'd need to play with
those and see which setting controls the font used in Outlook's folder list.
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
> Anyone know who to customize and change the Folder List
> Font Type in Outlook XP?
...update source & changes chart
First, how do i get rid of the slider on the left in this group showing all of the group choices
Second, is there a way to automaticely update the source data. I am inserting a new line of data at the top of and existing data set and like adding data at the top of a formula, etc excel does not recognize the new data. Does not appear that charting includes the "titles", thus allowing to add the new data with auto update
Third, when I go in and manualy update the source, by changing the row number from 3 to 2, picking up the new row added, the chart changes. It is a time series ch...Changing the ActiveCell
I want to Select and copy several block of data based on where the initial
ActiveCell is locate. The following copys the first block.
Dim StartingCell As String
Dim EndingCell As String
Dim RowOffset As Integer
Dim ColOffset As Integer
RowOffset = 2
ColOffset = 3
StartingCell = ActiveCell.Address
EndingCell = ActiveCell.Offset(RowOffset, ColOffset).Address
Worksheets("Sheet1").Range(StartingCell & ":" & EndingCell).Copy _
Now, "Logically" I ...Font change
I have a 500 page document with many text blocks that are using different
fonts. I would like to changa ALL the fonts to Arial. What is the easiest
way to do this.
I don't know that there will be an easy way.
MVP Microsoft [Publisher]
"Lizzzet" <LizzzetNOCAPS@dc.rr.com> wrote in message
>I have a 500 page document with many text blocks that are using different
>fonts. I would like to changa ALL the fonts to Arial. What is the easiest
>way to do this.
> Li...Change Excel Settings
How does one remove the highlight of a cell when it is clicked on and remove
the right click dialog box?
AFAIK first item cannot be done, although you could lock all cells and not
allow locked cells to be selected(if using xl2002 or 2003).
Second item requires VBA
Application.CommandBars("Cell").Enabled = False
Gord Dibben Excel MVP
On Mon, 10 Jan 2005 10:09:02 -0800, "Ronbo" <Ronbo@discussions.microsoft.com>
>How does one remove the highlight of a cell when it is clicked on and remove
>the right click dialog box?
...enormous formula bar and row height on opening excel
every time I open excel I get a huge formula bar and row height is set at 76.7
...Reports and SubReports Spacing
I have an AC2003 report. That main report (Main) has 4 subreport controls on
it (Sub1-4). Each of the reports associated with the subreport controls may
or may not have data in the corresponding table to report on. The Main
report has the following layout:
- Sub 2
- Sub 3
- Sub 4
When Main runs, if one of the subreports is blank, the area for that
subreport is blank (expected), but if any of the subsequent subreports do
have data, those subreports display in their position.
In the following example, subreport 2 has no data
Example ...group sections in a report to print or generate subreport
Is it possible to generate a report (or a subreport) that will allow a
separate report for each server (for grouping and printing purposes)
if I have many server names (with DB, Apps, etc.) in one huge report.
Maybe using a button on the large, main report (with all server names)
to print the server name on the current page along with the server's
information? Or instead of printing maybe there could be another
button that could generate a subreport of that current page's server
and it's information?
My question is:
After generating a report, how does one go about gr...Change Text Case
Anyone know how to change the case (from all caps to lower case, or just first letter cap) without retyping all the text in a worksheet? Thanks!
"Chel" <firstname.lastname@example.org> wrote in message
> Anyone know how to change the case (from all caps to lower case, or just
first letter cap) without retyping all the text in a worksheet? Thanks!
You can use a macro like the following:
Dim Rng As ...How to change the title of a CPropertyPage?
I would like to change the title of a property page.
I have tried to SetWindowText but it does not work.
Is there a solution?
Thank you in advance.
See if the following KB article helps you
Check Abdoul [ VC++ MVP ]
"Pierre Couderc" <email@example.com> wrote in message
> I would like to change the title of a property page.
> I have tried to SetWindowText but it does not work.
> Is there ...How do I convert an Access form into a data access page?
Is there a way to do this instead of redesigning a data access page?
"Chris" <Chris@discussions.microsoft.com> wrote
> Is there a way to do this instead of redesigning a data access page?
It may not be such a great move to do so... Data Access Pages have always
been limited, weren't well accepted, and have been "deprecated" in Access
2007 -- existing ones are still supported, but you can't modify them or
create new ones with Access 2007. They are "on the way out."
Microsoft Access MVP
We have front-end exchange 2003 owa server with a custom made
certificate configured with SSL. With the introduction of IE7, a error
is shown saying that the certificate is not valid and not trusted and
you should not continue. If you click on continue to this page things
work as normal.
However, we would like to purchase a proper verisign certificate so
that we do not get the error messages displayed. How would I change
this so that we use the new certificate instead of the custom made
Many thanks in advance.
On 29 Jan 2007 08:02:37 -0800, "justsimplequestions"
<s...How can I change the font and text size that occurs for all email?
I use Outlook 2003 and want to alter the font and text size for all email
messages that I create
See this article:
Change the text font
Microsoft Word MVP
(Message posted via NNTP)
"Jeff" <Jeff@discussions.microsoft.com> wrote in message
>I use Outlook 2003 and want to alter the font and text size for all email
> messages that I create
...change the frequency of downloading email in Outlook?
Can someone please help me, I can't find the way to change the email download
frequency for Outlook.
In 2003, it's Tools-->Options, Mail Setup tab. Click on Send/Receive button,
and change the value in "Schedule an automatic send/receive every..."
"NewPJ" <NewPJ@discussions.microsoft.com> wrote in message
> Can someone please help me, I can't find the way to change the email
> frequency for Outlook.
"Anne ...Exchange 2003 with OWA
We are running Exchange 2003 Enterprise Edition SP2 and have Outlook
Web Access running. We are going to implement a domain-wide password
policy so that the passwords change every 90 days. Is there a way for
OWA users to receive the prompt to change their password?
...linking to a range changes
hi, ive made a sheet where i'm linking a cell to another using =$a$
But when i cut and paste the value in a1, my link goes to referenc
fault. I thought if i used the $ signs the link wouldn't change. I
there any way to fix this?
Message posted from http://www.ExcelForum.com
> hi, ive made a sheet where i'm linking a cell to another using =$a$1
> But when i cut and paste the value in a1, my link goes to reference
> fault. I thought if i used the $ signs the lin...Excel 2003 & cutting/pasting text from web pages
When I cut text from a web page, Excel then tries to connect again to that
web page to setup some sort of auto-update option.
This is very annoying, especially if all I want to do is copy & paste the
text/numerical contents from an (https) web page onto a sheet - I can see
this since the desktop firewall I'm using (Sygate) keeps complaining about
Excel attempting to connect to the web.....
* How do I disable that feature - the copy operation should be over & done
with after Ctrl+C
THIS Feature is not a "productivity" enhancement...
You should copy, pa...