Questions & Answers

  • Subtracting cells only if they have a value in Excel

    I want to subtract two cells in excel but only if both cells have a value. For instance, the formula I am using is thus: F2 is currently =E2-D2 but I only want this to be calculated when E2 has a value.

    ITKE342,450 pointsBadges:
  • Unable to connect to Exchange with Pop3 and IMAP4

    hi,  I am unable to access my exchange account with pop3 and imap4 setting, i have tried various option but fail to do so, i can able to telnet port 110 and 143. i am also having TMG and firewall,is firewall restricting the access if yes can any one plz tell me how to modify setting in TMG server...

    Redhot2006360 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • How can view the source of QSYS commands

    Like If I want to see source of 'WRKMBRPDM'(object type both cmd and *pgm) command what should I have to do?.

    Alicsc370 pointsBadges:
  • Windows Server 2003 Enterprise edition domain

    I have Windows 2003 Server enterprise. We want use Windows 7 and Windows Vista business on a Client Machine but it will not join the domain in Windows 2003 Server enterprises domain but XP client system works properly and joins the domain.

    Sam25555 pointsBadges:
  • What is ovrdbf?

    Hi all, Actually I know OVRDBF is used to override database file. After OVRDBF, we have to use OPENQRY command. But my question is: What purpose this OVRDBF file created and after creation it will be accessible to all the programs at a single time? Meaning can we access OVRDBF file in multiple...

    Sms121185 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • Automating Windows Server 2008 R2 backup

    Is it possible to automate a backup of a Windows Server 2008 R2 box with just built in software? Is there a step by step guide somewhere?

    TeachMeIT975 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • SAP SD module implementation from 4.6 to ECC 6.0

    Hi I'm new to SAP SD module. I want to know which are the imporant steps involved during the implementation of SAP SD module from 4.6 to ECC 6.0. Which are the sensitive areas one has to be careful about? Please guide me in this area. I have some background of SAP PS & MM module but am new to...

    Sappsmm55 pointsBadges:
  • Best single user CRM software

    What is the best CRM software for a single user with VISTA?

    PWM5 pointsBadges:
  • Registering IFilter with SharePoint 2013

    I was able to do this with SharePoint 2007 and 2010 but I'm having trouble registering my custom IFilter with SharePoint 2013. Can someone point me in the right direction on how to do it?

    ITKE342,450 pointsBadges:
  • Adding SVG file into a Microsoft Word document

    This may sound like a simple question but I'm looking for a way to convert or insert an Inkscape SVG file into a Microsoft Word document. Is there an easy way to do this?

    ITKE342,450 pointsBadges:
  • What is JBoss?

    Is JBoss a Language? Why is RedHat associated? As a recruiter, what kinds of titles should I be searching for on a resume that would have these skills/ certifications?

    DonatellaCowabunga15 pointsBadges:
  • Registering ASP.NET with Windows Server 2012

    I'm was running a WCF service but was getting a "MIME is not registered error." However, I was able to resolve this issue. Now, I'm getting another error when I'm trying to register my ASP.NET framework with IIS. I tried using the "aspnet_regiis" command but this error appears: Microsoft (R)...

    ITKE342,450 pointsBadges:
  • Answer a Question, Innovate Your IT Department!

    This week's IT book giveaway promises to help you change your view of IT and keep up with the face of IT that's been changing for years now. David Croslin doesn't approach IT transformation with the usual fire and brimstone, but with a refreshing perspective that gives advice on forging ahead...

    MelanieYarbrough6,345 pointsBadges:
  • Convert to date format

    How do I convert the given number to date format e.g. 2009062 should result in 03-Mar-2009. where 2009 is the year and 062 is the number od days. 62th day is 3rd march.

    SanikaGurav10 pointsBadges:
  • Editing Active Directory users offline

    Our company has finally gotten in to an Active Directory domain and will be migrating to Exchange 2007 hopefully soon. I have been instructed to edit the users information for the Global address book. I have the tast of inputting 600+ address, phone numbers, and other such information. Most of this...

    Chetta100 pointsBadges:
  • Export/Import active directory users

    Is there a way to export all active directory users and groups to reimport them back into another active directory network? Can we retain permissions and passwords?

    TeachMeIT975 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following