Pie Chart display
The attached sheet is extracted from a workbook of many things that I
find helpful which I save as I learn.
However, when I extract this sheet the Chart numbers changed, meaning
that the pie and doughnut no longer display correctly.
To 'use' the .FirstSliceAngle (in the 'Spin Chase' button) it appears
to need the chart to be activated, producing the 'selected' look which
I was able to avoid in the other displays by activating a hidden chart
in the R column.
Other display problems were avoided by using a white font hidden behind
other charts for processing (to prevent ...Euro Display Not working in Form
I have an Access 2003 Client linked to a SQL Server DB (2005).
When I change a text box to format as Euro it never displays as Euro, only
the number. I've tried Currency Type in SQL Server, Decimal, Numeric, etc..
What Am I doing wrongly?
...Printing Barcode Font in RS2008
We have several reports that use custom barcode fonts, and these have been
working happily for ages.
We have recently deployed our reports to a sql2008 instance and have hit a
The Report Previews correctly in Reporting services (i.e. the user sees the
The report previews AND prints correctly in VS2008.
When we print from Reporting services the barcodes font is not displayed
(gibbersish characters are displayed instead).
We have checked that the users all have the barcode fonts installed locally.
We have also installed the barcode fonts on t...Upgrade from 8 to 10 and recived an error message when printing
SOP Inventory Sales History report
Error in Equation 'C Exception Item'
Not much to go by, but try recreating the calculated field. In addition, did
you check if this report would upgrade?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> SOP Inventory Sales History report
> Recieved Message
> Error in Equation 'C Exception Item'
I would like to know if it is possible to change by program the font
used in caption bar, menu, status bar, ...
Raymond Mercier wrote:
> I would like to know if it is possible to change by program the font
> used in caption bar, menu, status bar, ...
> Thank you
> Raymond Mercier
The status bar is a control, and like other controls its font can be
changed by calling its SetFont function with a CFont that you initialize.
But the caption bar and menus are drawn by Windows using the system
preferences. You cannot direct...displaying the Day from a date
I have a field on my form that displays a date like 2nd April 2007 is
there a way to display the day as well
Monday 2nd April 2007
Thanks very much
Set the Format property of the text box to:
That should show the day and date (depending on how you have Long Date
defined in the Windows Control Panel, under Regional Settings.)
You can also show the day in another text box with the Format property set
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allen...Excel with Concatenate does not format date correctly
I am using Excel 2007. I want to use concatenate to combine employee
name with date started.
The date is not showing correctly.
The screen shows:
What do I need to do differently, so it says:
> I am using Excel 2007. I want to use concatenate to combine employee
> name with date started.
> The date is not showing correctly.
> A1=Jane Doe
> The screen shows:
> Jane ...how to display two spread sheets side by side
How do I display two spread sheets side by side?
So that I can read from one and edit the other spread sheet, at the same
After you opened the spreadsheets you want to view, Try
"Andrea Gates" wrote:
> How do I display two spread sheets side by side?
> So that I can read from one and edit the other spread sheet, at the same
> Thank you.
The best way, if you can manage it, is to use multiple monitors. Personally,
I can hardly get along anymore with less than two.
Va...Inserted Picture Not Display
I have inserted a picture onto sheet1, but it wasnt displayed, only eight
handles can be seen. The inserted picture will display only after I move it,
but then when I switch to another sheet and come back to it later, it
disappeared again. Please help me!
I am using Excel 2003...My OS is XP Pro.
Love to be here
I would like to use projectors connected to networked computers to remotely
display the data from an excel spreadsheet.
The operator of the spreadsheet will be entering numbers in the cells that
represent the wrestling matches coming up on the mats. We would like the
fans and competitors to then see the schedule on the projected screens. Is
this possible? In real time?
Ohio Youth Wrestling
This mailbox protected from junk email by Matador
from MailFrontier, Inc. http://info.mailfrontier.com
...How to write in Japenese font?
I want to write in Japenese font in Word. Is there any possibility to write
in MS Office 2003 with On-screen keyboard?
It's not a Word thing, it's a Windows thing.
Go to Start > Control Panel > Regional and Language Options, and try
to follow the tabs and buttons for "installing a new keyboard" (not
"installing a new language") They are rather different in XP, Vista,
In XP you need to check the box for "Asian scripts" (not "complex
There are many different input methods for Japanese; you can read
As a test, I've created a text file in notepad containing the following 2
The delimeter is Comma,
The text qualifier is double-quote
The contacts import without error. When I activate the contacts, I don't see
Any idea why? Seems as though should without issue.
I am trying t convert 2 cells, but i only want to merge if the total
characters does not exceed 70 characters, can anyone help me with a formula
I am not sure if this is what you want:
check both columns if less than 70 = concatinate both, if not blank
this concatenate both cells up to 70 characters
Please click "yes" if this post helped you!
> I am trying t convert 2 cells, but i only want to me...Display Scroll bars
What is the best way to assure that when an Excel workbook is open it
fills the entire screen, regardless of the user's display specs, and
that both the horizontal and vertical scrollbars display.
Private Sub Workbook_Open()
.DisplayFullScreen = True
.DisplayScrollBars = True
.DisplayStatusBar = True
And I've also tried:
Private Sub Workbook_Open()
Application.DisplayFullScreen = True
ActiveWindow.DisplayHorizontalScrollBar = True
The problem is the horizotal scrollbar does not appear. Ironically
after ...Modify OWA GAL display
I will be customizing the fields that are returned when users view contacts
(from the GAL) in the outlook address book. Is there also a way to modify
the fields returned when user searches the GAL from OWA? i.e. display
middleName with the results.
Can it be done in both the rich version and the light (non-IE) version? How?
Exchange 2k3 running on win2k3.
...Looking fo upgrade from 10.0 to 10.0 SP3
I am trying to find documentation on upgrading from 10.0 to 10.0 SP3 (or the
latest GP 10 instance). I looked through the downloads and found this
10_GP_ENUS_FP1_DVD_SP3.zip 1.4gig file. I downloaded and unzipped and found a
normal setup.exe, but no real instructions on how to upgrade. I'm I looking
in the correct place? Do I need to upgrade to SP1 then SP2, then SP3? I'm a
little lost at this point.
Servie Packs are cumulative in nature so SP3 will include all fixes and
features for SP1 as well as SP2, so You can directly upgrade to SP3. You'll
find the upgrade to ...Signature Fonts
We are using Outlook 2000 and need to disable the font
selection for signature blocks (we want to keep it at
Times New Roman 10). Is this possible?
Again thank you in advance for your help.
...Suggestions regarding split in time upgrade option
We would like to suggest to you to provide with the much required feature of
upgrading GP to a higher version with an option to upgrade databases in
different phases for our clients.
We would like to stress on the fact that it gets more and more important by
day to have a "split in time" upgrade routine for bigger clients, as we see
that some upgrades are running into 4-5 days processing (big databases in
size and up to 15-20 operational companies running on GP).. Even taking into
account a weekend it still means that the client is down for 2-3 days of
daily b...Upgrade to Office:mac X from PC version
I am currently switching from PC to mac.
To this end I have purchased an upgrade copy of Mac Office vX to
replace my PC version.
However, when I try to install the Office Mac vX on my powerbook it
does not recognise the PC version on CD to confirm my eligibility for
The upgrade eligibility does not metion at all not being able to
switch OS for upgrades.
Can I upgrade from Office XP on my PC to Mac Office vX on my
powerbook? (I will be getting rid of my PC once all has been switched
In article <firstname.lastname@example.org>,
...Is there font size limitation on antialiasing?
I made a program to display a character on LCD.
To apply anti-aliasing, I created font with ANTIALIASED_QUALITY flag.
[ CFont.CreateFont(... , lfQuality, ...) ]
The problem is like this:
When I displayed characters that the font size is larger
than about 680-pixel, the anti-alising is not applied on displayed character.
So I tested my program on the other computer. (My computer is Win2k, the
other is WinXP.)
At this time, characters that the font size is larger than 330-pixel is
with no anti-aliasing.
[ ANTIALIASED_QUALITY ] Windows NT 4.0 and later: Font is ant...how do I add a functioning time display in a visio document?
Have a simple visio document and I want to add some simple clocks showing
various time throughout different time zones.
You can add text fields to shapes that display the current time. This could
be customized further to add or subtract a few hours to calculate the time
in a different time zone. Visio refreshes time fields every few seconds.
Office Graphics - Visio
This posting is provided "AS IS" with no warranties, and confers no rights.
"colezilla" <email@example.com> wrote in message
I can't seem to get the simple display name to work.
I modified the registry to use the simple domain name. I haven't restarted
the information store service yet. I thought that with SP2 it should fix this
I have Exchange 2003 SP2 on Windows 2003.
La Senza Support
La Senza Support <LaSenzaSupport@discussions.microsoft.com> typed:
> I can't seem to get the simple display name to work.
> I modified the registry to use the simple domain name. I haven't
> restarted the information store service...font size in comments
Excel 2003 all sp and patches loaded
OS: Windows XP
Can you change the default font size in comments?
From Debra Dalgleish..............
You can change the font size of new comments by changing the settings in your
(Instructions for Windows XP)
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the default font used in
Gord Dibben MS Excel MVP
On Tue, 9 Jan...Default Fonts and Font Colors
Can anyone tell me how to reset the default font type and color?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from glomax <firstname.lastname@example.org>...
> Can anyone tell me how to reset the default font type and color?
Can anyone tell me what version of Publisher you are running?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
You cannot, you need to upgrade to Publisher 97 for all those excellent
Publisher 2003 has re-introduced some of...Displaying numbers used in formula
Hello. I have a spreadsheet with many elementary formulas. The VP wants the
numbers used in the formulas displayed next to the cell with the formula. As
an example...Let's say in J11-J14 I have the numbers 34, 67, 57 and 48. In
D10 I have the formula: =(J11/J12)+(J13/J14). Great, but now in E10 the VP
wants to see: (34/67)+(57/48).
Of course I could do it manually, but there are LOTS of formulas on each
sheet and the numbers change weekly. Is there a way to EASILY automate this?
Use the & symbol and quotation marks. For example, if you enter