How do you calculate formulas in Excel 2007?
I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a  240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for [...]

Answer Question   |  November 9, 2012  1:16 AM
Excel 2007, Excel formulas

deleting toolbars from directory
I want to write a simple bat file to delete any add-on toolbars that have been installed but I can’t even find the folder that holds them. Any ideas?

Answer Question   |  April 7, 2010  7:16 PM
Batch file, IE, toolbar

New Member contest: Win a free iPad
Click here for all the details. Good luck to everyone.

Answer Question   |  February 7, 2011  6:34 PM
Database, DataCenter, DataManagement, Developement, Exchange, Linux, Lotus Notes, Mobile, Network connectivity, Oracle, SAP, Security, SQL Server, VMware, VoIP, Windows

What is XML toolkit for iSeries?
Hi everybody, could you tell me, what is this? and for what i need this? : 5733XT2   V1R2M0      XML Toolkit for IBM System i5   i thing that product as necessary for my RPG programs if i want put instructions in XML, and that’s all. could anybody give anything more about this? thanks, in advanced.    

Answer Question   |  April 6, 2010  2:11 PM
AS/400, Developement, iSeries, OS400 Upgrade, XML

what is the format of @ get function in Visual Foxpro
what is the format of @ get function in Visual Foxpro

Answer Question   |  May 1, 2011  3:03 PM
FoxPro 6, Visual FoxPro

Multiple versions of Java ?
I have multiple versions of Java listed on the software section of my control panel starting with Java 4 and ending with Java 6.  There are several updates for each version.  Do I need all these versions and updates or can I eliminate some?

Answer Question   |  April 11, 2010  9:49 PM
Java, Java developers

What includes in PS module of SAP R/3?
[h1 class="subject">What includes in PS module of SAP R/3?[/h1] I have a practical background of civil engineering infrastructure projects & I am a Chemical Engineer by qualification. Could Project Management Systems ( PS ) module of SAP R/3 be the better choice for me for training & certification? Please describe, why it could be or [...]

Answer Question   |  April 2, 2010  9:58 AM
Project management, SAP, SAP careers

MS Access query to show records that contain dates that differ by 1 year
I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a [...]

Answer Question   |  April 8, 2010  2:04 AM
Access, DATEDIFF, Microsoft Access 2003, Microsoft Access query, Query

MS Access Datasheet sorting using Runtime
In Access 2000 runtime is it possible to enable some quick an easy sorting on a DataSheet view in a subform?  I am currently using a ComboBox to achive this, but it would be more intuitive for the users to just be able to click on the column heading like one would do in Windows [...]

Answer Question   |  April 2, 2010  6:23 PM
Access Datasheet, ComboBox, Microsoft Access 2003, RunTime

leading zeros on numeric
In RPG how can I have a numeric field that keeps leading zeros?

Answer Question   |  April 2, 2010  12:58 PM
leading Zero, Numeric, RPG

ADO Connection to MaxDb
Using VBA (Excel 2007) I am trying to connect to MaxDb using the following connection string sapconn.Open “DRIVER={MaxDB};” _ & “SERVER=sapdevsrv_DEV_00;” _ & “DATABASE=200;” _ & “UID=AMJAD_PBL;” _ & “PWD= ;” But it’s generating an error saying [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified For your convenience the system [...]

Answer Question   |  March 31, 2010  1:15 PM
ADO Connection, VBA, VBA: ADO Connection to MaxDB

When is Test Strategy document prepared?
When is Test Strategy document prepared? Is it prepared before or after test plan? How is it different from Test Plan ? What are contains of Test Strategy Document?

Answer Question   |  December 29, 2010  6:55 AM
Software testing, Test Strategy

DR/HA questions with SQL Server design
Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring [...]

Answer Question   |  March 31, 2010  10:16 PM
SQL Server, SQL Server availability, SQL Server backup and restore

MySQLi and PHP problem with code
Can someone please tell me what I’m doing wrong with this particular line of code. echo "<td colspan=3>{$Row['areaCode'] . '-' . $Row['prefix'] . '-' . $Row['lineNumber']}</td></tr>"; I know that the concatenation operator is the . ‘areaCode’ ‘prefix’ and ‘lineNumber’ are all fields in a table within an SQL database. any help would be appreciated. Thanks [...]

Answer Question   |  April 9, 2010  10:02 PM
Concatenate, Database, MySQL, PHP, table

How to create a (visual) window baseclass without xaml
Hi, I want to create a window baseclass that contains 3 elements: - a ribbon control (ie devcomponents wpf ribbon) - a region to contain child form controls - a statusbar This way, all windows that inherit from this window will automatically provide these controls (and soms functions). I created a lookless windowbase.cs file that [...]

Answer Question   |  March 30, 2010  9:08 PM
baseform, C#, child, code behind, Inheritance, Template, visual, window, wpf

call php script from CL – slow
Hello, i try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH        CMD(&CMD) i try to send an email in the php script and i was wondering why it takes about 5-8 seconds to send the mail. So i tried to find out where the script is slow. [...]

Answer Question   |  March 31, 2010  12:45 PM
CL, i5, PHP, Qshell

Substring Query SQL
Hi All, I’m trying to build a query to join names in one table to abbreviated names in another table. So for example I have – Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the [...]

Answer Question   |  March 30, 2010  12:44 AM
SQL, SQL Server query optimization

Assembly injection/hook c#
I’m trying to inject/hook (or whatever method is the best) into a .net assembly exe. My objective is to extend the CollectionChanged event of all listviews. I’ve tried to use reflector to find some info on the assembly but it is obfuscatored and I’m not very skilled reading il code : ) So any help [...]

Answer Question   |  March 30, 2010  10:00 PM
.NET, C#

Ajax based multiserver GUI for MySQL?
I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

Answer Question   |  March 30, 2010  7:32 PM
Ajax, MySQL, MySQL admin

XPPRT1.dll threading
Running an app called LiquorPOS which uses this dll and, after malware infestation, has lost its threading. Is anyone familiar with this software? The error is ‘not found’, though 3 instances occur on the machine in the system mgr, application, and credit card directories. The system manager does open, just not the app — wondering [...]

Answer Question   |  April 5, 2010  1:26 AM
Alaska software, FoxPro, LiquorPOS, MerchantPOS