Folder displaying incorrect item number
I've got a number of users who have a shortcut to a public folder on their
outlook bar. This shortcut incorrectly displays the number of items in the
folder. For example, there is one item in the folder but the shortcut shows
52. If there's 2 items then it shows 53. If I log onto the PC then it
displays the item number correctly. I logged one of the users onto another
PC but the problem was still there. I recreated her network profile and her
outlook profile but no joy. Were using outlook XP and XP desktop.
Any help is appreciated
Have you seen if there is any filter ...Adding Task to Outlook
Option Compare Database
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
.Subject = "Date Case Began: " & [Forms]![frmERLR_Main]!
[DateCaseBegin] & " Action Type: " & [Forms]![frmERLR_Main]!
[ActionType] & " - " & [Forms]![frmERLR_Main]![ERLRAgencyName] & " -
Management POC: " & [Forms]![frmERLR_Main]![...2003 > 2007 Migration (AD Issue)
Exchange 2003 server is now gone and everything is running fine on Ex2007.
Viewed from adsiedit, the old Ex2003 administrative group named "First
Administrative Group" still exists in Active Directory, but the old removed
2003 server does not exist in the "First Administrative Group".
If I delete the "First Administrative Group" with adsiedit, the public
folder store in Exchange 2007 will not mount with an error
"MapiExceptionADPropertyError: . . . "
I have narrowed down the specific item in the old Adminsitrative Group to
the item in this path...? Virtual List Control Data Source
I've seen several examples and tutorials on using virtual list controls, but
they all generated the text in one of the same three ways in the LVN_GETDISPINFO
handlers: index some hypothetical array, convert a random number to a string, or
convert the item/subitem number to a string.
These are not very useful since I have always used the list control as the
container for the data itself. I know that some people use external data sources
even with non-virtual lists, but I have not needed to do that yet; writing and
reading from the control has been sufficient for the sizes of data (tex...Problem with MFC ActiveX Control
I have created an MFC ActiveX Control through the wizard. In the 2nd Step of
the wizard I have enabled the checkbox saying “Available in Insert Object
Dialog”, so that I can use my control in Microsoft Office Application like MS
Word, Excel, PowerPoint etc using Insert Objects.
I am using property sheet to change the text contents of my control. For
that I followed the steps mentioned the MSDN Example CIRC.
My control features the following characteristics.
• Changing the painting behavior of an ActiveX control
• Adding stoc...Deleting or Adding Zeros
I have two lists in CSV format that I need to join tables in Access.
One list, which is too large to open in Excel has no zeros at the end
or a letter. The other list has zeros or a letter.
How can I add zeros to one list or delete zeros from the other list?
100-01-002 (The other list has this number: 100-01-0020)
100-01-004 (The other list has this number: 100-01-0040)
For this example, I'm going to assume that you wan...Problems adding a POP account
I have 3 active email pop accounts on Outlook 2002. I tried to add a 4th
and it shows up on the list of accounts, but not on the popup screen when I
hit send/receive and I am not receiving any email on that account. On the
list of accounts I can not move it up on the list or make it the default
account, it is like it is ignored.
In the account setting you'll have a checkbox sayong "include this
account when I send/recieve" e-mail or somthing of that kind, makle sure
it is filled, and it should solve your problem.
> I have 3 active ...Added text to equations
I have a need to add text to a formula that references another cell.
Say on one worksheet, I have a column of text from January to December
Also, I have worksheets named from January to December. I hav
multiple cell references for each worksheet, but they are always th
same cell for each worksheet, i.e. January!A1, February!A1, etc.
How can I reference these cells without typing in the January! part (o
selecting them from each sheet). Ideally, I would like to be able t
point to a cell and effectively say add a cell reference to it and hav
it return the value of that cell
I have created a form which the user adds data to, on a button click
procedure I want the data to be check and then added to a spreadsheet.
I dont know how I would go about placing this data in the write
spreadsheet, in the ocrrect place. I would need to place the data at
the end of the data already there. So i need to check where the last
entry is write ??
also i am having issues with
where wksmain is the name of the sheet.
any ideas would be greatful for any help.
ba...Adding heading text to footers
I have a multi-section document in which each section begins with a level-1
I need the level-1 heading text for each section to be in the footer. I'm
currently doing it the hard way by manually inserting cross-references in the
odd-page and even-page footers of each section. The problem with this is that
if I make any changes (insert or delete section breaks), my cross-references
break or point to the heading text from another section.
Is there any way to automate this by creating a variable that could be in
all the footers and call the level-1 heading text f...Adding full acoounts in FRX
I want to add my all full accounts (full acct segments) in FRX. Does anyone
know how? The Edit-Add rows from chart of accounts only brings in main
Where you see the individual columns, you need to put ambersands (&) in the
Charles Allen, MVP
> I want to add my all full accounts (full acct segments) in FRX. Does anyone
> know how? The Edit-Add rows from chart of accounts only brings in main
> segments. Thanks
> Marisol Mortera
Marisol Mort...Adding functionalities to CRM Mobile
Hi, i want to know if its possible to add functionalities to the CRM Mobile.
If i can add "pages" created by me to tha they can be viewed in mobiles.
IS SOMEONE THAT CAN HELP ME?
regards, pedro airo
No, you cannot add new forms. You can fully customize existing ones.
> Hi, i want to know if its possible to add functionalities to the CRM Mobile.
> If i can add "pages" created by me to tha they can be viewed in mobiles.
> IS SOMEONE THAT CAN HELP ME?
> regards, pedro airo
Tnkz for your response.
Regards, Pedro Ai...Adding a Third Criteria (Counting problem)
I want to add a third criteria to the following formula:
I want to do a total count of every instance in column L that is
greater than zero and that also matches the above data...
I tried this but it gave an incorrect answer:
If I were to creata an example it would look like the following. I
want to know how many times (column C) is greater than zero for every
day that = hs. Answer would be 2.
1/4/09 hs 9
1/5/09 hs 4
1/6/09 hs -5
1/7/09 ty 7
&g...Documents in one folder won't open--specs added
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
I realized just as I clicked Send that I need to provide version #s. I�m
using Word 2004 and Snow Leopard 10.6.2. This is not happening with other
<TITLE>...adding multiple checkboxes in a single cell
I want to add 2 checkboxes in one cell, similar to a yes/no checkbox but name
one contract and one permanent so that the person entering the data chooses
either or in that cell in order to identify if an employee is a permanent
employee or not. Can this be done in excel?
Not really, not the way I think you mean. But remember that one box has two
conditions: checked and not checked. So you could simply put one box in the
cell and set it up so that Checked means Permanent Employee and unchecked
means not permanent employee (contractor/temp/etc).
Get a checkbox, eithe...Adding or to previously provided Average If Array function
Jacob Skaria helped me out by providing the following formula. Thank you Jacob
AVERAGE(IF(score>0,score))) entered as an array.
but I'm here again!
I need to add an OR (I think!) 'cos now I've been asked to amend this so
that a score of >4 in either Q3 or Q4 OR a score of >3 in either Q5 or Q6
means that the average cannot be lower than 3.
Any of these cells can contain a zero.
Q1:Q35 is the named range score.
If anyone can help me that would be more than brilliant!
Ch...MMC hangs when adding/removing a group from the security permissio
On both domain controllers (Server 2003 R2) when I right click a share> go
to security> go to add or remove a group, the security permission mmc hangs
and CPU goes up to about 90%. When I look in task manager, mmc.exe is the
process hogging all the CPU. Disabling antivirus as a test on one of them did
not help. I can't add or remove groups here at all. If I leave the mmc it
never gets out of its hanging state. Anyone seen this before?
On Tue, 8 Dec 2009 07:45:02 -0800, dstrand <firstname.lastname@example.org>
>On both domain co...Adding FA Adapter to IM 8.0 SP2
Need to add the FA Adapter to the Integration Manager 8.0 sp2 install. What
is the recommended way to do this? Do you just go to control panel -->
add/change programs select the Integration Manager then select the add/change
...Submitting params from HTML to activeX control
I have an activeX control (programmed with c++) which is displayed in
the Internet Explorer via the object tag. Now, as you probably know,
you can pass parameters to the activeX control by using the param tag.
My question now is, how do I get these parameters into my activeX
I have several "DISP_PROPERTY_EX_ID" in my control which I want to fill
via the param tag. Do I have to make my control safe for scripting or
do I have to implement a special interface to set the parameters?
Does anyone know how to realize that? Can anyone help me?
Thx in advance,
Kai I. H.
...MFC ActiveX control Refreshing problem
I have crerated MFC ActiveX controla and when I run it in the IE6, it
works fine, like it does downloading some files from server and
encrypts them on the local machine and
uploads the encrypted file back to the server. So during this process
and after that also, when I switch to the other window and come back to
the same IE page, then the control vanishes from the page, and instead
the image of previous window comes into the container, where ActiveX
control should come. Even though the control does'nt stop its
processing in the background.
So, this problem of refreshing is with web ...adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External
Referral" we'd like to track the actual Contact (or Account) so we can
them a thank you or special offer.
How can we create a "Lookup" attribute (relationship?) from the Lead to
Contact and put it on the Lead form for the user to select a lead
contact from the search Contacts form?
Would using the Referral field help?
Larry Lentz [CRM MVP]
MCSE+I, MCSE W2K, MCDBA, MCSA Messaging
Lentz Computer Services
Microsoft Small Business Specialist
San Antonio, Texas
Larry@LentzCo...Adding Signature on replies
In Outlook 2000 when I was replying to an email and I wanted to add my
signature I could simply go insert->signature and it would appear in
the email message. In Outlook 2003 I seem to only be able to always
have a signature or no signature, there doesn't appear to be a way add
the signature on demand.
The closest I found was Insert->Auto Text->Signature but that only
inserted my name, not my full "new message" signature.
Just wondering if there is something I can configure to do this.
Thanks In Advance,
WordMail does not include an Insert | Signature command...How to Tell a tab control which tab to have open from the ON_Load
Hi, I have a form with a tab control with lots of tabs. In the on_load of
the form, based on where the user came from, I want to be able to tell which
tab is "open" when the form is drawn.
Examine the Value of the tab control.
It is equal to the PageIndex of the chosen page.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"SteveInBeloit" <SteveInBeloit@discussions.microsoft.com> wrote in message
news:DBF790EE-DE33-...Adding dates ... to previous weekday if falls on weekend.
I found lots of solutions if one is using the AnalysisPak but I'm not and
with no possibility to use it since they don't like us installing stuff,
even things like this.
I have this formula:
It works fine except it deals with calendar days. The formula putting
today's date in A2, returns this date:
This is almost good enough but I need it to go to the nearest weekday, which
would be Friday, Dec.18.2009.
And if the date came up as, say, Sunday December 20th, same thing. The
value returned for eithe...Tally Position of Data
Sorry for the strange way I have labelled the 'subject' but that is all I
could think of.
I wish to return the position of a person in a list. That person's position
will change daily by the introduction of points gained.
There are 3 columns:
Column 1 has the persons name
Column 2 has the points gained
Column 3 is the current position
The table is below
Col A Col B Col C
Name Points Position
What is the formula to produce
Name Points Position
Tom 40 2
Dick 50 1
Harry 25 3
Thanks if yo...