Search results for query: *

Hi, a coworker upgraded to Outlook 2010 and wants to create a contact group in her boss' contact folder. She gets as far as creating the group but then she cannot add members from his contacts. Is this no longer possible in 2010? She used to do it in 2007. Thanks!

Hello, I have downloaded the binaries for a program that I'd like to install on a 32bit Windows Server 2008 R2. It includes an installer but that requires a 64bit OS. The instructions say that I can "sync to the source, build and deploy the binaries" myself. I've been searching the web for...

I have a workbook with two sheets and a range called 'guidance' on sheet2. I need to create a hyperlink on sheet1 to get the user to sheet2, based on a value lookup. So far I've got this: =HYPERLINK(CELL("address",INDEX(guidance,MATCH(C6,INDEX(guidance,,1),0),1)), "Go") The CELL function...

Hi, This should be pretty simple: I want to create a macro that deletes the contents of B19 and C19 as soon as the user deletes the contents of A19. I started with this but it doesn't work: Option Compare Text Sub clear_stuff() If Range("A19").Value = "" Then Range("B19:C19").ClearContents...

Using Backup Exec 9, a few weeks ago the time to back up the entire server went from 7.5 hours to 9 hours. I found that the extra 1.5 hours is entirely during the backup of the Exchange Mailboxes. However, the size of those mailboxes did not change. The only change to the server that...

I'm not sure this is realistic... but here's my ideal solution: When my Outlook 2003 users (on Exchange) start a new email message, I want them to have a way to select Categories to include as recipients, right in the email. It could be a button that pops open a custom form, or whatever. The...

I'd like to automate an annual task: I have a spreadsheet with 5 columns of data, and I need to create 20 bar charts. The data look like this: DRG Hospital Discharges AvgCharges Title 15 OHC 7 $5,225 CVA 15 Mt A 8 $5,651 CVA 15 Copley 6 $5,895 CVA 15 Valley 3 $6,070 CVA There are...

Hi, I've been using SQL Server 2000 for over a year with no performance issues. Suddenly for the last week it's been quite slow (even switching databases takes 5 seconds, as opposed to 0), but only when I'm logged in on my PC (Windows 2000) with my profile. My coworker has no trouble on his...

Maybe I'm taking the wrong approach. Our 12-person office works with LOTS of distribution lists in Outlook 2003, and we manage mailing labels and lists in MS Access XP. Many of the contacts are the same in the two apps, so I want to find a good way to have staff manage contacts in just ONE and...

I'm trying to take a text document that has data in paragraphs (job descriptions) and put it into a spreadsheet, shifting various pieces of text into Excel columns. Each paragraph has certain characteristics that I THINK would allow me to identify the different elements (Title, Salary...

Hi, I'd like to set the color of a specific bar in a bar chart in my report. The chart (MSGraph.Chart.8) is dynamic, so I can't edit the color in design view. I've added this code: Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)...

I have a report whose source is a SQL string (based on a form). There are two grouping levels (2 group headers and 1 group footer). The 2nd group footer sums up the detail's data (count of patients for hospitals in detail). I am trying to show each hospital's share of the group total (as a...

Is it possible to create a report based on a crosstab query that has dynamic columns and column headings? I've set up a form where the user can select Quarters (for columns) and Cities (for rows). Since the Quarters are chosen on the fly, there's no way to know ahead of time which will appear...