Reply:

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 Thanks Jeff Have you seen if there is any filter ...

Adding Task to Outlook
Option Compare Database Option Explicit Function AddOutLookTask() Dim OutlookApp As Outlook.Application Dim OutlookTask As Outlook.TaskItem Set OutlookApp = CreateObject("Outlook.Application") Set OutlookTask = OutlookApp.CreateItem(olTaskItem) With OutlookTask .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
Hi, 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. http://msdn2.microsoft.com/en-us/library/c6hzbzz6(VS.80).aspx 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-001P 100-01-001R 100-01-001S 100-01-002 (The other list has this number: 100-01-0020) 100-01-003A 100-01-004 (The other list has this number: 100-01-0040) 100-01-005 (Etc.....) 100-01-008 100-01-009 100-01-010 100-01-020E 100-01-020F 100-01-020G 100-01-020H 100-01-021 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. Any ideas? Thanks Gary 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. Gary wrote: > 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 -- AT ----------...

Adding information
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 Sheet("wksmain").Select where wksmain is the name of the sheet. any ideas would be greatful for any help. -- bach ------------------------------------------------------------------------ ba...

Adding heading text to footers
Hi ! I have a multi-section document in which each section begins with a level-1 header. 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
Hi! 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 Where you see the individual columns, you need to put ambersands (&) in the fields. -- Charles Allen, MVP "Marisol" wrote: > Hi! > > 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 Thanks Charles -- 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. Dean "Airo" wrote: > 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: =SUMPRODUCT(($B$22:$B$5000>0)*($H$22:$H$5000=$H$5)) 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: =SUMPRODUCT(($B$22:$B$5000>0)*($H$22:$H$5000=$H$5)*(L22:L5000>0)) 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. --B_3346073501_20170454 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit 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 documents. --B_3346073501_20170454 Content-type: text/html; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable <HTML> <HEAD> <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? -- Thanks, Pat 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
Hi, Jacob Skaria helped me out by providing the following formula. Thank you Jacob =IF(COUNTIF(Q3:Q4,">4"),MAX(3,AVERAGE(IF(score>0,score))), 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
Hi, 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 <dstrand@discussions.microsoft.com> wrote: >Hi, > >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 button? Thanks, John Born ...

Submitting params from HTML to activeX control
Hi, 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 control. 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
Hi, 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 send them a thank you or special offer. How can we create a "Lookup" attribute (relationship?) from the Lead to a Contact and put it on the Lead form for the user to select a lead source 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, Jason 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. Any idea? Thanks, Steve 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: =IF(A2<>"",A2+18,"") It works fine except it deals with calendar days. The formula putting today's date in A2, returns this date: Sat 2009.12.19 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
Hello, 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 Tom 40 Dick 50 Harry 25 What is the formula to produce Name Points Position Tom 40 2 Dick 50 1 Harry 25 3 Thanks if yo...