newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...Outboud Receipts; view
Some message came in requesting read reciepts. I accepted
the reciept request.
Now I have reciepts that will not send and I would like
to remove them from the queue. Because they are stuck I
cannot send any outgoing mail on this account.
Nothing shows up in the outbox but when send/receive(ing)
it shows the receipt count and fails.
Anybody have an idea how to view/remove these bad
get Outlookspy (www.dimastr.com/outspy/) and use it to delete the receipts.
They are hidden in the top level of the mailbox or personal folder.
Diane Poremsky [MVP -...Help! Unable to mount public folder store event 9519
I am getting the following error when tring to mount the public folder store.
Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 9519
Error 0x8004010f starting database "First Storage
Group\f7967383-856a-4b7f-9023-37c269a0e908" on the Microsoft Exchange
Look up of DB Info failed.
For more information, click http://www.microsoft.com/contentredirect.asp.
I have tried numerous ms kb articles to no avail.
I did find this on a news group :-
I'm looking for help some help with a formula.
How would I go about a formula for automatically adding 8 hours to a
number each calendar month? I would like to open it and have it done for
me if that's possible rather than having to remember to add it each
month or forgetting if I did or not.
For instance, i start out with the # 248 in a cell that I would like to
automatically add 8 to each calendar month.
"Gadgetman" <email@example.com> wrote in message
> I'm looking for help some help with a formula....need document properties statistics revision information
using excel 2000 pro
in document properties; statistics tab; bottom half of info i do see "last
saved by" info but cannot find help on how to get the "revision number" and
"total editing time" information.. can anyone help me with this.. I would
like to set it up so that it is automatically entered for every document i
create and not have to recreate for every file.. thanks
...Creating a view with concatenated columns
I have a table with about 20 columns and I am trying to create a view of it
about 10 columns. The problem is that in the process, I am trying to
fields into one field and I am unable to get any thing working. Below is one
my attempts to tackle this. Any ideas will be highly appreciated.
// The following should be considered as pseudo-SQL
CREATE function [dbo].[fn_myview] (@CardNo varchar(11)) returns Table
declare @FullName as nvarchar(128)
(SELECT FirstName, FatherName, GFatherName, FamilyName, Birthdate,
Birthplace...I need help with a formula
I'm making a stock list sheet and I like to put on it the value - and +
like when I take boxes out it will give me the total and when I add in
it will change also.
This is for a weekly count.
I'm very new to excel so please H-E-L-P-.
I need the instruction like u give it to a child. :) :)
Thanks a lot
pampam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26224
View this thread: http://www.excelforum.com/showthread.php?threadid=395241
We need ...formula help 02-10-10
Would like to accomplish:
How do I add number 2 infront of the above ISSUE numbers as I have thousands
of line to do.
If your number is in column A then in column B type
=2 & A1
and copy it down.
Please rate when your question is answered to help us and others know what
> Would like to accomplish:
> 2...Need Exchange limit help
I have a new SBS 2008 Server setup in a manufacturing environment. Two
users within the company send and receive large CAD files. How do I allow
this process? Right now one user is try to send a 185MB file and it is
saying "the message being sent exceeds the message size established for this
user." I have tried setting the limit in the console to 10GB and now I have
unchecked the "enforce the mailbox quotas" box and he still can't send. If
I go into the Exchange Management Console I still don't see how I can make
this work. Is this something that...MFC CPropertySheet: hiding Apply button partially works
I am hiding the Apply button in a property sheet by using the following code
before creating it:
m_psh.dwFlags |= PSH_NOAPPLYNOW; // remove the "Apply Now" button
This works in the sense that the button is gone, but what I'm finding is
that the "A" hotkey is still assigned to it!
If I add a checkbox to one of the tabs, for instance, and I underline the
"A" in the label. If I hit Alt-A it will only set focus to the checkbox but
not check it.
This is the behavior that you get if you have another field with the same
hot key, but there is none. My only tho...static control color in Custom Control in MFC
In the win32 application I have written WM_CTLCOLORSTATIC which was
processed and white brush was returned(GetStockObject(WHITE_BRUSH)), so the
static control which is child windows of the custom control looked white.
In the corresponding MFC program I have the OnCtlColor for the "custom
control" handled as:-
HBRUSH CEditHold::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)
HBRUSH hbr = CWnd::OnCtlColor(pDC, pWnd, nCtlColor);
int id = pWnd->GetDlgCtrlID();
if(nCtlColor == CTLCOLOR_STATIC && (id > 0 && id < 9))
return (HBRUSH)GetStockObje...Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000
stores in 10 states - mostly in the South. We have many stores in the
hurricane zones. During Rita and Katrina we decided we needed a better way
to track how our stores are affected and what help we could provide. I've
designed a database to do this.
I have three main tables:
fldUnit - the unit number assigned to the store
fldPr...Viewing 4 different graphs at once
I have a workbook with 4 sheets. Each sheet has a graph on it. I want to show all 4 graphs on one sheet in a window pane environment. But I can't click on the chart and get it to allow me to do a Window - Split
Any help would be greatly appreciatied
Hi Kelly -
Insert a blank worksheet. Right click on each chart in turn, select
Location from the pop up menu, select the As Object option, and select
the new sheet from the drop down list. When you've gotten all four
charts onto the sheet, you can arrange them to your liking. If you hold
down the Alt key while ...Creating MFC child dialogs and windows in DLL.
Hi, I need to write some kind of plug-in, which are implemented as separate
dll's. I already wrote a few plugins for this program using MFC and it
worked ok, but now I need to create some GUI inside a plugin.
I have an interface like that
virtual void ShowConfDialog( HWND hwndParent ) = 0;
virtual HWND CreatePanel( HWND hwndParent ) =0; // create child
window, position and size will be
// controlled by a parent window.
But when creating a child windows in MFC I nee...Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you
enjoy the respect and additional income that could come from being able to
help everyone in your office on Microsoft Outlook? Get your Outlook
Specialist certification and realize the benefits it can have.
"Are You Certifiable (In Outlook, At Least)" is available at
http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go
through each subject on the test and help you to prepare for this
certification. If you do not plan to get certified but need a little extra
help on using Outlook it is an excell...MFC 7: Dropdown combobox not working under Win98?
I've written a dialog based app which has comboboxes. In my RC file it is
COMBOBOX IDC_WSCBOW,168,100,72,12,CBS_DROPDOWNLIST | WS_VSCROLL |
and I use CComboBox type as mapped variable. The dialog runs ok on XP, but
in 98, the dropdown list is not drawn. Any ideas to get around this
problem? I've tried the SetItemHeight() but in vain.
CheckAbduol loves this question. Open the RC File and click on the arrow of
the combo box, same way you would drop down the list, it should give you the
outline of the drop down area, resize it t...SQL script to create views
I think I saw a script somewhere on CustomerSource that
would crete views with Table Display Names - would anybody
know where to find it?
Do a search for SDK and GenView (or Gen View, and it's part of the SDK). I
believe that's what it's called. It's not so much a script as it is a
"Mario" <firstname.lastname@example.org> wrote in message
> I think I saw a script somewhere on CustomerSource that
> would crete views with Table Display Names - would anybody
> know wh...Looking for help...I can't send e-mail using CRM web client
I'm having a problem with trying to send e-mails vie the CRM web client.
When I try to send the e-mail I get a pop-up with the message in bold
"Unexpected Error" "An error has occurred. For more information, contact
your system administrator". I've checked the event logs, no errors are
showing up in either my CRM server or my exchange server.
I'm lost, new to CRM. Any help or ideas is appreciated.
You could try to add pre-windows2000 account to the administrator group on
the exchange server. Some time that helps
"Marty" wrote:...Font format of rich edit ctrl in dialogs, Help!
I have used a lot of rich edit ctrl in my dialogs (I am sorry that I haven't
use edit ctrl instead) and I found one problem now. The text displayed
initially in the ctrl (set by DoDataExchange()) has different font format
with the text which users type in later. Any experienced people can tell me
the functions to make these two font same? Otherwise I think I will have to
change about 100 rich edit ctrl to edit ctrl besides a lot of codes.
Thank you a lot.
...Views in Outlook
I'm using Outlook 2002 and am having issues with the Views...
- I created a custom view while in my "Outlook Today" folder and gave it a
- I apply the view to several folders within the "Outlook Today" folder (is
there a way to apply it globally?)
- I notice that I need to alter the formatting, so I go to the "Outlook
Today" folder and change the formatting to my view.
- The folders using that view *DO NOT* change to reflect the current
formatting of this view. If I go to define views while in one of these
folders I do not see the changes that we...Help in Query with two condition
I have a table like this:
Planner Qty User6 CUT SUB
BAM-06 1 CONC Yes No
BAM-06 1 CONC No Yes
BAM-06 1 TOC Yes No
BAM-06 1 TOC No Yes
BAM-06 1 TACT Yes No
BAM-06 1 TACT No Yes
JAXM-06 1 CONC Yes No
JAXM-06 1 CONC No Yes
JAXM-06 1 TOC Yes No
JAXM-06 1 TOC No Yes
JAXM-06 1 TACT Yes No
JAXM-06 1 TACT No Yes
Note: CUT and SUB are check box
I want a result as follow:
User6 A B C D E F
CONC 2 2 1 1 1 1
TACT 2 2 1 1 1 1
TOC 2 2 1 1 1 1
A SUM Qty =BAM-06
B SUM Qty =JAXM-06
C SUM Qty =BAM-06 if Cut=YES
D SUM Qty =JAXM-06 if Cut=YES
E SUM Qty =BAM-06 if SUB=YES
F SUM Qty =JAXM-06 i...Help with Date format
I want to enter dates into a worksheet like this:
January 25, 2001
And i want to get excel to display the date with the following format:
I have tried using a date format from the format menu but it wont display
the date like i want! It will only display the date as I typed it in.
Thanks to anyone who can help. :)
It appears you're typing the date into a cell formatted
as something other than General.
1. Delete the current contents of the cell.
2. Format > Cell > Number tab. Choose a date format.
3. Now key in the date into the cell.
>-----Or...Excel File Rename Macro Help!
Daily csv files are dumped into a shared folder and i have written a
macro that goes into that folder and automatically pull in data to put
it in microsoft access tables. What i want to do next is after
importing the data into access, rename those files to include dates and
times. This import runs every morning so whenever a new csv is dumped
in there, my macro will run the newest ones and avoid the past ones.
Any ideas guys? I guess im looking for a rename macro sql script.
Please see below script. Any help would be greatly appreciated!!
Dim fso As Object, fol As Object, fils...A little macro help?
I would like to use a macro to copy and repeat lines 'X' times on a new
page. To find out how many times each row is to be copied, the number is
provided in the last column ('C' in this case) of a spreadsheet.
Sample data for start point:
Lastname First Name Qty
Smith John 3
Hank Aaron 5
Result required on new sheet in same spreadsheet:
Lastname First Name
Can someone provide some macro code that will create the number of
required rows on a new sheet called 'list' within th...I need to set up about 50 resources without a delegate
Is there some way to automate this? The method described by Microsoft is
very time consumming <http://support.microsoft.com/kb/180424/EN-US/>
I'm using Exchange 2003 with Outlook 2003.