Stacked Column Graph
I have data that counts in two separrate ways. How can I put two stacked
columns next to each other on the same graph (X is in days, Y1 is # of
incidents, Y2 is currently an average of days used for a line above the
Have a look at the resources referred to by Jon.
> I have data that counts in two separrate ways. How can I put two stacked
> columns next to each other on the same graph (X is in days, Y1 is # of
> incidents, Y2 is currently an average of days used for a line a...List Boxes #2
Can someone tell me how to correct the following code so that both
columns in the listbox will be updated? Only the first column
ReDim MyArray(mycount, 1)
usrGLDist.lstOutput.ColumnCount = 2
For i = 0 To rst.Count - 1
MyArray(i, 0) = rst.Value("descr")
MyArray(i, 1) = rst.Value("pcamt")
usrGLDist.lstOutput.List() = MyArray
Richard wrote :
> Can someone tell me how to correct the following code so that both
> columns in the listbox will be updated? Only the first col...In Publisher "Help" there is nothing about inserting FOOTNOTES or.
How do you insert footnotes or endnotes in Publisher?
Hi pastorcam (firstname.lastname@example.org),
in the newsgroups
|| How do you insert footnotes or endnotes in Publisher?
You need to create them manually. Publisher does not offer footnote/endnote
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
...adding and counting Help!! #2
Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe
doing the sum of dollar amount
alexm999's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=491
View this thread: http://www.excelforum.com/showthread.php?threadid=27264
> Just to add, I'd like to sort the dates 2004.10.01 to 2004.10.31 whe
> doing the sum of dollar amount.
Assuming that dates are true dates...
=SUMPRODUCT(--(CodeRange=101),--(AdvertisingRange="TV"),--(TEX...Outlook 2003 Add-on help
Is there a way, either built-in to Outlook 2003 or through third party
software that will display contacts in a alphabetical list when
composing a mail message? Specifically, the user wants to be able to
select a letter, e.g. "A", "B", "C", etc... when composing a message
(when clicking the "To" field in the mail form) that will pull up an
alphabetical listing of contacts from the address book.
I know this capability resides in OWA, but I have yet to find a
solution for Outlook 2003. Any assistance would be greatly appreciated.
ryan.hopm...Help: my reminders don't work
I'm running OL 2003 on WinXP pro connected to an exchange server.
I run this configuration on both my laptop and my desktop. On my desktop
the calendar reminder pop ups and alert sounds don't work but they do on my
laptop. As far as I can tell, the configuration is identical. I've tried
the /cleanreminders and /resetfolder switches, but the don't make any
Any advice appreciated. Thanks.
Cut off: yourhead to respond
Have you checked your Sounds and Multimedia options on the desktop to ensure
that your sounds are working correctly and th...How to disable "A Program is trying to access Outlook" dialogue box?
After I re-installed Outlook XP, it has started displaying a dialogue box
saying "A Program is trying to access Outlook. Do you want to allow access"
with Yes/No buttons and if Yes, then to allow access for specified period in
minutes, whenever I try to synchronize Outlook with my Palm Pilot
Is there a way to disable this dialogue, and allow automatic access to
Outlook as it was before re-installation?
No, you need to go to Palm and get an update.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (inse...Trying to do progress bar
I have a Form with a progress bar and a thread that should update the
progress every quarter of a second. The operation being monitored for
progress on is a file loading job.
So I start off the monitor like this:
long currprogress = 0;
FileInfo info = new FileInfo(currFile);
long maxprogress = info.Length / 100;
bool IsMonitoring = true;
Thread monitor = new Thread(new ThreadStart(RunMonitor));
(the scope of these variables is class level though, just made them local
scope for easier reading)
Then my RunMonitor method looks like:
private void RunMonit...Change events for all controls on a dialog
Is it possible to have a single method that handles all
change notifications to text boxes on a dialog? I want to
enable the OK button if any text box changes.
The application I am porting to MFC has the following
code in its dialog handling procedure:
switch ( uMessage )
// Enable the OK button only when changes are made
if ( GET_WM_COMMAND_CMD( wparam, lparam ) == EN_CHANGE )
Button_Enable( GetDlgItem( hdlg, IDOK ), TRUE );
switch ( GET_WM_COMMAND_ID( wparam, lparam ) )
// handle other commands
It seems that in ...Hyperlink in my Dialog control
I want my text in a dialog control to behave like a hyperlink in a web page.
Is it possible and how(VC 6.0)
Here are some examples:
http://msdn.microsoft.com/msdnmag/issues/01/01/c/default.aspx (look for CStaticLink)
Ajay Kalra [MVP - VC++]
"Lesher" <Lesher@triplebit.com> wrote in message
| I want my text in a dialog contr...Loosing Data-Help needed
Hi All, I have an huge spreadsheet with macros on it, which is
continuously updated. Off recently my spreadsheet is loosing the data
i.e. I will have 2-3 days old information, all the updates that we made
recently is lost. I am saving the spreadsheet every 15-20 mins still it
is doing it. Could anyone please help me :confused: .
neomemphis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33240
View this thread: http://www.excelforum.com/showthread.php?th...List Box refer to an array
I need to create a listbox1 within a userform to select one name from a list
The list of names varies in length from 3 to 60 people.
The list of names starts at B2 and goes down (and varies in number)
Can I get it to default to the 'users' name (from Tools>Options...>General)?
Do I have to set up a dynamic 1d array when I call up the userform?
Andrew 'The Ox' Heath
UserForm1.ListBox1.RowSource = "B2:B" & _
>-----Original Message---...Dialog based problem in vc6
I am writing an mfc project in vs6 and I have a problem!
When I add radio button to my dialog based application and run the
application and press that button my application hang, even when I try to
run it in the test mode inside visual studio and press that radio button it
stack the all environment why??
It append only if I add a radio button for a regular button its all ok!
I install sp-6 but it didn't solve the problem.
"Dave" <email@example.com> wrote in message
> I am writing an mfc project in ...Column Sum in Footer
I have created a Tabular report that lists names and weights for different
people. I want to create a stand-alone field in the page footer that will
display the SUM of all the weights on the report. Can somebody please help
me? (I'm using Access 2000 btw)
I have tried creating a text box with the Control Source property set as
"=Sum(weight)". However, this just produces an error.
Thanks in advance.
Julie Smith wrote:
>I have created a Tabular report that lists names and weights for different
>people. I want to create a stand-alone field in the page f...Help! #12
It repeatedly asks for my network password.And doesnt
recognise it when i enter it. I havent changed the
password from the original. Has this happened to anyone
else? Does anyone know how to fix it?
Do you mean that Outlook keeps asking for your Outlook password? Check
CapLocks, etc. I believe Outlook passwords are case specific.
"Leslie" <firstname.lastname@example.org> wrote in message
> It repeatedly asks for my network password.And doesnt
> recognise it when i enter it. I havent changed the
> password from ...How to group similar column titles together????
I have an excel spreadsheet with 6 column titles as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ab1
4th column title = ob3
5th column title = ab2
6th column title = ob4
I have about 200 lines of information on each column. I want to run a macro
/ function on this spreadsheet and my spreadsheet should regroup similar
titles together as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ob3
4th column title = ob4
5th column title = ab1
6th column title = ab2
Can someone think of any way to do this? (A macro ...Displaying all of the fields for a record chosen in a combo box
I run projects for retail customers. I have a form that allows me to see all
of the phases of the project at once. I cannot figure out how to display the
entire record of the particular unit on which I am working. Subforms haven't
worked as I need to choose from a master list each time. Any help on this
would be greatly appreciated.
On Fri, 8 Feb 2008 07:49:02 -0800, Ed3 <Ed3@discussions.microsoft.com> wrote:
>I run projects for retail customers. I have a form that allows me to see all
>of the phases of the project at once. I cannot figure out how to displ...opening file problem please help
When I click on an Excel file in Windows Explorer, I get the following error
"a document with the name "filename".xls is already open. You can not open
two documents with the same name at the same time". (Clicking ok closes the
message and the file opens.)
This happens on every Excel file in Explorer. There are no other files open
on my p.c. at all.
If I open Excel first and open the file I want by clicking the File menu and
selecting Open, the file will open with no error message. Other than that
the programme works perfectly
I'm using Excel 97 and Windo...Custom entity with same display name as out of the box?
I tried to create a new entity "new_InvoiceDDI" with a display name of
"Invoice" and it won't allow the display name to
be the same as a "out of the box" entity.
Why is this? Anyone know a way around it?
There's no way around it except renaming the existing invoice entity to
something else. One obvious reason is the Outlook Client. It uses the
display names to show folders, but folders needs to have a unique name. The
web client uses the display names as well, so how can a user differentiate
between two entities having the...format colors on bar charts by value
I'm working on a Bar chart with 5 bars. What I would like to do is change
the color of each bar depending on the number it is graphing. My table is
very simple, column A is the data names, column B are the values from 0 to 3.
If the value is 1 I would like it to change the color of the bar to red, if
it is 2 I'd like it to change to yellow, if it is 3 I'd like it to change to
Can this be done?
Bernard V Liengme
remove caps from email
"BillC...Reports Columns Help/Field Name Help
I wrote in previous to get information on makin a 3 column report w/out
Fieldnames repeating. The code worked and it is listed below:
If Me.Left < (2 * 1440) Then
Me![FirstNameLabel].Visible = True
Me![LastNameLabel].Visible = True
Me![TitleLabel].Visible = True
Me![FirstName].Visible = False
Me![LastName].Visible = False
Me![Title].Visible = False
Me.NextRecord = False
Me![FirstNameLabel].Visible = False
Me![LastNameLabel].Visible = False
Me![TitleLabel].Visible = False
Me![FirstName].Visible = True
Me![LastName].Visible = True
Me![Title]...Help !!!!!! Excel 97 keeps crashing out of my file.
I have a workbook that has been in existance for several years and is
continually being developed. After adding some additional graphics I
suddenly started to get The Program error Dialog Box : "Excel.exe has
generated errors and will be closed by Windows. You will need to restart the
program. An error log is being created". I've deleted the graphics and I
continue to get the error whenever I try to copy to the clipboard. I am
running Excel 97 under Windows 2000 on A DEll Latintude 640 laptop. Any one
any suggestions as to what has happened and how I can rescue the situation?
The...exchange OWA mzil boxes access rigths
Guys, hello to everyone, who will try you help or just to read this
Here is my problem.
I have started a new job, this company migrated exchange 2000 to 2003.
OWA was not working I have modified some to the setting within the IIS;
it works now, but.........
When I open my mail box at the first time, it asks for password, after
I put the password and I am seeing my mail box, I can simply change
just the user name part,
On the browser and get to entire company e-mail boxes without supplying
a password. Looks real cool to be hones I can read everyone's e-mail.
What is the way to have OW...exchange help #2
im having a problem on exchange where some boxes can receive mail and
others cant, and then other times it gets inverted and the ones that
couldnt now can and visa versa
any ideas where i can start looking?
thx in advance
Start by describing your environment. Single 2003 Exchange Server?
FE/BE? Outlook 2003 Clients? All mail having problems, or just
external? Any error messages in the event logs? What exactly does the
David A. Bermingham, MCSE, MCSA:Messaging
Senior Systems Engineer
> hi guys,
> im having a probl...InterOrg Synchro tool
Please help - I need the InterOrg Synchronization Tool for Exch 5.5 - It can
be found on the Back Office Resource Kit. I found a download link at Technet
but it turned out to be a dead link..."sorry...no longer available" Ay
Caramba! Can anyone find a download location for it?