Hot Solutions

Installed Lync 2010 Enterprise. Followed all the instructions. Now, when I try and PUBLISH the topology I get the following error:

Error: An error occurred: "Microsoft.Rtc.Common.Data.SqlConnectionException" "Cannot open database "xds"...

I have been emailing my wife to her cell phone successfully until the other day...now when I attempt to email her I get the below response...I use Outlook 2010 and Exchange 2010...any solutions?...


From: Microsoft Outlook...

I am in the preliminary stages of planning my migration from ConfigMgr 2007 to 2012 when it goes on RTM release. The current deployment is a single (virtual on Hyper-V) server of 2007 R2 in mixed mode which supports a workload of ~500 clients, 40...

Hello Expert,

i have issues with Lync Gal, my external users unable to download the GAL.  when i ran the Lync configuration from lync client, i got to know GAL url is taking my internal website URL "pool1.domain.local).. i am not sure why it...

I created a dynamic range using the Offset function. This formula works in 2007 but does not work in Excel 2010? Did something change?

it looked something like this...

=offset($A$1,0,0,counta($A:$A),40)  

What I am trying to accomplish...

Alright, this has been mind boggling for me.

I have SCCM installed on a server and I am using a remote admin console.  Before I upgraded to SCCM SP2, I had not issues.

I upgraded the server to SP2, then my remote admin console could not see...

I am new to using a Microsoft Volume Licensing Agreement and have yet to install my first program. In the past, I have used MSDN and downloaded installation files with the authorization key also downloadable. In this case, I just get the ID, and...

Hi,

I have two tabs Sheet1 and Sheet2.  On Sheet 2 in cells A2 to A1000, there are Text values.  On Sheet1 I want a formula that will randomly pick one of the values from that range on Sheet2 and put it in a cell.  I can do a @Rand on numbers...

Hi all, thanks for reading.
I have a copy of vmware workstation 8 and have it installed with windows xp pro and server 2003 as two vm`s .
My question is...
Is there a way to get these two vm`s to talk to eachother inside workstation8.
My...

Hi. I got another failure for Backup exec. I have checked and the devices are online, the services are running. Backup Exec 2010 on a Windows 2008R2 SP1.

Here is the rundown of the error:

Checked and devices are online. Services are...

I am using my Mac to access my company email via outlook web access.  The Microsoft server is SBS2011 now here is the problem, up until yesterday I had no issue attaching document, images etc. to email but now whenever I try to attach anything it...

I am new to Access 2010, and I'm not a developer or advanced user.  I know how to import external data (Excel, txt files, etc) to create new tables or append data to existing tables.  I would like to make this a 'push-button'/menu type action...

=INDEX(Sheet8:Sheet1300!$A$2:$E$3,,MATCH(B9,Sheet8:Sheet1300!$A$1:$E$1,0))
=HLOOKUP(B9,Sheet7:Sheet1300!$B$1:$F$6,2,0)
I have 1300 sheets and one sheet with phone numbers in the B column on sheet7
In B1of all the sheets i have a phone number...

I have a table that I need to update (append records) daily from a delimited text file.  I know how to do this with a form button that runs VBA code, but I would like to schedule this task to run automatically every day.  I am not a programmer or...

I would like to have a VBA code write the formula

="SUMMARY FOR "&TEXT(TradeDate,"MMMM D, YYYY")

into Cell A1 as the document title.

However, I have not been successful yet with the following approach:
 

What is the correct syntax to...

I have Office 2007 and I can't connect to any of my live meetings.  It says Access denied.  My permissions all check out ok.  Any ideas?

I have a sumifs statement that sums all of the authorizations if the the code is column C is equal to the reason code and the State is equal "NJ"

SUMIFS(auths,State,"NJ",Rsn,$C21)

The challenge I have is that there are some outliers that I...

Hi Experts

I am looking for a solution for something that seems very simple on the surface but I am not sure if it really is in reality.  

Here's the challenge:
              A      B      C      D      E      F      G      H     I      J ...

Should I only Install RU2 for Exchange 2010 SP2, or should I install RU1 first then RU2 for Exchange 2010 SP2?

I need help on seting up a RUNONCE event. I have a windows 7 image. the imag has office 2007 Compress on a .rar and winrar app located under users\public\documents. I been trying to create a onload that will call the batch file bellow to have the...

Hi Experts,

I have a query in Excel which I regularly export to Excel using VBA. I would like to automatically apply a Theme (a Table Style) when it exports to Excel so that the background color of the rows are alternating. How do I do that?
...

Hi, I have two mailboxes configured on a users workstation.  The first mailbox is the users default account (name@domain.com) the second mailbox is for new employment applications (HR).  I have configured the HR mailbox in my outlook client and...

A client has a SharePoint intranet where documents and pictures are a large part of the usage. I was given the following user story:

"A user goes to a Document Library on a site, chooses New Document from the ribbon, gets the dropdown of...

Hello, I want to modify a Word 2007 date and time stamp macro with the following code:
 
Sub DateTimeStamp()
  'Inserts current date
  Selection.InsertDateTime DateTimeFormat:="MMMM dd, yyyy hh:mm AM/PM", InsertAsField:=False
lbl_Exit:
 ...

Dear Experts

I am downloading all the hotfix offline I am not using Windows Update, and I do not want to use it

I can not install KB968930 the extension is .msu a msg box appears
"Windows cannot open the file:"
"File:...

Microsoft Outlook: OUTLOOK.EXE - Bad Image

C:\Program Files (x86)\Microsoft Office\Office14\1033\OUTLLIBR.DLL is either not designed to run on Windows or it contains an error. Try installing the program again using the original installation...

Once I respond to a setting and go into site settings, the survey is listed as 'View Response #18' under View Response in Overview view.  Is there any way to change this?

Is there a difference if a variable is dimentioned as:
Global gstrUserID   vs  strUserID
when declared at the top of a module (not a form or report module)?  I want the variable to be used throughout the application.

Sandra

on http://msdn.microsoft.com/en-us/vstudio/ff520697 is says:
Visual Studio 2010 Load Test Feature Pack: MSDN subscribers with Visual Studio Ultimate are provided a license key to generate UNLIMITED virtual users without having to purchase the...

I have attached a network diagram.

The terminal server hosts the Remote App for the remote users to access the database server and application server.

The user will log into the NAS (Network Access Server).  Upon authentication, the NAS...

I have 2 macros that work fine on my PC (thanks to jigneshtahr who helped get one working)...
 
The problem one copies a sheet from each workbook in a folder and pastes values to a new sheet in a new workbook (consolidates 50 Budget sheets from...

Windows XP SP3 Running in a VMware Player virtual machine on Ubuntu 10.04.

Several versions of .NET installed: (according to Add or Remove Programs)
2.0 Service Pack 2
3.0 Service Pack 2
3.5 SP1
4 Client Profile
4 Extended

Problem...

I have a spreadsheet with 2 fields, with date and time. See below

Severity               Closed.TIME              Re-Assigned.TIME      
Sev 3              2/2/2012 11:41      1/31/2012 16:09      
Work Order      2/13/2012 10:07      12/22/2011 15:46      
Work Order      3/5/2012 11:14...

I type text into shapes in Visio drawings derived from Templates. Now I want to add automation,  by importing text automatically from various third party XMLs. Can I and ought I import the data fields of the 3rd party into MSOffice XML derived...

We have internal and external users on Lync and they have no problems.  Only one user tries to connect with Lync and gets this error message:  

Cannot sign in to Lync
Cannot sign in because the server is temporarily unavailable.

I've tried...

How to get rid of the norton email pop up ?  
there is no norton program in the control panel to uninstall?

I know that this...

Private Sub Command92_Click()
Me.Date_Paid = Date
End Sub

Gives me the current date but how would I rig it to give me a date 1 year in the future?

Thanks

In VMWare v5, I have the following set on my VM->Edit Settings->CPUs

 

I have a machine with 16 cores.

How can I allocate this to my VM (or do I have to leave one core for the VM)

Can anyone give me a formula that will work like SUMIF, but instead of giving the SUM, gives the MIN instead, all [other] things being equal?

Example:
=SUMIF(A:A,A7,Q:Q)    << returns the sum of values in column Q
                           ...

HI All,

I have a Host Header site Collection with URL http://www.123.com. Now I want to create a site collection with URL http://www.123.com/456. Due to some predefined issue, I cannot create a host header webapplication and host header site...

Hi,

Please tell me how an app-v package behaves on a Xenapp server.
I thought it was a real isolated bubble but now it seems to interact with applixations already installed (like ms Office) and printers on Xenappserver??

A customer was having problems with their pst file that a compact and a repair was not resolving.  So we thought we could open a new pst.  We did this and set it as default.  We found that the e-mails were still being sent from the old pst, so we...

I received a newsletter as a pdf.  Here is my scenario:

Scenario #1 - works fine:  Windows XP, Adobe 9 and OWA 2010.

Scenario #2 - works fine:  Windows 7 Pro, Adobe 9 and OWA 2010.

Scenario #3 - THE PROBLEM:  Windows 7 Pro, Adobe X and...

I would like to be able to take notes alongside my "Day" view in the Outlook 2007 Calendar. The goal is to use the program as a journal by taking notes on the daily meetings/events. Is this possible; I have not been able to find a solution.

Hi,

I built a Microsfot Access application that print a report. After this report I need to print some files with instructions, images and so on.
The problem is that I have many documents and I dont know all file types I'll need to print, so...

This program really changed from the XP version.  I'm currently having problems in two areas;

1) How can I put two workbooks side by side on the desktop?

2) How can I use "paste special" or "paste values"

Thanks

Hi I have an excel table that looks something like this

 

What I need to do is could the distinct values in A for each grouping of B

So the out put needs to look like

 

Any ideas how I can accomplish this in Excel 2003?

Thanks

I was able to convert a date field that was in text format to date by using this query in Access

UPDATE
  tblYourTable
SET
  NewDate = IIf(IsDate(Format([TextDate],"!@@@@/@@/@@")),CDate(Format([TextDate],"!@@@@/@@/@@")),Null)

How would I...

I'm trying to convert my project from .Net 3.5 to .Net 4.0;  My project built just fine in .Net 3.5.  But after converting to .Net 4.0, I get the following compile error:

The type or namespace name 'DataSetExtensions' does not exist in the...

I have the below VBScript that works for one database, but what woudl be the best approach to loop through about 10 databases?  Or do I have to create 10 different scripts and call each one by one in the Scheduler?

Option Explicit

dim...

I have a user who can't open any emails that have SMIME content or signatures.  No one else in the company is having the problem.  I cannot locate anything that she  has changed as far as security goes.  When I look at a reading pane or Preview...

I have the below where I am trying to TRIM the data in the column.  For some reason, when it is downloaded, teh userid always has leading spaces, usually four.  But while the code loops through the column it does not trim the string in the cell. ...

Hi,

In column "E" I need to add a Conditional Format Formula that higlight the cell in red when the value format typed is NOT as need it.

The values un column "E" must be like this:  J-31473021-5
(Letter "J" or "G" followed by "-" then 8...

I have one user in our enterprise that every time a meeting request is sent to her, 3 other people get it as well.  

All AD users are set up correctly, no dlegates are set in AD, on the Exchange Server, or on the client.

No forwards are in...

Hi guys, I have a transmittal system, that automatically emails transmittal information out to appropriate users. It gets the users names from a  list specific to the active project, then looks that user up in a contacts matrix that lists all...

I am looking for a solution to the following problem:

We run scheduled reports overnight using Jet Reports. Jet Reports work with Excel, so that the report is saved as an Excel Workbook.

The problem is that, when people view a given report,...

Hi Experts'

I am getting an error in form wizard when I try to create a form and sub form when I add the second (sub) information and click next, I get the error listed below. The customer is the primary table and the contract is the sub....

I am trying to help someeone with a problem on one of their forms.  the data source for the unbound text box is one of the fields in teh query for the list box.  When teh user changes the list box selection, the items on the form update with the...

Is there away to calculate the person's age and to show up in the TABLE not a query.  I have created a query to caculate the age but I want it to show up in the table.  Is that possible, if so how?
the function I used for the query I created is...

I did the following to create a VM

From the vClient

 

Now, at this point I have not specified the size of the disk, or the number of CPU's or the amount of memory

I have 2 questions

- Why did the VClient not ask me how much...

Hi there,

I have managed to get code to utilise the balloon tooltip function from MS Access which works great with no problems. What I am struggling with is making the pop up appear on all the front end applications when a user creates a new...

I installed Remote Desktop Gateway on a Windows 2008 Server that was running Exchange 2010... after the install, the Exchange Service will not start-- it may be due to the fact that I chose to share it with the RDP Gateway... I uninstalled RDP...

How do I know open a .msg file in Internet Explorer V8

I'm about to create a shared mailbox that will be available for all users (up to 100 users)

I want to prevent Outlook from caching the shared mailbox.  In Exchange 2010 SP1 and Outlook 2010 the shared mailbox is automatically added to all...

My OS is windows 7 prof 64 bit and I use Outlook 2007.  My IS is verizon FIOS, and use Outlook 2007.  Of late, my emails are not going out.  I have 2 accounts in Outlook, a MAPI account which is the msn email account, and this is the default...

Hi,
I'm trying to filter a range of rows in a worksheet using the wildcard character *. However the filter criteria doesn't seem to work. My code is.....

      wsApprovalsPerm.Range("$A$1:$AB$500").AutoFilter Field:=7, Criteria1:="440*"

It...

Hi
We provide a simple a backup solution for our customers and have following issues with Windows Live Mail (further WLM).

Situation: Customer works with Win XP and WLM 2009. In the background the backup-software just copied the file...

I have a 64 gig SSD hard drive that is simply too small at this point.  This drive is running my OS and whatever else has made it's way to this drive. I want to create an exact image of this drive and put it onto a larger SSD drive and just swap...

Hi Experts,

I would like to copy the current cell (highted range) to the cells next (next 10 cell on the right) to it.

Now I'm doing it on an uneffective way :

Set CurrCell = ActiveCell
    Application.ScreenUpdating = False
   ...

Hi, please see attached.

In Word I have "my company" in the top left corner is there a vba code that will save the file as "my company" in a file in "c:\master".

Thank you

I used this statement with numbers and had no problem but trying to match text and it does not seam to work.  

 

I have inherited a database with 311 queries.  Is there a way to simply loop through all the queries and have them printed out?  I am trying to "cleanup" this database and am trying to figure out where all the tables are used (or not as about 25%...

dbse uploaded
see form called files

what i am trying to do and failing is to have a combo box that when selected with colleagues names restricts or filters those records shown to that colleague.
any pratical help welcome

I have an ACCESS 2003 database that I am using to open other databases.  This "menu" database only has one form and on that button that open other databases.  However, I am trying to set up the first database and while the "child" database has an...

Hello,

I have around  100 windows 2 K3 and 2K8 servers.  I was wondering if there was a script to remotely connect to the windows servers,  check if lotus domino service was running and than gracefully shutdown domino server.  After the domino...

Hello Experts,

Is it possible to get exchange 2007 to use different send connectors based on the source address of the sender.

One of the useful features in previous versions of Outlook was the ability - having downloaded headers only - to mark those you don't want for deletion and those you do want for download.

In the 2010 version, I can still see the delete option...

I recently bought a used/refurbished Dell Optiplex with Windows XP Pro on it as a backup in my home office. It was working fine but now, I can't get it to come on. It sounds like it's booting up but I only have one light on the front, and it is...

I wanted to turn a mailbox into a distro group in Exchange 2007.  I removed the mailbox and deleted the user in active directory.  I then created a distribution group in Exchange with the same name and put the appropriate users in the group.  I...

Windows 7 32b-bit running IE9. Cant print, above script error appears and then nothing happens when clicked on yes.
Able to print from Firefox.

Please advise

I am poping email on my exchange 2007 SBS server. Some user reported they couldn't receive some emails. Checked the event viewer and found the following message:

One or more messages (5) were left in the 'jay@abc.com' account on the POP3...

I have a text file that lists all the source file information included in a GIS MXD project.  I'd like to search the file and reformat the results into a new table.  I'm not a programmer - just sort of dinking around with this to see if I can get...

I have data like below :

A      B

3       Person1

15     Person2

63     Person1

7       Person1

82     Person2

12     Person1

43     Person1


I want to get the sum of two people in separate cells

So it comes like :...

I've created an org chart in Visio 2010. When someone click on a box, I'd like another org chart to pop up showing direct reports. Can this be done?

Hello I have a phisical server with a folder with the PST files, the clients has a mappint network unit to this folder (net use z: \\server\folder_pst).

I have virtualize this server but the performance is decrement an the outlook is hang on....

I need to create a "virtual spedometer" and am wondering if it can be done at a low cost.  Perhaps there's some software already out there.... Ina sense, I just need the spedometer panel and a needle that moves...right?    So I thought I'd see if...

I received the email below from a teacher.  (first paragraph)


I am attempting to use a website that requires adobe shockwave – are there technical problems associated with using this software?  My students and I cannot use this website...

I just started at a new company and there are plenty of problems here but one of them is the possiblity that the former Network admin was using MSDN licneses in production. unfortunatly the former Net admin seems to have been the worst record...

I have a database created in MS Access 2010 - File Format is Access 2007, New Database Sort order is General - Legacy.  When my client tries to run in MS Access 2007, he's getting an unrecognized file format error.

I thought DB settings as...

I am having difficulites installing and running custom VB6 applications on win7 64-bit system.
The application was built and deployed using package and deployment wizard.  It uses win 32 API calls to read an initialization file and logon to an...

Hi There,

I am supporting one of my colleagues and they are having a very bizarre problem.
When they access their emails (gmail) through internet explorer, they cannot download or open PPT files, when you click the file (e.g -...

In SharePoint, when I click on a document library, by default the columns for the files are:
Name, Modified, Modified By, Check In Comment, Check Out to, Version and Type.

How do I change the default view for all users so that other columns...

We currently have a requirment to put in a SharePoint server for approx 150 users. Most users only need the features that comes with a Standard CAL, however there is about 10 users that require enterprise features. Is there a way to mix the CALS?...

All,

I'm looking for a way to convert a formula calculation of the age of an entry (calculated with the formula "=Today()-$E5") to a static entry when Column A for that row is set to 1.

Example

A5 = 0
E5 = 5/1/2012
F5 =Today()-$E5
...

dbse uploaded

go to form called files-see subform

i am trying todouble click on a client index record in the subform to open the corresponding record in the clients1 form.

but access cannit find the form.
there is s syntax error in the...

I have recently set up MBSA to scan our servers (Windows 2003) and now I am getting an error on my backup (evault online).  Their support says that their folder on each server should be excluded from all scans and that MBSA must be scanning the...

Hi,

I have 2 domains (east and west domains)with an exchange server under each child domain in the same forest .  the east domain is moving to a different office and will have to be shutdown for a few days.  we need to provide the east domain...

We are currently using Exchange 2010.  One of our customers is trying to send an email to us with a large attachment (18Mb).  The customer gets a response back of

552 Sorry, that message exceeds the maximum message length

We went into...